Trying to understand general pool queue time in MC

Forum|Forum|11 years ago
September 17, 2015
3 replies
20 views

+2

Luc_Lecocq
Participating Frequently

Hello,

I a using Vertica 7.1.2.2 with 7.1.2.4 MC.

In the main screen, the "General pool activity" shows that the max queue time sometimes goes up to 1sec.

If I click on the point with 1 sec value, it brings me to the activity screen where I can see details on the queue time for the general pool, which shows ..., 0 sec queue time !!

For me, there should not be any query queing here, the queing threshold is at 95GB, and I am not using that much when I monitor the use.

So what is the actual value of the queue time ?

Chris_S
Participating Frequently
Forum|Forum|11 years ago
September 17, 2015

Hi Luc_Lecocq,

There is a known issue with the view that the MC is using which involves incorrect queue times being observed. This stems from the fact that it is difficult to get the queue duration for running queries. I suspect you will see queue duration ~1s only when you have running queries.

When you click on a point in the chart, the activity page will show queue durations for completed queries, which is more accurate. For now, assume that what you see on the activity page is the actual queue duration.

Thanks,

Chris