Redshift Observatory

System Table Tracker

System view pg_catalog.stl_mem_fragmentation version 1.0.77433 / 2024-11-01

schema	name	column	data type
pg_catalog	stl_mem_fragmentation	allocator	char(16)
pg_catalog	stl_mem_fragmentation	available	int8
pg_catalog	stl_mem_fragmentation	blocks_128k	int8
pg_catalog	stl_mem_fragmentation	blocks_128m	int8
pg_catalog	stl_mem_fragmentation	blocks_16k	int8
pg_catalog	stl_mem_fragmentation	blocks_16m	int8
pg_catalog	stl_mem_fragmentation	blocks_1g	int8
pg_catalog	stl_mem_fragmentation	blocks_1m	int8
pg_catalog	stl_mem_fragmentation	blocks_256k	int8
pg_catalog	stl_mem_fragmentation	blocks_256m	int8
pg_catalog	stl_mem_fragmentation	blocks_2g	int8
pg_catalog	stl_mem_fragmentation	blocks_2m	int8
pg_catalog	stl_mem_fragmentation	blocks_32k	int8
pg_catalog	stl_mem_fragmentation	blocks_32m	int8
pg_catalog	stl_mem_fragmentation	blocks_4k	int8
pg_catalog	stl_mem_fragmentation	blocks_4m	int8
pg_catalog	stl_mem_fragmentation	blocks_512k	int8
pg_catalog	stl_mem_fragmentation	blocks_512m	int8
pg_catalog	stl_mem_fragmentation	blocks_64k	int8
pg_catalog	stl_mem_fragmentation	blocks_64m	int8
pg_catalog	stl_mem_fragmentation	blocks_8k	int8
pg_catalog	stl_mem_fragmentation	blocks_8m	int8
pg_catalog	stl_mem_fragmentation	fragmentation	float8
pg_catalog	stl_mem_fragmentation	node	int4
pg_catalog	stl_mem_fragmentation	now	timestamp
pg_catalog	stl_mem_fragmentation	since	timestamp

View Text

SELECT stll_mem_fragmentation.now,
       stll_mem_fragmentation.since,
       stll_mem_fragmentation.node,
       stll_mem_fragmentation.allocator,
       stll_mem_fragmentation.available,
       stll_mem_fragmentation.fragmentation,
       stll_mem_fragmentation.blocks_4k,
       stll_mem_fragmentation.blocks_8k,
       stll_mem_fragmentation.blocks_16k,
       stll_mem_fragmentation.blocks_32k,
       stll_mem_fragmentation.blocks_64k,
       stll_mem_fragmentation.blocks_128k,
       stll_mem_fragmentation.blocks_256k,
       stll_mem_fragmentation.blocks_512k,
       stll_mem_fragmentation.blocks_1m,
       stll_mem_fragmentation.blocks_2m,
       stll_mem_fragmentation.blocks_4m,
       stll_mem_fragmentation.blocks_8m,
       stll_mem_fragmentation.blocks_16m,
       stll_mem_fragmentation.blocks_32m,
       stll_mem_fragmentation.blocks_64m,
       stll_mem_fragmentation.blocks_128m,
       stll_mem_fragmentation.blocks_256m,
       stll_mem_fragmentation.blocks_512m,
       stll_mem_fragmentation.blocks_1g,
       stll_mem_fragmentation.blocks_2g
FROM stll_mem_fragmentation

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