Contributors mailing list archives

Browse archives


Re: Regular postgres VACUUM command

Vauxoo, Moisés López Calderón
- 02/08/2023 00:20:55
> can anyone recommend a visual Postgres monitoring tool

I use pgbadger too but PGHero is my favorite tool to see real time stats

El vie, 28 jul 2023 a las 3:22, Tom Blauwendraat (<>) escribió:
Thanks Moises and Graeme for the detailed information!

I'm going to look at tweaking autovacuum and statistics settings for the 
busy tables. Also, whenever replacing a big chunk of data, I'll run 
ANALYSE <table> afterwards.

As for most situations the default Postgres settings are fine, and I 
can't think of any "generic" solutions other than monitoring and doing 
individual tweaks, I won't create an OCA module for it.

Parting question: can anyone recommend a visual Postgres monitoring tool 
that could ideally also work on Amazon RDS? I'm familiar with log 
parsing tools such as pgBadger, but maybe there's a tool out there 
somewhere that can give information just by connecting to the instance 
and running smart queries?


Post to:

Moisés López Calderón
Mobile: (+521) 477-752-22-30
Twitter: @moylop260
hangout: - Odoo Gold Partner
Twitter: @vauxoo