Hologres

Tools · 39

• execute_hg_select_sql Execute a SELECT SQL query in Hologres database
• execute_hg_select_sql_with_serverless Execute a SELECT SQL query in Hologres database with serverless computing
• execute_hg_dml_sql Execute a DML (INSERT, UPDATE, DELETE) SQL query in Hologres database
• execute_hg_ddl_sql Execute a DDL (CREATE, ALTER, DROP, COMMENT ON) SQL query in Hologres database
• gather_hg_table_statistics Collect table statistics in Hologres database
• get_hg_query_plan Get query plan in Hologres database
• get_hg_execution_plan Get execution plan in Hologres database
• call_hg_procedure Invoke a procedure in Hologres database
• create_hg_maxcompute_foreign_table Create MaxCompute foreign tables in Hologres database
• list_hg_schemas Lists all schemas in the current Hologres database, excluding system schemas
• list_hg_tables_in_a_schema Lists all tables in a specific schema, including their types (table, view, external table, partitioned table)
• show_hg_table_ddl Show the DDL script of a table, view, or external table in the Hologres database
• query_and_plotly_chart Execute a SELECT SQL query and generate a chart (bar, line, scatter, pie, histogram, area). Returns query results and a base64-encoded PNG image
• analyze_hg_query_by_id Analyze a specific query's performance profile by its query_id from hg_query_log. Returns detailed metrics including duration, memory, CPU time, read/write stats
• get_hg_slow_queries Get slow queries from hg_query_log ordered by duration
• list_hg_dynamic_tables List all Dynamic Tables with their status, freshness settings, and last refresh info
• get_hg_dynamic_table_refresh_history Get refresh history for a specific Dynamic Table, including duration, status, and latency
• list_hg_recyclebin List all tables in the Hologres recycle bin (dropped tables that can be restored)
• restore_hg_table_from_recyclebin Restore a dropped table from the Hologres recycle bin
• list_hg_warehouses List all computing groups (warehouses) with their CPU, memory, cluster count, and status
• switch_hg_warehouse Switch the current session's computing resource to a specified warehouse
• get_hg_table_storage_size Get storage size details of a table, including total, data, index, and metadata breakdown
• cancel_hg_query Cancel or terminate a running query by its process ID
• list_hg_active_queries List currently active queries and connections from pg_stat_activity
• list_hg_query_queues List all Query Queues and their classifiers (concurrency limits, routing rules). Requires V3.0+
• get_hg_table_properties Get table properties including distribution_key, clustering_key, segment_key, bitmap_columns, binlog settings, etc
• get_hg_table_shard_info Get table's Table Group and shard count info for diagnosing data skew
• list_hg_external_databases List all External Databases and Foreign Servers for Lakehouse acceleration. Requires V3.0+
• get_hg_lock_diagnostics Diagnose lock contention by showing blocking and waiting queries
• get_hg_table_info_trend Get table storage trend from hg_table_info, showing daily storage size, file count, and row count changes
• manage_hg_query_queue Create, drop, or clear a Query Queue. Requires V3.0+ and superuser privileges
• manage_hg_classifier Create or drop a classifier for a Query Queue. Requires V3.0+
• set_hg_query_queue_property Set or remove properties on a Query Queue or classifier. Requires V3.0+
• manage_hg_warehouse Manage a computing group: suspend, resume, restart, rename, or resize. Requires superuser
• get_hg_warehouse_status Get detailed running status and scaling progress of a computing group
• rebalance_hg_warehouse Trigger shard rebalancing for a computing group to eliminate data skew
• list_hg_data_masking_rules List all data masking rules configured via hg_anon extension (column-level and user-level)
• query_hg_external_files Query files directly from OSS using EXTERNAL_FILES function without creating foreign tables. Requires V4.1+
• get_hg_guc_config Get the current value of a GUC (Grand Unified Configuration) parameter