更新时间:2025-09-12 GMT+08:00
分享

Schema

继承了DBE_PLDEVELOPER、SYS Schema,具体请参考《开发指南》的“Schema”章节。继承了DBE_PERF和PG_CATALOG Schema的部分视图同时,在此Schema下新增gs_前缀的更名视图。 其对应关系如表1所示。 为了保证兼容性,请优先使用带有gs_前缀的别名视图。

表1 M-Compatibility模式数据库系统视图别名

schema名称

原视图名称

视图别名

dbe_perf

ai_watchdog_detection_warnings

gs_ai_watchdog_detection_warnings

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

config_settings

gs_config_settings

dbe_perf

file_iostat

gs_file_iostat

dbe_perf

file_redo_iostat

gs_file_redo_iostat

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_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_instance_time

gs_global_instance_time

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_clean

gs_global_plancache_clean

dbe_perf

global_plancache_status

gs_global_plancache_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_workload_transaction

gs_global_workload_transaction

dbe_perf

slow_query_history

gs_slow_query_history

dbe_perf

slow_query_info

gs_slow_query_info

dbe_perf

instance_time

gs_instance_time

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

node_name

gs_node_name

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

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

shared_memory_detail

gs_shared_memory_detail

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_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

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_events

gs_wait_events

dbe_perf

wlm_user_resource_config

gs_wlm_user_resource_config

dbe_perf

wlm_user_resource_runtime

gs_wlm_user_resource_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

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

ai_watchdog_ftask_status

gs_ai_watchdog_ftask_status

dbe_perf

perf_query

gs_perf_query

pg_catalog

dv_sessions

gs_dv_sessions

pg_catalog

dv_session_longops

gs_dv_session_longops

pg_catalog

mpp_tables

gs_mpp_tables

pg_catalog

get_global_prepared_xacts

gs_get_global_prepared_xacts

pg_catalog

pgxc_prepared_xacts

gs_pgxc_prepared_xacts

pg_catalog

pgxc_thread_wait_status

gs_pgxc_thread_wait_status

pg_catalog

pg_comm_delay

gs_comm_delay

pg_catalog

pg_comm_recv_stream

gs_comm_recv_stream

pg_catalog

pg_comm_send_stream

gs_comm_send_stream

pg_catalog

pg_comm_status

gs_comm_status

pg_catalog

session_memory

gs_session_memory

相关文档