Help Center> Data Warehouse Service> Developer Guide> System Catalogs and System Views> System Views> GS_WORKLOAD_TRANSACTION
GS_WORKLOAD_TRANSACTION
GS_WORKLOAD_TRANSACTION provides transaction information about workload cgroups on a single CN. The database records the number of times that each workload Cgroup commits and rolls back transactions and the response time of transaction commitment and rollback, in microseconds.
| Name | Type | Description |
|---|---|---|
| workload | name | Workload Cgroup name |
| 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: PGXC_WORKLOAD_SQL_ELAPSE_TIME
Next Article: GS_STAT_DB_CU
Did this article solve your problem?
Thank you for your score！Your feedback would help us improve the website.