Postgres monitoring 8.4

 I like the monitoring enhancement of postgres8.4  The following two are very useful if you are debugging the performance issue.

Pg_stat_statements can provide you all the queries and response time. 

• pg_stat_statements (contrib module)
  
  
  • Allows real-time monitoring of summary query statistics, letting you see at a glance which of your normalized queries is executing the most often and using the most system time. pg_stat_statement will speed up the process of "bad query" troubleshooting by an order of magnitude. 
   
  Auto Explain is good if you are debugging application performance.  Just enable for few hours and get SQL performance and turn it off.
  
  
  
• auto_explain (contrib module)
  
  
  • Lets you automatically log select EXPLAIN plans to the PostgreSQL log for later analysis. Will help a great deal with troubleshooting slow stored procedures, as well as queries which perform differently between production and testing. Also allows logging of EXPLAIN plans for nested statements, that is, statements executed from within a function.