{% extends "base.html" %} {% block content %}
See also Interpreting Server Log Files
When peeking is enabled (typically any server >= 2013.3), see also Peeking track information and Commands supporting lockless reads.
Field Name | Field Type | Notes |
processKey | char(50) | Prime key for join with TableUse - MD5 hash of line |
lineNumber | int | Linumber of initial start command in log file |
StartTime | date | Time command started. Format "YYYY-mm-dd HH:MM:SS" |
EndTime | date | Time command finished (if finish found). Format "YYYY-mm-dd HH:MM:SS" |
computedLapse | float | Time in seconds during compute phase of command (only present for some commands) |
CompletedLapse | float | Time in seconds until commmand completed |
pid | int | Process id |
User | text | Perforce user id |
workspace | text | Name of workspaces in which command was executed |
ip | text | IP address from which command was executed |
app | text | String application version - as used in calls to P4API |
cmd | text | Actual perforce command executed - typically with "user-" prefix |
args | text | Command arguments (if any) |
uCpu | int | User CPU used (milliseconds) |
sCpu | int | System CPU (milliseconds) |
diskIn | int | Disk blocks (512 bytes) read |
diskOut | int | Disk blocks (512 bytes) written |
IPCin | int | IPC messages received |
IPCout | int | IPC messages sent |
maxRss | int | |
pageFaults | int | page faults that were serviced by doing I/O |
rpcMsgsIn | int | Number of RPC messages received |
rpcMsgsOut | int | Number of RPC messages sent |
rpcSizeIn | int | Size of RPC messages received (rounded to 1MB) |
rpcSizeOut | int | Size of RPC messages sent (rounded to 1MB) |
rpcHimarkFwd | int | RPC send Window size - check for mismatch with receive |
rpcHimarkRev | int | RPC receive Window size - check for mismatch with send |
rpcSend | float | Time in seconds sending RPC messages |
rpcRcv | float | Time in seconds receiving RPC messages |
running | int | Number of concurrent processes at the same time - only valid if configurable server>=3 |
error | text | Any error message |
Field Name | Field Type | Notes |
processKey | char(50) | Prime key for join with Process - MD5 hash of line |
lineNumber | int | Part of prime key - required for duplicate commands with same MD5 within same second |
tableName | varchar | Name of table involved, e.g. db.have, db.user. Includes certain "meta" tables with prefixes: meta/client/change and can have R/W suffixes |
pagesIn | int | Number of pages read in process-private memory (not filesystem cache) |
pagesOut | int | Number of pages written in process-private memory (not filesystem cache) |
pagesCached | int | Number of pages for process-private memory (not filesystem cache) |
pagesSplitInternal | int | Number of pages for internal B-Tree node splits |
pagesSplitLeaf | int | Number of pages for leaf B-Tree node splits |
readLocks | int | Number of read locks for this table |
writeLocks | int | Number of write locks for this table |
getRows | int | Number of fetches of rows by key |
posRows | int | Number of rows used to position for scan |
scanRows | int | Number of rows scanned |
putRows | int | Number of rows written |
delRows | int | Number of rows deleted |
totalReadWait | int | Total time waiting for read lock (ms) |
totalReadHeld | int | Total time read lock held (ms) |
totalWriteWait | int | Total time waiting for write lock (ms) |
totalWriteHeld | int | Total time write lock held (ms) |
maxReadWait | int | Maximum time any one read lock was waited for (ms) |
maxReadHeld | int | Maximum time any one read lock was held (ms) |
maxWriteWait | int | Maximum time any one write lock was waited for (ms) |
maxWriteHeld | int | Maximum time any one write lock was held (ms) |
peekCount | int | How many peeks |
totalPeekWait | int | Time waiting for peek locks (ms) |
totalPeekHeld | int | Time peek locks held (ms) |
maxPeekWait | int | Max time waiting for any one peek lock (ms) |
maxPeekHeld | int | Max time any one peek lock held (ms) |
triggerLapse | float | Time (secs) for trigger to run - trigger is part of tablename, e.g. trigger_[triggername] |