How to Monitor Mergeout in Vertica ?

Monitor the merge-out in Vertica using the print_next_mergeout_job().

The mergeout is the process of consolidating ROS containers and purging deleted records.

dbadmin=> select print_next_mergeout_job();
 print_next_mergeout_job
----------------------------------
 Eligible for mergeout:
No ROSes eligible for mergeout
 Eligible for dv mergeout:
No DVROSes eligible for mergeout
(1 row)

The function will give you details about your merge jobs and their pending mergout tasks.