you have your points, my friend.
On 07/17/2018 11:23 AM, Jehan-Guillaume (ioguix) de Rorthais wrote:
> On Tue, 17 Jul 2018 11:03:08 +0200
> Fabio Pardi wrote:
>
>> On 07/17/2018 10:21 AM, Jehan-Guillaume (ioguix) de Rorthais wrote:
>>> On Tue, 17 Jul 2018 10:11:50 +0200
>>
>>> ...and check th
On Tue, 17 Jul 2018 11:03:08 +0200
Fabio Pardi wrote:
> On 07/17/2018 10:21 AM, Jehan-Guillaume (ioguix) de Rorthais wrote:
> > On Tue, 17 Jul 2018 10:11:50 +0200
>
> > ...and check this one: https://github.com/OPMDG/check_pgactivity/
> >
> > It uses bloat queries for tables and btree indexes
On 07/17/2018 10:21 AM, Jehan-Guillaume (ioguix) de Rorthais wrote:
> On Tue, 17 Jul 2018 10:11:50 +0200
> ...and check this one: https://github.com/OPMDG/check_pgactivity/
>
> It uses bloat queries for tables and btree indexes Adrien Nayrat was pointing
> earlier in this thread.
>
> In fact,
On Tue, 17 Jul 2018 10:11:50 +0200
Fabio Pardi wrote:
> If you monitor using nagios (or if you want to make a wrapper around it):
>
> https://bucardo.org/check_postgres/check_postgres.pl.html#bloat
...and check this one: https://github.com/OPMDG/check_pgactivity/
It uses bloat queries for tabl
If you monitor using nagios (or if you want to make a wrapper around it):
https://bucardo.org/check_postgres/check_postgres.pl.html#bloat
works like a charm.
regards,
fabio pardi
On 07/16/2018 05:16 PM, Alessandro Aste wrote:
> Hello, I am trying to put togheter a query to monitor the index
On 07/16/2018 11:50 PM, Alessandro Aste wrote:
> Thanks much, I'll check that out. I see the queries are 3 years old so I'm
> wondering if they still work for 9.6.x or 10
AFAIK they work. You can try yourself by comparing bloated table/index size
before and after vacuum full or reindex ;)
sig
Thanks much, I'll check that out. I see the queries are 3 years old so I'm
wondering if they still work for 9.6.x or 10
Il lun 16 lug 2018, 17:44 Adrien NAYRAT ha
scritto:
> On 07/16/2018 05:16 PM, Alessandro Aste wrote:
> > Hello, I am trying to put togheter a query to monitor the index bloat
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
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 mu
