Add pg_stat_database counters for sessions and session time
authorMagnus Hagander <magnus@hagander.net>
Sun, 17 Jan 2021 12:34:09 +0000 (13:34 +0100)
committerMagnus Hagander <magnus@hagander.net>
Sun, 17 Jan 2021 12:52:31 +0000 (13:52 +0100)
commit960869da0803427d14335bba24393f414b476e2c
treec36a0991f757696e4d46c079055c1e926e4623f6
parent891a1d0bca262ca78564e0fea1eaa5ae544ea5ee
Add pg_stat_database counters for sessions and session time

This add counters for number of sessions, the different kind of session
termination types, and timers for how much time is spent in active vs
idle in a database to pg_stat_database.

Internally this also renames the parameter "force" to disconnect. This
was the only use-case for the parameter before, so repurposing it to
this mroe narrow usecase makes things cleaner than inventing something
new.

Author: Laurenz Albe
Reviewed-By: Magnus Hagander, Soumyadeep Chakraborty, Masahiro Ikeda
Discussion: https://postgr.es/m/b07e1f9953701b90c66ed368656f2aef40cac4fb.camel@cybertec.at
doc/src/sgml/monitoring.sgml
src/backend/catalog/system_views.sql
src/backend/postmaster/pgstat.c
src/backend/tcop/postgres.c
src/backend/utils/adt/pgstatfuncs.c
src/backend/utils/error/elog.c
src/include/catalog/catversion.h
src/include/catalog/pg_proc.dat
src/include/pgstat.h
src/test/regress/expected/rules.out