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