Make the pg_stat_activity view call a SRF (pg_stat_get_activity())
Magnus Hagander <magnus@hagander.net>
Make the pg_stat_activity view call a SRF (pg_stat_get_activity()) instead of calling a bunch of individual functions. This function can also be called directly, taking a PID as an argument, to return only the data for a single PID.
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/monitoring.sgml | modified | +22 −9 |
| src/backend/catalog/system_views.sql | modified | +19 −16 |
| src/backend/utils/adt/pgstatfuncs.c | modified | +223 −1 |
| src/include/catalog/catversion.h | modified | +2 −2 |
| src/include/catalog/pg_proc.h | modified | +3 −1 |
| src/test/regress/expected/rules.out | modified | +1 −1 |