Find Out When Vertica Was Last Updated

Posted March 25, 2019 by James Knicely, Vertica Field Chief Technologist

Database Server Room
You can check the data collector table DC_UPGRADES to see 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!