gs_collector工具支持收集的系统表和视图列表

表 1 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