[DATABASE/POSTGRESQL] 인덱스 정보 조회하기

icodebroker POSTGRESQL 2024-06-18

■ 인덱스 정보를 조회하는 방법을 보여준다.

▶ 예제 코드 (SQL)


SELECT
    A.TABLENAME
   ,A.INDEXNAME
   ,B.COLUMN_NAME
FROM  PG_CATALOG.PG_INDEXES      A
     ,INFORMATION_SCHEMA.COLUMNS B
WHERE A.SCHEMANAME = 'public'
AND   A.TABLENAME = B.TABLE_NAME
ORDER BY
    A.TABLENAME ASC
   ,A.INDEXNAME ASC
   ,B.COLUMN_NAME;

1

2

3

4

5

6

7

8

9

10

11

12

13

14

SELECT

A.TABLENAME

,A.INDEXNAME

,B.COLUMN_NAME

FROM PG_CATALOG.PG_INDEXES A

,INFORMATION_SCHEMA.COLUMNS B

WHERE A.SCHEMANAME = 'public'

AND A.TABLENAME = B.TABLE_NAME

ORDER BY

A.TABLENAME ASC

,A.INDEXNAME ASC

,B.COLUMN_NAME;