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