Redshift Observatory

System Table Tracker

System view pg_catalog.stl_leader_snapshot version 1.0.74097 / 2024-09-02

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