Redshift Observatory

System Table Tracker

System view pg_catalog.stl_lbc_replay_stats version 1.0.43980 / 2022-11-18

schema	name	column	data type
pg_catalog	stl_lbc_replay_stats	active_applied	int4
pg_catalog	stl_lbc_replay_stats	active_seen	int4
pg_catalog	stl_lbc_replay_stats	checkpoint_applied	int4
pg_catalog	stl_lbc_replay_stats	checkpoint_seen	int4
pg_catalog	stl_lbc_replay_stats	encrypted_log_blocks_seen	int4
pg_catalog	stl_lbc_replay_stats	end_time	timestamp
pg_catalog	stl_lbc_replay_stats	inactive_applied	int4
pg_catalog	stl_lbc_replay_stats	inactive_seen	int4
pg_catalog	stl_lbc_replay_stats	index_applied	int4
pg_catalog	stl_lbc_replay_stats	index_seen	int4
pg_catalog	stl_lbc_replay_stats	log_blocks_seen	int4
pg_catalog	stl_lbc_replay_stats	node	int4
pg_catalog	stl_lbc_replay_stats	replay_type	char(32)
pg_catalog	stl_lbc_replay_stats	start_time	timestamp

View Text

SELECT stll_lbc_replay_stats.replay_type,
       stll_lbc_replay_stats.node,
       stll_lbc_replay_stats.start_time,
       stll_lbc_replay_stats.end_time,
       stll_lbc_replay_stats.index_seen,
       stll_lbc_replay_stats.index_applied,
       stll_lbc_replay_stats.active_seen,
       stll_lbc_replay_stats.active_applied,
       stll_lbc_replay_stats.inactive_seen,
       stll_lbc_replay_stats.inactive_applied,
       stll_lbc_replay_stats.checkpoint_seen,
       stll_lbc_replay_stats.checkpoint_applied,
       stll_lbc_replay_stats.log_blocks_seen,
       stll_lbc_replay_stats.encrypted_log_blocks_seen
FROM stll_lbc_replay_stats

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