Tools for investigating query performance?

What are the best visualization tools / reporting tools to investigate query performance, or anything automated?
Question from Optimizing Query Performance and Resource Pool Tuning @rbankula @bat

Answers

  • siddyashsiddyash Employee

    We have Management Console that can provide Query performance and monitor the Vertica Cluster.
    Apart from this, Datadog is the first 3rd party Monitoring tool that provide information provide similar performance monitoring information of Vertica database and this automatically collects and refresh at a fixed interval. Here is link for more information https://www.datadoghq.com/blog/monitoring-vertica-analytics-platform/
    In addition, using any visualization tools or reporting tools (like Tableau, PowerBI etc) , one can create their query performance dashboard.
    @rbankular, you can add about Advisory Reports that is generated based on the scrutinize that is provided by customers.

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.