pg_stat_database view column xact_commit description should be more descriptive?

From: jian he <jian(dot)universality(at)gmail(dot)com>
To: pgsql-docs(at)lists(dot)postgresql(dot)org
Subject: pg_stat_database view column xact_commit description should be more descriptive?
Date: 2022-06-03 06:45:44
Message-ID: CACJufxFUjNvGXWO7Rq8y5V8YyoMPGnf9Deeyw61Q=wVTqm-SiQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

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

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message David G. Johnston 2022-06-03 06:59:59 Re: pg_stat_database view column xact_commit description should be more descriptive?
Previous Message PG Doc comments form 2022-06-01 10:20:44 Proposal to improve uniq function documentation in intarray extension