Redshift Research Project

System Table Tracker

System Table Version 1.0.41465 / 2022-09-10

schema name column data type
pg_catalog stl_wlm_query est_peak_mem int8
pg_catalog stl_wlm_query exec_end_time timestamp
pg_catalog stl_wlm_query exec_start_time timestamp
pg_catalog stl_wlm_query final_state char(16)
pg_catalog stl_wlm_query query int4
pg_catalog stl_wlm_query query_priority char(20)
pg_catalog stl_wlm_query queue_end_time timestamp
pg_catalog stl_wlm_query queue_start_time timestamp
pg_catalog stl_wlm_query service_class int4
pg_catalog stl_wlm_query service_class_end_time timestamp
pg_catalog stl_wlm_query service_class_name char(64)
pg_catalog stl_wlm_query service_class_start_time timestamp
pg_catalog stl_wlm_query slot_count int4
pg_catalog stl_wlm_query task int4
pg_catalog stl_wlm_query total_exec_time int8
pg_catalog stl_wlm_query total_queue_time int8
pg_catalog stl_wlm_query userid int4
pg_catalog stl_wlm_query xid int8

View Text

SELECT stll_wlm_query.userid,
       stll_wlm_query.xid,
       stll_wlm_query.task,
       stll_wlm_query.query,
       stll_wlm_query.service_class,
       stll_wlm_query.slot_count,
       stll_wlm_query.service_class_start_time,
       stll_wlm_query.queue_start_time,
       stll_wlm_query.queue_end_time,
       stll_wlm_query.total_queue_time,
       stll_wlm_query.exec_start_time,
       stll_wlm_query.exec_end_time,
       stll_wlm_query.total_exec_time,
       stll_wlm_query.service_class_end_time,
       stll_wlm_query.final_state,
       stll_wlm_query.est_peak_mem,
       stll_wlm_query.query_priority,
       stll_wlm_query.service_class_name
FROM stll_wlm_query


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