System Views

The M-compatible database inherits some system views of GaussDB. Table 1 shows the inherited system views. For details about the system 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
DATABASE LINKS	gs_db_links
Partitioned tables	gs_stat_all_partitions
	gs_stat_xact_all_partitions
	gs_statio_all_partitions
Auditing	gs_auditing
	gs_auditing_access
	gs_auditing_privilege
User and permission management	gs_db_privileges
User and permission management	gs_labels
Dynamic data masking	gs_masking
Communications	gs_comm_listen_address_ext_info
	gs_get_listen_address_ext_info
	gs_static_threadpool_ctrl_status
Segment-page storage	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
Workload management	gs_wlm_cgroup_info
	gs_wlm_rebuild_user_resource_pool
	gs_wlm_user_info
OLTP table compression	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
Materialized view	gs_matviews
Other system views	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
Multi-tenant	mtd_user (You are advised not to use and query this view in distributed mode.)
Deprecated system views	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

The middle view is used by the CN to collect views in a distributed system. For details about the middle view, see Table 2. You are advised not to use it directly.

**Table 2** Middle views
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

The M-compatible database also inherits the original GaussDB system views, such as dv_session_longops and dv_sessions. In addition to the original GaussDB system views, view aliases prefixed with gs_ are created in the corresponding system views, as described in Table 3. To ensure compatibility, preferentially use views whose alias prefixed with gs_.

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