Redshift Observatory

System Table Tracker

System view pg_catalog.stl_async_rerep_worker_stats version 1.0.77706 / 2024-11-05

schema	name	column	data type
pg_catalog	stl_async_rerep_worker_stats	completed_dirty_writes	int8
pg_catalog	stl_async_rerep_worker_stats	completed_rerep_reads	int8
pg_catalog	stl_async_rerep_worker_stats	completed_rerep_writes	int8
pg_catalog	stl_async_rerep_worker_stats	ignored_comp_block_pinned_during_write	int8
pg_catalog	stl_async_rerep_worker_stats	ignored_comp_block_state_changed	int8
pg_catalog	stl_async_rerep_worker_stats	ignored_comp_table_not_in_active_set	int8
pg_catalog	stl_async_rerep_worker_stats	ignored_dirty_writes	int8
pg_catalog	stl_async_rerep_worker_stats	ignored_rerep_reads	int8
pg_catalog	stl_async_rerep_worker_stats	ignored_rerep_writes	int8
pg_catalog	stl_async_rerep_worker_stats	issued_dirty_writes	int8
pg_catalog	stl_async_rerep_worker_stats	issued_rerep_reads	int8
pg_catalog	stl_async_rerep_worker_stats	issued_rerep_writes	int8
pg_catalog	stl_async_rerep_worker_stats	logtime	timestamp
pg_catalog	stl_async_rerep_worker_stats	node_num	int4
pg_catalog	stl_async_rerep_worker_stats	rerep_pool_exhausted	int8

View Text

SELECT stll_async_rerep_worker_stats.logtime,
       stll_async_rerep_worker_stats.node_num,
       stll_async_rerep_worker_stats.issued_rerep_reads,
       stll_async_rerep_worker_stats.issued_rerep_writes,
       stll_async_rerep_worker_stats.issued_dirty_writes,
       stll_async_rerep_worker_stats.completed_rerep_reads,
       stll_async_rerep_worker_stats.completed_rerep_writes,
       stll_async_rerep_worker_stats.completed_dirty_writes,
       stll_async_rerep_worker_stats.ignored_rerep_reads,
       stll_async_rerep_worker_stats.ignored_rerep_writes,
       stll_async_rerep_worker_stats.ignored_dirty_writes,
       stll_async_rerep_worker_stats.rerep_pool_exhausted,
       stll_async_rerep_worker_stats.ignored_comp_table_not_in_active_set,
       stll_async_rerep_worker_stats.ignored_comp_block_state_changed,
       stll_async_rerep_worker_stats.ignored_comp_block_pinned_during_write
FROM stll_async_rerep_worker_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