Redshift Observatory

System Table Tracker

System view pg_catalog.stl_wlm_auto_concurrency version 1.0.52931 / 2023-07-07

schema	name	column	data type
pg_catalog	stl_wlm_auto_concurrency	avg_exec_time_heavy_sec	float8
pg_catalog	stl_wlm_auto_concurrency	heavy_queries_exec_time	float8
pg_catalog	stl_wlm_auto_concurrency	heavy_queries_finished	int4
pg_catalog	stl_wlm_auto_concurrency	heavy_queries_queued	int4
pg_catalog	stl_wlm_auto_concurrency	heavy_queries_queue_time_sec	float8
pg_catalog	stl_wlm_auto_concurrency	heavy_slots	int4
pg_catalog	stl_wlm_auto_concurrency	heavy_util	float8
pg_catalog	stl_wlm_auto_concurrency	light_queries_exec_time_sec	float8
pg_catalog	stl_wlm_auto_concurrency	light_queries_finished	int4
pg_catalog	stl_wlm_auto_concurrency	light_queries_queued	int4
pg_catalog	stl_wlm_auto_concurrency	light_queries_queue_time_sec	float8
pg_catalog	stl_wlm_auto_concurrency	light_slots	int4
pg_catalog	stl_wlm_auto_concurrency	light_util	float8
pg_catalog	stl_wlm_auto_concurrency	new_light_slots	int4
pg_catalog	stl_wlm_auto_concurrency	now	timestamp
pg_catalog	stl_wlm_auto_concurrency	p90_exec_time_heavy_sec	float8
pg_catalog	stl_wlm_auto_concurrency	spilled_blocks	int8
pg_catalog	stl_wlm_auto_concurrency	spilling_queries	int4
pg_catalog	stl_wlm_auto_concurrency	utilization_state	char(6)
pg_catalog	stl_wlm_auto_concurrency	window_time_sec	float8

View Text

SELECT stll_wlm_auto_concurrency.now,
       stll_wlm_auto_concurrency.heavy_slots,
       stll_wlm_auto_concurrency.light_slots,
       stll_wlm_auto_concurrency.heavy_util,
       stll_wlm_auto_concurrency.light_util,
       stll_wlm_auto_concurrency.utilization_state,
       stll_wlm_auto_concurrency.new_light_slots,
       stll_wlm_auto_concurrency.window_time_sec,
       stll_wlm_auto_concurrency.heavy_queries_finished,
       stll_wlm_auto_concurrency.heavy_queries_exec_time,
       stll_wlm_auto_concurrency.heavy_queries_queue_time_sec,
       stll_wlm_auto_concurrency.light_queries_finished,
       stll_wlm_auto_concurrency.light_queries_exec_time_sec,
       stll_wlm_auto_concurrency.light_queries_queue_time_sec,
       stll_wlm_auto_concurrency.spilling_queries,
       stll_wlm_auto_concurrency.spilled_blocks,
       stll_wlm_auto_concurrency.light_queries_queued,
       stll_wlm_auto_concurrency.heavy_queries_queued,
       stll_wlm_auto_concurrency.avg_exec_time_heavy_sec,
       stll_wlm_auto_concurrency.p90_exec_time_heavy_sec
FROM stll_wlm_auto_concurrency

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