3-2-5. 인덱스의 실제 크기

-- [SQL-3-2-5-a]

SELECT  t1.relname ,t1.relpages block_cnt 
        ,pg_size_pretty(pg_relation_size((t1.oid))) size
FROM    pg_class t1
WHERE   t1.oid = 'startdbpg.tr_ord_big'::regclass;
SQL
복사

-- [SQL-3-2-5-b]

SELECT  t1.relname ,t1.relpages block_cnt 
        ,pg_size_pretty(pg_relation_size((t1.oid))) size
FROM    pg_class t1
WHERE   t1.oid = 'startdbpg.tr_ord_big_pk'::regclass;
SQL
복사