Track temporary file count and size in pg_stat_database
Magnus Hagander <magnus@hagander.net>
Track temporary file count and size in pg_stat_database Add counters for number and size of temporary files used for spill-to-disk queries for each database to the pg_stat_database view. Tomas Vondra, review by Magnus Hagander
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/monitoring.sgml | modified | +24 −1 |
| src/backend/catalog/system_views.sql | modified | +2 −0 |
| src/backend/postmaster/pgstat.c | modified | +50 −0 |
| src/backend/storage/file/fd.c | modified | +16 −20 |
| src/backend/utils/adt/pgstatfuncs.c | modified | +33 −0 |
| src/include/catalog/catversion.h | modified | +1 −1 |
| src/include/catalog/pg_proc.h | modified | +4 −0 |
| src/include/pgstat.h | modified | +18 −1 |
| src/test/regress/expected/rules.out | modified | +1 −1 |