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 54.15. 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 |
The types of the columns returned by 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.
If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.