Are you an LLM? You can read better optimized documentation at /en/docs/latest/sql_reference/sql_statistics.md for this page in Markdown format
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. |
SQL Stats by Database
Aggregates Unique SQL completion-path execution count and elapsed time by database, and computes the percentage of instance DB_TIME. Node-wide report, which can be viewed in node mode for detail or all report types. Unique SQL must be enabled.
Data source: snapshot.snap_summary_database_sql_stat (from dbe_perf.summary_database_sql_stat / dbe_perf.database_sql_stat).
Table 2 Columns in SQL Stats by Database
Column | Description |
|---|
DB Name | Database name. |
Exec Count | Execution-count delta for the database between snapshots. |
Total Time(s) | Total elapsed time in seconds. |
Avg Time(ms) | Average elapsed time in milliseconds; 0 when Exec Count is 0. |
% of DB Time | Percentage of the instance DB_TIME delta. |
Only databases with Exec Count or elapsed-time delta greater than 0 are listed, ordered by Total Time descending.