pg_prepared_statements view displays all the prepared statements that are available in the current session. See PREPARE for more information about prepared statements.
pg_prepared_statements contains one row for each prepared statement. Rows are added to the view when a new prepared statement is created and removed when a prepared statement is released (for example, via the
The identifier of the prepared statement
The query string submitted by the client to create this prepared statement. For prepared statements created via SQL, this is the
The time at which the prepared statement was created
The expected parameter types for the prepared statement in the form of an array of
Number of times generic plan was chosen
Number of times custom plan was chosen
pg_prepared_statements view is read-only.