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!

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