系统视图
M-Compatibility模式数据库继承了GaussDB原有的部分系统视图,继承的系统视图如表1所示,系统视图的具体定义及视图信息请参见《开发指南》中“系统表和系统视图”章节。

- 当前M-Compatibility模式数据库不支持审计能力,gs_auditing、gs_auditing_access和gs_auditing_privilege视图数据为空。
- 当前M-Compatibility模式数据库不支持脱敏能力,gs_masking视图数据为空。
视图分类 | 视图名称 |
|---|---|
DATABASE LINKS | gs_db_links |
分区表 | gs_stat_all_partitions |
gs_stat_xact_all_partitions | |
gs_statio_all_partitions | |
审计 | gs_auditing |
gs_auditing_access | |
gs_auditing_privilege | |
用户和权限管理 | gs_db_privileges |
gs_labels | |
动态脱敏 | gs_masking |
通信 | gs_comm_listen_address_ext_info |
gs_get_listen_address_ext_info | |
gs_static_threadpool_ctrl_status | |
段页式存储 | 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 | |
负载管理 | gs_wlm_cgroup_info |
gs_wlm_rebuild_user_resource_pool | |
gs_wlm_user_info | |
OLTP表压缩 | 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 | |
物化视图 | gs_matviews |
其他系统视图 | 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 | |
多租户 | mtd_user (不建议在分布式下使用和查看本视图) |
废弃系统视图 | 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 |
中间视图主要是在分布式上CN用来收集对应视图时使用,具体视图如表2所示,不建议用户直接使用。
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 |
M-Compatibility模式数据库还继承了dv_session_longops、dv_sessions等GaussDB原有的系统视图,在继承GaussDB原有系统视图的同时,在对应系统视图下建立了以gs_为前缀的视图别名,如表3所示。 为了保证兼容性,请优先使用带有gs_前缀的别名视图。
视图名称 | 视图别名 |
|---|---|
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 |

