Redshift Observatory

System Table Tracker

System view pg_catalog.stl_tiered_storage_s3_blocks version 1.0.52931 / 2023-07-07

schema name column data type
pg_catalog stl_tiered_storage_s3_blocks blks_evictable int8
pg_catalog stl_tiered_storage_s3_blocks blks_to_backup int8
pg_catalog stl_tiered_storage_s3_blocks event_time timestamp
pg_catalog stl_tiered_storage_s3_blocks evicted_without_reads int8
pg_catalog stl_tiered_storage_s3_blocks local_capacity int8
pg_catalog stl_tiered_storage_s3_blocks node_num int4
pg_catalog stl_tiered_storage_s3_blocks num_blocks_evicted int8
pg_catalog stl_tiered_storage_s3_blocks on_demand_eviction int4
pg_catalog stl_tiered_storage_s3_blocks superblock_version int8
pg_catalog stl_tiered_storage_s3_blocks transaction_id int8
pg_catalog stl_tiered_storage_s3_blocks ts_cache_elems int8

View Text

SELECT stll_tiered_storage_s3_blocks.node_num,
       stll_tiered_storage_s3_blocks.event_time,
       stll_tiered_storage_s3_blocks.num_blocks_evicted,
       stll_tiered_storage_s3_blocks.on_demand_eviction,
       stll_tiered_storage_s3_blocks.superblock_version,
       stll_tiered_storage_s3_blocks.transaction_id,
       stll_tiered_storage_s3_blocks.local_capacity,
       stll_tiered_storage_s3_blocks.ts_cache_elems,
       stll_tiered_storage_s3_blocks.blks_evictable,
       stll_tiered_storage_s3_blocks.blks_to_backup,
       stll_tiered_storage_s3_blocks.evicted_without_reads
FROM stll_tiered_storage_s3_blocks


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