Postgres Pro
Downloads
Home   >   mailing lists

Re: Query running for 12 hours - Mailing list pgsql-general

From Yavuz Selim Sertoğlu
Subject Re: Query running for 12 hours
Date
Msg-id CAJTnKsp6iop5hiOiLOGgzFdxeu+-OhX6AT=M5goJceq4z6OfQg@mail.gmail.com
Whole thread Raw
In response to Re: Query running for 12 hours  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: Query running for 12 hours
List pgsql-general
Tree view


2018-05-30 17:02 GMT+03:00 Adrian Klaver <adrian.klaver@aklaver.com>:
On 05/30/2018 06:54 AM, Yavuz Selim Sertoğlu wrote:
I am just a regular dba so I dont know what's sent from application exactly but I assume now()-1 week.
 In the log file, there are two more same queries. And their value is *2018-05-23 02:00:00*

 
And these queries are not showing up in pg_stat_activity as still active?
>> I think these were completed so they are not in pg_stat_activity.

 




--
Adrian Klaver
adrian.klaver@aklaver.com


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Query running for 12 hours
Next
From: Adrian Klaver
Date:
Subject: Re: Query running for 12 hours