The syssesprof table lists cumulative counts of the number of occurrences of user actions such as writes, deletes, or commits.
| Column | Type | Description |
|---|---|---|
| coserver_id | integer | Coserver number |
| sid | integer | Session ID |
| lockreqs | decimal(32,0) | Number of locks requested |
| locksheld | decimal(32,0) | Number of locks currently held |
| lockwts | decimal(32,0) | Number of times waited for a lock |
| deadlks | decimal(32,0) | Number of deadlocks detected |
| lktouts | decimal(32,0) | Number of deadlock timeouts |
| logrecs | decimal(32,0) | Number of logical-log records written |
| isreads | decimal(32,0) | Number of reads |
| iswrites | decimal(32,0) | Number of writes |
| isrewrites | decimal(32,0) | Number of rewrites |
| isdeletes | decimal(32,0) | Number of deletes |
| iscommits | decimal(32,0) | Number of commits |
| isrollbacks | decimal(32,0) | Number of rollbacks |
| longtxs | decimal(32,0) | Number of long transactions |
| bufreads | decimal(32,0) | Number of buffer reads |
| bufwrites | decimal(32,0) | Number of buffer writes |
| seqscans | decimal(32,0) | Number of sequential scans |
| pagreads | decimal(32,0) | Number of page reads |
| pagwrites | decimal(32,0) | Number of page writes |
| total_sorts | decimal(32,0) | Number of total sorts |
| dsksorts | decimal(32,0) | Number of sorts that did not fit in memory |
| max_sortdiskspace | decimal(32,0) | Maximum space used by a sort |
| logspused | decimal(32,0) | Number of bytes of logical-log space used by current transaction of session |
| maxlogsp | decimal(32,0) | Maximum number of bytes of logical-log space ever used by the session |