Vertica Quick Tip: Monitoring the Ancient History Mark

Posted May 23, 2018 by Soniya Shah, Information Developer

This blog post was authored by Jim Knicely. Also known as AHM, the ancient history mark is the oldest epoch whose data is accessible to historical queries. Any data that precedes the AHM is eligible to be purged. If a cluster nodes is down or if a database contains projections that need to be refreshed, the AHM can lag behind the Current Epoch (CE) increasing the catalog size and degrading query performance. You can view the AHM and CE in several ways. Example: dbadmin=> SELECT ahm_epoch, current_epoch FROM v_monitor.system; ahm_epoch | current_epoch -----------+--------------- 6680 | 6681 dbadmin=> SELECT get_ahm_epoch(), get_current_epoch(); get_ahm_epoch | get_current_epoch —————+——————- 6680 | 6681 (1 row) It’s also really helpful to now when the AHM last advanced! dbadmin=> SELECT get_ahm_time(); get_ahm_time ------------------------------------------------- Current AHM Time: 2018-05-21 09:48:39.075679-04 (1 row) Have Fun!