What resource pool did query use?

Moderator: NorbertKrupa

Post Reply
User avatar
Julie
Master
Master
Posts: 221
Joined: Thu Apr 19, 2012 9:29 pm

What resource pool did query use?

Post by Julie » Tue Apr 25, 2017 7:19 pm

Hi all,

Anyone know how I can figure out which resource pool was used for a particular query? I checked the query_profiles table and didn't see anything that indicated which pool was used.

Thank you!!!
Thanks,
Juliette

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

Re: What resource pool did query use?

Post by JimKnicely » Tue Apr 25, 2017 8:27 pm

Hi Julie,

Try joining the dc_requests_issued and dc_resource_acquisitions data collector tables... Something like this:

select a.node_name, a.time, a.request, b.pool_name
from dc_requests_issued a
join dc_resource_acquisitions b
on b.transaction_id = a.transaction_id
and b.statement_id = a.statement_id
where a.user_name = '???' -- Put the username here
and a.request ilike '%???%' -- Put a portion of your query in here
order by time desc;
Jim Knicely

Image

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

Post Reply

Return to “New to Vertica SQL”