## 53.77. `pg_autoprepared_statements`

The `pg_autoprepared_statements` view displays all the autoprepared statements that are available in the current session. See Section 14.6 for more information about autoprepared statements.

Table 53.78. `pg_autoprepared_statements` Columns

Name | Type | Description
--- | --- | ---
`statement` | `text` | The query string submitted by the client from which this prepared statement was created. Note that literals in this string are not replaced with prepared statement placeholders.
`parameter_types` | `regtype[]` | The expected parameter types for the autoprepared 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`.
`exec_count` | `int8` | Number of times this statement was executed.

The `pg_autoprepared_statements` view is read only.