I am planing to have very soon few highly loaded postgresql databases. I have some expirience managing mysql databases with high load, but now we have to use postgresql.

I want to know what are the best tools for day-to-day database management and status reporting. (Of course console is the best one, but I want to know about other options too)

All expirience is welcome!

  • What sort of load - OLTP? – Jack says try topanswers.xyz May 17 '11 at 18:55
  • Yes, mostly OLTP and some stats calculation. It will be a backend for online game for social networks with some capitalism in it. – Worker May 18 '11 at 5:26

Is pg_statsinfo something for you? Maybe the default stats collected are sufficient? There are some nice posts on SO with a similar topic.

|improve this answer|||||

What are you using for your other monitoring, e.g. disk space, processor load, etc? If it is Nagios then you can just get a Postgres plugin for it. That is probably better than having a whole 'nother monitoring framework.

|improve this answer|||||

Depending on what you're exactly looking for there are many different tools to consider. As always, there's no silver bullet in the monitoring world.

I started compiling a somewhat authoritative list of tools at the PostgreSQL Wiki which can be found here: http://wiki.postgresql.org/wiki/Monitoring

At the end of 2012 I also started working on a Postgres monitoring project, trying to harness the information that pg_stat_plans offers. It's called pganalyze and can be found at https://pganalyze.com - the parts we're opensourcing are available at github.

|improve this answer|||||

There is a new tool available from Cybertec:


(I have not used it though)

|improve this answer|||||


|improve this answer|||||

You can check out dbWatch. Its a cross platform monitoring and administration tool, that in the future will also add more modules such as audit, database replication and improved performance tuning.

I am quite partial, as I work there, but check it out at http://www.dbwatch.com/. There is a free 10 day full use license included, but we can extend this if you need to test further.


|improve this answer|||||
  • 2
    voting up, no reason this required a downvote as the user clearly explained he works there and presented a solution that addressed the OPs needs. – Ali Razeghi Oct 4 '13 at 18:37

I suggest you to check out MindArray IPM. It provides much deeper insight of Postgresql performance by rendering you a customizable performance metrics for monitoring key performance indicators. All the performance issues related to slow SQL, table locks and user sessions are reported to DBA/IT admins in real-time. IPM allows you to specify your own thresholds or smart threshold based on baselining the collected data from normal database performance behavior. Smart threshold helps you eliminate false alters from your mailbox.

I am using this from last one year.


|improve this answer|||||
  • 1
    Do you have any affiliation with the vendor? – Colin 't Hart Apr 14 '14 at 10:16

Not the answer you're looking for? Browse other questions tagged or ask your own question.