Postgres Pro
Downloads
Home   >   mailing lists

Question regarding DEALLOCATE pdo_stmt_00000001 - Mailing list pgsql-general

From Laurentius Purba
Subject Question regarding DEALLOCATE pdo_stmt_00000001
Date
Msg-id CAMfLBniLNa2ZevO39-C_D5aQjvLVamV4RmWTk-0kBf+t0jufmA@mail.gmail.com
Whole thread Raw
Responses Re: Question regarding DEALLOCATE pdo_stmt_00000001  (David G Johnston <david.g.johnston@gmail.com>)
List pgsql-general
Tree view
Hello all,

I've been seeing lots of this processes in my database DEALLOCATE pdo_stmt_00000001 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 the pid by executing select * from pg_stat_activity where pid = 63882; (for example), after few minutes (can be longer), it became DISCARD ALL and after that it was removed from pg_stat_activity.

I was wondering if this is the normal behavior, since some of them are idle for +/- 30 minutes.

I am using PostgreSQL 9.3.2 and PgBouncer.

Any help is appreciated.

Regards,

-Laurentius

pgsql-general by date:

Previous
From: Jeff Janes
Date:
Subject: Re: Do foreign key triggers get ran even if the key's value doesn't change?
Next
From: AI Rumman
Date:
Subject: Lock during insert statement