Redshift Research Project

System Table Tracker

System view pg_catalog.pg_indexes version 1.0.39009 / 2022-06-08

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