Contributors mailing list archives
contributors@odoo-community.org
Browse archives
Re: Regular postgres VACUUM command
by
Vauxoo, Moisés López Calderón
> 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 (<notifications@odoo-community.org>) 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? -Tom_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
Moisés López Calderón
Mobile: (+521) 477-752-22-30
Twitter: @moylop260
Twitter: @vauxoo
