Redshift Observatory

System Table Tracker

System view pg_catalog.stl_mem_block_details version 1.0.45698 / 2023-01-27

schema	name	column	data type
pg_catalog	stl_mem_block_details	buddy_page	int8
pg_catalog	stl_mem_block_details	node	int4
pg_catalog	stl_mem_block_details	page	int8
pg_catalog	stl_mem_block_details	pid	int4
pg_catalog	stl_mem_block_details	process	char(30)
pg_catalog	stl_mem_block_details	qid	int4
pg_catalog	stl_mem_block_details	recordtime	timestamp
pg_catalog	stl_mem_block_details	requested	int8
pg_catalog	stl_mem_block_details	roundedsize	int8
pg_catalog	stl_mem_block_details	slice	int4
pg_catalog	stl_mem_block_details	type	char(15)
pg_catalog	stl_mem_block_details	uid	int4

View Text

SELECT stll_mem_block_details.recordtime,
       stll_mem_block_details.node,
       stll_mem_block_details.slice,
       stll_mem_block_details.type,
       stll_mem_block_details.uid,
       stll_mem_block_details.pid,
       stll_mem_block_details.process,
       stll_mem_block_details.qid,
       stll_mem_block_details.requested,
       stll_mem_block_details.roundedsize,
       stll_mem_block_details.page,
       stll_mem_block_details.buddy_page
FROM stll_mem_block_details

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