Help Center> Data Warehouse Service> Developer Guide> System Catalogs and System Views> System Views> GS_USER_TRANSACTION
GS_USER_TRANSACTION
GS_USER_TRANSACTION provides transaction information about users on a single CN. The database records the number of times that each user commits and rolls back transactions and the response time of transaction commitment and rollback, in microseconds.
| Name | Type | Description |
|---|---|---|
| usename | name | Username |
| commit_counter | bigint | Number of the commit times |
| rollback_counter | bigint | Number of rollbacks |
| resp_min | bigint | Minimum response time |
| resp_max | bigint | Maximum response time |
| resp_avg | bigint | Average response time |
| resp_total | bigint | Total response time |
Parent topic: System Views
Last Article: GS_TOTAL_NODEGROUP_MEMORY_DETAIL
Next Article: PG_AVAILABLE_EXTENSION_VERSIONS
Did this article solve your problem?
Thank you for your score！Your feedback would help us improve the website.