Redshift Observatory

System Table Tracker

System view pg_catalog.stl_wlm_query version 1.0.47357 / 2023-03-08

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