Redshift Observatory

System Table Tracker

System view pg_catalog.stl_query_memory version 1.0.41881 / 2022-09-30

schema	name	column	data type
pg_catalog	stl_query_memory	cheating_working_mem	int8
pg_catalog	stl_query_memory	consumed_mem	int8
pg_catalog	stl_query_memory	query	int4
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
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