SQL Statistics
The following table describes 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: μs). |
| 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. |