首页 > 代码库 > POSTGRESQL 查看数据库 数据表大小
POSTGRESQL 查看数据库 数据表大小
1、查看数据库大小：
select pg_database_size(‘log_analysis‘);
***(Single step mode: verify command)*******************************************select pg_database_size(‘log_analysis‘);***(press return to proceed or enter x and return to cancel)******************** pg_database_size ------------------ 23799992(1 row)
2、select pg_database.datname, pg_size_pretty (pg_database_size(pg_database.datname)) AS size from pg_database;
log_analysis=# select pg_database.datname, pg_size_pretty (pg_database_size(pg_database.datname)) AS size from pg_database; ***(Single step mode: verify command)*******************************************select pg_database.datname, pg_size_pretty (pg_database_size(pg_database.datname)) AS size from pg_database;***(press return to proceed or enter x and return to cancel)******************** datname | size --------------+--------- template1 | 6594 kB template0 | 6457 kB postgres | 6586 kB b2c_product | 27 GB spider | 11 MB crm | 54 MB log_analysis | 23 MB(7 rows)log_analysis=#
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;
log_analysis=# select indexrelname, pg_size_pretty(pg_relation_size(relid)) from pg_stat_user_indexes where schemaname=‘public‘ order by pg_relation_size(relid) desc;***(Single step mode: verify command)*******************************************select indexrelname, pg_size_pretty(pg_relation_size(relid)) from pg_stat_user_indexes where schemaname=‘public‘ order by pg_relation_size(relid) desc;***(press return to proceed or enter x and return to cancel)******************** indexrelname | pg_size_pretty ------------------------------------------------------------+---------------- pk_dim_sight_area | 184 kB idx_area_dim_sight_area | 184 kB idx_city_dim_sight_area | 184 kB idx_country_dim_sight_area | 184 kB idx_region_dim_sight_area | 184 kB pk_dim_page_type | 8192 bytes cpc_supplier_sight_daily_pkey | 0 bytes
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;
log_analysis=# select relname, pg_size_pretty(pg_relation_size(relid)) from pg_stat_user_tables where schemaname=‘public‘ order by pg_relation_size(relid) desc;***(Single step mode: verify command)*******************************************select relname, pg_size_pretty(pg_relation_size(relid)) from pg_stat_user_tables where schemaname=‘public‘ order by pg_relation_size(relid) desc;***(press return to proceed or enter x and return to cancel)******************** relname | pg_size_pretty ------------------------------------------------+---------------- dim_sight_area | 184 kB dim_page_type | 8192 bytes wirelessapi_log_2014_08_08 | 0 bytes trace_log_2014_08_04 | 0 bytes dm_mobile | 0 bytes trace_log_2014_07_14 | 0 bytes
声明：以上内容来自用户投稿及互联网公开渠道收集整理发布，本网站不拥有所有权，未作人工编辑处理，也不承担相关法律责任，若内容有误或涉及侵权可进行投诉： 投诉/举报 工作人员会在5个工作日内联系你，一经查实，本站将立刻删除涉嫌侵权内容。