SQL Statistics

Table 1 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.
Parent Unique SQL Id	Normalized SQL ID of the parent statement. The value is 0 for non-stored procedure substatements.
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).
Lock Wait Time(us)	Lock waiting time of the SQL statement (unit: μs).
Avg Lock Wait Time(us)	Average lock waiting time of each SQL statement (unit: μs).
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.