public inbox for [email protected]  

help / color / mirror / Atom feed

From: Jaime Casanova <[email protected]>
To: jian he <[email protected]>
Cc: [email protected]
Subject: Re: pg_stat_database view column xact_commit description should be more descriptive?
Date: Fri, 16 Dec 2022 15:40:30 -0500
Message-ID: <CAJKUy5iHOZZ+z66c3FUOWN_VVnYq-hDTeew_GK1JXmUdGw5Jvw@mail.gmail.com> (raw)
In-Reply-To: <CACJufxFUjNvGXWO7Rq8y5V8YyoMPGnf9Deeyw61Q=wVTqm-SiQ@mail.gmail.com>
References: <CACJufxFUjNvGXWO7Rq8y5V8YyoMPGnf9Deeyw61Q=wVTqm-SiQ@mail.gmail.com>

On Fri, Jun 3, 2022 at 1:46 AM jian he <[email protected]> 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 transaction until 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 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...."
>

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.

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: pg_stat_database view column xact_commit description should be more descriptive?
  In-Reply-To: <CAJKUy5iHOZZ+z66c3FUOWN_VVnYq-hDTeew_GK1JXmUdGw5Jvw@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox