I have to monitor database statistic for postgresql.In future it may change.So the tool which support multiple database server would be better. The statistics are like : 1. Query execution time. 2. Number of queries that are executed per sec. 3. Number of queries are still in execution. 4. Ram usage of the query utlitization.

If any module available to integrate in my applications??


I don't know any open source module, which really meet your requirements (especially real-time analyzing), but you might take a look at comercial product Postgres Plus® HQ Monitoring.

Another attempt is to set log_duration and log_statement parameters and anylyze logfiles. For example you can use CSV format and load data back to server or use ordinary format with pgFouine (a PostgreSQL log analyzer).

To get currently executed queries you can use pg_stat_activity view. I have no idea how to obtain their memory usage.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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