Re: Query to monitor index bloat

From: Adrien NAYRAT <adrien(dot)nayrat(at)anayrat(dot)info>
To: Alessandro Aste <alessandro(dot)aste(at)gmail(dot)com>, <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Query to monitor index bloat
Date: 2018-07-16 15:44:48
Message-ID: 81b6dcfb-8b3b-ae7c-ac38-f65c4a6d5f6e@anayrat.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 07/16/2018 05:16 PM, Alessandro Aste wrote:
> Hello,  I am trying to put togheter a query to monitor the index bloat
> for a database I maintain.
> Is there a "SQL" way to obtain  bloated index ? I googled around but I
> found nothing working.
>
> I'm currently running 9.6 but I'm looking for something compatible with
> version 10 too.
>
> Thank you very much in advance,
>
>
> Alessandro.

Hello,

You should look at : https://github.com/ioguix/pgsql-bloat-estimation

Regards,

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2018-07-16 20:32:56 User documentation vs Official Docs
Previous Message Alessandro Aste 2018-07-16 15:16:11 Query to monitor index bloat