Vertica Health Check script
One common qquery I often get with vertica is this, the system is slow and queries are taking a very long time to run.
If my vertica version is V5, I would like to know what kind of diagnostic queries I can run to check on the health of the vertica db instance. Apologies for asking such a trivial question, I am quote new to it.
Thanks in advance.