Postgres Pro
Downloads
Home   >   mailing lists

Fwd: Emit namespace in post-copy output - Mailing list pgsql-hackers

From Mike
Subject Fwd: Emit namespace in post-copy output
Date
Msg-id CAMerE0oz+8G-aORZL_BJcPxnBqewZAvND4bSUysjz+r-oT1BxQ@mail.gmail.com
Whole thread Raw
Responses Re: Emit namespace in post-copy output
List pgsql-hackers
Tree view
When running a VACUUM or CLUSTER command, the namespace name is not part of the emitted message.

Using `vacuumdb` CLI tool recently with multiple jobs, I found that reading the output messages harder to match the relations with their namespaces.

Example:

INFO:  vacuuming "sendgrid.open"
INFO:  vacuuming "mailgun.open"
...
INFO:  "open": found 0 removable, 31460776 nonremovable row versions in 1358656 pages
DETAIL:  0 dead row versions cannot be removed yet.
CPU 31.35s/261.26u sec elapsed 1620.68 sec.
...

In this example. the user can't readily tell which `open` relation was completed.

Attached is a patch using existing functions to include the namespace in the output string.

Looking forward to feedback!
-Mike Fiedler
Attachment

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Reducing the cycle time for CLOBBER_CACHE_ALWAYS buildfarm members
Next
From: Alvaro Herrera
Date:
Subject: Re: Pipeline mode and PQpipelineSync()