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