Movatterモバイル変換

ホーム

52.15. `pg_prepared_statements`
Prev	Up	Chapter 52. System Views	Home	Next

52.15. `pg_prepared_statements`#

Thepg_prepared_statements view displays all the prepared statements that are available in the current session. SeePREPARE 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 theDEALLOCATE command).

Table 52.15. pg_prepared_statements Columns

Column Type Description
`nametext` The identifier of the prepared statement
`statementtext` The query string submitted by the client to create this prepared statement. For prepared statements created via SQL, this is the`PREPARE` statement submitted by the client. For prepared statements created via the frontend/backend protocol, this is the text of the prepared statement itself.
`prepare_timetimestamptz` The time at which the prepared statement was created
`parameter_typesregtype[]` The expected parameter types for the prepared statement in the form of an array of`regtype`. The OID corresponding to an element of this array can be obtained by casting the`regtype` value to`oid`.
`result_typesregtype[]` The types of the columns returned by the prepared statement in the form of an array of`regtype`. The OID corresponding to an element of this array can be obtained by casting the`regtype` value to`oid`. If the prepared statement does not provide a result (e.g., a DML statement), then this field will be null.
`from_sqlbool` `true` if the prepared statement was created via the`PREPARE` SQL command;`false` if the statement was prepared via the frontend/backend protocol
`generic_plansint8` Number of times generic plan was chosen
`custom_plansint8` Number of times custom plan was chosen

Column Type

Description

nametext

The identifier of the prepared statement

statementtext

The query string submitted by the client to create this prepared statement. For prepared statements created via SQL, this is thePREPARE statement submitted by the client. For prepared statements created via the frontend/backend protocol, this is the text of the prepared statement itself.

prepare_timetimestamptz

The time at which the prepared statement was created

parameter_typesregtype[]

The expected parameter types for the prepared statement in the form of an array ofregtype. The OID corresponding to an element of this array can be obtained by casting theregtype value tooid.

result_typesregtype[]

The types of the columns returned by the prepared statement in the form of an array ofregtype. The OID corresponding to an element of this array can be obtained by casting theregtype value tooid. If the prepared statement does not provide a result (e.g., a DML statement), then this field will be null.

from_sqlbool

true if the prepared statement was created via thePREPARE SQL command;false if the statement was prepared via the frontend/backend protocol

generic_plansint8

Number of times generic plan was chosen

custom_plansint8

Number of times custom plan was chosen

Thepg_prepared_statements view is read-only.

Prev	Up	Next
52.14. `pg_policies`	Home	52.16. `pg_prepared_xacts`

pdf epub

By continuing to browse this website, you agree to the use of cookies. Go toPrivacy Policy.

ページ先頭

Movatterモバイル変換

52.15. pg_prepared_statements#

52.15. `pg_prepared_statements`#