Redshift Observatory

System Table Tracker

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

schema	name	column	data type
pg_catalog	stl_block_needs_recovery	blkid	char(64)
pg_catalog	stl_block_needs_recovery	blknum	int8
pg_catalog	stl_block_needs_recovery	col	int4
pg_catalog	stl_block_needs_recovery	flags	int4
pg_catalog	stl_block_needs_recovery	global_slice	int4
pg_catalog	stl_block_needs_recovery	logtime	timestamp
pg_catalog	stl_block_needs_recovery	node	int4
pg_catalog	stl_block_needs_recovery	num_values	int4
pg_catalog	stl_block_needs_recovery	reason	char(24)
pg_catalog	stl_block_needs_recovery	reps	int4
pg_catalog	stl_block_needs_recovery	rep_strings	char(512)
pg_catalog	stl_block_needs_recovery	s3_state	char(32)
pg_catalog	stl_block_needs_recovery	sb_pos	int4
pg_catalog	stl_block_needs_recovery	tbl	int4
pg_catalog	stl_block_needs_recovery	xid	int8

View Text

SELECT stll_block_needs_recovery.logtime,
       stll_block_needs_recovery.xid,
       stll_block_needs_recovery.node,
       stll_block_needs_recovery.tbl,
       stll_block_needs_recovery.col,
       stll_block_needs_recovery.global_slice,
       stll_block_needs_recovery.blknum,
       stll_block_needs_recovery.sb_pos,
       stll_block_needs_recovery.blkid,
       stll_block_needs_recovery.reason,
       stll_block_needs_recovery.num_values,
       stll_block_needs_recovery.flags,
       stll_block_needs_recovery.reps,
       stll_block_needs_recovery.s3_state,
       stll_block_needs_recovery.rep_strings
FROM stll_block_needs_recovery

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