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

Copyright© 2019 HCL Technologies Limited