Hi ,
I am trying to check current running sql queries in postgres through
pg_stat_activity .However, in the current_query column I could see only
"IDLE" . I am not able to see the query .
Thanks
Paramjib Baruah
On 23/11/2015 10:33, paramjib baruah wrote:
I am trying to check current running sql queries in postgres through
pg_stat_activity .However, in the current_query column I could see
only "IDLE" . I am not able to see the query .
That would suggest no query is running, what suggests to you that
You have not specified your O/S or PostgreSQL version, but if you are
running on a Linux O/S, you can run the attached current_queries.sh, which
loops every 5 seconds by default.
Note the usage options below:
usage() {
echo "Usage: $0 [-s -d -h -U -p
-x -i]"
echo "-x will exit after 1