Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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!

share|improve this question

closed as off-topic by Paul White, Phil, RolandoMySQLDBA, Aaron Bertrand Jan 26 '15 at 14:40

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Shopping list question - questions about which tool, library, product or resource you should use are off-topic here because they quickly become obsolete and often are just about the preferences of the answerer. If you have an issue with or a question about a specific tool, please revise your question to conform to that scope." – Paul White, Phil, RolandoMySQLDBA, Aaron Bertrand
If this question can be reworded to fit the rules in the help center, please edit the question.

What sort of load - OLTP? – Jack Douglas 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
up vote 10 down vote accepted

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

share|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.

share|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:

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 - the parts we're opensourcing are available at github.

share|improve this answer

There is a new tool available from Cybertec:

(I have not used it though)

share|improve this answer

share|improve this answer
Hi Steve, consider this a brief warning. I encourage you to read this… and then to peruse our FAQ May I promote products or websites I am affiliated with here? where it states "May I promote products or websites I am affiliated with here? Be careful, because the community frowns on overt self-promotion and tends to vote it down and flag it as spam." ~ Bear in mind we absolutely value your expert opinion, and really do want you to contribute. Help us help you! – jcolebrand May 18 '11 at 22:24

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 There is a free 10 day full use license included, but we can extend this if you need to test further.


share|improve this answer
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.

share|improve this answer
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.