表6-1 gs_collector 工具支持收集的系统表和视图列表
类别
系统对象名
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
GBase 8c 工具参考手册
南大通用数据技术股份有限公司
291
类别
系统对象名
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
GBase 8c 工具参考手册
南大通用数据技术股份有限公司
292
类别
系统对象名
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
GBase 8c 工具参考手册
南大通用数据技术股份有限公司
293
类别
系统对象名
Transaction
pg_running_xacts
pg_prepared_xacts
Waits
pg_thread_wait_status
GBase 8c 工具参考手册
南大通用数据技术股份有限公司
294