| From: | Laurentius Purba <lpurba(at)sproutloud(dot)com> |
|---|---|
| To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Question regarding DEALLOCATE pdo_stmt_00000001 |
| Date: | 2014-05-21 22:02:48 |
| Message-ID: | CAMfLBniLNa2ZevO39-C_D5aQjvLVamV4RmWTk-0kBf+t0jufmA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | AI Rumman | 2014-05-21 22:14:38 | Lock during insert statement |
| Previous Message | Jeff Janes | 2014-05-21 21:01:28 | Re: Do foreign key triggers get ran even if the key's value doesn't change? |