- 查看数据库物理大小
select pg_size_pretty(pg_database_size('库'));
- 查看所有数据库大小
select datname,pg_size_pretty(pg_database_size(datname)) from pg_database;
- 查看表大小:
select pg_size_pretty(pg_relation_size('表'));
- 查看表和索引大小
select pg_size_pretty(pg_total_relation_size('表'));
- 检查表的数据是否均匀存放
select gp_segment_id,count(*) from 表 group by gp_segment_id;
-
正在执行的sql(可以配置日志的时候,打印慢查询,但是和正常日志冲突)
select current_query,query_start from pg_stat_activity ORDER BY query_start;