Add views and functions to monitor hot standby query conflicts
Magnus Hagander <magnus@hagander.net>
Add views and functions to monitor hot standby query conflicts Add the view pg_stat_database_conflicts and a column to pg_stat_database, and the underlying functions to provide the information.
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/high-availability.sgml | modified | +7 −0 |
| doc/src/sgml/monitoring.sgml | modified | +53 −1 |
| src/backend/catalog/system_views.sql | modified | +13 −1 |
| src/backend/postmaster/pgstat.c | modified | +69 −0 |
| src/backend/tcop/postgres.c | modified | +7 −0 |
| src/backend/utils/adt/pgstatfuncs.c | modified | +101 −0 |
| src/include/catalog/pg_proc.h | modified | +12 −0 |
| src/include/pgstat.h | modified | +22 −1 |
| src/test/regress/expected/rules.out | modified | +3 −2 |