Redshift Observatory

System Table Tracker

System view pg_catalog.stl_wlm_trace_query_state version 1.0.69451 / 2024-06-27

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