系统视图
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 |
