Description
INFORMIX System Monitoring Interface Tables
syssesprof (Counts of various user actions)
Column Type Description
sid int Session id
isreads int Number of reads
iswrites int Number of writes
isrewrites int Number of rewrites
isdeletes int Number of deletes
iscommits int Number of commits
isrollbacks int Number of rollbacks
isrollbacks int Number of rollbacks
lockreqs int Number of locks requested
locksheld int Number of locks currently held
deadlks int Number of deadlocks detected
lktouts int Number of deadlocks timeouts
lockwts int Number of times waited for a lock
logrecs int Number of logical log records written
logspused int Number of bytes of logical log space used
by current transaction of session
maxlogsp int Maximum number of bytes of logical log
space ever used by the session
longtxs int Number of long transactions
bufreads int Number of buffer reads
bufwrites int Number of buffer writes
seqscans int Number of sequential scans