sys_size_pretty(sys_relation_size(x.indexrelid))ASindex_size, sys_size_pretty(sys_total_relation_size(x.indrelid))AStotal_sizeFROMsys_class cJOINsys_index xONc.oid=x.indrelidJOINsys_class iONi.oid=x.indexrelidLEFTJOINsys_namespace nONn.oid=c.relnamespaceWHEREc.relkind=ANY(ARRAY['r',...
(relid)) from sys_stat_user_indexes where schemaname='public' order by sys_relation_size(relid) desc; --查看指定表大小 select sys_size_pretty(sys_table_size('tablename')); --查看指定表的总大小 select sys_size_pretty(sys_total_relation_size('tablename')); --查看指定schema 里所有的表...
1. select sys_relation_size('public.t02')/1024|| 'KB' KB; 2. select sys_size_pretty(sys_relation_size('public.t02')); 统计表和与表关联的索引占用空间总量 1. select sys_total_relation_size('public.t02')/1024|| 'KB' KB; 2. select sys_size_pretty(sys_total_relation_size('public....
sys_size_pretty --- 61 MB (1 row) Time: 0.820 ms --查看主键大小 test=# select sys_size_pretty(sys_relation_size('test1_pkey')); sys_size_pretty --- 22 MB (1 row) test=# select sys_size_pretty(sys_relation_size('test2_pkey')); sys_size_pretty --- 22 MB (1 row) 更新数...
6.2.1.1 使用 sys_locks 所有活动事务持有的监控锁的基本配置即为系统视图 sys_locks.这个视图为每个可加锁的对象,已请求的锁模 式和相关事务包含一行记录. test=# select * from sys_locks; -[ RECORD 1 ]---+--- locktype | relation database | 16384 relation | 12168 page | tuple | virtualxid ...
SYS_NODE_TREE | TYPDEFAULT | TEXT | TYPACL | ACLITEM [] | Indexes: SYS_TYPE_OID_INDEX UNIQUE, BTREE (OID) SYS_TYPE_TYPNAME_NSP_INDEX UNIQUE, BTREE (TYPNAME, TYPNAMESPACE) 查看表SYS_TYPE的大小 TEST=# select sys_size_pretty(sys_relation_size (SYS_USER_MAPPING)); SYS_SIZE_PRETTY 0...
1. select sys_relation_size('public.t02')/1024|| 'KB' KB; 2. select sys_size_pretty(sys_relation_size('public.t02')); 统计表和与表关联的索引占用空间总量 1. select sys_total_relation_size('public.t02')/1024|| 'KB' KB; 2. select sys_size_pretty(sys_total_relation_size('public....
1. select sys_relation_size('public.t02')/1024|| 'KB' KB; 2. select sys_size_pretty(sys_relation_size('public.t02')); 统计表和与表关联的索引占用空间总量 1. select sys_total_relation_size('public.t02')/1024|| 'KB' KB; 2. select sys_size_pretty(sys_total_relation_size('public....
(sys_relation_size('tb_tb_p0')); sys_size_pretty --- 0 bytes (1 row) Time: 36.671 ms test=# select sys_size_pretty(sys_relation_size('tb_tb_p1')); sys_size_pretty --- 1980 MB (1 row) Time: 0.648 ms test=# select sys_size_pretty(sys_relation_size('tb_tb_p2')); sys_...
通过sys_stat_statements 查看数据库sql语句执行情况,发现有问题语句并进行优化 该视图可以查询内容包括 1、语句内容 2、语句执行次数 3、语句解析次数和时间 3、shared_buffer 使用情况是否用到了磁盘read 还是用到了 shared _buffer hit 4、temp_buffer ,work_me,maintance_men 命中情况 通过local字段排查 ...