pg_prepared_statements
The 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 DEALLOCATE command).
Table pg_prepared_statements
Columns
Column Type Description |
---|
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 |
The pg_prepared_statements
view is read-only.