Mastering PostgreSQL 12 - Third Edition

Inspecting transactions in real time

Thus far, some statistics tables have been discussed. The idea behind all of them is to see what is going on in the entire system. But what if you are a developer who wants to inspect an individual transaction? pg_stat_xact_user_tables is here to help. It doesn't contain system-wide transactions; it only contains data about your current transaction. This is shown in the following code:

test=# \d pg_stat_xact_user_tables        View "pg_catalog.pg_stat_xact_user_tables"    Column     |  Type  | Collation | Nullable | Default ---------------+--------+-----------+----------+--------- relid         | oid    |           |          |  schemaname    | name   |           |          |  relname       | name   |           |          |  seq_scan      | bigint |           |          |  seq_tup_read  | bigint |           |          |  idx_scan | bigint ...