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
Question
What are some query performance troubleshooting tips?
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.
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
