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