postgres数据库查看数据表大小

最新推荐文章于 2024-05-29 09:42:56 发布

MarcyTheLibrarian

最新推荐文章于 2024-05-29 09:42:56 发布

阅读量2.6k

点赞数 3

分类专栏： linux pgsql 文章标签：数据库 postgresql

本文链接：https://blog.csdn.net/twi_twi/article/details/128367141

版权

linux 同时被 2 个专栏收录

38 篇文章 2 订阅

订阅专栏

pgsql

13 篇文章 0 订阅

订阅专栏

1 查看某个数据库大小

select pg_database_size('【数据库名】');

2 查看多个数据库大小

select pg_database.datname, 
	   pg_size_pretty (pg_database_size(pg_database.datname)) 
AS size 
from pg_database;

3 按顺序查看索引

select indexrelname, pg_size_pretty(pg_relation_size(relid)) 
from pg_stat_user_indexes 
where schemaname='public' 
order by pg_relation_size(relid) desc;

4 查看所有表的大小

select relname, pg_size_pretty(pg_relation_size(relid)) 
from pg_stat_user_tables 
where schemaname='public' 
order by pg_relation_size(relid) desc;

5 查看特定表的大小

select relname, pg_size_pretty(pg_relation_size(relid)) 
from pg_stat_user_tables 
where schemaname='public' and relname='【表名】'
order by pg_relation_size(relid) desc;