diff options
| author | Magnus Hagander <magnus@hagander.net> | 2013-07-05 15:02:09 +0200 |
|---|---|---|
| committer | Magnus Hagander <magnus@hagander.net> | 2013-07-05 15:10:15 +0200 |
| commit | c87ff71f374652936a6089215a30998492b14d52 (patch) | |
| tree | b258309f40ab3f9302bcc2d29b0753c29cf8fbed /doc/src | |
| parent | 9ce9dfdb999960aa7596bb219db02ccdbe2da855 (diff) | |
| download | postgresql-c87ff71f374652936a6089215a30998492b14d52.tar.gz postgresql-c87ff71f374652936a6089215a30998492b14d52.zip | |
Expose the estimation of number of changed tuples since last analyze
This value, now pg_stat_all_tables.n_mod_since_analyze, was already
tracked and used by autovacuum, but not exposed to the user.
Mark Kirkwood, review by Laurenz Albe
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/monitoring.sgml | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/doc/src/sgml/monitoring.sgml b/doc/src/sgml/monitoring.sgml index d38c009db3a..4ec6981ab82 100644 --- a/doc/src/sgml/monitoring.sgml +++ b/doc/src/sgml/monitoring.sgml @@ -951,6 +951,11 @@ postgres: <replaceable>user</> <replaceable>database</> <replaceable>host</> <re <entry>Estimated number of dead rows</entry> </row> <row> + <entry><structfield>n_mod_since_analyze</></entry> + <entry><type>bigint</></entry> + <entry>Estimated number of rows modified since this table was last analyzed</entry> + </row> + <row> <entry><structfield>last_vacuum</></entry> <entry><type>timestamp with time zone</></entry> <entry>Last time at which this table was manually vacuumed |