We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now

How to check mergeout history?? — Vertica Forum

How to check mergeout history??

HyeontaeJu

HyeontaeJu Vertica Customer ✭

September 2020 edited September 2020 in General Discussion

How to check mergeout history by query??

0

Answers

Jim_Knicely - Select Field - Administrator

September 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

0

Leave a Comment