Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Query Progress

Hi Team,

Is there a way we can find if the query which is active for so long is progressing at all or not?

We see some sessions/queries active in the query_requests/sessions but not really sure if they are moving or just a stale connection which is stuck to close the session.

Do we have any easier way to find if the query is moving or not?

Answers

  • Bryan_HBryan_H Employee

    There are a few system tables you could check based on transaction ID and statement ID, for example:
    resource_acquisitions (getting new resources?)
    resource_queues (waiting for resources?)
    execution_engine_profiles (what is it doing now?)
    vs_plan_activities,vs_plan_activity_details (like EE profiles but finer-grained)

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.