Re: [GENERAL] Innotop for postgresl
On Jan 3, 2010, at 4:10 AM, Alexis Michon wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Hello, Is there any software for postgresql like innotop for mysql ? I would like to monitor postgresql with Cacti, but i didn't find any module for that in cacti, do you know a module for that ? While some templates that already do this are fine, it's not hard to write some cacti graph templates that simply execute scripts that get their values from the pg_stat_get_*() functions directly: http://www.postgresql.org/docs/8.4/interactive/monitoring-stats.html#MONITORING-STATS-VIEWS Erik Jones, Database Administrator Engine Yard Support, Scalability, Reliability 866.518.9273 x 260 Location: US/Pacific IRC: mage2k -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] Innotop for postgresl
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Hello, Is there any software for postgresql like innotop for mysql ? I would like to monitor postgresql with Cacti, but i didn't find any module for that in cacti, do you know a module for that ? ++ Alexis - -- Alexis MICHON CNRS, France IBCP, Institut de Biologie et Chimie des Proteines Mail : alexis.mic...@ibcp.fr Tel : 04.72.72.26.46 Empreinte : 8FDA 1594 2C18 EEDA 681E 8A6D 56EF F0A0 6F06 892A -BEGIN PGP SIGNATURE- Version: GnuPG/MacGPG2 v2.0.12 (Darwin) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iF4EAREIAAYFAktAiR4ACgkQ1SPVZdGGxBlMIQEAntoGgS53ci4ZGLBmcoYJ4mxe dCH9GqZMV43dQXj/7CoA/AoInQfqk0RCRKJGjcX0wsS4GN8AZ799q0umKQnPD/+P =MPum -END PGP SIGNATURE- -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Innotop for postgresl
Is there any software for postgresql like innotop for mysql ? I would like to monitor postgresql with Cacti, but i didn't find any module for that in cacti, do you know a module for that ? You have pgstats from Kenny Gorman. you can download my modified version with some enhacements (cosmetic at all) here: http://desarrollos.siu.edu.ar/trac/postgresql/attachment/wiki/Desarrollos/pgstat -- Emanuel Calvo Franco DBA at: www.siu.edu.ar www.emanuelcalvofranco.com.ar -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Innotop for postgresl
Hi, Is there any software for postgresql like innotop for mysql ? I am not sure. A while ago I saw a demo of pgtop, but I haven't actually used it. I forget exactly who created it, but I think that at least Selena Deckelmann had contributed to it. I would like to monitor postgresql with Cacti, but i didn't find any module for that in cacti, do you know a module for that ? No, but perhaps it would be a good thing to add to http://code.google.com/p/mysql-cacti-templates/ (which despite the name has high-quality templates for quite a few different things). -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Innotop for postgresl
Alexis Michon wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Hello, Is there any software for postgresql like innotop for mysql ? I would like to monitor postgresql with Cacti, but i didn't find any module for that in cacti, do you know a module for that ? There is 'ptop' for watching things in progress: http://pgfoundry.org/projects/ptop/ This looks promising for monitoring postgres in cacti: http://forums.cacti.net/about23300.html I don't use cacti myself so not sure how well it works if at all. -- Postgresql php tutorials http://www.designmagick.com/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Innotop for postgresl
Alexis Michon wrote: Is there any software for postgresql like innotop for mysql ? I would like to monitor postgresql with Cacti, but i didn't find any module for that in cacti, do you know a module for that ? See pg_top http://ptop.projects.postgresql.org/ Not sure about Cacti, but some people use Munin and Zabbix successfully. You can probably find scripts/modules by searching around. -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general