# 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 |