The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

resource_queues and resource_pool_status table are blank

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?

Answers

  • 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;

  • Hey Nimmi,
    Please find attached file.

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

  • ++ 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;

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.