| column | sysmaster
| description
|
| sql_id | syssqltrace | unique id for this statement |
| sql_address | syssqltrace | internal address |
| sql_sid | syssqltrace | session id who executed the sql statement |
| sql_uid | syssqltrace | user id who executed the sql |
| sql_stmttype | syssqltrace | id number for type of sql |
| sql_stmtname | syssqltrace | type of SQL statement, e.g. SELECT, INSERT, DELETE |
| sql_finishtime | syssqltrace | time stamp when query completed |
| sql_begintxtime | syssqltrace | time stamp when transaction began |
| sql_runtime | syssqltrace | how long the SQL ran for |
| sql_pgreads | syssqltrace | how many pages where read |
| sql_bfreads | syssqltrace | how many buffers where read |
| sql_rdcache | syssqltrace | percentage of reads cached |
| sql_bfidxreads | syssqltrace | number of index page buffer reads |
| sql_pgwrites | syssqltrace | number of pages written |
| sql_bfwrites | syssqltrace | number of buffers written |
| sql_wrcache | syssqltrace | percent of writes cached |
| sql_lockreq | syssqltrace | number of locks requested |
| sql_lockwaits | syssqltrace | number of times waited for a lock |
| sql_lockwttime | syssqltrace | how long spent waiting for locks, in seconds |
| sql_logspace | syssqltrace | how many pages of log space SQL used |
| sql_sorttotal | syssqltrace | total number of sorts |
| sql_sortdisk | syssqltrace | total number of sorts done on disk |
| sql_sortmem | syssqltrace | total number of sorts that ran in memory |
| sql_executions | syssqltrace | number of times this statement ran |
| sql_totaltime | syssqltrace | total execution time in seconds |
| sql_avgtime | syssqltrace | avg execution time |
| sql_maxtime | syssqltrace | max execution time |
| sql_numiowaits | syssqltrace | number of times waited for I/O |
| sql_avgiowaits | syssqltrace | average number of times waited for I/O |
| sql_totaliowaits | syssqltrace | total time statement had to wait for I/O |
| sql_rowspersec | syssqltrace | Average number of rows produced per second |
| sql_estcost | syssqltrace | SQL optimizer estimated cost |
| sql_estrows | syssqltrace | SQL optimizer estimated number of rows |
| sql_actualrows | syssqltrace | Actual number of rows returned |
| sql_sqlerror | syssqltrace | Number of any SQL error |
| sql_isamerror | syssqltrace | Number of any ISAM error |
| sql_isolevel | syssqltrace | Locking isolation level for this statement |
| sql_sqlmemory | syssqltrace | Amount of memory required, in bytes |
| sql_numiterators | syssqltrace | Number of iterators in statement |
| sql_database | syssqltrace | Name of the database |
| sql_numtables | syssqltrace | Tables of tables used in statement |
| sql_tablelist | syssqltrace | List of tables directly referenced by the statement |
| sql_statement | syssqltrace | The text of the SQL statement |
| sql_stmlen | syssqltrace | Length in bytes f the statement |
| sql_stmthash | syssqltrace | Hash number to reference this statement |
| sql_pdq | syssqltrace | PDQ value set for statement |
| sql_num_hvars | syssqltrace | Number of host vars in statement |
| sql_dbspartnum | syssqltrace | Part number of database |
| dbname | infx | because you cannot rely on the sql_database value |
| uname | infx | username who executed the query |