Skip to main content
Question

resource_queues and resource_pool_status table are blank

  • November 13, 2019
  • 4 replies
  • 16 views

hsaxena20
Forum|alt.badge.img+1

Hello All,
These two tables are blank in Vertica. What should be possible cases when it is blank and how I can enable logging in these tables?

4 replies

Nimmi_gupta
Forum|alt.badge.img
  • Participating Frequently
  • November 13, 2019

Resource queues could be blank if there are no requests pending for various resource pools.
Can you provide the out of the below query
select * from resource_pool_status;


hsaxena20
Forum|alt.badge.img+1
  • Author
  • Participating Frequently
  • November 14, 2019

Hey Nimmi,
Please find attached file.


Nimmi_gupta
Forum|alt.badge.img
  • Participating Frequently
  • November 14, 2019

Downloaded and reviewed the status table and it's not blank. What information you trying to look into resource_pool_status table?


Nimmi_gupta
Forum|alt.badge.img
  • Participating Frequently
  • November 14, 2019

++ Can you check for active sessions by running the below query
select count() from sessions where statement_id is not null;
++ Check for the total number of executing query
select count(
) from query_requests where is_executing;
++ If both the above table return some value resource_pool_status should show some records by running below query. If not it could be a bug.
select * from resource_pool_status where running_query_count > 0;