Redshift Observatory

System Table Tracker

System view pg_catalog.stl_blocklist version 1.0.78160 / 2024-11-17

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

View Text

SELECT stll_blocklist.logtime,
       stll_blocklist.slice,
       stll_blocklist.col,
       stll_blocklist.tbl,
       stll_blocklist.blocknum,
       stll_blocklist.num_values,
       stll_blocklist.extended_limits,
       stll_blocklist.minvalue,
       stll_blocklist.maxvalue,
       stll_blocklist.sb_pos,
       stll_blocklist.pinned,
       stll_blocklist.on_disk,
       stll_blocklist.backed_up,
       stll_blocklist.modified,
       stll_blocklist.hdr_modified,
       stll_blocklist.unsorted,
       stll_blocklist.tombstone,
       stll_blocklist.preferred_diskno,
       stll_blocklist.temporary,
       stll_blocklist.newblock,
       stll_blocklist.num_readers,
       stll_blocklist.id,
       stll_blocklist.flags
FROM stll_blocklist
WHERE stll_blocklist.access_control = 0
   OR stll_blocklist.access_control IS NULL
   OR NOT is_seclog_downgrade_enabled()

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