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!!!
What resource pool did query use?
Moderator: NorbertKrupa
What resource pool did query use?
Thanks,
Juliette
Juliette
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: What resource pool did query use?
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;
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
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.