Schema

M-Compatibility模式数据库继承了GaussDB原有的部分DBE_PERF Schema视图，在继承GaussDB原有视图的同时，在对应视图下建立了以gs_为前缀的视图别名，其对应关系如表1所示。为了保证兼容性，请优先使用带有gs_前缀的别名视图。

表1 M-Compatibility模式数据库系统视图别名
schema名称	视图名称	视图别名
dbe_perf	ai_watchdog_detection_warnings	gs_ai_watchdog_detection_warnings
dbe_perf	ai_watchdog_ftask_status	gs_ai_watchdog_ftask_status
dbe_perf	ai_watchdog_monitor_status	gs_ai_watchdog_monitor_status
dbe_perf	ai_watchdog_parameters	gs_ai_watchdog_parameters
dbe_perf	bgwriter_stat	gs_bgwriter_stat
dbe_perf	class_vital_info	gs_class_vital_info
dbe_perf	comm_delay	gs_comm_delay
dbe_perf	comm_recv_stream	gs_comm_recv_stream
dbe_perf	comm_send_stream	gs_comm_send_stream
dbe_perf	comm_status	gs_comm_status
dbe_perf	config_settings	gs_config_settings
dbe_perf	file_iostat	gs_file_iostat
dbe_perf	file_redo_iostat	gs_file_redo_iostat
dbe_perf	global_active_session	gs_global_active_session
dbe_perf	global_adio_completer_status	gs_global_adio_completer_status
dbe_perf	global_aio_slot_usage_status	gs_global_aio_slot_usage_status
dbe_perf	global_bgwriter_stat	gs_global_bgwriter_stat
dbe_perf	global_candidate_status	gs_global_candidate_status
dbe_perf	global_ckpt_status	gs_global_ckpt_status
dbe_perf	global_comm_check_connection_status	gs_global_comm_check_connection_status
dbe_perf	global_comm_delay	gs_global_comm_delay
dbe_perf	global_comm_recv_stream	gs_global_comm_recv_stream
dbe_perf	global_comm_send_stream	gs_global_comm_send_stream
dbe_perf	global_comm_status	gs_global_comm_status
dbe_perf	global_config_settings	gs_global_config_settings
dbe_perf	global_double_write_status	gs_global_double_write_status
dbe_perf	global_file_iostat	gs_global_file_iostat
dbe_perf	global_file_redo_iostat	gs_global_file_redo_iostat
dbe_perf	global_get_bgwriter_status	gs_global_get_bgwriter_status
dbe_perf	global_instance_time	gs_global_instance_time
dbe_perf	global_io_wait_info	gs_global_io_wait_info
dbe_perf	global_locks	gs_global_locks
dbe_perf	global_memory_node_detail	gs_global_memory_node_detail
dbe_perf	global_operator_history	gs_global_operator_history
dbe_perf	global_operator_history_table	gs_global_operator_history_table
dbe_perf	global_operator_runtime	gs_global_operator_runtime
dbe_perf	global_os_runtime	gs_global_os_runtime
dbe_perf	global_os_threads	gs_global_os_threads
dbe_perf	global_pagewriter_status	gs_global_pagewriter_status
dbe_perf	global_parallel_decode_status	gs_global_parallel_decode_status
dbe_perf	global_parallel_decode_thread_info	gs_global_parallel_decode_thread_info
dbe_perf	global_plancache_status	gs_global_plancache_status
dbe_perf	global_pooler_status	gs_global_pooler_status
dbe_perf	global_prepare_statement_status	gs_global_prepare_statement_status
dbe_perf	global_record_reset_time	gs_global_record_reset_time
dbe_perf	global_recovery_status	gs_global_recovery_status
dbe_perf	global_redo_status	gs_global_redo_status
dbe_perf	global_rel_iostat	gs_global_rel_iostat
dbe_perf	global_replication_slots	gs_global_replication_slots
dbe_perf	global_replication_stat	gs_global_replication_stat
dbe_perf	global_rto_status	gs_global_rto_status
dbe_perf	global_session_memory	gs_global_session_memory
dbe_perf	global_session_memory_detail	gs_global_session_memory_detail
dbe_perf	global_session_stat	gs_global_session_stat
dbe_perf	global_session_stat_activity	gs_global_session_stat_activity
dbe_perf	global_session_time	gs_global_session_time
dbe_perf	global_shared_memory_detail	gs_global_shared_memory_detail
dbe_perf	global_single_flush_dw_status	gs_global_single_flush_dw_status
dbe_perf	global_slow_query_history	gs_global_slow_query_history
dbe_perf	global_slow_query_info	gs_global_slow_query_info
dbe_perf	global_stat_all_indexes	gs_global_stat_all_indexes
dbe_perf	global_stat_all_tables	gs_global_stat_all_tables
dbe_perf	global_stat_bad_block	gs_global_stat_bad_block
dbe_perf	global_stat_database	gs_global_stat_database
dbe_perf	global_stat_database_conflicts	gs_global_stat_database_conflicts
dbe_perf	global_stat_db_cu	gs_global_stat_db_cu
dbe_perf	global_stat_session_cu	gs_global_stat_session_cu
dbe_perf	global_stat_sys_indexes	gs_global_stat_sys_indexes
dbe_perf	global_stat_sys_tables	gs_global_stat_sys_tables
dbe_perf	global_stat_user_functions	gs_global_stat_user_functions
dbe_perf	global_stat_user_indexes	gs_global_stat_user_indexes
dbe_perf	global_stat_user_tables	gs_global_stat_user_tables
dbe_perf	global_stat_xact_all_tables	gs_global_stat_xact_all_tables
dbe_perf	global_stat_xact_sys_tables	gs_global_stat_xact_sys_tables
dbe_perf	global_stat_xact_user_functions	gs_global_stat_xact_user_functions
dbe_perf	global_stat_xact_user_tables	gs_global_stat_xact_user_tables
dbe_perf	global_statement_complex_history	gs_global_statement_complex_history
dbe_perf	global_statement_complex_history_table	gs_global_statement_complex_history_table
dbe_perf	global_statement_complex_runtime	gs_global_statement_complex_runtime
dbe_perf	global_statement_count	gs_global_statement_count
dbe_perf	global_statio_all_indexes	gs_global_statio_all_indexes
dbe_perf	global_statio_all_sequences	gs_global_statio_all_sequences
dbe_perf	global_statio_all_tables	gs_global_statio_all_tables
dbe_perf	global_statio_sys_indexes	gs_global_statio_sys_indexes
dbe_perf	global_statio_sys_sequences	gs_global_statio_sys_sequences
dbe_perf	global_statio_sys_tables	gs_global_statio_sys_tables
dbe_perf	global_statio_user_indexes	gs_global_statio_user_indexes
dbe_perf	global_statio_user_sequences	gs_global_statio_user_sequences
dbe_perf	global_statio_user_tables	gs_global_statio_user_tables
dbe_perf	global_streaming_hadr_rto_and_rpo_stat	gs_global_streaming_hadr_rto_and_rpo_stat
dbe_perf	global_thread_wait_status	gs_global_thread_wait_status
dbe_perf	global_threadpool_status	gs_global_threadpool_status
dbe_perf	global_transactions_prepared_xacts	gs_global_transactions_prepared_xacts
dbe_perf	global_transactions_running_xacts	gs_global_transactions_running_xacts
dbe_perf	global_user_transaction	gs_global_user_transaction
dbe_perf	global_wait_events	gs_global_wait_events
dbe_perf	global_wlm_workload_runtime	gs_global_wlm_workload_runtime
dbe_perf	global_workload_transaction	gs_global_workload_transaction
dbe_perf	instance_time	gs_instance_time
dbe_perf	local_active_session	gs_local_active_session
dbe_perf	local_io_wait_info	gs_local_io_wait_info
dbe_perf	local_plancache_clean	gs_local_plancache_clean
dbe_perf	local_plancache_status	gs_local_plancache_status
dbe_perf	local_prepare_statement_status	gs_local_prepare_statement_status
dbe_perf	local_rel_iostat	gs_local_rel_iostat
dbe_perf	local_threadpool_status	gs_local_threadpool_status
dbe_perf	locks	gs_locks
dbe_perf	memory_node_detail	gs_memory_node_detail
dbe_perf	memory_node_ng_detail	gs_memory_node_ng_detail
dbe_perf	operator_history	gs_operator_history
dbe_perf	operator_history_table	gs_operator_history_table
dbe_perf	operator_runtime	gs_operator_runtime
dbe_perf	os_runtime	gs_os_runtime
dbe_perf	os_threads	gs_os_threads
dbe_perf	parallel_decode_status	gs_parallel_decode_status
dbe_perf	parallel_decode_thread_info	gs_parallel_decode_thread_info
dbe_perf	perf_query	gs_perf_query
dbe_perf	pooler_status	gs_pooler_status
dbe_perf	replication_slots	gs_replication_slots
dbe_perf	replication_stat	gs_replication_stat
dbe_perf	session_cpu_runtime	gs_session_cpu_runtime
dbe_perf	session_memory_detail	gs_session_memory_detail
dbe_perf	session_memory_runtime	gs_session_memory_runtime
dbe_perf	session_stat	gs_session_stat
dbe_perf	session_stat_activity	gs_session_stat_activity
dbe_perf	session_time	gs_session_time
dbe_perf	session_memory	gs_session_memory
dbe_perf	shared_memory_detail	gs_shared_memory_detail
dbe_perf	slow_query_history	gs_slow_query_history
dbe_perf	slow_query_info	gs_slow_query_info
dbe_perf	stat_all_indexes	gs_stat_all_indexes
dbe_perf	stat_all_tables	gs_stat_all_tables
dbe_perf	stat_bad_block	gs_stat_bad_block
dbe_perf	stat_database	gs_stat_database
dbe_perf	stat_database_conflicts	gs_stat_database_conflicts
dbe_perf	stat_sys_indexes	gs_stat_sys_indexes
dbe_perf	stat_sys_tables	gs_stat_sys_tables
dbe_perf	stat_user_functions	gs_stat_user_functions
dbe_perf	stat_user_indexes	gs_stat_user_indexes
dbe_perf	stat_user_tables	gs_stat_user_tables
dbe_perf	stat_xact_all_tables	gs_stat_xact_all_tables
dbe_perf	stat_xact_sys_tables	gs_stat_xact_sys_tables
dbe_perf	stat_xact_user_functions	gs_stat_xact_user_functions
dbe_perf	stat_xact_user_tables	gs_stat_xact_user_tables
dbe_perf	statement	gs_statement
dbe_perf	statement_complex_history	gs_statement_complex_history
dbe_perf	statement_complex_history_table	gs_statement_complex_history_table
dbe_perf	statement_complex_runtime	gs_statement_complex_runtime
dbe_perf	statement_count	gs_statement_count
dbe_perf	statement_history	gs_statement_history
dbe_perf	statement_iostat_complex_runtime	gs_statement_iostat_complex_runtime
dbe_perf	statement_responsetime_percentile	gs_statement_responsetime_percentile
dbe_perf	statement_user_complex_history	gs_statement_user_complex_history
dbe_perf	statement_wlmstat_complex_runtime	gs_statement_wlmstat_complex_runtime
dbe_perf	statio_all_indexes	gs_statio_all_indexes
dbe_perf	statio_all_sequences	gs_statio_all_sequences
dbe_perf	statio_all_tables	gs_statio_all_tables
dbe_perf	statio_sys_indexes	gs_statio_sys_indexes
dbe_perf	statio_sys_sequences	gs_statio_sys_sequences
dbe_perf	statio_sys_tables	gs_statio_sys_tables
dbe_perf	statio_user_indexes	gs_statio_user_indexes
dbe_perf	statio_user_sequences	gs_statio_user_sequences
dbe_perf	statio_user_tables	gs_statio_user_tables
dbe_perf	summary_file_iostat	gs_summary_file_iostat
dbe_perf	summary_file_redo_iostat	gs_summary_file_redo_iostat
dbe_perf	summary_rel_iostat	gs_summary_rel_iostat
dbe_perf	summary_stat_all_indexes	gs_summary_stat_all_indexes
dbe_perf	summary_stat_all_tables	gs_summary_stat_all_tables
dbe_perf	summary_stat_bad_block	gs_summary_stat_bad_block
dbe_perf	summary_stat_database	gs_summary_stat_database
dbe_perf	summary_stat_database_conflicts	gs_summary_stat_database_conflicts
dbe_perf	summary_stat_sys_indexes	gs_summary_stat_sys_indexes
dbe_perf	summary_stat_sys_tables	gs_summary_stat_sys_tables
dbe_perf	summary_stat_user_functions	gs_summary_stat_user_functions
dbe_perf	summary_stat_user_indexes	gs_summary_stat_user_indexes
dbe_perf	summary_stat_user_tables	gs_summary_stat_user_tables
dbe_perf	summary_stat_xact_all_tables	gs_summary_stat_xact_all_tables
dbe_perf	summary_stat_xact_sys_tables	gs_summary_stat_xact_sys_tables
dbe_perf	summary_stat_xact_user_functions	gs_summary_stat_xact_user_functions
dbe_perf	summary_stat_xact_user_tables	gs_summary_stat_xact_user_tables
dbe_perf	summary_statement	gs_summary_statement
dbe_perf	summary_statement_count	gs_summary_statement_count
dbe_perf	summary_statio_all_indexes	gs_summary_statio_all_indexes
dbe_perf	summary_statio_all_sequences	gs_summary_statio_all_sequences
dbe_perf	summary_statio_all_tables	gs_summary_statio_all_tables
dbe_perf	summary_statio_sys_indexes	gs_summary_statio_sys_indexes
dbe_perf	summary_statio_sys_sequences	gs_summary_statio_sys_sequences
dbe_perf	summary_statio_sys_tables	gs_summary_statio_sys_tables
dbe_perf	summary_statio_user_indexes	gs_summary_statio_user_indexes
dbe_perf	summary_statio_user_sequences	gs_summary_statio_user_sequences
dbe_perf	summary_statio_user_tables	gs_summary_statio_user_tables
dbe_perf	summary_transactions_prepared_xacts	gs_summary_transactions_prepared_xacts
dbe_perf	summary_transactions_running_xacts	gs_summary_transactions_running_xacts
dbe_perf	summary_user_login	gs_summary_user_login
dbe_perf	summary_workload_sql_count	gs_summary_workload_sql_count
dbe_perf	summary_workload_sql_elapse_time	gs_summary_workload_sql_elapse_time
dbe_perf	summary_workload_transaction	gs_summary_workload_transaction
dbe_perf	thread_wait_status	gs_thread_wait_status
dbe_perf	track_memory_context_detail	gs_track_memory_context_detail
dbe_perf	transactions_prepared_xacts	gs_transactions_prepared_xacts
dbe_perf	transactions_running_xacts	gs_transactions_running_xacts
dbe_perf	user_login	gs_user_login
dbe_perf	user_transaction	gs_user_transaction
dbe_perf	wait_event_info	gs_wait_event_info
dbe_perf	wait_events	gs_wait_events
dbe_perf	wlm_cgroup_config	gs_wlm_cgroup_config
dbe_perf	wlm_cluster_resource_runtime	gs_wlm_cluster_resource_runtime
dbe_perf	wlm_controlgroup_config	gs_wlm_controlgroup_config
dbe_perf	wlm_controlgroup_ng_config	gs_wlm_controlgroup_ng_config
dbe_perf	wlm_resourcepool_runtime	gs_wlm_resourcepool_runtime
dbe_perf	wlm_user_resource_config	gs_wlm_user_resource_config
dbe_perf	wlm_user_resource_runtime	gs_wlm_user_resource_runtime
dbe_perf	wlm_workload_history_info	gs_wlm_workload_history_info
dbe_perf	wlm_workload_runtime	gs_wlm_workload_runtime
dbe_perf	workload_sql_count	gs_workload_sql_count
dbe_perf	workload_sql_elapse_time	gs_workload_sql_elapse_time
dbe_perf	workload_transaction	gs_workload_transaction