Redshift Observatory

System Table Tracker

System view pg_catalog.stl_disk_cache_stats version 1.0.41194 / 2022-09-03

schema	name	column	data type
pg_catalog	stl_disk_cache_stats	accesses_to_outstanding_req	int8
pg_catalog	stl_disk_cache_stats	adds	int8
pg_catalog	stl_disk_cache_stats	avg_size_limit	int8
pg_catalog	stl_disk_cache_stats	cache_size	int4
pg_catalog	stl_disk_cache_stats	dbr_blocks	int8
pg_catalog	stl_disk_cache_stats	disk_upgrade_requests	int8
pg_catalog	stl_disk_cache_stats	disk_upgrades_dropped	int8
pg_catalog	stl_disk_cache_stats	disk_upgrades_not_useful	int8
pg_catalog	stl_disk_cache_stats	evictions	int8
pg_catalog	stl_disk_cache_stats	faults	int8
pg_catalog	stl_disk_cache_stats	largest_size_limit	int8
pg_catalog	stl_disk_cache_stats	logtime	timestamp
pg_catalog	stl_disk_cache_stats	lru_size	int4
pg_catalog	stl_disk_cache_stats	max_percentage_shared_mem_used	int4
pg_catalog	stl_disk_cache_stats	max_pushout_latency_us	int8
pg_catalog	stl_disk_cache_stats	max_rowsets_pinned	int8
pg_catalog	stl_disk_cache_stats	max_size	int4
pg_catalog	stl_disk_cache_stats	new_blocks	int8
pg_catalog	stl_disk_cache_stats	node	int4
pg_catalog	stl_disk_cache_stats	num_downsizings	int8
pg_catalog	stl_disk_cache_stats	num_pushout_downsizings	int8
pg_catalog	stl_disk_cache_stats	num_upsizings	int8
pg_catalog	stl_disk_cache_stats	oom_eviction_calls	int4
pg_catalog	stl_disk_cache_stats	percentage_shared_mem_used	int4
pg_catalog	stl_disk_cache_stats	pins	int8
pg_catalog	stl_disk_cache_stats	prefetches	int8
pg_catalog	stl_disk_cache_stats	ra_points	float8
pg_catalog	stl_disk_cache_stats	rerep_write_skipped_exhausted_write_pool	int8
pg_catalog	stl_disk_cache_stats	rowset_blocks_spilled	int8
pg_catalog	stl_disk_cache_stats	rowsets_currently_in_cache	int8
pg_catalog	stl_disk_cache_stats	rowsets_currently_pinned	int8
pg_catalog	stl_disk_cache_stats	s3_upgrade_requests	int8
pg_catalog	stl_disk_cache_stats	s3_upgrades_dropped	int8
pg_catalog	stl_disk_cache_stats	scans_running	int4
pg_catalog	stl_disk_cache_stats	scan_starts	int8
pg_catalog	stl_disk_cache_stats	smallest_size_limit	int8
pg_catalog	stl_disk_cache_stats	successful_disk_upgrades	int8
pg_catalog	stl_disk_cache_stats	successful_s3_upgrades	int8
pg_catalog	stl_disk_cache_stats	throttle	int8
pg_catalog	stl_disk_cache_stats	throttles	int8

View Text

SELECT stll_disk_cache_stats.logtime,
       stll_disk_cache_stats.adds,
       stll_disk_cache_stats.new_blocks,
       stll_disk_cache_stats.dbr_blocks,
       stll_disk_cache_stats.pins,
       stll_disk_cache_stats.faults,
       stll_disk_cache_stats.throttles,
       stll_disk_cache_stats.scan_starts,
       stll_disk_cache_stats.cache_size,
       stll_disk_cache_stats.lru_size,
       stll_disk_cache_stats.throttle,
       stll_disk_cache_stats.ra_points,
       stll_disk_cache_stats.scans_running,
       stll_disk_cache_stats.evictions,
       stll_disk_cache_stats.prefetches,
       stll_disk_cache_stats.node,
       stll_disk_cache_stats.max_size,
       stll_disk_cache_stats.max_pushout_latency_us,
       stll_disk_cache_stats.rowset_blocks_spilled,
       stll_disk_cache_stats.rerep_write_skipped_exhausted_write_pool,
       stll_disk_cache_stats.max_rowsets_pinned,
       stll_disk_cache_stats.rowsets_currently_in_cache,
       stll_disk_cache_stats.rowsets_currently_pinned,
       stll_disk_cache_stats.accesses_to_outstanding_req,
       stll_disk_cache_stats.percentage_shared_mem_used,
       stll_disk_cache_stats.max_percentage_shared_mem_used,
       stll_disk_cache_stats.disk_upgrade_requests,
       stll_disk_cache_stats.successful_disk_upgrades,
       stll_disk_cache_stats.disk_upgrades_dropped,
       stll_disk_cache_stats.disk_upgrades_not_useful,
       stll_disk_cache_stats.s3_upgrade_requests,
       stll_disk_cache_stats.successful_s3_upgrades,
       stll_disk_cache_stats.s3_upgrades_dropped,
       stll_disk_cache_stats.num_upsizings,
       stll_disk_cache_stats.num_downsizings,
       stll_disk_cache_stats.largest_size_limit,
       stll_disk_cache_stats.smallest_size_limit,
       stll_disk_cache_stats.avg_size_limit,
       stll_disk_cache_stats.oom_eviction_calls,
       stll_disk_cache_stats.num_pushout_downsizings
FROM stll_disk_cache_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