Waiting for PostgreSQL 13 – Allow autovacuum to log WAL usage statistics.

On 6th of April 2020, Amit Kapila committed patch:

Allow autovacuum to log WAL usage statistics. 
 
This commit allows autovacuum to log WAL usage statistics added by commit
df3b181499.
 
Author: Julien Rouhaud
Reviewed-by: Dilip Kumar and Amit Kapila
Discussion: https://postgr.es/m/CAB-hujrP8ZfUkvL5OYETipQwA=e3n7oqHFU=4ZLxWS_Cza3kQQ@mail.gmail.com

Description is pretty obvious, but let's see how it looks.

After enabling autovacuum logs by setting log_autovacuum_min_duration to 0, and triggering autovacuum, I saw in logs:

2020-04-17 14:57:28.762 CEST @ 243260  LOG:  automatic vacuum OF TABLE "depesz.public.test": INDEX scans: 1
        pages: 0 removed, 648 remain, 0 skipped due TO pins, 0 skipped frozen
        tuples: 51253 removed, 50162 remain, 0 are dead but NOT yet removable, oldest xmin: 5708
        buffer usage: 2309 hits, 0 misses, 1 dirtied
        avg READ rate: 0.000 MB/s, avg WRITE rate: 0.105 MB/s
        system usage: CPU: USER: 0.04 s, system: 0.00 s, elapsed: 0.07 s
        WAL usage: 2232 records, 1 FULL page writes, 441039 bytes

Which is pretty cool. Thanks to all involved.

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.