>
>
>> 9.3 - On an idle connection the value of query is the last executed query
>> -
>> which in this case is some form session cleanup command before returning
>> the
>> connection to the pool.
>>
>>
> So, it is a normal behavior in Postgres.
>
> One more thing that bothers me, why this idle con
On Wed, May 21, 2014 at 7:50 PM, David G Johnston <
david.g.johns...@gmail.com> wrote:
> Laurentius Purba wrote
> > Hello all,
> >
> > I've been seeing lots of this processes in my database DEALLOCATE
> > pdo_stmt_0001 with idle state.
> >
> > Executing *select * from pg_stat_activity where qu
Laurentius Purba wrote
> Hello all,
>
> I've been seeing lots of this processes in my database DEALLOCATE
> pdo_stmt_0001 with idle state.
>
> Executing *select * from pg_stat_activity where query like
> 'DEALLOCATE%';*I can see some of them are idle for +/- 30 minutes, and
> there is one idl
Hello all,
I've been seeing lots of this processes in my database DEALLOCATE
pdo_stmt_0001 with idle state.
Executing *select * from pg_stat_activity where query like
'DEALLOCATE%';*I can see some of them are idle for +/- 30 minutes, and
there is one idle
for 4 days.
When I checked one of th
