This page lists all transactions which contain two or more queries.
| Name | Type |
|---|---|
| start | timestamp |
| end | timestamp |
| duration | interval |
| count:queries | int8 |
| owner_user_id | int4 |
| owner | varchar |
| pid | int4 |
| xid | int8 |
| related pages | varchar |
The start time of the earliest query in the transaction.
The end time of the earliest query in the transaction.
If a transaction is still open, this column is empty.
The duration of the transaction.
If a transaction is still open, this column is empty.
Number of queries in the transaction.
All queries, even single queries, are in their own transaction. This page lists only transactions with two or more queries.
The owner user ID. This column is emitted in CSV exports only.
The owner user name.
The process ID.
When a user connects to the cluster, a process is spawned, which accepts that connection. That’s the process the ID is for. That process is also the process which issues queries, and when you need to cancel a query, you in fact cancel the process, which by being cancelled, inherently also cancels the query it is running.
The transaction ID.