첨부 소스 코드는 나눔고딕코딩 폰트를 사용합니다.
728x90
반응형
728x170
SELECT
    RELNAME      AS TABLE_NAME
   ,INDEXRELNAME AS INDEX_NAME
   ,IDX_SCAN
   ,IDX_TUP_READ
   ,IDX_TUP_FETCH
   ,PG_SIZE_PRETTY(PG_RELATION_SIZE(INDEXRELNAME::REGCLASS))
FROM  PG_STAT_ALL_INDEXES
WHERE SCHEMANAME    = 'public'
AND   IDX_SCAN      = 0
AND   IDX_TUP_READ  = 0
AND   IDX_TUP_FETCH = 0
ORDER BY PG_RELATION_SIZE(INDEXRELNAME::REGCLASS) DESC;
728x90
반응형
그리드형(광고전용)
Posted by icodebroker

댓글을 달아 주세요