# MV\_ACTIVE\_DISTRIBUTED\_TRANSACTIONS

This view shows internal information on distributed transactions that are currently active in the system.

Primarily for use by SingleStore Customer Support. No additional information about this view is available.

| Column Name                   | Description                                                                            |
| ----------------------------- | -------------------------------------------------------------------------------------- |
| `DISTRIBUTED_XACT_ID`         | The internal ID of the distributed transaction.                                        |
| `COORDINATOR_ID`              | ID of the aggregator coordinating the distributed transaction.                         |
| `CONNECTION_ID`               | Internal connection ID between the node and the aggregator.                            |
| `NODE_ID`                     | ID of the node where the transaction is running.                                       |
| `DATABASE_NAME`               | The name of the database or partition running the transaction.                         |
| `ISOLATION_LEVEL`             | The isolation level the distributed transaction is running on.                         |
| `REAL_CLOCK_BEGIN_TIME_STAMP` | Time of the start of the transaction.                                                  |
| `START_TIME_STAMP`            | Internal timestamp of the start of the transaction.                                    |
| `READ_TIME_STAMP`             | Internal timestamp of the first data read from the transaction.                        |
| `EXECUTION_STATE`             | The state of the transaction:`idle`,`running`,`preparing`,`prepared`,`prepare_failed`. |
| `PREPARE_TIME_STAMP`          | The internal timestamp of when the local prepare step of the transaction was executed. |
| `ROW_LOCKS`                   | Number of rows locks held by the transaction.                                          |

***

Modified at: July 30, 2024

Source: [/db/v9.1/reference/information-schema-reference/query-performance-workload-management-and-statistics/mv-active-distributed-transactions/](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/query-performance-workload-management-and-statistics/mv-active-distributed-transactions/)

(An index of the documentation is available at /llms.txt)