Redshift Observatory

System Table Tracker

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

schema	name	column	data type
pg_catalog	stl_wlm_service_class_config	concurrency_scaling	char(20)
pg_catalog	stl_wlm_service_class_config	eventtime	timestamp
pg_catalog	stl_wlm_service_class_config	evictable	char(8)
pg_catalog	stl_wlm_service_class_config	eviction_threshold	int8
pg_catalog	stl_wlm_service_class_config	max_execution_time	int4
pg_catalog	stl_wlm_service_class_config	min_step_mem	int4
pg_catalog	stl_wlm_service_class_config	name	char(64)
pg_catalog	stl_wlm_service_class_config	num_query_tasks	int4
pg_catalog	stl_wlm_service_class_config	query_group_wild_card	char(8)
pg_catalog	stl_wlm_service_class_config	query_priority	char(20)
pg_catalog	stl_wlm_service_class_config	query_working_mem	int4
pg_catalog	stl_wlm_service_class_config	queueing_strategy	char(32)
pg_catalog	stl_wlm_service_class_config	service_class	int4
pg_catalog	stl_wlm_service_class_config	target_num_query_tasks	int4
pg_catalog	stl_wlm_service_class_config	target_query_working_mem	int4
pg_catalog	stl_wlm_service_class_config	user_group_wild_card	char(8)
pg_catalog	stl_wlm_service_class_config	user_role_wild_card	char(8)

View Text

SELECT stll_wlm_service_class_config.service_class,
       stll_wlm_service_class_config.queueing_strategy,
       stll_wlm_service_class_config.num_query_tasks,
       stll_wlm_service_class_config.target_num_query_tasks,
       stll_wlm_service_class_config.evictable,
       stll_wlm_service_class_config.eviction_threshold,
       stll_wlm_service_class_config.query_working_mem,
       stll_wlm_service_class_config.target_query_working_mem,
       stll_wlm_service_class_config.min_step_mem,
       stll_wlm_service_class_config.name,
       stll_wlm_service_class_config.max_execution_time,
       stll_wlm_service_class_config.user_group_wild_card,
       stll_wlm_service_class_config.query_group_wild_card,
       stll_wlm_service_class_config.concurrency_scaling,
       stll_wlm_service_class_config.query_priority,
       stll_wlm_service_class_config.eventtime,
       stll_wlm_service_class_config.user_role_wild_card
FROM stll_wlm_service_class_config

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