How to check mergeout history??

HyeontaeJu

How to check mergeout history by query??

Jim_Knicely

Check the DC_TUPLE_MOVER_EVENTS Data Collector table:

SELECT * FROM dc_tuple_mover_events WHERE operation = 'Mergeout' ORDER BY time DESC;

https://www.vertica.com/docs/10.0.x/HTML/Content/Authoring/AdministratorsGuide/Monitoring/Vertica/RetainingMonitoringInformation.htm