On Fri, Jun 3, 2022 at 1:46 AM jian he <jian.universality@gmail.com> wrote:
>
>
> 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
transactionuntil an explicit COMMIT or ROLLBACK 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
theend 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...."
>
Hi,
I want to hijack this thread to say that xact_commit seems to be also
counting COMMIT records received by logical replication.
Should we explain that in documentation?
What about physical replication? Are those also counted?
--
Jaime Casanova
Director de Servicios Profesionales
SYSTEMGUARDS S.A.