diff options
| -rw-r--r-- | doc/src/sgml/monitoring.sgml | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/doc/src/sgml/monitoring.sgml b/doc/src/sgml/monitoring.sgml index b2a27c8c7fc..f2d99b5c117 100644 --- a/doc/src/sgml/monitoring.sgml +++ b/doc/src/sgml/monitoring.sgml @@ -3291,6 +3291,24 @@ SELECT pid, wait_event_type, wait_event FROM pg_stat_activity WHERE wait_event i Discard the current statistics snapshot </entry> </row> + + <row> + <entry><literal><function>pg_stat_get_xact_blocks_fetched</function>(oid)</literal><indexterm><primary>pg_stat_get_xact_blocks_fetched</primary></indexterm></entry> + <entry><type>bigint</type></entry> + <entry> + Returns the number of buffers fetched for table or index, in the current + transaction. + </entry> + </row> + + <row> + <entry><literal><function>pg_stat_get_xact_blocks_hit</function>(oid)</literal><indexterm><primary>pg_stat_get_xact_blocks_hit</primary></indexterm></entry> + <entry><type>bigint</type></entry> + <entry> + Returns the number of buffer hits for table or index, in the current + transaction. + </entry> + </row> <row> <entry><literal><function>pg_stat_reset()</function></literal><indexterm><primary>pg_stat_reset</primary></indexterm></entry> |