Can we identified purge,analyze_statisitics or similar query run on which pool?

hsaxena20hsaxena20 Community Edition User

Can we identified purge,analyze_statisitics or similar query run on which pool?

Answers

  • moshegmosheg Vertica Employee Administrator

    Try something like this if you know the transaction_id and statement_id:
    select resource_pool from query_consumption
    where
    transaction_id = 72057594230919944 and statement_id = 1;

    Or this if you don't:
    select resource_pool from query_consumption
    where
    label = 'xyz';

  • hsaxena20hsaxena20 Community Edition User

    I am using a 9.0.1 version. query_consumption table is not present.

  • Nimmi_guptaNimmi_gupta - Select Field - Employee

    It's from TM (Tuple Mover) pool. Try the below query
    select * from system_services;

Leave a Comment

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