syssqltrace
The syssqltrace table provides detailed information about a single SQL statement.
| Column | Type | Description |
|---|---|---|
| sql_id | int8 | Unique SQL execution ID |
| sql_address | int8 | Address of the statement in the code block |
| sql_sid | int | Database session ID of the user running the SQL statement |
| sql_uid | int | User ID of the statement running the SQL |
| sql_stmttype | int | Statement type |
| sql_stmtname | char(40) | Statement type displayed as a word |
| sql_finishtime | int | Time this statement completed (UNIX™) |
| sql_begintxtime | int | Time this transaction started |
| sql_runtime | float | Statement execution time |
| sql_pgreads | int | Number of disk reads for this SQL statement |
| sql_bfreads | int | Number of buffer reads for this SQL statement |
| sql_rdcache | float | Percentage of time the page was read from the buffer pool |
| sql_bfidxreads | int | Number of index page buffer reads |
| sql_pgwrites | int | Number of pages written to disk |
| sql_bfwrites | int | Number of pages modified and returned to the buffer pool |
| sql_wrcache | float | Percentage of time a page was written to the buffer pool but not to disk |
| sql_lockreq | int | Total number of locks required by this SQL statement |
| sql_lockwaits | int | Number of times the SQL statement waited on locks |
| sql_lockwttime | float | Time the system waited for locks during SQL statement |
| sql_logspace | int | Amount of space the SQL statement used in the logical log |
| sql_sorttotal | int | Number of sorts that ran for the statement |
| sql_sortdisk | int | Number of sorts that ran on disk |
| sql_sortmem | int | Number of sorts that ran in memory |
| sql_executions | int | Number of times the SQL statement ran |
| sql_totaltime | float | Total amount of time spent running the statement |
| sql_avgtime | float | Average amount of time spent running the statement |
| sql_maxtime | float | Maximum amount of time spent executing the SQL statement |
| sql_numiowaits | int | Number of times an I/O operation had to wait |
| sql_avgiowaits | float | Average amount of time that the SQL statement had to wait |
| sql_totaliowaits | float | Total amount of time that the SQL statement had to wait for I/O. This excludes any asynchronous I/O. |
| sql_rowspersec | float | Average number of rows (per second) produced |
| sql_estcost | int | Cost associated with the SQL statement |
| sql_estrows | int | Estimated number of rows returned for the SQL statement as predicted by the optimizer |
| sql_actualrows | int | Number of rows returned for the SQL statement |
| sql_sqlerror | int | SQL error number |
| sql_isamerror | int | RSAM/ISAM error number |
| sql_isollevel | int | Isolation level of the SQL statement. |
| sql_sqlmemory | int | Number of bytes needed to execute the SQL statement |
| sql_numiterators | int | Number of iterators used by the statement |
| sql_database | char(128) | Database name |
| sql_numtables | int | Number of tables used in executing the SQL statement |
| sql_tablelist | char(4096) | List of table names directly referenced in the SQL statement. If the SQL statement fires triggers that execute statements against other tables, the other tables are not listed. |
| sql_statement | char(1600) | SQL statement that ran |