In my return from pg_stat_activity, there are many processes in the "query" column that have the value "DEALLOCATE pdo_stmt_00000001".
What does it mean?
PostgreSQL – Understanding DEALLOCATE pdo_stmt_00000001 in pg_stats_activity
postgresql
Related Question
- PostgreSQL – Query Behavior of Composite GIN Index
- PostgreSQL – What Does IDLE State Mean in pg_stat_activity?
- Postgresql – Collapsing a column to yes/no on query
- Postgresql – What does ‘fully determines’ mean in the context of postgres functional dependency statistics
- Postgresql – Postgres query slow, shows long running active queries, statement_timeout does not work
- PostgreSQL – Return Only Rows Under Certain Constraints in Join
- PostgreSQL INSERT Stuck – Causes and Solutions
Best Answer
The
stateof these connections is probably (and hopefully)idle.That means that the last thing that happened on these connections was to deallocate a prepared statement.
That is kind of funny, because one of the key advantages of prepared statements is to exist for a longer time and be reused. Maybe the application uses a connection pool and wants to “clean” the connection before returning it to the pool.
Anyway, there is nothing to worry about.