diff options
| author | Fujii Masao | 2020-07-20 02:55:50 +0000 |
|---|---|---|
| committer | Fujii Masao | 2020-07-20 02:55:50 +0000 |
| commit | d05b172a760e0ccb3008a2144f96053720000b12 (patch) | |
| tree | 8acef7bc05b6485a04613c58ae2c3dce50c6701e /doc/src | |
| parent | 044dc7b964147ec6303d59320fb743693b22af30 (diff) | |
Add generic_plans and custom_plans fields into pg_prepared_statements.
There was no easy way to find how many times generic and custom plans
have been executed for a prepared statement. This commit exposes those
numbers of times in pg_prepared_statements view.
Author: Atsushi Torikoshi, Kyotaro Horiguchi
Reviewed-by: Tatsuro Yamada, Masahiro Ikeda, Fujii Masao
Discussion: https://postgr.es/m/CACZ0uYHZ4M=NZpofH6JuPHeX=__5xcDELF8hT8_2T+R55w4RQw@mail.gmail.com
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/catalogs.sgml | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/doc/src/sgml/catalogs.sgml b/doc/src/sgml/catalogs.sgml index 80c183b2355..9f00ea90e32 100644 --- a/doc/src/sgml/catalogs.sgml +++ b/doc/src/sgml/catalogs.sgml @@ -10841,6 +10841,24 @@ SELECT * FROM pg_locks pl LEFT JOIN pg_prepared_xacts ppx frontend/backend protocol </para></entry> </row> + + <row> + <entry role="catalog_table_entry"><para role="column_definition"> + <structfield>generic_plans</structfield> <type>int8</type> + </para> + <para> + Number of times generic plan was chosen + </para></entry> + </row> + + <row> + <entry role="catalog_table_entry"><para role="column_definition"> + <structfield>custom_plans</structfield> <type>int8</type> + </para> + <para> + Number of times custom plan was chosen + </para></entry> + </row> </tbody> </tgroup> </table> |