Redshift Observatory

System Table Tracker

System view pg_catalog.stl_disk_cache_stats version 1.0.70890 / 2024-07-14

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,
       stll_disk_cache_stats.dirty_block_size,
       stll_disk_cache_stats.dirty_rowset_block_size,
       stll_disk_cache_stats.max_dirty_block_size,
       stll_disk_cache_stats.max_dirty_rowset_block_size,
       stll_disk_cache_stats.num_tree_blocks,
       stll_disk_cache_stats.num_log_blocks,
       stll_disk_cache_stats.max_num_tree_blocks,
       stll_disk_cache_stats.max_num_log_blocks
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