Chapter 8. SQL Query Drill-Down 237
sql_sortdisk 0
sql_sortmem 0
sql_executions 1
sql_totaltime 3.544297100000
sql_avgtime 3.544297100000
sql_maxtime 1.997457400000
sql_numiowaits 0
sql_avgiowaits 0.00
sql_totaliowaits 0.00
sql_rowspersec 106.1349293357
sql_estcost 105
sql_estrows 211
sql_actualrows 212
sql_sqlerror 0
sql_isamerror 0
sql_isollevel 2
sql_sqlmemory 19248
sql_numiterators 3
sql_database <None>
sql_numtables 0
sql_tablelist None
sql_statement select l.tabname, r.created from sysmaster:systables l,
sysmaster@vj_acme_tcp:systables r where l.tabname = r.tabname
8.2.3 Using syssqltrace_info
The table syssqltrace_info is another pseudo table similar to the syssqltrace
table. The syssqltrace_info table stores the tracing profile information while
syssqltrace stores the statement statistics information. The profile information
consists of the trace settings, such as ntraces, size, memory used, and trace
starting time. Table 8-2 on page 238 contains the schema of this table. The first
few lines displayed by onstat -g his output are actually the information
displayed from this pseudo table. However, you can also run SQL queries on this
table just as you can with the syssqltrace table.
Get Informix Dynamic Server 11: Advanced Functionality for Modern Business now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
