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
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 |