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.