Redshift Observatory

System Table Tracker

System view pg_catalog.svv_diskusage version 1.0.52931 / 2023-07-07

schema	name	column	data type
pg_catalog	svv_diskusage	backed_up	int4
pg_catalog	svv_diskusage	blocknum	int4
pg_catalog	svv_diskusage	col	int4
pg_catalog	svv_diskusage	db_id	int4
pg_catalog	svv_diskusage	extended_limits	int4
pg_catalog	svv_diskusage	flags	int4
pg_catalog	svv_diskusage	hdr_modified	int4
pg_catalog	svv_diskusage	id	char(64)
pg_catalog	svv_diskusage	maxvalue	int8
pg_catalog	svv_diskusage	minvalue	int8
pg_catalog	svv_diskusage	modified	int4
pg_catalog	svv_diskusage	name	char(128)
pg_catalog	svv_diskusage	newblock	int4
pg_catalog	svv_diskusage	num_readers	int4
pg_catalog	svv_diskusage	num_values	int4
pg_catalog	svv_diskusage	on_disk	int4
pg_catalog	svv_diskusage	pinned	int4
pg_catalog	svv_diskusage	preferred_diskno	int4
pg_catalog	svv_diskusage	sb_pos	int4
pg_catalog	svv_diskusage	slice	int4
pg_catalog	svv_diskusage	tbl	int4
pg_catalog	svv_diskusage	temporary	int4
pg_catalog	svv_diskusage	tombstone	int4
pg_catalog	svv_diskusage	unsorted	int4

View Text

SELECT a.db_id,
       a.name,
       b.slice,
       b.col,
       b.tbl,
       b.blocknum,
       b.num_values,
       b.extended_limits,
       b.minvalue,
       b.maxvalue,
       b.sb_pos,
       b.pinned,
       b.on_disk,
       b.backed_up,
       b.modified,
       b.hdr_modified,
       b.unsorted,
       b.tombstone,
       b.preferred_diskno,
       b.temporary,
       b.newblock,
       b.num_readers,
       b.id,
       b.flags
FROM stv_tbl_perm AS a, stv_blocklist AS b
WHERE a.id = b.tbl
  AND a.slice = b.slice

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