Redshift Research Project

System Table Tracker

System view pg_catalog.stl_query_mem_stats_by_type version 1.0.63269 / 2024-02-17

schema	name	column	data type
pg_catalog	stl_query_mem_stats_by_type	allocated_count	int8
pg_catalog	stl_query_mem_stats_by_type	allocated_size	int8
pg_catalog	stl_query_mem_stats_by_type	freed_count	int8
pg_catalog	stl_query_mem_stats_by_type	freed_size	int8
pg_catalog	stl_query_mem_stats_by_type	max_mem_count	int8
pg_catalog	stl_query_mem_stats_by_type	max_mem_size	int8
pg_catalog	stl_query_mem_stats_by_type	node	int4
pg_catalog	stl_query_mem_stats_by_type	query	int4
pg_catalog	stl_query_mem_stats_by_type	type	char(25)

View Text

SELECT stll_query_mem_stats_by_type.node,
       stll_query_mem_stats_by_type.query,
       stll_query_mem_stats_by_type.type,
       stll_query_mem_stats_by_type.allocated_count,
       stll_query_mem_stats_by_type.freed_count,
       stll_query_mem_stats_by_type.max_mem_count,
       stll_query_mem_stats_by_type.allocated_size,
       stll_query_mem_stats_by_type.freed_size,
       stll_query_mem_stats_by_type.max_mem_size
FROM stll_query_mem_stats_by_type

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