Help Center > > Developer Guide> System Catalogs and System Views> System Views> GS_USER_TRANSACTION

GS_USER_TRANSACTION

Updated at: Jul 15, 2020 GMT+08:00

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.

Table 1 GS_USER_TRANSACTION columns

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

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel