Mastering PostgreSQL 9.6

Inspecting transactions in real time

Up to now, a couple of statistics tables have already 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 does not contain system-wide transactions but only data about your current transaction:

test=# \d pg_stat_xact_user_tables  View "pg_catalog.pg_stat_xact_user_tables"     Column     |  Type  | Modifiers  ---------------+--------+-----------  relid         | oid    |   schemaname    | name   |   relname       | name   |   seq_scan      | bigint |   seq_tup_read  | bigint |   idx_scan      | bigint |   idx_tup_fetch | bigint |   n_tup_ins     | bigint |   n_tup_upd     | bigint |   n_tup_del | bigint ...