Redshift Observatory

System Table Tracker

System view pg_catalog.stl_block_needs_recovery version 1.0.41881 / 2022-09-30

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