System Catalogs and Views Supported by gs_collector
Table 1 System catalogs and views supported by gs_collector
| Class | View Name | 
|---|
| OS | gs_os_run_info | 
| pg_os_threads | 
| Session /Thread | gs_session_stat | 
| gs_session_time | 
| gs_session_cpu_statistics | 
| gs_session_memory_statistics | 
| gs_session_memory_context | 
| gs_session_memory | 
| gs_session_memory_detail | 
| pg_stat_activity | 
| gs_thread_memory_context | 
| WLM | gs_cluster_resource_info | 
| pg_total_user_resource_info | 
| pg_total_user_resource_info_oid | 
| gs_wlm_rebuild_user_resource_pool | 
| gs_wlm_resource_pool | 
| gs_wlm_workload_records | 
| pg_wlm_statistics | 
| pg_app_workloadgroup_mapping | 
| Query-AP Operator | gs_wlm_operator_info | 
| gs_wlm_operator_history | 
| gs_wlm_operator_statistics | 
| Query-AP | gs_wlm_session_info_all | 
| gs_wlm_session_history | 
| gs_wlm_session_info | 
| gs_wlm_user_session_info | 
| gs_wlm_session_statistics | 
| pg_session_iostat | 
| pg_session_wlmstat | 
| Cache I/O | pg_statio_all_indexes | 
| pg_statio_all_sequences | 
| pg_statio_all_tables | 
| pg_statio_sys_indexes | 
| pg_statio_sys_sequences | 
| pg_statio_sys_tables | 
| pg_statio_user_indexes | 
| pg_statio_user_sequences | 
| pg_statio_user_tables | 
| gs_stat_db_cu | 
| gs_stat_session_cu | 
| Memory | pg_total_memory_detail | 
| pg_shared_memory_detail | 
| gs_total_memory_detail | 
| File | gs_file_stat | 
| gs_redo_stat | 
| pg_stat_bad_block | 
| Object | pg_stat_user_tables | 
| pg_stat_user_indexes | 
| pg_stat_sys_tables | 
| pg_stat_sys_indexes | 
| pg_stat_all_tables | 
| pg_stat_all_indexes | 
| pg_stat_database | 
| pg_stat_database_conflicts | 
| pg_stat_xact_all_tables | 
| pg_stat_xact_sys_tables | 
| pg_stat_xact_user_tables | 
| pg_stat_xact_user_functions | 
| Lock | pg_locks | 
| Utility | pg_stat_replication | 
| pg_replication_slots | 
| pg_stat_bgwriter | 
| Transaction | pg_running_xacts | 
| pg_prepared_xacts | 
| Waits | pg_thread_wait_status | 
openGauss 2025-10-31 07:42:18