POSTGRESQL 查看数据库 数据表大小
2024-09-24 23:32:00
1、查看数据库大小：
select pg_database_size('log_analysis');
select pg_database_size('log_analysis');
pg_database_size
------------------
( 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; datname | size
--------------+---------
template1 | kB
template0 | kB
postgres | kB
b2c_product | GB
spider | MB
crm | MB
log_analysis | MB
( 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;
indexrelname | pg_size_pretty
------------------------------------------------------------+----------------
pk_dim_sight_area | kB
idx_area_dim_sight_area | kB
idx_city_dim_sight_area | kB
idx_country_dim_sight_area | kB
idx_region_dim_sight_area | kB
pk_dim_page_type | bytes
cpc_supplier_sight_daily_pkey | 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;
relname | pg_size_pretty
------------------------------------------------+----------------
dim_sight_area | kB
dim_page_type | bytes
wirelessapi_log_2014_08_08 | bytes
trace_log_2014_08_04 | bytes
dm_mobile | bytes
trace_log_2014_07_14 | bytes
最新文章
- 博客代码：iframe—网页中嵌入其他网页
- 新浪微博iOS客户端架构与优化之路
- SQL Server T-SQL高级查询(转)
- IE下实现类似CSS3 text-shadow文字阴影的几种方法
- crtmpserver系列之一：流媒体概述
- TreeList的VisibleNodesCount，Noes.Count，AllNdoesCount以及焦点节点的删除
- android Bitmap（将视图转为bitmap对象）
- java基础(七)-----深入剖析Java中的装箱和拆箱
- PHP 面向切面编程
- 第十七节: EF的CodeFirst模式的四种初始化策略和通过Migration进行数据的迁移
- SQL的几种连接：内连接、外连接（左连接、右连接、全连接）
- plsql developer 11 + Oracle 11g 开发环境setup
- 一次enq: TX - index contention等待事件处理
- Java 虚拟机面试题全面解析（干货）
- CF528D Fuzzy Search 【NTT】
- 浅谈Java中的栈和堆
- 可以替代alert 的漂亮的Js弹框
- redis 使用管道提升写入的性能[pipeline]
- Appium 并发多进程基于 Pytest框架
- docker中宿主机与容器（container）互相拷贝传递文件的方法