Redshift Observatory

System Table Tracker

System view pg_catalog.stl_query_memory version 1.0.40467 / 2022-08-08

schema name column data type
pg_catalog stl_query_memory cheating_working_mem int8
pg_catalog stl_query_memory consumed_mem int8
pg_catalog stl_query_memory query int4
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
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