Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

find TOP 10 Long Running Queries using pg_stat_statements

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.
SELECT 
 pd.datname
 ,pss.query AS SQLQuery
 ,pss.rows AS TotalRowCount
 ,(pss.total_time / 1000 / 60) AS TotalMinute 
 ,((pss.total_time / 1000 / 60)/calls) as TotalAverageTime  
FROM pg_stat_statements AS pss
INNER JOIN pg_database AS pd
 ON pss.dbid=pd.oid
ORDER BY 1 DESC 
LIMIT 10;

Comments

  1. as a suggestion, the result should be sorted by column 4

    ReplyDelete

Post a Comment

Popular posts from this blog

PostgreSQL Pgbadger Installation On Linux

PostgreSQL Sequence

Postgresql maximum size

How to configure Replication Manager (repmgr) ?

PostgreSQL pgBadger