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.

Tagged:

Answers

  • baron42bbabaron42bba

    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
Format
Heading 1Heading 2
QuoteCodeSpoiler
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.