diff options
| author | Amit Kapila <akapila@postgresql.org> | 2019-11-16 18:24:00 +0530 |
|---|---|---|
| committer | Amit Kapila <akapila@postgresql.org> | 2019-11-21 08:06:51 +0530 |
| commit | 9290ad198b15d6b986b855d2a58d087a54777e87 (patch) | |
| tree | 1758f43591a31c8b469434b8079b373872aae078 /doc/src | |
| parent | 168d2064001f704965899bb2057591271c44e57a (diff) | |
| download | postgresql-9290ad198b15d6b986b855d2a58d087a54777e87.tar.gz postgresql-9290ad198b15d6b986b855d2a58d087a54777e87.zip | |
Track statistics for spilling of changes from ReorderBuffer.
This adds the statistics about transactions spilled to disk from
ReorderBuffer. Users can query the pg_stat_replication view to check
these stats.
Author: Tomas Vondra, with bug-fixes and minor changes by Dilip Kumar
Reviewed-by: Amit Kapila
Discussion: https://postgr.es/m/688b0b7f-2f6c-d827-c27b-216a8e3ea700@2ndquadrant.com
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/monitoring.sgml | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/doc/src/sgml/monitoring.sgml b/doc/src/sgml/monitoring.sgml index 901fee97ffb..a3c5f86b7e8 100644 --- a/doc/src/sgml/monitoring.sgml +++ b/doc/src/sgml/monitoring.sgml @@ -1972,6 +1972,26 @@ SELECT pid, wait_event_type, wait_event FROM pg_stat_activity WHERE wait_event i <entry><type>timestamp with time zone</type></entry> <entry>Send time of last reply message received from standby server</entry> </row> + <row> + <entry><structfield>spill_bytes</structfield></entry> + <entry><type>bigint</type></entry> + <entry>Amount of decoded transaction data spilled to disk.</entry> + </row> + <row> + <entry><structfield>spill_txns</structfield></entry> + <entry><type>bigint</type></entry> + <entry>Number of transactions spilled to disk after the memory used by + logical decoding exceeds <literal>logical_decoding_work_mem</literal>. The + counter gets incremented both for toplevel transactions and + subtransactions.</entry> + </row> + <row> + <entry><structfield>spill_count</structfield></entry> + <entry><type>bigint</type></entry> + <entry>Number of times transactions were spilled to disk. Transactions + may get spilled repeatedly, and this counter gets incremented on every + such invocation.</entry> + </row> </tbody> </tgroup> </table> |