Redshift Observatory

System Table Tracker

System view pg_catalog.stl_query_memory version 1.0.52931 / 2023-07-07

schema	name	column	data type
pg_catalog	stl_query_memory	avg_runtime_working_mem	int8
pg_catalog	stl_query_memory	cheating_working_mem	int8
pg_catalog	stl_query_memory	consumed_mem	int8
pg_catalog	stl_query_memory	contributed_mem	int8
pg_catalog	stl_query_memory	max_runtime_working_mem	int8
pg_catalog	stl_query_memory	memory_action	int4
pg_catalog	stl_query_memory	min_runtime_working_mem	int8
pg_catalog	stl_query_memory	pool_out_of_memory	char(1)
pg_catalog	stl_query_memory	query	int4
pg_catalog	stl_query_memory	reached_upper_bound	char(1)
pg_catalog	stl_query_memory	reported_mem	int8
pg_catalog	stl_query_memory	segment	int4
pg_catalog	stl_query_memory	slice	int4
pg_catalog	stl_query_memory	step	int4
pg_catalog	stl_query_memory	userid	int4
pg_catalog	stl_query_memory	wlm_working_mem	int8

View Text

SELECT stll_query_memory.userid,
       stll_query_memory.query,
       stll_query_memory.slice,
       stll_query_memory.segment,
       stll_query_memory.step,
       stll_query_memory.consumed_mem,
       stll_query_memory.reported_mem,
       stll_query_memory.wlm_working_mem,
       stll_query_memory.cheating_working_mem,
       stll_query_memory.avg_runtime_working_mem,
       stll_query_memory.max_runtime_working_mem,
       stll_query_memory.min_runtime_working_mem,
       stll_query_memory.contributed_mem,
       stll_query_memory.pool_out_of_memory,
       stll_query_memory.reached_upper_bound,
       stll_query_memory.memory_action
FROM stll_query_memory

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