Hello,
PostgreSQL 11.6 (Debian 11.6-2~sid1) on x86_64-pc-linux-gnu, compiled
by gcc (Debian 9.2.1-21) 9.2.1 20191130, 64-bit
Is there something awry with the pg_prepared_statements view?
This is the only row found and it is NOT created by the application.
name statement prepare_time parameter_types from_sql
S_1 ROLLBACK 2020-01-21 12:35:35.031257 {} false
In the development environment every statement is logged, however for
some reason the DEALLOCATE's never appear in the logs. This could be
caused by the view not recording the prepared statement, as the
DEALLOCATE is only made if the prepared statement name exists in the
view.
max_prepared_transactions = 6 is the value set in postgresql.conf.
TIA,
Robert
