Take the 2-minute tour ×
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. It's 100% free, no registration required.

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
    
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. –  MinimeDJ May 18 '11 at 5:26
add comment

7 Answers 7

up vote 8 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
add comment

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
add comment

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)

share|improve this answer
add comment

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.

share|improve this answer
add comment

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

share|improve this answer
3  
Hi Steve, consider this a brief warning. I encourage you to read this meta.stackexchange.com/questions/88642/… 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
add comment

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

share|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
add comment

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

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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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