Redshift Observatory

System Table Tracker

System view pg_catalog.stl_window version 1.0.60140 / 2023-11-19

schema name column data type
pg_catalog stl_window endtime timestamp
pg_catalog stl_window is_diskbased char(1)
pg_catalog stl_window memory_usage_ratio int4
pg_catalog stl_window query int4
pg_catalog stl_window rows int8
pg_catalog stl_window segment int4
pg_catalog stl_window slice int4
pg_catalog stl_window starttime timestamp
pg_catalog stl_window step int4
pg_catalog stl_window tasknum int4
pg_catalog stl_window used_mega_block char(1)
pg_catalog stl_window userid int4
pg_catalog stl_window workmem int8

View Text

SELECT stll_window.userid,
       stll_window.query,
       stll_window.slice,
       stll_window.segment,
       stll_window.step,
       stll_window.starttime,
       stll_window.endtime,
       stll_window.tasknum,
       stll_window.rows,
       stll_window.is_diskbased,
       stll_window.workmem,
       stll_window.used_mega_block,
       stll_window.memory_usage_ratio
FROM stll_window


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