Updated on 2024-05-07 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.

Avg Tuples Fetched

Average number of rows randomly scanned.

Avg Tuples Returned

Average number of rows sequentially scanned.

Calls

Number of calls.

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.

Avg Returned Rows

Average number of rows returned by SELECT.

Tuples Affected

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

Avg Tuples Affected

Average number of rows affected by INSERT, UPDATE, and DELETE.

Logical Read

Number of logical reads on the buffer.

Avg Logical Read

Average number of logical reads on the buffer.

Physical Read

Number of physical reads on the buffer.

Avg Physical Read

Average number of physical reads on the buffer.

CPU Time(us)

CPU time (unit: us).

Avg CPU Time(us)

Average CPU time (unit: us).

Data IO Time(us)

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

Avg Data IO Time(us)

Average 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.