Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Vertica super slow, should I restart it?

Vertica 7.1


I added a new column to a table.  Ran database designer with comprehensive design.  After a few minutes system stated database designer failed for unknown reasons.  


Waited for an hour but server top shows 22 load.  Normally load is around 1.


Screen Shot 2016-07-27 at 11.11.02 AM.png



No queries are running:


Screen Shot 2016-07-27 at 11.15.15 AM.png



System is now so slow it is unusable.  Should I use adminTools to restart Vertica?


  • Can you check to see what is going on in Vertica.log?




  •  See if you have internal session running. Best way is to install Vertica Management Console so you can track the IO/CPU and cross refrerence with internal and user query usage.


Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

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