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?

7 Answers 7


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, 2009 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.