Redshift Observatory

System Table Tracker

System view pg_catalog.stl_query_heap_memory_stats_by_component version 1.0.41533 / 2022-09-18

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