52.77. 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 52.78.
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.