What are some query performance troubleshooting tips?

rjs_docsrjs_docs Employee
edited April 1 in General Discussion

Can you please provide some query performance troubleshooting tips? For example, when most of my users are reporting that queries are running longer than expected time, what can I quickly check to find the source of the issue?
@bat @rbankula

From Optimizing Query Performance and Resource Pool Tuning.

Answers

  • I would start with the current list of sessions and queries executed.
    Maybe a web frontend is running a "attack" on Vertica.
    Next step should be the system performance.
    Is everything healthy? RAID Controller with healthy cache? BatteryBackupUnit?
    AWS EBS slow?
    Only after these checks I would dive into the data and tables itself.
    Maybe recent changes on projections or the amount of data getting ingested changed.

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.