Redshift Observatory

System Table Tracker

System view pg_catalog.stl_memory_pressure_suspects version 1.0.57798 / 2023-10-25

schema	name	column	data type
pg_catalog	stl_memory_pressure_suspects	heap_mem_used	int8
pg_catalog	stl_memory_pressure_suspects	node	int4
pg_catalog	stl_memory_pressure_suspects	now	timestamp
pg_catalog	stl_memory_pressure_suspects	num_blocks_pinned	int8
pg_catalog	stl_memory_pressure_suspects	query	int4
pg_catalog	stl_memory_pressure_suspects	shared_mem_used	int8
pg_catalog	stl_memory_pressure_suspects	state	int4

View Text

SELECT stll_memory_pressure_suspects.now,
       stll_memory_pressure_suspects.node,
       stll_memory_pressure_suspects.state,
       stll_memory_pressure_suspects.query,
       stll_memory_pressure_suspects.shared_mem_used,
       stll_memory_pressure_suspects.heap_mem_used,
       stll_memory_pressure_suspects.num_blocks_pinned
FROM stll_memory_pressure_suspects

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