Find out When Vertica was Last Updated

Jim_KnicelyJim_Knicely Administrator, Moderator, Employee, Registered User, VerticaExpert
edited March 25 in Vertica Tips

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

Example:

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:
https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/Glossary/DataCollector.htm

Have fun!

Sign In or Register to comment.