Redshift Observatory

System Table Tracker

System view pg_catalog.stl_query_mem_stats version 1.0.51594 / 2023-06-10

schema	name	column	data type
pg_catalog	stl_query_mem_stats	max_mem_count	int8
pg_catalog	stl_query_mem_stats	max_mem_size	int8
pg_catalog	stl_query_mem_stats	max_pinned_count	int8
pg_catalog	stl_query_mem_stats	node	int4
pg_catalog	stl_query_mem_stats	now	timestamp
pg_catalog	stl_query_mem_stats	num_pin_count	int8
pg_catalog	stl_query_mem_stats	num_unpin_count	int8
pg_catalog	stl_query_mem_stats	query	int4

View Text

SELECT stll_query_mem_stats.node,
       stll_query_mem_stats.query,
       stll_query_mem_stats.max_mem_count,
       stll_query_mem_stats.max_mem_size,
       stll_query_mem_stats.num_pin_count,
       stll_query_mem_stats.num_unpin_count,
       stll_query_mem_stats.max_pinned_count,
       stll_query_mem_stats.now
FROM stll_query_mem_stats

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