17

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!

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
12

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

8

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.

5

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.

3

There is a new tool available from Cybertec:

http://www.cybertec.at/en/postgresql_products/pgwatch-cybertec-enterprise-postgresql-monitor

(I have not used it though)

1

http://www.logicmonitor.com/monitoring/databases/postgres-monitoring/

1

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.

-Chris

  • 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
1

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.

http://www.mindarraysystems.com/postgresql-monitoring.php

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