Redshift Observatory

System Table Tracker

System view pg_catalog.stl_leader_snapshot version 1.0.76832 / 2024-10-24

schema name column data type
pg_catalog stl_leader_snapshot currenttime timestamp
pg_catalog stl_leader_snapshot last_wal_chain_block_num int4
pg_catalog stl_leader_snapshot num_snapshot_blocks int4
pg_catalog stl_leader_snapshot persist_duration int8
pg_catalog stl_leader_snapshot pid int4
pg_catalog stl_leader_snapshot snapshot_creation_duration int8
pg_catalog stl_leader_snapshot xid int8

View Text

SELECT stll_leader_snapshot.currenttime,
       stll_leader_snapshot.num_snapshot_blocks,
       stll_leader_snapshot.snapshot_creation_duration,
       stll_leader_snapshot.persist_duration,
       stll_leader_snapshot.last_wal_chain_block_num,
       stll_leader_snapshot.pid,
       stll_leader_snapshot.xid
FROM stll_leader_snapshot


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