pg_relation_size(pi.schemaname||'.'||pi.indexname),--指定的单个索引pg_indexes_size(pi.schemaname||'.'||pi.tablename)--表上的所有索引frompg_tables ptleftouterjoinpg_indexespionpt.schemaname||'.'||pt.tablename=pi.schemaname||'.'||pi.tablenamewhere1=1andpt.schemaname='myschema'and...
postgres=# create table x (a int); CREATE TABLE postgres=# insert into x values (1),(2),(3),(4); INSERT 0 4 postgres=# delete from x where a%2 =0; DELETE 2 postgres=# \x Expanded display is on. postgres=# select * from pg_stat_all_tables where relname...