-- [SQL-5-3-4-a]
SELECT REPLACE(t1.indexname,t1.tablename||'_' ,'') ix
,pg_size_pretty(pg_relation_size((t1.schemaname || '.' || t1.indexname)::regclass)) ix_size
,t1.indexdef
FROM pg_indexes t1
WHERE t1.tablename = 'tr_ord_big'
ORDER BY t1.indexname;
SQL
복사
-- [SQL-5-3-4-b]
SELECT pg_size_pretty(pg_relation_size('startdbpg.tr_ord_big'::regclass)) tab_size;
SQL
복사

