CNDBA社区
openGauss 5.0.0 中 pg_catalog 和 information_schema 模式 说明
作者：
dave
1 openGauss 模式说明
在之前的博客，我们介绍了模式和用户的关系，如下：
openGauss 数据库 表空间 用户模式 操作示例
https://www.cndba.cn/dave/article/116487
数据库创建时默认有一个名为public的Schema，且所有用户都拥有此Schema的usage权限，只有系统管理员和初始化用户可以在public Schema下创建函数、存储过程和同义词对象，其他用户即使赋予create权限后也不可以创建上述三种对象。
在openGauss中，我们可以查询所有的模式：
[dave@www.cndba.cn ~]$ gsql -d postgres -p 15500 -r
gsql ((openGauss 5.0.0 build a07d57c3) compiled at 2023-03-29 03:07:56 commit 0 last mr )
Non-SSL connection (SSL connection is recommended when requiring high-security)
Type "help" for help.
openGauss=# /dn+
List of schemas
Name | Owner | Access privileges | Description | WithBlockChain
-----------------+-------+-------------------+----------------------------------+----------------
blockchain | omm | | blockchain schema | f
cstore | omm | | reserved schema for DELTA tables | f
dave | dave | | | f
db4ai | omm | omm=UC/omm +| db4ai schema | f
| | =U/omm | |
dbe_perf | omm | | dbe_perf schema | f
dbe_pldebugger | omm | omm=UC/omm +| dbe_pldebugger schema | f
| | =U/omm | |
dbe_pldeveloper | omm | omm=UC/omm +| dbe_pldeveloper schema | f
| | =U/omm | |
dbe_sql_util | omm | omm=UC/omm +| sql util schema | f
| | =U/omm | |
pkg_service | omm | | pkg_service schema | f
public | omm | omm=UC/omm +| standard public schema | f
| | =U/omm | |
snapshot | omm | | snapshot schema | f
sqladvisor | omm | omm=UC/omm +| sqladvisor schema | f
| | =U/omm | |
(12 rows)
openGauss=#
注意这里显示的模式并不全。 openGauss支持的模式有如下：
- blockchain： 用于存储账本数据库特性中创建防篡改表时自动创建的用户历史表。
- cstore： 该模式用于储存列存表相关的辅助表如cudesc或者delta表。
- db4ai： 用于管理AI训练中不同版本的数据信息。
- dbe_perf： DBE_PERF Schema内视图主要用来诊断性能问题，也是WDR Snapshot的数据来源。数据库安装后，默认只有初始用户和监控管理员具有模式dbe_perf的权限，有权查看该模式下的视图和函数。
- dbe_pldebugger： 用于调试plpgsql函数及存储过程。
- snapshot： 用于管理WDR snapshot的相关的数据信息，默认初始化用户或监控管理员用户可以访问。
- sqladvisor： 用于分布列推荐，openGauss不可用。
- sys： 用于提供系统信息视图接口。
- pg_catalog： 用于维护系统的catalog信息，包含系统表和所有内置数据类型、函数、操作符。
- pg_toast： 用于存储大对象（系统内部使用）。
- public： 公共模式，缺省时，创建的表（以及其它对象）自动放入该模式。
- pkg_service： 用于管理package服务相关信息。
- information_schema：对应信息模式表，方便用户查看表／视图／函数信息提供的，它大多是视图。
我们这里看2个重要的模式：pg_catalog 和 information_schema。 我们对openGauss的进行运维操作，大部分都和这2个模式有关系。
2 information_schema 模式
2.1 模式下的对象
information_schema模式包含定义在当前数据库中对象的信息。这个模式的拥有者是初始数据库用户，并且该用户自然地拥有这个模式上的所有特权，包括删除它的能力。
openGauss是基于pg 9.2.4 修改的，所以继承了该版本的information_schema模式的对象。
- view_table_usage
- views
- information_schema_catalog_name
- administrable_role_authorizations
- applicable_roles
- attributes
- character_sets
- check_constraint_routine_usage
- check_constraints
- collations
- collation_character_set_applicability
- column_domain_usage
- column_options
- column_privileges
- column_udt_usage
- columns
- constraint_column_usage
- constraint_table_usage
- data_type_privileges
- domain_constraints
- domain_udt_usage
- domains
- element_types
- enabled_roles
- foreign_data_wrapper_options
- foreign_data_wrappers
- foreign_server_options
- foreign_servers
- foreign_table_options
- foreign_tables
- key_column_usage
- parameters
- referential_constraints
- role_column_grants
- role_routine_grants
- role_table_grants
- role_udt_grants
- role_usage_grants
- routine_privileges
- routines
- schemata
- sequences
- sql_features
- sql_implementation_info
- sql_languages
- sql_packages
- sql_parts
- sql_sizing
- sql_sizing_profiles
- table_constraints
- table_privileges
- tables
- triggered_update_columns
- triggers
- udt_privileges
- usage_privileges
- user_defined_types
- user_mapping_options
- user_mappings
- view_column_usage
- view_routine_usage
关于这些模式的对象和具体说明，可以直接参考pg 官网，共有61个：
另外openGauss中还新增了6个视图，如下：
- _PG_FOREIGN_DATA_WRAPPERS
- _PG_FOREIGN_SERVERS
- _PG_FOREIGN_TABLE_COLUMNS
- _PG_FOREIGN_TABLES
- _PG_USER_MAPPINGS
- INFORMATION_SCHEMA_CATALOG_NAME
2.2 使用示例
information_schema 模式的对象较多，可以根据需要查找相关的列。
获取表的信息：
[dave@www.cndba.cn ~]$ gsql -d postgres -p 15500 -r
gsql ((openGauss 5.0.0 build a07d57c3) compiled at 2023-03-29 03:07:56 commit 0 last mr )
Non-SSL connection (SSL connection is recommended when requiring high-security)
Type "help" for help.
openGauss=#
cndba=# select table_catalog,table_schema,table_name,table_type from information_schema.tables limit 15;
table_catalog | table_schema | table_name | table_type
---------------+--------------+-----------------------+------------
cndba | pg_catalog | pg_type | BASE TABLE
cndba | pg_catalog | gs_column_keys_args | BASE TABLE
cndba | pg_catalog | pgxc_prepared_xacts | VIEW
cndba | pg_catalog | pg_shadow | VIEW
cndba | pg_catalog | pg_roles | VIEW
cndba | pg_catalog | pg_user | VIEW
cndba | pg_catalog | pg_group | VIEW
cndba | pg_catalog | gs_labels | VIEW
cndba | pg_catalog | pg_rules | VIEW
cndba | pg_catalog | gs_auditing_access | VIEW
cndba | pg_catalog | pg_rlspolicies | VIEW
cndba | pg_catalog | gs_auditing_privilege | VIEW
cndba | pg_catalog | pg_views | VIEW
cndba | pg_catalog | gs_auditing | VIEW
cndba | pg_catalog | pg_tables | VIEW
(15 rows)
获取列的信息：
[dave@www.cndba.cn ~]$ gsql -d postgres -p 15500 -r
gsql ((openGauss 5.0.0 build a07d57c3) compiled at 2023-03-29 03:07:56 commit 0 last mr )
Non-SSL connection (SSL connection is recommended when requiring high-security)
Type "help" for help.
openGauss=#
cndba=# select table_name, column_name, data_type from information_schema.columns where table_name='pg_class';
table_name | column_name | data_type
------------+------------------+------------------
pg_class | relminmxid | xid
pg_class | relbucketkey | ARRAY
pg_class | relbucket | oid
pg_class | relfrozenxid64 | xid
pg_class | relreplident | "char"
pg_class | relacl | ARRAY
pg_class | relfrozenxid | xid32
pg_class | parttype | "char"
pg_class | relrowmovement | boolean
pg_class | relhasclusterkey | boolean
pg_class | relcmprs | tinyint
pg_class | relhassubclass | boolean
pg_class | relhastriggers | boolean
pg_class | relhasrules | boolean
pg_class | relhaspkey | boolean
pg_class | relhasoids | boolean
pg_class | relchecks | smallint
pg_class | relnatts | smallint
pg_class | relkind | "char"
pg_class | relpersistence | "char"
pg_class | relisshared | boolean
……
3 pg_catalog 模式
3.1 模式下的对象
在pg 官网看到有71个对象：
- pg_views
- pg_aggregate
- pg_am
- pg_amop
- pg_amproc
- pg_attrdef
- pg_attribute
- pg_authid
- pg_auth_members
- pg_cast
- pg_class
- pg_constraint
- pg_collation
- pg_conversion
- pg_database
- pg_db_role_setting
- pg_default_acl
- pg_depend
- pg_description
- pg_enum
- pg_extension
- pg_foreign_data_wrapper
- pg_foreign_server
- pg_foreign_table
- pg_index
- pg_inherits
- pg_language
- pg_largeobject
- pg_largeobject_metadata
- pg_namespace
- pg_opclass
- pg_operator
- pg_opfamily
- pg_pltemplate
- pg_proc
- pg_range
- pg_rewrite
- pg_seclabel
- pg_shdepend
- pg_shdescription
- pg_shseclabel
- pg_statistic
- pg_tablespace
- pg_trigger
- pg_ts_config
- pg_ts_config_map
- pg_ts_dict
- pg_ts_parser
- pg_ts_template
- pg_type
- pg_user_mapping
- System Views
- pg_available_extensions
- pg_available_extension_versions
- pg_cursors
- pg_group
- pg_indexes
- pg_locks
- pg_prepared_statements
- pg_prepared_xacts
- pg_roles
- pg_rules
- pg_seclabels
- pg_settings
- pg_shadow
- pg_stats
- pg_tables
- pg_timezone_abbrevs
- pg_timezone_names
- pg_user
- pg_user_mappings
详细说明可以参考官网：
在openGauss 5.0.0 版本中，pg_catalog 模式下的表和视图共有224个：
[dave@www.cndba.cn ~]$ gsql -d postgres -p 15500 -r
gsql ((openGauss 5.0.0 build a07d57c3) compiled at 2023-03-29 03:07:56 commit 0 last mr )
Non-SSL connection (SSL connection is recommended when requiring high-security)
Type "help" for help.
openGauss=#
cndba=# /dS
List of relations
Schema | Name | Type | Owner | Storage
------------+-----------------------------------+-------+-------+----------------------------------
pg_catalog | get_global_prepared_xacts | view | omm |
pg_catalog | gs_all_control_group_info | view | omm |
pg_catalog | gs_asp | table | omm |
pg_catalog | gs_auditing | view | omm |
pg_catalog | gs_auditing_access | view | omm |
pg_catalog | gs_auditing_policy | table | omm |
pg_catalog | gs_auditing_policy_access | table | omm |
pg_catalog | gs_auditing_policy_filters | table | omm |
pg_catalog | gs_auditing_policy_privileges | table | omm |
pg_catalog | gs_auditing_privilege | view | omm |
pg_catalog | gs_client_global_keys | table | omm |
pg_catalog | gs_client_global_keys_args | table | omm |
pg_catalog | gs_cluster_resource_info | view | omm |
pg_catalog | gs_column_keys | table | omm |
pg_catalog | gs_column_keys_args | table | omm |
pg_catalog | gs_comm_proxy_thread_status | view | omm |
pg_catalog | gs_db_privilege | table | omm |
pg_catalog | gs_db_privileges | view | omm |
pg_catalog | gs_encrypted_columns | table | omm |
pg_catalog | gs_encrypted_proc | table | omm |
pg_catalog | gs_file_stat | view | omm |
pg_catalog | gs_get_control_group_info | view | omm |
pg_catalog | gs_global_chain | table | omm |
pg_catalog | gs_global_config | table | omm |
pg_catalog | gs_gsc_memory_detail | view | omm |
pg_catalog | gs_instance_time | view | omm |
pg_catalog | gs_job_argument | table | omm |
pg_catalog | gs_job_attribute | table | omm |
pg_catalog | gs_labels | view | omm |
pg_catalog | gs_lsc_memory_detail | view | omm |
pg_catalog | gs_masking | view | omm |
pg_catalog | gs_masking_policy | table | omm |
pg_catalog | gs_masking_policy_actions | table | omm |
pg_catalog | gs_masking_policy_filters | table | omm |
pg_catalog | gs_matview | table | omm |
pg_catalog | gs_matview_dependency | table | omm |
pg_catalog | gs_matviews | view | omm |
pg_catalog | gs_model_warehouse | table | omm |
pg_catalog | gs_obsscaninfo | table | omm |
pg_catalog | gs_opt_model | table | omm |
pg_catalog | gs_os_run_info | view | omm |
pg_catalog | gs_package | table | omm |
pg_catalog | gs_policy_label | table | omm |
pg_catalog | gs_recyclebin | table | omm |
pg_catalog | gs_redo_stat | view | omm |
pg_catalog | gs_session_cpu_statistics | view | omm |
pg_catalog | gs_session_memory | view | omm |
pg_catalog | gs_session_memory_context | view | omm |
pg_catalog | gs_session_memory_detail | view | omm |
pg_catalog | gs_session_memory_statistics | view | omm |
pg_catalog | gs_session_stat | view | omm |
pg_catalog | gs_session_time | view | omm |
pg_catalog | gs_shared_memory_detail | view | omm |
pg_catalog | gs_sql_count | view | omm |
pg_catalog | gs_sql_patch | table | omm |
pg_catalog | gs_stat_session_cu | view | omm |
pg_catalog | gs_thread_memory_context | view | omm |
pg_catalog | gs_total_memory_detail | view | omm |
pg_catalog | gs_total_nodegroup_memory_detail | view | omm |
pg_catalog | gs_txn_snapshot | table | omm |
pg_catalog | gs_uid | table | omm |
pg_catalog | gs_wlm_cgroup_info | view | omm |
pg_catalog | gs_wlm_ec_operator_history | view | omm |
pg_catalog | gs_wlm_ec_operator_info | table | omm | {orientation=row,compression=no}
pg_catalog | gs_wlm_ec_operator_statistics | view | omm |
pg_catalog | gs_wlm_instance_history | table | omm | {orientation=row,compression=no}
pg_catalog | gs_wlm_operator_history | view | omm |
pg_catalog | gs_wlm_operator_info | table | omm | {orientation=row,compression=no}
pg_catalog | gs_wlm_operator_statistics | view | omm |
pg_catalog | gs_wlm_plan_encoding_table | table | omm | {orientation=row,compression=no}
pg_catalog | gs_wlm_plan_operator_history | view | omm |
pg_catalog | gs_wlm_plan_operator_info | table | omm | {orientation=row,compression=no}
pg_catalog | gs_wlm_rebuild_user_resource_pool | view | omm |
pg_catalog | gs_wlm_resource_pool | view | omm |
pg_catalog | gs_wlm_session_history | view | omm |
pg_catalog | gs_wlm_session_info | view | omm |
pg_catalog | gs_wlm_session_info_all | view | omm |
pg_catalog | gs_wlm_session_query_info_all | table | omm | {orientation=row,compression=no}
pg_catalog | gs_wlm_session_statistics | view | omm |
pg_catalog | gs_wlm_user_info | view | omm |
pg_catalog | gs_wlm_user_resource_history | table | omm | {orientation=row,compression=no}
pg_catalog | gs_wlm_workload_records | view | omm |
pg_catalog | mpp_tables | view | omm |
pg_catalog | pg_aggregate | table | omm |
pg_catalog | pg_am | table | omm |
pg_catalog | pg_amop | table | omm |
pg_catalog | pg_amproc | table | omm |
pg_catalog | pg_app_workloadgroup_mapping | table | omm |
pg_catalog | pg_attrdef | table | omm |
pg_catalog | pg_attribute | table | omm |
pg_catalog | pg_auth_history | table | omm |
pg_catalog | pg_auth_members | table | omm |
pg_catalog | pg_authid | table | omm |
pg_catalog | pg_available_extension_versions | view | omm |
pg_catalog | pg_available_extensions | view | omm |
pg_catalog | pg_cast | table | omm |
pg_catalog | pg_class | table | omm |
pg_catalog | pg_collation | table | omm |
pg_catalog | pg_comm_delay | view | omm |
pg_catalog | pg_comm_recv_stream | view | omm |
pg_catalog | pg_comm_send_stream | view | omm |
pg_catalog | pg_comm_status | view | omm |
pg_catalog | pg_constraint | table | omm |
pg_catalog | pg_control_group_config | view | omm |
pg_catalog | pg_conversion | table | omm |
pg_catalog | pg_cursors | view | omm |
pg_catalog | pg_database | table | omm |
pg_catalog | pg_db_role_setting | table | omm |
pg_catalog | pg_default_acl | table | omm |
pg_catalog | pg_depend | table | omm |
pg_catalog | pg_description | table | omm |
pg_catalog | pg_directory | table | omm |
pg_catalog | pg_enum | table | omm |
pg_catalog | pg_event_trigger | table | omm |
pg_catalog | pg_ext_stats | view | omm |
pg_catalog | pg_extension | table | omm |
pg_catalog | pg_extension_data_source | table | omm |
pg_catalog | pg_foreign_data_wrapper | table | omm |
pg_catalog | pg_foreign_server | table | omm |
pg_catalog | pg_foreign_table | table | omm |
pg_catalog | pg_get_invalid_backends | view | omm |
pg_catalog | pg_get_senders_catchup_time | view | omm |
pg_catalog | pg_group | view | omm |
pg_catalog | pg_gtt_attached_pids | view | omm | {security_barrier=true}
pg_catalog | pg_gtt_relstats | view | omm | {security_barrier=true}
pg_catalog | pg_gtt_stats | view | omm | {security_barrier=true}
pg_catalog | pg_hashbucket | table | omm |
pg_catalog | pg_index | table | omm |
pg_catalog | pg_indexes | view | omm |
pg_catalog | pg_inherits | table | omm |
pg_catalog | pg_job | table | omm |
pg_catalog | pg_job_proc | table | omm |
pg_catalog | pg_language | table | omm |
pg_catalog | pg_largeobject | table | omm |
pg_catalog | pg_largeobject_metadata | table | omm |
pg_catalog | pg_locks | view | omm |
pg_catalog | pg_namespace | table | omm |
pg_catalog | pg_node_env | view | omm |
pg_catalog | pg_object | table | omm |
pg_catalog | pg_obsscaninfo | table | omm |
pg_catalog | pg_opclass | table | omm |
pg_catalog | pg_operator | table | omm |
pg_catalog | pg_opfamily | table | omm |
pg_catalog | pg_os_threads | view | omm |
pg_catalog | pg_partition | table | omm |
pg_catalog | pg_pltemplate | table | omm |
pg_catalog | pg_prepared_statements | view | omm |
pg_catalog | pg_prepared_xacts | view | omm |
pg_catalog | pg_proc | table | omm |
pg_catalog | pg_publication | table | omm |
pg_catalog | pg_publication_rel | table | omm |
pg_catalog | pg_publication_tables | view | omm |
pg_catalog | pg_range | table | omm |
pg_catalog | pg_replication_origin | table | omm |
pg_catalog | pg_replication_origin_status | view | omm |
pg_catalog | pg_replication_slots | view | omm |
pg_catalog | pg_resource_pool | table | omm |
pg_catalog | pg_rewrite | table | omm |
pg_catalog | pg_rlspolicies | view | omm |
pg_catalog | pg_rlspolicy | table | omm |
pg_catalog | pg_roles | view | omm |
pg_catalog | pg_rules | view | omm |
pg_catalog | pg_running_xacts | view | omm |
pg_catalog | pg_seclabel | table | omm |
pg_catalog | pg_seclabels | view | omm |
pg_catalog | pg_session_iostat | view | omm |
pg_catalog | pg_session_wlmstat | view | omm |
pg_catalog | pg_set | table | omm |
pg_catalog | pg_settings | view | omm |
pg_catalog | pg_shadow | view | omm |
pg_catalog | pg_shdepend | table | omm |
pg_catalog | pg_shdescription | table | omm |
pg_catalog | pg_shseclabel | table | omm |
pg_catalog | pg_stat_activity | view | omm |
pg_catalog | pg_stat_activity_ng | view | omm |
pg_catalog | pg_stat_all_indexes | view | omm |
pg_catalog | pg_stat_all_tables | view | omm |
pg_catalog | pg_stat_bad_block | view | omm |
pg_catalog | pg_stat_bgwriter | view | omm |
pg_catalog | pg_stat_database | view | omm |
pg_catalog | pg_stat_database_conflicts | view | omm |
pg_catalog | pg_stat_replication | view | omm |
pg_catalog | pg_stat_subscription | view | omm |
pg_catalog | pg_stat_sys_indexes | view | omm |
pg_catalog | pg_stat_sys_tables | view | omm |
pg_catalog | pg_stat_user_functions | view | omm |
pg_catalog | pg_stat_user_indexes | view | omm |
pg_catalog | pg_stat_user_tables | view | omm |
pg_catalog | pg_stat_xact_all_tables | view | omm |
pg_catalog | pg_stat_xact_sys_tables | view | omm |
pg_catalog | pg_stat_xact_user_functions | view | omm |
pg_catalog | pg_stat_xact_user_tables | view | omm |
pg_catalog | pg_statio_all_indexes | view | omm |
pg_catalog | pg_statio_all_sequences | view | omm |
pg_catalog | pg_statio_all_tables | view | omm |
pg_catalog | pg_statio_sys_indexes | view | omm |
pg_catalog | pg_statio_sys_sequences | view | omm |
pg_catalog | pg_statio_sys_tables | view | omm |
pg_catalog | pg_statio_user_indexes | view | omm |
pg_catalog | pg_statio_user_sequences | view | omm |
pg_catalog | pg_statio_user_tables | view | omm |
pg_catalog | pg_statistic | table | omm |
pg_catalog | pg_statistic_ext | table | omm |
pg_catalog | pg_stats | view | omm |
pg_catalog | pg_subscription | table | omm |
pg_catalog | pg_subscription_rel | table | omm |
pg_catalog | pg_synonym | table | omm |
pg_catalog | pg_tables | view | omm |
pg_catalog | pg_tablespace | table | omm |
pg_catalog | pg_tde_info | view | omm |
pg_catalog | pg_thread_wait_status | view | omm |
pg_catalog | pg_timezone_abbrevs | view | omm |
pg_catalog | pg_timezone_names | view | omm |
pg_catalog | pg_total_memory_detail | view | omm |
pg_catalog | pg_total_user_resource_info | view | omm |
pg_catalog | pg_total_user_resource_info_oid | view | omm |
pg_catalog | pg_trigger | table | omm |
pg_catalog | pg_ts_config | table | omm |
pg_catalog | pg_ts_config_map | table | omm |
pg_catalog | pg_ts_dict | table | omm |
pg_catalog | pg_ts_parser | table | omm |
pg_catalog | pg_ts_template | table | omm |
pg_catalog | pg_type | table | omm |
pg_catalog | pg_user | view | omm |
pg_catalog | pg_user_mapping | table | omm |
pg_catalog | pg_user_mappings | view | omm |
pg_catalog | pg_user_status | table | omm |
pg_catalog | pg_variable_info | view | omm |
pg_catalog | pg_views | view | omm |
pg_catalog | pg_wlm_statistics | view | omm |
pg_catalog | pg_workload_group | table | omm |
pg_catalog | pgxc_class | table | omm |
pg_catalog | pgxc_group | table | omm |
pg_catalog | pgxc_node | table | omm |
pg_catalog | pgxc_prepared_xacts | view | omm |
pg_catalog | pgxc_slice | table | omm |
pg_catalog | pgxc_thread_wait_status | view | omm |
pg_catalog | plan_table | view | omm |
pg_catalog | plan_table_data | table | omm | {orientation=row,compression=no}
pg_catalog | statement_history | table | omm | {orientation=row,compression=no}
pg_catalog | streaming_cont_query | table | omm |
pg_catalog | streaming_reaper_status | table | omm |
pg_catalog | streaming_stream | table | omm |
pg_catalog | sys_dummy | view | omm |
(244 rows)
cndba=#
3.2 使用示例
pg_class：该表包含indexes , sequences, views, composite types, TOAST tables
cndba=# select relname,relnamespace,reltype from pg_catalog.pg_class limit 10;
relname | relnamespace | reltype
-------------------------------+--------------+---------
pg_type | 11 | 71
gs_column_keys_args | 11 | 12000
gs_column_keys_args_oid_index | 11 | 0
pgxc_prepared_xacts | 11 | 12053
pg_shadow | 11 | 12061
pg_roles | 11 | 12057
pg_user | 11 | 12069
pg_group | 11 | 12065
gs_labels | 11 | 12077
pg_rules | 11 | 12073
(10 rows)
查看表信息：
openGauss=# select schemaname,tablename,created from pg_tables limit 10;
schemaname | tablename | created
------------+---------------------------------------+------------------------------
pg_catalog | pg_type |
pg_catalog | gs_column_keys_args |
snapshot | tables_snap_timestamp | 2023-04-10 21:27:43.068232+08
snapshot | snapshot | 2023-04-10 21:27:43.068232+08
snapshot | snap_global_os_runtime | 2023-04-10 21:27:43.068232+08
snapshot | snap_global_os_threads | 2023-04-10 21:27:43.068232+08
snapshot | snap_global_instance_time | 2023-04-10 21:27:43.068232+08
snapshot | snap_summary_workload_sql_count | 2023-04-10 21:27:43.068232+08
snapshot | snap_summary_workload_sql_elapse_time | 2023-04-10 21:27:43.068232+08
snapshot | snap_global_workload_transaction | 2023-04-10 21:27:43.068232+08
(10 rows)
版权声明：本文为博主原创文章，未经博主允许不得转载。
