Redshift Observatory

System Table Tracker

System view pg_catalog.stl_query_memory version 1.0.70695 / 2024-07-11

schema name column data type
pg_catalog stl_query_memory avg_runtime_working_mem int8
pg_catalog stl_query_memory cheating_working_mem int8
pg_catalog stl_query_memory consumed_mem int8
pg_catalog stl_query_memory contributed_mem int8
pg_catalog stl_query_memory max_runtime_working_mem int8
pg_catalog stl_query_memory memory_action int4
pg_catalog stl_query_memory min_runtime_working_mem int8
pg_catalog stl_query_memory pool_out_of_memory char(1)
pg_catalog stl_query_memory query int4
pg_catalog stl_query_memory reached_upper_bound char(1)
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,
       stll_query_memory.avg_runtime_working_mem,
       stll_query_memory.max_runtime_working_mem,
       stll_query_memory.min_runtime_working_mem,
       stll_query_memory.contributed_mem,
       stll_query_memory.pool_out_of_memory,
       stll_query_memory.reached_upper_bound,
       stll_query_memory.memory_action
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