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

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)

{% from "_formhelpers.html" import render_field %}
{{ form.csrf_token }} {{ 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 %}