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 |