Question

How to check mergeout history??

Forum|Forum|6 years ago
September 14, 2020
1 reply
4 views

Forum|alt.badge.img

+2

HyeontaeJu
Participating Frequently

How to check mergeout history by query??

Forum|alt.badge.img

+2

Jim_Knicely
Participating Frequently
Forum|Forum|6 years ago
September 14, 2020

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

Like