在schema中运维SQL是怎样的一种状态呢？

select table_name from information_schema.tables where table_schema='myschema';

select table name, pg_total relation_size(quote _ident(table_name) from information_schema.tables where table schema ='myschema' order by 2 desc limit 5;

非分 区 表：select pg_size_pretty(pg_relation_size(public.t1);

分区 表：select pg_size_pretty(pg_total relation_size(public.t1));

select oid from pg_class where relname='b'and relnamespace in (select oid fro m pg_namespace where nspname='public');

select * from pg_stat_last_operation where objd='public.table_name'regclass:oid order by statime;

查看指定schema下所有表

查看指定schema下表大小由大到 下排序）

查看指定表大小

查看指定表public.b的oid

查看指定表public.table_name的 操作记录