System Views

M compatibility inherits some system views of GaussDB. Table 1 shows the inherited views. For details about the view definitions and view information, see section "System Catalogs and System Views" in Developer Guide.

M-compatible databases do not support auditing. The gs_auditing, gs_auditing_access, and gs_auditing_privilege views are empty.
M-compatible databases do not support masking. The gs_masking view is empty.

**Table 1** Views of GaussDB inherited by the M-compatible database
View Category	View Name
System views	database links
System views	gs_db_links
Partitioned tables	gs_stat_all_partitions
	gs_stat_xact_all_partitions
	gs_statio_all_partitions
Audit	gs_auditing
	gs_auditing_access
	gs_auditing_privilege
User and permission management	gs_db_privileges
	gs_labels
	pg_rlspolicies
	pg_roles
	pg_seclabels
	pg_shadow
	pg_user
	pg_user_mappings
Dynamic data masking	gs_masking
TDE	pg_tde_info
Communications	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
Segment-page storage	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
Workload management	gs_wlm_cgroup_info
	gs_wlm_plan_operator_history
	gs_wlm_rebuild_user_resource_pool
	gs_wlm_user_info
Multi-tenant	mtd_user
Other system views	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-compatible databases inherit system views including pg_available_extension_versions, pg_available_extensions, pg_comm_delay, and pg_comm_recv_stream, as well as the original GaussDB system views. Aliases prefixed with GS_ are created for the corresponding system views. For details, see Table 2. To ensure compatibility, preferentially use renamed views with the prefix GS_.

**Table 2** Aliases of the system view in the M-compatible database
View Name	View Alias
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