Redshift Research Project

System Table Tracker

System view pg_catalog.pg_indexes version 1.0.67699 / 2024-05-26

schema name column data type
pg_catalog pg_indexes indexdef text
pg_catalog pg_indexes indexname name
pg_catalog pg_indexes schemaname name
pg_catalog pg_indexes tablename name
pg_catalog pg_indexes tablespace name

View Text

SELECT n.nspname AS schemaname,
       c.relname AS tablename,
       i.relname AS indexname,
       t.spcname AS tablespace,
       pg_get_indexdef(i.oid) AS indexdef
FROM pg_index AS x
     INNER JOIN pg_class AS c ON c.oid = x.indrelid
     INNER JOIN pg_class AS i ON i.oid = x.indexrelid
     LEFT JOIN pg_namespace AS n ON n.oid = c.relnamespace
     LEFT JOIN pg_tablespace AS t ON t.oid = i.reltablespace
WHERE c.relkind = CAST('r' AS "char")
  AND i.relkind = CAST('i' AS "char")

Home 3D Друк Blog Bring-Up Times Consultancy Cross-Region Benchmarks Email Forums IRC Mailing Lists Reddit Redshift Price Tracker Redshift Version Tracker Redshift Workbench System Table Tracker The Known Universe Twitter White Papers