Redshift Observatory

System Table Tracker

System view pg_catalog.stl_wlm_trace_query_state version 1.0.51304 / 2023-06-04

schema name column data type
pg_catalog stl_wlm_trace_query_state new_state char(16)
pg_catalog stl_wlm_trace_query_state old_state char(16)
pg_catalog stl_wlm_trace_query_state query int4
pg_catalog stl_wlm_trace_query_state recordtime timestamp
pg_catalog stl_wlm_trace_query_state service_class int4
pg_catalog stl_wlm_trace_query_state task int4
pg_catalog stl_wlm_trace_query_state userid int4
pg_catalog stl_wlm_trace_query_state xid int8

View Text

SELECT stll_wlm_trace_query_state.userid,
       stll_wlm_trace_query_state.xid,
       stll_wlm_trace_query_state.task,
       stll_wlm_trace_query_state.query,
       stll_wlm_trace_query_state.service_class,
       stll_wlm_trace_query_state.recordtime,
       stll_wlm_trace_query_state.old_state,
       stll_wlm_trace_query_state.new_state
FROM stll_wlm_trace_query_state


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