Redshift Observatory

System Table Tracker

System view pg_catalog.stl_mem_alloc_histograms version 1.0.107910 / 2025-02-20

schema	name	column	data type
pg_catalog	stl_mem_alloc_histograms	blocks_128m	int8
pg_catalog	stl_mem_alloc_histograms	blocks_16m	int8
pg_catalog	stl_mem_alloc_histograms	blocks_1g	int8
pg_catalog	stl_mem_alloc_histograms	blocks_1m	int8
pg_catalog	stl_mem_alloc_histograms	blocks_256m	int8
pg_catalog	stl_mem_alloc_histograms	blocks_2g	int8
pg_catalog	stl_mem_alloc_histograms	blocks_2m	int8
pg_catalog	stl_mem_alloc_histograms	blocks_32m	int8
pg_catalog	stl_mem_alloc_histograms	blocks_4m	int8
pg_catalog	stl_mem_alloc_histograms	blocks_512m	int8
pg_catalog	stl_mem_alloc_histograms	blocks_64m	int8
pg_catalog	stl_mem_alloc_histograms	blocks_8m	int8
pg_catalog	stl_mem_alloc_histograms	max_blocks_128m	int8
pg_catalog	stl_mem_alloc_histograms	max_blocks_16m	int8
pg_catalog	stl_mem_alloc_histograms	max_blocks_1g	int8
pg_catalog	stl_mem_alloc_histograms	max_blocks_1m	int8
pg_catalog	stl_mem_alloc_histograms	max_blocks_256m	int8
pg_catalog	stl_mem_alloc_histograms	max_blocks_2g	int8
pg_catalog	stl_mem_alloc_histograms	max_blocks_2m	int8
pg_catalog	stl_mem_alloc_histograms	max_blocks_32m	int8
pg_catalog	stl_mem_alloc_histograms	max_blocks_4m	int8
pg_catalog	stl_mem_alloc_histograms	max_blocks_512m	int8
pg_catalog	stl_mem_alloc_histograms	max_blocks_64m	int8
pg_catalog	stl_mem_alloc_histograms	max_blocks_8m	int8
pg_catalog	stl_mem_alloc_histograms	mem_type	char(32)
pg_catalog	stl_mem_alloc_histograms	node	int4
pg_catalog	stl_mem_alloc_histograms	now	timestamp
pg_catalog	stl_mem_alloc_histograms	since	timestamp

View Text

SELECT stll_mem_alloc_histograms.now,
       stll_mem_alloc_histograms.since,
       stll_mem_alloc_histograms.node,
       stll_mem_alloc_histograms.mem_type,
       stll_mem_alloc_histograms.blocks_1m,
       stll_mem_alloc_histograms.blocks_2m,
       stll_mem_alloc_histograms.blocks_4m,
       stll_mem_alloc_histograms.blocks_8m,
       stll_mem_alloc_histograms.blocks_16m,
       stll_mem_alloc_histograms.blocks_32m,
       stll_mem_alloc_histograms.blocks_64m,
       stll_mem_alloc_histograms.blocks_128m,
       stll_mem_alloc_histograms.blocks_256m,
       stll_mem_alloc_histograms.blocks_512m,
       stll_mem_alloc_histograms.blocks_1g,
       stll_mem_alloc_histograms.blocks_2g,
       stll_mem_alloc_histograms.max_blocks_1m,
       stll_mem_alloc_histograms.max_blocks_2m,
       stll_mem_alloc_histograms.max_blocks_4m,
       stll_mem_alloc_histograms.max_blocks_8m,
       stll_mem_alloc_histograms.max_blocks_16m,
       stll_mem_alloc_histograms.max_blocks_32m,
       stll_mem_alloc_histograms.max_blocks_64m,
       stll_mem_alloc_histograms.max_blocks_128m,
       stll_mem_alloc_histograms.max_blocks_256m,
       stll_mem_alloc_histograms.max_blocks_512m,
       stll_mem_alloc_histograms.max_blocks_1g,
       stll_mem_alloc_histograms.max_blocks_2g
FROM stll_mem_alloc_histograms

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