Redshift Observatory

System Table Tracker

System view pg_catalog.stl_query_heap_memory_stats_by_component version 1.0.41465 / 2022-09-10

schema	name	column	data type
pg_catalog	stl_query_heap_memory_stats_by_component	calloc	int8
pg_catalog	stl_query_heap_memory_stats_by_component	checkpoint	int4
pg_catalog	stl_query_heap_memory_stats_by_component	free	int8
pg_catalog	stl_query_heap_memory_stats_by_component	heap_mem_consumption	int8
pg_catalog	stl_query_heap_memory_stats_by_component	malloc	int8
pg_catalog	stl_query_heap_memory_stats_by_component	memalign	int8
pg_catalog	stl_query_heap_memory_stats_by_component	pid	int4
pg_catalog	stl_query_heap_memory_stats_by_component	query	int8
pg_catalog	stl_query_heap_memory_stats_by_component	realloc	int8
pg_catalog	stl_query_heap_memory_stats_by_component	recordtime	timestamp
pg_catalog	stl_query_heap_memory_stats_by_component	time_consumption	int8
pg_catalog	stl_query_heap_memory_stats_by_component	userid	int4
pg_catalog	stl_query_heap_memory_stats_by_component	valloc	int8
pg_catalog	stl_query_heap_memory_stats_by_component	xid	int8

View Text

SELECT stll_query_heap_memory_stats_by_component.recordtime,
       stll_query_heap_memory_stats_by_component.pid,
       stll_query_heap_memory_stats_by_component.xid,
       stll_query_heap_memory_stats_by_component.query,
       stll_query_heap_memory_stats_by_component.userid,
       stll_query_heap_memory_stats_by_component.checkpoint,
       stll_query_heap_memory_stats_by_component.heap_mem_consumption,
       stll_query_heap_memory_stats_by_component.time_consumption,
       stll_query_heap_memory_stats_by_component.malloc,
       stll_query_heap_memory_stats_by_component.calloc,
       stll_query_heap_memory_stats_by_component.valloc,
       stll_query_heap_memory_stats_by_component.realloc,
       stll_query_heap_memory_stats_by_component.memalign,
       stll_query_heap_memory_stats_by_component.free
FROM stll_query_heap_memory_stats_by_component

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