https://www.postgresql.org/docs/current/monitoring-stats.html#MONITORING-PG-STAT-DATABASE-VIEW
> xact_commit bigint > > Number of transactions in this database that have been committed > In https://www.postgresql.org/docs/current/sql-begin.html BEGIN initiates a transaction block, that is, all statements after a BEGIN > command will be executed in a single transaction until an explicit COMMIT > <https://www.postgresql.org/docs/current/sql-commit.html> or ROLLBACK > <https://www.postgresql.org/docs/current/sql-rollback.html> is given. By > default (without BEGIN), PostgreSQL executes transactions in “autocommit” > mode, that is, each statement is executed in its own transaction and a > commit is implicitly performed at the end of the statement (if execution > was successful, otherwise a rollback is done). > I guess the pg_stat_database view column *xact_commit *refers to 'non-autocommit' transactions? If so, should we say something like "Number of autocommit transactions...." -- I recommend David Deutsch's <<The Beginning of Infinity>> Jian
