Redshift Observatory

System Table Tracker

System view pg_catalog.stl_disk_cache_write version 1.0.46534 / 2023-02-21

schema	name	column	data type
pg_catalog	stl_disk_cache_write	avg_lru_size_before_push	int4
pg_catalog	stl_disk_cache_write	avg_lru_size_before_writeback	int4
pg_catalog	stl_disk_cache_write	avg_push_time_microsec	int8
pg_catalog	stl_disk_cache_write	avg_writeback_time_microsec	int8
pg_catalog	stl_disk_cache_write	blocks_instant_pushed	int4
pg_catalog	stl_disk_cache_write	blocks_pushed	int4
pg_catalog	stl_disk_cache_write	blocks_written_back	int4
pg_catalog	stl_disk_cache_write	node	int4
pg_catalog	stl_disk_cache_write	pending_reads_push	int4
pg_catalog	stl_disk_cache_write	pending_reads_writeback	int4
pg_catalog	stl_disk_cache_write	pending_writes_push	int4
pg_catalog	stl_disk_cache_write	pending_writes_writeback	int4
pg_catalog	stl_disk_cache_write	push_attempts	int4
pg_catalog	stl_disk_cache_write	rowsets_instant_pushed	int4
pg_catalog	stl_disk_cache_write	rowsets_pushed	int4
pg_catalog	stl_disk_cache_write	sample_end_time	timestamp
pg_catalog	stl_disk_cache_write	sample_start_time	timestamp
pg_catalog	stl_disk_cache_write	writeback_attempts	int4
pg_catalog	stl_disk_cache_write	writeback_preempts	int4

View Text

SELECT stll_disk_cache_write.blocks_pushed,
       stll_disk_cache_write.blocks_instant_pushed,
       stll_disk_cache_write.avg_lru_size_before_push,
       stll_disk_cache_write.push_attempts,
       stll_disk_cache_write.pending_writes_push,
       stll_disk_cache_write.pending_reads_push,
       stll_disk_cache_write.blocks_written_back,
       stll_disk_cache_write.writeback_preempts,
       stll_disk_cache_write.avg_lru_size_before_writeback,
       stll_disk_cache_write.writeback_attempts,
       stll_disk_cache_write.pending_writes_writeback,
       stll_disk_cache_write.pending_reads_writeback,
       stll_disk_cache_write.avg_push_time_microsec,
       stll_disk_cache_write.avg_writeback_time_microsec,
       stll_disk_cache_write.sample_start_time,
       stll_disk_cache_write.sample_end_time,
       stll_disk_cache_write.node,
       stll_disk_cache_write.rowsets_pushed,
       stll_disk_cache_write.rowsets_instant_pushed
FROM stll_disk_cache_write

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