PostgreSQL – Check Queries Running More Than 15 Minutes

  By ,

Below is a script to check queries that are running for more than 15 minutes.

SELECT datname,query,state,query_start,
now() - query_start AS query_time
FROM pg_stat_activity
WHERE (now() - query_start) > interval '15 minutes';

Cheers!

Knowledge worth sharing...Share on linkedin
Linkedin
Share on facebook
Facebook
Share on google
Google
Share on twitter
Twitter

Related posts:

  1. PostgreSQL – Get the Size of All Databases
  2. PostgreSQL – Check Transactional Locks / Blocking
  3. PostgreSQL – Check Table Level Locks
  4. PostgreSQL – TOAST (The Oversized-Attribute Storage Technique)
Bookmark the permalink.

Leave a Reply

Leave a Reply

Your email address will not be published. Required fields are marked *