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 |
