【笔记】GaussDB常用命令

1. 常用系统表

1. deb_perf.workload_sql_count 当前节点workload上SQL数量分布

2. 常用SQL

#显示外部数据封装器的信息
select * from information_schema._PG_FOREIGN_DATA_WRAPPERS;

#显示外部服务器的信息
select * from information_schema._PG_FOREIGN_SERVERS;

#显示外部表的列信息
select * from information_schema._PG_FOREIGN_TABLE_COLUMNS;

#存储所有的定义在本数据库的外部表信息
select * from information_schema.schemata;

#显示当前操作系统运行的状态信息
select * from dbe_perf.os_runtime;

select * from dbe_perf.statement_count;

select * from dbe_perf.GLOBAL_STATEMENT_COUNT;

select * from PG_NODE_ENV;

select * from PG_ROLES;

#分布式
select * from PGXC_NODE_ENV;

#主备
select * from PGXC_PREPARED_XACTS;

select * from GS_OS_RUN_INFO;

select * from DB_TYPES;

select * from PGXC_NODE;

select * from dbe_perf.NODE_NAME;

select * from dbe_perf.workload_sql_count;

select * from dbe_perf.MEMORY_NODE_DETAIL;

select * from dbe_perf.TRANSACTIONS_RUNNING_XACTS;

select * from dbe_perf.GLOBAL_TRANSACTIONS_PREPARED_XACTS;