{% extends "base.html" %} {% block content %}

Perforce Server Log Analyzer - Interactive Queries

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 Single Chart for Log DB

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,
    pagesSplitInternal, pagesSplitLeaf,
    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)

{% from "_formhelpers.html" import render_field %}
{{ form.csrf_token }} {{ render_field(form.logFile) }} {{ render_field(form.queryOptions) }} {{ render_field(form.sqlQuery, rows=20, cols=80) }}

{{ form.submit() }}

{% if dbName %}

Analyze Server Log: '{{ dbName }}'

Query results

{{ data.sql }}

Time to run query: {{ data.time_taken }}

{{ data.data|safe }} {% endif %}
{% endblock %}