The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
Resource Pool Usage History (v11.1)

Hi all
I'm looking at resource_pool_status, and use (memory_inuse_kb/memory_size_actual_kb)*100 to determine the % Used for each pool.
I'm trying to get the history for this, so looking at dc_resource_pool_status%. However, these columns don't exist and I can't determine how to get this historically?
Any help would be appreciated.
Thanks
Tagged:
0
Answers
Check out the history tables such as:
dc_resource_pool_status_by_minute
You can list all history tables by running:
select * from data_collector order by table_name;
Hi Bryan_H, I've been looking at the dc_resource_pool_status_by_minute, but there is no column that looks like it contains anything that's 'inuse'.
I usually check reserved memory/queries as "in use". Here's a sample query I run to find maximum reserved memory compared to concurrency in resource pools:
select pool_name,reserved_queries_max_value,max(reserved_memory_kb_max_value) as memoryKB,count(*) as minutes from dc_resource_pool_status_by_minute
where date(start_time) = current_date
group by 1,2 order by 1 asc,2 desc;
Thanks Bryan_H, I'm guessing that reserved_memory_kb_max_value is a good indicator for "in use", so will use that.