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.

  • Running the print_next_mergeout_job() function.
  • 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.