diff options
| author | Magnus Hagander <magnus@hagander.net> | 2010-01-28 14:25:41 +0000 |
|---|---|---|
| committer | Magnus Hagander <magnus@hagander.net> | 2010-01-28 14:25:41 +0000 |
| commit | 083e1b0f27df985a82dda656c0e5bafd17930d06 (patch) | |
| tree | 8cceaf19d305f0370fa2f442e9665683f0199f8c /doc/src | |
| parent | 21d3ae09da6821c0014a4f8e60c547286ffb9b41 (diff) | |
Add functions to reset the statistics counter for a single table/index or
a single function.
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/monitoring.sgml | 20 |
1 files changed, 19 insertions, 1 deletions
diff --git a/doc/src/sgml/monitoring.sgml b/doc/src/sgml/monitoring.sgml index 940b8b79ffe..954dd1a2e4b 100644 --- a/doc/src/sgml/monitoring.sgml +++ b/doc/src/sgml/monitoring.sgml @@ -1,4 +1,4 @@ -<!-- $PostgreSQL: pgsql/doc/src/sgml/monitoring.sgml,v 1.74 2010/01/19 14:11:30 mha Exp $ --> +<!-- $PostgreSQL: pgsql/doc/src/sgml/monitoring.sgml,v 1.75 2010/01/28 14:25:41 mha Exp $ --> <chapter id="monitoring"> <title>Monitoring Database Activity</title> @@ -929,6 +929,24 @@ postgres: <replaceable>user</> <replaceable>database</> <replaceable>host</> <re <structname>pg_stat_bgwriter</>. </entry> </row> + + <row> + <entry><literal><function>pg_stat_reset_single_table_counters</function>(oid)</literal></entry> + <entry><type>void</type></entry> + <entry> + Reset statistics for a single table or index in the current database to + zero (requires superuser privileges) + </entry> + </row> + + <row> + <entry><literal><function>pg_stat_reset_single_function_counters</function>(oid)</literal></entry> + <entry><type>void</type></entry> + <entry> + Reset statistics for a single function in the current database to + zero (requires superuser privileges) + </entry> + </row> </tbody> </tgroup> </table> |