# getTransactionStatus {#gettransactionstatus}

**Parent topic:**[Functions](../../Functions/category.md)

## Syntax {#syntax}

`getTransactionStatus()`

## Arguments {#arguments}

None

## Details {#details}

Get the status of transactions. Return a table containing the following columns:

-   tid: The transaction ID.

-   startTime: The time when the transaction started.

-   type: The type of operations involved in the transaction, including APPEND, DROP, SQLUPDATE, SQLUPSERT, SQLDELETE, FILEOPERATE, or UNKNOWN.

-   status: The transaction status. It can be BEGIN, COMMIT, COMPLETE, or ROLLBACK.

-   partitionCount: The number of partitions involved in the transaction.

-   endTime: The time when the transaction ended.

-   elapsedTime: The elapsed time of the transaction.


## Examples {#examples}

```
getTransactionStatus()
```

|tid|startTime|type|status|partitionCount|endTime|elapsedTime|
|---|---------|----|------|--------------|-------|-----------|
|3135|2022.06.07 16:19:48.477|APPEND|BEGIN|4||584|
|3143|2022.06.07 16:11:27.489|APPEND|COMMIT|4|2022.06.07 16:11:33.100|484|

