CODEWITHSUNDEEP
postgresqlpostgresql-8.4
Arun Padule
Arun Padule

Reputation: 941

How to get a status of a running query in postgresql database

I have a select query running very long. How will I get a status of that query, like how long will it be running? Whether it is accessing a data from the tables or not.

Note : As per pg_stat_activity the query state is shown as active and not in a waiting state. Like in Oracle, we can see the source/target and processing status of a query - is there something like this in postgresql?

Upvotes: 92

Views: 153257

Answers (3)

Mircea Vutcovici
Mircea Vutcovici

Reputation: 2374

Based on @Anshu answer I am using:

SELECT datname, pid, state, query, age(clock_timestamp(), query_start) AS age 
FROM pg_stat_activity
WHERE state <> 'idle' 
    AND query NOT LIKE '% FROM pg_stat_activity %' 
ORDER BY age;

Upvotes: 99

Himanshu sharma
Himanshu sharma

Reputation: 7891

we can find the query log with respect to the database in postgres .

select *
from pg_stat_activity
where datname = 'yourdatabasename'

This will give active query log of database .

Upvotes: 12

supyo
supyo

Reputation: 3037

This can't be done yet, but is on the TODO.

Upvotes: 9

Related Questions