public inbox for [email protected]
help / color / mirror / Atom feedFrom: Sami Imseih <[email protected]>
To: Alena Rybakina <[email protected]>
Cc: wenhui qiu <[email protected]>
Cc: pgsql-hackers <[email protected]>
Subject: Re: POC: track vacuum/analyze cumulative time per relation
Date: Fri, 10 Jan 2025 10:21:56 -0600
Message-ID: <CAA5RZ0uVgHa2JLSEsq8jDMRdUmyfhz9gg0UHhx0g2zoB7h_faA@mail.gmail.com> (raw)
In-Reply-To: <CAA5RZ0tBsAa-CY=-z_VPjFvMRWnKLzkt0QAUQxUx+CO1-YiS8g@mail.gmail.com>
References: <CAA5RZ0uVOGBYmPEeGF2d1B_67tgNjKx_bKDuL+oUftuoz+=Y1g@mail.gmail.com>
<CAGjGUAJEhvsjni3q5y0iGAptb6s5UpxKJiLj3A_1CUwGdrujdA@mail.gmail.com>
<[email protected]>
<CAA5RZ0tBsAa-CY=-z_VPjFvMRWnKLzkt0QAUQxUx+CO1-YiS8g@mail.gmail.com>
> > this information gives a complete picture of vacuum efficiency, because
> > analyzing only total_time statistics does not give a complete picture of
> > what vacuum did: was it cleaning almost huge index, cleaning tables or
> > just sleeping.
>
> The purpose of total_time is to be able to calculate the average
> time of a vacuum per relation from pg_stat_all_tables (by
> total_time/vacuum_count) This is useful on its own to be able to
> trend slow downs of vacuum ( or improvements after vacuum tuning )
> for specific relations.
>
> The work going into [1] is more detailed and will be useful
> for deep dive investigations.In short, I think both proposals
> have merit.
Missed this point in my last reply. This patch also tracks
(auto)analyze per relation cumulative timing which can
be useful along with (auto)analyze_count to derive
the average.
Regards,
Sami
view thread (5+ messages)
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: POC: track vacuum/analyze cumulative time per relation
In-Reply-To: <CAA5RZ0uVgHa2JLSEsq8jDMRdUmyfhz9gg0UHhx0g2zoB7h_faA@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox