Resource Pool Usage History (v11.1)

Answers

• Bryan_H Vertica Employee Administrator

  November 2022

  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;

  0
• bmurrell Community Edition User ✭

  November 2022

  @Bryan_H said:
  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'.

  0
• Bryan_H Vertica Employee Administrator

  November 2022

  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;

  0
• bmurrell Community Edition User ✭

  November 2022

  Thanks Bryan_H, I'm guessing that reserved_memory_kb_max_value is a good indicator for "in use", so will use that.

  0