Improve automatic analyze messages for inheritance trees - Mailing list pgsql-hackers

From Etsuro Fujita
Subject Improve automatic analyze messages for inheritance trees
Date
Msg-id 543269C4.30407@lab.ntt.co.jp
Whole thread Raw
Responses Re: Improve automatic analyze messages for inheritance trees
List pgsql-hackers
I noticed that analyze messages shown by autovacuum don't discriminate
between non-inherited cases and inherited cases, as shown in the below
example:

LOG:  automatic analyze of table "postgres.public.pt" system usage: CPU
0.00s/0.01u sec elapsed 0.06 sec
LOG:  automatic analyze of table "postgres.public.pt" system usage: CPU
0.00s/0.02u sec elapsed 0.11 sec

(The first one is for table "postgres.public.pt" and the second one is
for table inheritance tree "postgres.public.pt".)

So, I'd like to propose improving the messages for inherited cases, in
order to easily distinguish such cases from non-inherited cases.  Please
find attached a patch.  I'll add this to the upcoming CF.

Thanks,

Best regards,
Etsuro Fujita

Attachment

pgsql-hackers by date:

Previous
From: David Rowley
Date:
Subject: Re: Patch to support SEMI and ANTI join removal
Next
From: Andres Freund
Date:
Subject: Re: pg_receivexlog and replication slots