A Quick Way to View the Current and Ancient History Mark Epochs

Posted June 20, 2019 by Jim Knicely, Vertica Principal Solution Architect

Tips and Tricks Orange Button
The MANAGE_EPOCH function can be called to quickly display the Current Epoch (CE) and Ancient History Mark (AHM) Epochs!

Example: dbadmin=> SELECT manage_epoch(); manage_epoch ------------------------------------ Current Epoch=1045, AHM Epoch=1044 (1 row) Helpful Links:

https://www.vertica.com/kb/Understanding-Vertica-Epochs/Content/BestPractices/Understanding-Vertica-Epochs.htm

Have fun!