{% 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.

Table: Process

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

Table: tableUse

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]
{% endblock %}