Redshift Observatory

System Table Tracker

System view pg_catalog.svv_diskusage version 1.0.41465 / 2022-09-10

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