Redshift Observatory

System Table Tracker

System view pg_catalog.stl_memory_pressure_actions version 1.0.47470 / 2023-03-11

schema	name	column	data type
pg_catalog	stl_memory_pressure_actions	action_type	char(64)
pg_catalog	stl_memory_pressure_actions	heap_mem_used	int8
pg_catalog	stl_memory_pressure_actions	memory_type	char(64)
pg_catalog	stl_memory_pressure_actions	node	int4
pg_catalog	stl_memory_pressure_actions	now	timestamp
pg_catalog	stl_memory_pressure_actions	pid	int4
pg_catalog	stl_memory_pressure_actions	pinned_blocks_mem_used	int8
pg_catalog	stl_memory_pressure_actions	process_type	char(64)
pg_catalog	stl_memory_pressure_actions	query	int4
pg_catalog	stl_memory_pressure_actions	shared_mem_used	int8
pg_catalog	stl_memory_pressure_actions	src_pid	int4
pg_catalog	stl_memory_pressure_actions	state	int4

View Text

SELECT stll_memory_pressure_actions.now,
       stll_memory_pressure_actions.node,
       stll_memory_pressure_actions.memory_type,
       stll_memory_pressure_actions.action_type,
       stll_memory_pressure_actions.state,
       stll_memory_pressure_actions.process_type,
       stll_memory_pressure_actions.query,
       stll_memory_pressure_actions.pid,
       stll_memory_pressure_actions.shared_mem_used,
       stll_memory_pressure_actions.heap_mem_used,
       stll_memory_pressure_actions.pinned_blocks_mem_used,
       stll_memory_pressure_actions.src_pid
FROM stll_memory_pressure_actions

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