Add a 'waiting' column to pg_stat_activity to carry the same information
Tom Lane <tgl@sss.pgh.pa.us>
Add a 'waiting' column to pg_stat_activity to carry the same information that ps_status provides by appending 'waiting' to the PS display. This completes the project of making it feasible to turn off process title updates and instead rely on pg_stat_activity. Per my suggestion a few weeks ago.
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/monitoring.sgml | modified | +14 −2 |
| src/backend/catalog/system_views.sql | modified | +3 −2 |
| src/backend/postmaster/pgstat.c | modified | +27 −1 |
| src/backend/storage/lmgr/lock.c | modified | +7 −2 |
| src/backend/utils/adt/pgstatfuncs.c | modified | +21 −1 |
| src/include/catalog/catversion.h | modified | +2 −2 |
| src/include/catalog/pg_proc.h | modified | +3 −1 |
| src/include/pgstat.h | modified | +5 −1 |
| src/test/regress/expected/rules.out | modified | +1 −1 |