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