Server Fault is a question and answer site for system and network administrators. 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

Does PostgreSQL have good performance or administration tools?

I have been using postgres for quite some time now, but I still do not know a huge amount about ways to optimise and maintain a database, and keep it running well.

I have had a look through the manual, but since it is quite a mature product, I am assuming there are a couple of 'must-have' utilities for it?


locked by HopelessN00b Dec 5 '14 at 6:29

This question exists because it has historical significance, but it is not considered a good, on-topic question for this site, so please do not use it as evidence that you can ask similar questions here. This question and its answers are frozen and cannot be changed. More info: help center.

closed as not constructive by mgorven, Stefan Lasiewski, Bryan, Dave M, Michael Hampton Feb 13 '13 at 23:57

As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, visit the help center for guidance.If this question can be reworded to fit the rules in the help center, please edit the question.

up vote 13 down vote accepted

I think that PgAdmin is pretty popular. There's also PhpPgAdmin, which is rougly analagous to the very popular phpMyAdmin.


Perhaps not what you're looking for, but plain old psql is excellent. You can tell that the devs really meant for it to be a comfortable place to spend a lot of time.


For general schema navigation DBVisualizer is quite nice.

For performance information there are hardly any complete tools like MySQL Enterprise Monitor; I'd suggest to use pgFouine (already suggested) and any tool that can graph performance data (like Munin for example), collect the relevant information from PostgreSQL (pg_stat_ views/system tables) and the system itself (memory, cpu, disk utiliziation, etc.) and use this as a basis for deducing trends.

This book has a few chapters on PostgreSQL performance; the PostgreSQL Wiki has a list of presentations on this topic.

And for specific questions there's always the pgsql-performance mailinglist and it's comprehensive archive.


this guy has developed quite a few useful tools. take a look at his blog.


For real simple tasks we use phpPgAdmin.

phpPgAdmin is a web-based administration tool for PostgreSQL. It is perfect for PostgreSQL DBAs, newbies and hosting services.



pgFouine is a great log analyzer that has helped many times in the past. It is really easy to set up too. At one point the project ran on Rails, but I think it's using PHP now.

+1 because it is a great tool. It looks like the project hasn't been touched in a long time. It also has a lot of issues processing a lot of data (it is a PHP script after all). – Trey May 29 '09 at 17:00

TeamPostgreSQL is by far the best I've ever used.

  • Works on any platform (Windows, OS X, or Linux)
  • No stability issues that I've encountered (pgAdmin plagued me with them)
  • Columns can be sorted by clicking on them (unlike pgAdmin)
  • DB hosts not hard coded into a config file (unlike phpPgAdmin)
  • Doesn't feel antiquated

Major drawback: it doesn't support SSL connections.


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