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

How to check maximum parallel query count for processing of vertica?

How to check maximum parallel query count for processing of vertica?

Answers

  • moshegmosheg Administrator
    edited November 2020

    In general, when running more than one query concurrently, both queries are sharing the system resources.
    Queries on segmented tables run on all the nodes, and adding more nodes usually improve the run time of a query.
    If a query does not get enough of a particular resource to run, then the system becomes a bottleneck and you may reach a limit.
    In order to increase concurrency in such cases, the system must be expanded by adding more of that resource.
    One can monitor the utilization via Vertica management console or via CLI manually,
    For example, monitor correlation between concurrent queries count, CPU utilization, and queries elapsed time here:
    https://www.vertica.com/blog/vsql-visual-storytelling-through-query-language/

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.