系统视图
M-Compatibility模式数据库继承了GaussDB原有的部分系统视图，继承的系统视图如表1所示，系统视图的具体定义及视图信息请参见《开发指南》中“系统表和系统视图”章节。
- 当前M-Compatibility模式数据库不支持审计能力，gs_auditing、gs_auditing_access和gs_auditing_privilege视图数据为空。
- 当前M-Compatibility模式数据库不支持脱敏能力，gs_masking视图数据为空。
|
视图分类 |
视图名称 |
|---|---|
|
DATABASE LINKS |
gs_db_links |
|
分区表 |
gs_stat_all_partitions |
|
gs_stat_xact_all_partitions |
|
|
gs_statio_all_partitions |
|
|
审计 |
gs_auditing |
|
gs_auditing_access |
|
|
gs_auditing_privilege |
|
|
用户和权限管理 |
gs_db_privileges |
|
gs_labels |
|
|
动态脱敏 |
gs_masking |
|
通信 |
gs_comm_listen_address_ext_info |
|
gs_get_listen_address_ext_info |
|
|
gs_static_threadpool_ctrl_status |
|
|
段页式存储 |
global_gs_seg_datafiles |
|
global_gs_seg_extents |
|
|
global_gs_seg_segments |
|
|
global_gs_seg_spc_extents |
|
|
global_gs_seg_spc_segments |
|
|
gs_seg_datafile_layout |
|
|
gs_seg_datafiles |
|
|
gs_seg_extents |
|
|
gs_seg_segments |
|
|
gs_seg_segment_layout |
|
|
gs_seg_spc_segments |
|
|
gs_seg_spc_extents |
|
|
gs_seg_spc_remain_extents |
|
|
gs_seg_spc_remain_segments |
|
|
SPM计划管理 |
gs_spm_sql_baseline |
|
gs_spm_sql_param |
|
|
gs_spm_sql_evolution |
|
|
gs_spm_sys_baseline |
|
|
负载管理 |
gs_wlm_cgroup_info |
|
gs_wlm_rebuild_user_resource_pool |
|
|
gs_wlm_user_info |
|
|
OLTP表压缩 |
gs_adm_ilmevaluationdetails |
|
gs_adm_ilmdatamovementpolicies |
|
|
gs_adm_ilmobjects |
|
|
gs_adm_ilmparameters |
|
|
gs_adm_ilmpolicies |
|
|
gs_adm_ilmresults |
|
|
gs_adm_ilmtasks |
|
|
gs_my_ilmevaluationdetails |
|
|
gs_my_ilmdatamovementpolicies |
|
|
gs_my_ilmobjects |
|
|
gs_my_ilmpolicies |
|
|
gs_my_ilmresults |
|
|
gs_my_ilmtasks |
|
|
物化视图 |
gs_matviews |
|
其他系统视图 |
global_bad_block_info |
|
global_clear_bad_block_info |
|
|
global_stat_hotkeys_info |
|
|
global_wal_sender_status |
|
|
gs_all_control_group_info |
|
|
gs_all_prepared_statements |
|
|
gs_bucket_locks |
|
|
gs_get_control_group_info |
|
|
gs_glc_memory_detail |
|
|
gs_global_archive_status |
|
|
gs_gsc_memory_detail |
|
|
gs_libcomm_fd_info |
|
|
gs_libcomm_memory_info |
|
|
gs_lsc_memory_detail |
|
|
gs_my_plan_trace |
|
|
gs_session_all_settings |
|
|
gs_sql_count |
|
|
gs_stat_db_cu |
|
|
gs_stat_session_cu |
|
|
gs_total_nodegroup_memory_detail |
|
|
gs_workload_rule_stat |
|
|
sys_dummy |
|
|
多租户 |
mtd_user （不建议在分布式下使用和查看本视图） |
|
废弃系统视图 |
gs_cluster_resource_info |
|
gs_session_cpu_statistics |
|
|
gs_session_memory_statistics |
|
|
gs_wlm_operator_history |
|
|
gs_wlm_operator_statistics |
|
|
gs_wlm_resource_pool |
|
|
gs_wlm_session_history |
|
|
gs_wlm_session_info |
|
|
gs_wlm_session_info_all |
|
|
gs_wlm_session_statistics |
|
|
gs_wlm_user_session_info |
|
|
gs_wlm_workload_records |
中间视图主要是在分布式上CN用来收集对应视图时使用，具体视图如表2所示，不建议用户直接使用。
|
gs_local_adm_ilmdatamovementpolicies |
gs_local_my_ilmdatamovementpolicies |
|
gs_local_adm_ilmevaluationdetails |
gs_local_my_ilmevaluationdetails |
|
gs_local_adm_ilmobjects |
gs_local_my_ilmobjects |
|
gs_local_adm_ilmpolicies |
gs_local_my_ilmpolicies |
|
gs_local_adm_ilmresults |
gs_local_my_ilmresults |
|
gs_local_adm_ilmtasks |
gs_local_my_ilmtasks |
M-Compatibility模式数据库还继承了dv_session_longops、dv_sessions等GaussDB原有的系统视图，在继承GaussDB原有系统视图的同时，在对应系统视图下建立了以gs_为前缀的视图别名，如表3所示。 为了保证兼容性，请优先使用带有gs_前缀的别名视图。
|
视图名称 |
视图别名 |
|---|---|
|
dv_session_longops |
gs_dv_session_longops |
|
dv_sessions |
gs_dv_sessions |
|
get_global_prepared_xacts |
gs_get_global_prepared_xacts |
|
mpp_tables |
gs_mpp_tables |
|
pg_available_extension_versions |
gs_available_extension_versions |
|
pg_available_extensions |
gs_available_extensions |
|
pg_comm_delay |
gs_comm_delay |
|
pg_comm_recv_stream |
gs_comm_recv_stream |
|
pg_comm_send_stream |
gs_comm_send_stream |
|
pg_comm_status |
gs_comm_status |
|
pg_control_group_config |
gs_control_group_config |
|
pg_cursors |
gs_cursors |
|
pg_ext_stats |
gs_ext_stats |
|
pg_get_invalid_backends |
gs_get_invalid_backends |
|
pg_get_senders_catchup_time |
gs_get_senders_catchup_time |
|
pg_group |
gs_group |
|
pg_gtt_attached_pids |
gs_gtt_attached_pids |
|
pg_gtt_relstats |
gs_gtt_relstats |
|
pg_gtt_stats |
gs_gtt_stats |
|
pg_indexes |
gs_indexes |
|
pg_locks |
gs_locks |
|
pg_node_env |
gs_node_env |
|
pg_os_threads |
gs_os_threads |
|
pg_pooler_status |
gs_pooler_status |
|
pg_prepared_statements |
gs_prepared_statements |
|
pg_prepared_xacts |
gs_prepared_xacts |
|
pg_replication_slots |
gs_replication_slots |
|
pg_rlspolicies |
gs_rlspolicies |
|
pg_roles |
gs_roles |
|
pg_rules |
gs_rules |
|
pg_running_xacts |
gs_running_xacts |
|
pg_seclabels |
gs_seclabels |
|
pg_session_iostat |
gs_session_iostat |
|
pg_session_wlmstat |
gs_session_wlmstat |
|
pg_settings |
gs_settings |
|
pg_shadow |
gs_shadow |
|
pg_shared_memory_detail |
gs_shared_memory_detail |
|
pg_stat_activity |
gs_stat_activity |
|
pg_stat_activity_ng |
gs_stat_activity_ng |
|
pg_stat_all_indexes |
gs_stat_all_indexes |
|
pg_stat_all_tables |
gs_stat_all_tables |
|
pg_stat_bad_block |
gs_stat_bad_block |
|
pg_stat_bgwriter |
gs_stat_bgwriter |
|
pg_stat_database |
gs_stat_database |
|
pg_stat_database_conflicts |
gs_stat_database_conflicts |
|
pg_stat_replication |
gs_stat_replication |
|
pg_stat_sys_indexes |
gs_stat_sys_indexes |
|
pg_stat_sys_tables |
gs_stat_sys_tables |
|
pg_stat_user_functions |
gs_stat_user_functions |
|
pg_stat_user_indexes |
gs_stat_user_indexes |
|
pg_stat_user_tables |
gs_stat_user_tables |
|
pg_stat_xact_all_tables |
gs_stat_xact_all_tables |
|
pg_stat_xact_sys_tables |
gs_stat_xact_sys_tables |
|
pg_stat_xact_user_functions |
gs_stat_xact_user_functions |
|
pg_stat_xact_user_tables |
gs_stat_xact_user_tables |
|
pg_statio_all_indexes |
gs_statio_all_indexes |
|
pg_statio_all_sequences |
gs_statio_all_sequences |
|
pg_statio_all_tables |
gs_statio_all_tables |
|
pg_statio_sys_indexes |
gs_statio_sys_indexes |
|
pg_statio_sys_sequences |
gs_statio_sys_sequences |
|
pg_statio_sys_tables |
gs_statio_sys_tables |
|
pg_statio_user_indexes |
gs_statio_user_indexes |
|
pg_statio_user_sequences |
gs_statio_user_sequences |
|
pg_statio_user_tables |
gs_statio_user_tables |
|
pg_stats |
gs_stats |
|
pg_tables |
gs_tables |
|
pg_tde_info |
gs_tde_info |
|
pg_thread_wait_status |
gs_thread_wait_status |
|
pg_timezone_abbrevs |
gs_timezone_abbrevs |
|
pg_timezone_names |
gs_timezone_names |
|
pg_total_memory_detail |
gs_total_memory_detail |
|
pg_total_user_resource_info |
gs_total_user_resource_info |
|
pg_total_user_resource_info_oid |
gs_total_user_resource_info_oid |
|
pg_user |
gs_user |
|
pg_user_mappings |
gs_user_mappings |
|
pg_variable_info |
gs_variable_info |
|
pg_views |
gs_views |
|
pg_wlm_statistics |
gs_wlm_statistics |
|
pgxc_comm_delay |
gs_pgxc_comm_delay |
|
pgxc_comm_recv_stream |
gs_pgxc_comm_recv_stream |
|
pgxc_comm_send_stream |
gs_pgxc_comm_send_stream |
|
pgxc_comm_status |
gs_pgxc_comm_status |
|
pgxc_get_stat_all_tables |
gs_pgxc_get_stat_all_tables |
|
pgxc_get_table_skewness |
gs_pgxc_get_table_skewness |
|
pgxc_node_env |
gs_pgxc_node_env |
|
pgxc_os_threads |
gs_pgxc_os_threads |
|
pgxc_prepared_xacts |
gs_pgxc_prepared_xacts |
|
pgxc_running_xacts |
gs_pgxc_running_xacts |
|
pgxc_sql_count |
gs_pgxc_sql_count |
|
pgxc_stat_activity |
gs_pgxc_stat_activity |
|
pgxc_stat_activity_with_conninfo_new |
gs_pgxc_stat_activity_with_conninfo_new |
|
pgxc_stat_bad_block |
gs_pgxc_stat_bad_block |
|
pgxc_thread_wait_status |
gs_pgxc_thread_wait_status |
|
pgxc_total_memory_detail |
gs_pgxc_total_memory_detail |
|
pgxc_variable_info |
gs_pgxc_variable_info |
|
pgxc_wlm_operator_history |
gs_pgxc_wlm_operator_history |
|
pgxc_wlm_operator_info |
gs_pgxc_wlm_operator_info |
|
pgxc_wlm_operator_statistics |
gs_pgxc_wlm_operator_statistics |
|
pgxc_wlm_rebuild_user_respool |
gs_pgxc_wlm_rebuild_user_respool |
|
pgxc_wlm_session_history |
gs_pgxc_wlm_session_history |
|
pgxc_wlm_session_info |
gs_pgxc_wlm_session_info |
|
pgxc_wlm_session_statistics |
gs_pgxc_wlm_session_statistics |
|
pgxc_wlm_workload_records |
gs_pgxc_wlm_workload_records |
|
pv_file_stat |
gs_pv_file_stat |
|
pv_instance_time |
gs_pv_instance_time |
|
pv_os_run_info |
gs_pv_os_run_info |
|
pv_redo_stat |
gs_pv_redo_stat |
|
pv_session_memory |
gs_pv_session_memory |
|
pv_session_memory_context |
gs_pv_session_memory_context |
|
pv_session_memory_detail |
gs_pv_session_memory_detail |
|
pv_session_stat |
gs_pv_session_stat |
|
pv_session_time |
gs_pv_session_time |
|
pv_thread_memory_context |
gs_pv_thread_memory_context |
|
pv_total_memory_detail |
gs_pv_total_memory_detail |
