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