Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
What are some query performance troubleshooting tips?
Leave a Comment
Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.
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.