| dskreads |
Number of actual reads from disk |
| bufreads |
Number of reads from shared memory |
| dskwrites |
Actual number of writes to disk |
| bufwrites |
Number of writes to shared memory |
| isamtot |
Total number of calls |
| isopens |
isopen calls |
| isstarts |
isstart calls |
| isreads |
isread calls |
| iswrites |
iswrite calls |
| isrewrites |
isrewrite calls |
| isdeletes |
isdelete calls |
| iscommits |
iscommit calls |
| isrollbacks |
isrollback calls |
| ovlock |
Overflow lock table |
| ovuser |
Overflow user table |
| ovtrans |
Overflow transaction table |
| latchwts |
Latch request waits |
| bufwts |
Buffer waits |
| lockreqs |
Lock requests |
| lockwts |
Lock waits |
| ckptwts |
Checkpoint waits |
| deadlks |
Deadlocks |
| lktouts |
Deadlock time-outs |
| numckpts |
Number checkpoints |
| plgpagewrites |
Physical-log pages written |
| plgwrites |
Physical-log writes |
| llgrecs |
Logical-log records |
| llgpagewrites |
Logical-log writes |
| llgwrites |
Logical-log pages written |
| pagreads |
Page reads |
| pagwrites |
Page writes |
| flushes |
Buffer-pool flushes |
| compress |
Page compresses |
| fgwrites |
Foreground writes |
| lruwrites |
Least-recently used (LRU) writes |
| chunkwrites |
Writes during a checkpoint |
| btradata |
Read-ahead data pages read through index leaf node |
| btraidx |
Read-ahead data pages read through index branch or root
node |
| dpra |
Data pages read into memory with read-ahead feature |
| rapgs_used |
Read-ahead data pages that user used |
| seqscans |
Sequential scans |
| totalsorts |
Total sorts |
| memsorts |
Sorts that fit in memory |
| disksorts |
Sorts that did not fit in memory |
| maxsortspace |
Maximum disk space used by a sort |