Monitor query cascading

Moderator: NorbertKrupa

Post Reply
Posts: 1
Joined: Mon Feb 19, 2018 6:34 pm

Monitor query cascading

Post by sarafandee » Mon Feb 19, 2018 6:36 pm


We are using Vertica 8.0.1, and I would like to know if there is a way to monitor queries that get cascaded from pool X to pool Y. I currently have the a setup for two resource pools, pool X with a RUNTIME CAP of 3 seconds, which cascades to Pool Y. However, I am unable to see any log for queries that got cascaded to pool Y when they reach the RUNTIME CAP limit, and there are many that do. I am pasting the configurations for both pool below, help is appreciated, thank you.

pool_id name is_internal memorysize maxmemorysize executionparallelism priority runtimepriority runtimeprioritythreshold queuetimeout plannedconcurrency maxconcurrency runtimecap singleinitiator cpuaffinityset cpuaffinitymode cascadeto
45,036,003,939,602,884 pool_x false 45G 45G 16 10 MEDIUM 10 00:16:40 20 96 00:00:03 false ANY pool_y
54,043,196,336,280,420 pool_y false 30G 30G 16 10 MEDIUM 10 00:16:40 10 10 00:05:00 false ANY [NULL]

Thank you

User avatar
Site Admin
Site Admin
Posts: 1825
Joined: Sat Jan 21, 2012 4:58 am

Re: Monitor query cascading

Post by JimKnicely » Thu Feb 22, 2018 6:25 pm

Jim Knicely


Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.

Post Reply

Return to “General”