Redshift Observatory

System Table Tracker

System view pg_catalog.stl_disk_cache_stats version 1.0.41533 / 2022-09-18

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