The following features help in tuning performance:
Monitoring event history
Postgres Enterprise Manager
Performance Diagnostic