系统视图
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 |
|
|
pg_rlspolicies |
|
|
pg_roles |
|
|
pg_seclabels |
|
|
pg_shadow |
|
|
pg_user |
|
|
pg_user_mappings |
|
|
动态脱敏 |
gs_masking |
|
透明加密 |
pg_tde_info |
|
通信 |
gs_comm_listen_address_ext_info |
|
gs_get_listen_address_ext_info |
|
|
pg_comm_delay |
|
|
pg_comm_recv_stream |
|
|
pg_comm_send_stream |
|
|
pg_comm_status |
|
|
pg_get_invalid_backends |
|
|
段页式存储 |
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_plan_operator_history |
|
|
gs_wlm_rebuild_user_resource_pool |
|
|
gs_wlm_user_info |
|
|
多租户 |
mtd_user |
|
其他系统视图 |
gs_all_control_group_info |
|
gs_all_prepared_statements |
|
|
gs_comm_proxy_thread_status |
|
|
gs_file_stat |
|
|
gs_get_control_group_info |
|
|
gs_glc_memory_detail |
|
|
gs_gsc_memory_detail |
|
|
gs_instance_time |
|
|
gs_lsc_memory_detail |
|
|
gs_my_plan_trace |
|
|
gs_os_run_info |
|
|
gs_redo_stat |
|
|
gs_session_all_settings |
|
|
gs_session_memory |
|
|
gs_session_memory_context |
|
|
gs_session_memory_detail |
|
|
gs_session_stat |
|
|
gs_session_time |
|
|
gs_sql_count |
|
|
gs_stat_session_cu |
|
|
gs_thread_memory_context |
|
|
gs_total_memory_detail |
|
|
gs_total_nodegroup_memory_detail |
|
|
pg_available_extension_versions |
|
|
pg_available_extensions |
|
|
pg_control_group_config |
|
|
pg_cursors |
|
|
pg_ext_stats |
|
|
pg_get_senders_catchup_time |
|
|
pg_group |
|
|
pg_gtt_attached_pids |
|
|
pg_gtt_relstats |
|
|
pg_gtt_stats |
|
|
pg_indexes |
|
|
pg_locks |
|
|
pg_node_env |
|
|
pg_os_threads |
|
|
pg_prepared_statements |
|
|
pg_prepared_xacts |
|
|
pg_replication_origin_status |
|
|
pg_replication_slots |
|
|
pg_running_xacts |
|
|
pg_session_iostat |
|
|
pg_settings |
|
|
pg_stat_activity |
|
|
pg_stat_activity_ng |
|
|
pg_stat_all_indexes |
|
|
pg_stat_all_tables |
|
|
pg_stat_bad_block |
|
|
pg_stat_bgwriter |
|
|
pg_stat_database |
|
|
pg_stat_database_conflicts |
|
|
pg_stat_replication |
|
|
pg_stat_sys_indexes |
|
|
pg_stat_sys_tables |
|
|
pg_stat_user_functions |
|
|
pg_stat_user_indexes |
|
|
pg_stat_user_tables |
|
|
pg_stat_xact_all_tables |
|
|
pg_stat_xact_sys_tables |
|
|
pg_stat_xact_user_functions |
|
|
pg_stat_xact_user_tables |
|
|
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 |
|
|
pg_stats |
|
|
pg_tables |
|
|
pg_thread_wait_status |
|
|
pg_timezone_abbrevs |
|
|
pg_timezone_names |
|
|
pg_total_memory_detail |
|
|
pg_total_user_resource_info |
|
|
pg_total_user_resource_info_oid |
|
|
pg_variable_info |
|
|
pg_views |
|
|
gs_global_archive_status |
|
|
gs_workload_rule_stat |
M-Compatibility继承了pg_available_extension_versions、 pg_available_extensions、pg_comm_delay、pg_comm_recv_stream等系统视图，继承了原有GaussDB系统视图的同时，在对应系统视图下建立了以GS_前缀的别名，具体如表2所示。 为了保证兼容性，请优先使用GS_前缀的更名视图。
|
视图名称 |
视图别名 |
|---|---|
|
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_prepared_statements |
gs_prepared_statements |
|
pg_prepared_xacts |
gs_prepared_xacts |
|
pg_replication_origin_status |
gs_replication_origin_status |
|
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_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 |
