Updated on 2023-10-23 GMT+08:00

SQL Statistics

The following table describes columns in the SQL Statistics report.

Table 1 Columns in the SQL Statistics report

Column

Description

Unique SQL Id

ID of the normalized SQL statement.

Node Name

Node name.

User Name

Username.

Tuples Read

Number of tuples that are read.

Calls

Number of calls.

Min Elapse Time(us)

Minimum execution time (unit: us).

Max Elapse Time(us)

Maximum execution time (unit: us).

Total Elapse Time(us)

Total execution time (unit: us).

Avg Elapse Time(us)

Average execution time (unit: us).

Returned Rows

Number of rows returned by SELECT.

Tuples Affected

Number of rows affected by INSERT, UPDATE, and DELETE.

Logical Read

Number of logical reads on the buffer.

Physical Read

Number of physical reads on the buffer.

CPU Time(us)

CPU time (unit: us).

Data IO Time(us)

Time spent on I/O (unit: us).

Sort Count

Number of sorting execution times.

Sort Time(us)

Sorting execution time (unit: us).

Sort Mem Used(KB)

Size of work memory used during sorting (unit: KB).

Sort Spill Count

Number of file writes when data is flushed to disks during sorting.

Sort Spill Size(KB)

File size used when data is flushed to disks during sorting (unit: KB).

Hash Count

Number of hashing execution times.

Hash Time(us)

Hashing execution time (unit: us).

Hash Mem Used(KB)

Size of work memory used during hashing (unit: KB).

Hash Spill Count

Number of file writes when data is flushed to disks during hashing.

Hash Spill Size(KB)

File size used when data is flushed to disks during hashing (unit: KB).

SQL Text

Normalized SQL character string.