| 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 | dirty_block_size | int8 |
| pg_catalog | stl_disk_cache_stats | dirty_rowset_block_size | 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_dirty_block_size | int8 |
| pg_catalog | stl_disk_cache_stats | max_dirty_rowset_block_size | int8 |
| 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 |
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
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