Redshift Observatory

System Table Tracker

System view pg_catalog.pg_class_info version 1.0.70890 / 2024-07-14

schema	name	column	data type
pg_catalog	pg_class_info	relacl	aclitem[]
pg_catalog	pg_class_info	relam	oid
pg_catalog	pg_class_info	relchecks	int2
pg_catalog	pg_class_info	relcreationtime	timestamp
pg_catalog	pg_class_info	reldiststyle	int2
pg_catalog	pg_class_info	releffectivediststyle	int2
pg_catalog	pg_class_info	relexternid	oid
pg_catalog	pg_class_info	relfilenode	oid
pg_catalog	pg_class_info	relfkeys	int2
pg_catalog	pg_class_info	relhasindex	bool
pg_catalog	pg_class_info	relhasoids	bool
pg_catalog	pg_class_info	relhaspkey	bool
pg_catalog	pg_class_info	relhasrules	bool
pg_catalog	pg_class_info	relhassubclass	bool
pg_catalog	pg_class_info	relispinned	bool
pg_catalog	pg_class_info	relisreplicated	bool
pg_catalog	pg_class_info	relisshared	bool
pg_catalog	pg_class_info	relkind	char(1)
pg_catalog	pg_class_info	relname	name
pg_catalog	pg_class_info	relnamespace	oid
pg_catalog	pg_class_info	relnatts	int2
pg_catalog	pg_class_info	reloid	oid
pg_catalog	pg_class_info	relowner	int4
pg_catalog	pg_class_info	relpages	int4
pg_catalog	pg_class_info	relprojbaseid	oid
pg_catalog	pg_class_info	relrefs	int2
pg_catalog	pg_class_info	reltablespace	oid
pg_catalog	pg_class_info	reltoastidxid	oid
pg_catalog	pg_class_info	reltoastrelid	oid
pg_catalog	pg_class_info	reltriggers	int2
pg_catalog	pg_class_info	reltuples	float4
pg_catalog	pg_class_info	reltype	oid
pg_catalog	pg_class_info	relukeys	int2

View Text

SELECT pgc.oid AS reloid,
       pgc.relname,
       pgc.relnamespace,
       pgc.reltype,
       pgc.relowner,
       pgc.relam,
       pgc.relfilenode,
       pgc.reltablespace,
       pgc.relpages,
       pgc.reltuples,
       pgc.reltoastrelid,
       pgc.reltoastidxid,
       pgc.relhasindex,
       pgc.relisshared,
       pgc.relkind,
       pgc.relnatts,
       pgc.relexternid,
       pgc.relisreplicated,
       pgc.relispinned,
       pgc.reldiststyle,
       pgc.relprojbaseid,
       pgc.relchecks,
       pgc.reltriggers,
       pgc.relukeys,
       pgc.relfkeys,
       pgc.relrefs,
       pgc.relhasoids,
       pgc.relhaspkey,
       pgc.relhasrules,
       pgc.relhassubclass,
       pgc.relacl,
       COALESCE(CAST(pgce0.value AS smallint),
                pgc.reldiststyle) AS releffectivediststyle,
       date_add(CAST('microsecond' AS text),
                CAST(pgce1.value AS bigint),
                CAST('2000-01-01 00:00:00' AS timestamp)) AS relcreationtime
FROM pg_class AS pgc
     LEFT JOIN pg_class_extended AS pgce0 ON pgc.oid = pgce0.reloid
                                         AND pgce0.colnum = 0
     LEFT JOIN pg_class_extended AS pgce1 ON pgc.oid = pgce1.reloid
                                         AND pgce1.colnum = 1

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