Options
Find out When Vertica was Last Updated
Jim_Knicely
- Select Field - Administrator
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!
0