public inbox for [email protected]  

help / color / mirror / Atom feed

From: jian he <[email protected]>
To: [email protected]
Subject: pg_stat_database view column xact_commit description should be more descriptive?
Date: Fri, 3 Jun 2022 12:15:44 +0530
Message-ID: <CACJufxFUjNvGXWO7Rq8y5V8YyoMPGnf9Deeyw61Q=wVTqm-SiQ@mail.gmail.com> (raw)

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

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]
  Subject: Re: pg_stat_database view column xact_commit description should be more descriptive?
  In-Reply-To: <CACJufxFUjNvGXWO7Rq8y5V8YyoMPGnf9Deeyw61Q=wVTqm-SiQ@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