Help Center/ GaussDB/ Centralized_8.x/ Schemas/ DBE_PERF Schema/ Workload/ GLOBAL_WORKLOAD_TRANSACTION
Updated on 2024-06-03 GMT+08:00
View PDF

GLOBAL_WORKLOAD_TRANSACTION

Displays load information about workloads on each node, as shown in Table 1.

Table 1 GLOBAL_WORKLOAD_TRANSACTION columns

Name

Type

Description

node_name

name

Node name.

workload

name

Workload name.

commit_counter

bigint

Number of user transactions committed.

rollback_counter

bigint

Number of user transactions rolled back.

resp_min

bigint

Minimum response time of user transactions (unit: μs).

resp_max

bigint

Maximum response time of user transactions (unit: μs).

resp_avg

bigint

Average response time of user transactions (unit: μs).

resp_total

bigint

Total response time of user transactions (unit: μs).

bg_commit_counter

bigint

Number of background transactions committed.

bg_rollback_counter

bigint

Number of background transactions rolled back.

bg_resp_min

bigint

Minimum response time of background transactions (unit: μs).

bg_resp_max

bigint

Maximum response time of background transactions (unit: μs).

bg_resp_avg

bigint

Average response time of background transactions (unit: μs).

bg_resp_total

bigint

Total response time of background transactions (unit: μs).
Parent topic: Workload