The Vertica Database Forums

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!!!

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;