What resource pool did query use?

Forum for the novice Vertica database SQL topics

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: 1738
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 HPE. My views, opinions, and thoughts expressed here do not represent those of my employer.

Post Reply

Return to “New to Vertica SQL”

Who is online

Users browsing this forum: No registered users and 1 guest