Redshift Observatory

System Table Tracker

System view pg_catalog.stl_global_alloc_stats version 1.0.118447 / 2025-08-02

schema	name	column	data type
pg_catalog	stl_global_alloc_stats	alloc_base_req	int8
pg_catalog	stl_global_alloc_stats	alloc_disk_block_req	int8
pg_catalog	stl_global_alloc_stats	alloc_private_req	int8
pg_catalog	stl_global_alloc_stats	alloc_public_req	int8
pg_catalog	stl_global_alloc_stats	disable_privilege_system	int8
pg_catalog	stl_global_alloc_stats	enable_privilege_system	int8
pg_catalog	stl_global_alloc_stats	end_of_segment_updates	int8
pg_catalog	stl_global_alloc_stats	fix_access_other_page	int8
pg_catalog	stl_global_alloc_stats	fix_access_public_page	int8
pg_catalog	stl_global_alloc_stats	free_base_req	int8
pg_catalog	stl_global_alloc_stats	free_disk_block_req	int8
pg_catalog	stl_global_alloc_stats	free_private_req	int8
pg_catalog	stl_global_alloc_stats	free_public_req	int8
pg_catalog	stl_global_alloc_stats	mark_public_page	int8
pg_catalog	stl_global_alloc_stats	node	int4
pg_catalog	stl_global_alloc_stats	now	timestamp
pg_catalog	stl_global_alloc_stats	release_evicted_page	int8
pg_catalog	stl_global_alloc_stats	since	timestamp
pg_catalog	stl_global_alloc_stats	update_on_access_base_page	int8
pg_catalog	stl_global_alloc_stats	update_on_access_private_page	int8
pg_catalog	stl_global_alloc_stats	update_on_access_public_page	int8

View Text

SELECT stll_global_alloc_stats.now,
       stll_global_alloc_stats.since,
       stll_global_alloc_stats.node,
       stll_global_alloc_stats.alloc_base_req,
       stll_global_alloc_stats.alloc_public_req,
       stll_global_alloc_stats.alloc_disk_block_req,
       stll_global_alloc_stats.alloc_private_req,
       stll_global_alloc_stats.free_base_req,
       stll_global_alloc_stats.free_public_req,
       stll_global_alloc_stats.free_disk_block_req,
       stll_global_alloc_stats.free_private_req,
       stll_global_alloc_stats.end_of_segment_updates,
       stll_global_alloc_stats.update_on_access_base_page,
       stll_global_alloc_stats.update_on_access_public_page,
       stll_global_alloc_stats.update_on_access_private_page,
       stll_global_alloc_stats.fix_access_public_page,
       stll_global_alloc_stats.fix_access_other_page,
       stll_global_alloc_stats.enable_privilege_system,
       stll_global_alloc_stats.disable_privilege_system,
       stll_global_alloc_stats.mark_public_page,
       stll_global_alloc_stats.release_evicted_page
FROM stll_global_alloc_stats

Home 3D Друк Blog Bring-Up Times Cross-Region Benchmarks Email Forums Mailing Lists Redshift Price Tracker Redshift Version Tracker Replacement System Tables Reserved Instances Marketplace Slack System Table Tracker The Known Universe White Papers