PostgreSQL: Script to find TOP 10 Long Running Queries using pg_stat_statements (Day 2/2)

This is the second day with the PostgreSQL pg_stat_statements module.
In the previous post, I have shared basic steps to configure and enable pg_stat_statements module for tracking query statistics.

In this post, I have prepared one small DBA script to find query statistics such a way that we can easily see the long executed queries.

The PostgreSQL database administrator can use this script for investigating performance related issues.

Anvesh Patel

Leave a Reply

2 Comments on "PostgreSQL: Script to find TOP 10 Long Running Queries using pg_stat_statements (Day 2/2)"

Notify of
avatar
Sort by:   newest | oldest | most voted
kashi
Guest

is this pg_stat_statements available in 9.3?

wpDiscuz