{% extends "base.html" %} {% block content %}
Table schema/example SQL - you can copy this statement showing all columns, and edit it to suite your needs (or copy one from analyzeLog page.
Table schema with explanations
SELECT process.processKey, process.lineNumber, startTime, endTime, computedLapse, completedLapse,
pid, user, workspace, ip, app, cmd, args,
uCpu, sCpu, diskIn, diskOut, ipcIn, ipcOut, maxRss, pageFaults,
rpcMsgsIn, rpcMsgsOut, rpcSizeIn, rpcSizeOut, rpcHimarkFwd, rpcHimarkRev,
rpcSnd, rpcRcv, running, error,
pagesIn, pagesOut, pagesCached, readLocks, writeLocks,
getRows, posRows, scanRows, putRows, delRows,
totalReadWait, totalReadHeld, totalWriteWait, totalWriteHeld,
maxReadWait, maxReadHeld, maxWriteWait, maxWriteHeld,
peekCount, totalPeekWait, totalPeekHeld, maxPeekWait, maxPeekHeld, triggerLapse
FROM tableUse JOIN process USING (processKey)
LIMIT 10
{{ data.sql }}
Time to run query: {{ data.time_taken }}
{{ data.data|safe }} {% endif %}