Redshift Observatory

System Table Tracker

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

schema name column data type
pg_catalog stl_rowblock_manager_stats added_mega_rowblocks int8
pg_catalog stl_rowblock_manager_stats added_rowblocks int8
pg_catalog stl_rowblock_manager_stats dirty_rowblocks int8
pg_catalog stl_rowblock_manager_stats logtime timestamp
pg_catalog stl_rowblock_manager_stats max_rowblock_manager_size int8
pg_catalog stl_rowblock_manager_stats max_rowblock_size int8
pg_catalog stl_rowblock_manager_stats mega_rowblocks_in_disk_cache int8
pg_catalog stl_rowblock_manager_stats mega_rowblocks_reads int8
pg_catalog stl_rowblock_manager_stats mega_rowblocks_writes int8
pg_catalog stl_rowblock_manager_stats min_rowblock_manager_size int8
pg_catalog stl_rowblock_manager_stats min_rowblock_size int8
pg_catalog stl_rowblock_manager_stats node int8
pg_catalog stl_rowblock_manager_stats num_megarowblocks_in_disk_cache int8
pg_catalog stl_rowblock_manager_stats percentage_shared_mem_used float8
pg_catalog stl_rowblock_manager_stats pinned_rowblocks int8
pg_catalog stl_rowblock_manager_stats rowblocks_in_disk int8
pg_catalog stl_rowblock_manager_stats rowblocks_in_disk_cache int8
pg_catalog stl_rowblock_manager_stats rowblocks_in_s3 int8
pg_catalog stl_rowblock_manager_stats tossed_rowblocks int8
pg_catalog stl_rowblock_manager_stats total_mega_rowblocks int8
pg_catalog stl_rowblock_manager_stats total_rowblocks int8

View Text

SELECT stll_rowblock_manager_stats.logtime,
       stll_rowblock_manager_stats.node,
       stll_rowblock_manager_stats.total_rowblocks,
       stll_rowblock_manager_stats.total_mega_rowblocks,
       stll_rowblock_manager_stats.max_rowblock_manager_size,
       stll_rowblock_manager_stats.min_rowblock_manager_size,
       stll_rowblock_manager_stats.max_rowblock_size,
       stll_rowblock_manager_stats.min_rowblock_size,
       stll_rowblock_manager_stats.added_rowblocks,
       stll_rowblock_manager_stats.added_mega_rowblocks,
       stll_rowblock_manager_stats.tossed_rowblocks,
       stll_rowblock_manager_stats.mega_rowblocks_writes,
       stll_rowblock_manager_stats.mega_rowblocks_reads,
       stll_rowblock_manager_stats.rowblocks_in_disk_cache,
       stll_rowblock_manager_stats.num_megarowblocks_in_disk_cache,
       stll_rowblock_manager_stats.mega_rowblocks_in_disk_cache,
       stll_rowblock_manager_stats.pinned_rowblocks,
       stll_rowblock_manager_stats.percentage_shared_mem_used,
       stll_rowblock_manager_stats.dirty_rowblocks,
       stll_rowblock_manager_stats.rowblocks_in_disk,
       stll_rowblock_manager_stats.rowblocks_in_s3
FROM stll_rowblock_manager_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