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

Find out When Vertica was Last Updated

Jim_KnicelyJim_Knicely Administrator
edited March 2019 in Tips from the Team

You can check the data collector table DC_UPGRADES to see a list of when you upgraded Vertica by version!


dbadmin=> SELECT time, new_version
dbadmin->   FROM dc_upgrades
dbadmin->  LIMIT 1 OVER (PARTITION BY new_version ORDER BY time DESC);
             time             | new_version
2019-02-08 06:37:00.631821-05 | v9.2.0-3
2019-02-14 15:37:10.681135-05 | v9.2.0-4
2019-03-20 11:44:51.630861-04 | v9.2.0-5
2019-03-25 09:51:24.638255-04 | v9.2.0-6
(4 rows)

Helpful Link:

Have fun!

Sign In or Register to comment.

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