MIME-Version: 1.0
References: 
 <CACJufxFUjNvGXWO7Rq8y5V8YyoMPGnf9Deeyw61Q=wVTqm-SiQ@mail.gmail.com>
In-Reply-To: 
 <CACJufxFUjNvGXWO7Rq8y5V8YyoMPGnf9Deeyw61Q=wVTqm-SiQ@mail.gmail.com>
From: Jaime Casanova <jcasanov@systemguards.com.ec>
Date: Fri, 16 Dec 2022 15:40:30 -0500
Message-ID: 
 <CAJKUy5iHOZZ+z66c3FUOWN_VVnYq-hDTeew_GK1JXmUdGw5Jvw@mail.gmail.com>
Subject: Re: pg_stat_database view column xact_commit description should be
 more descriptive?
To: jian he <jian.universality@gmail.com>
Cc: pgsql-docs@lists.postgresql.org
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Archived-At: 
 <https://www.postgresql.org/message-id/CAJKUy5iHOZZ%2Bz66c3FUOWN_VVnYq-hDTeew_GK1JXmUdGw5Jvw%40mail.gmail.com>
Precedence: bulk

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 BEG=
IN command will be executed in a single transaction until an explicit COMMI=
T or ROLLBACK is given. By default (without BEGIN), PostgreSQL executes tra=
nsactions in =E2=80=9Cautocommit=E2=80=9D 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-autoc=
ommit' 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?

--=20
Jaime Casanova
Director de Servicios Profesionales
SYSTEMGUARDS S.A.