queryLog.html #3

  • //
  • guest/
  • perforce_software/
  • utils/
  • log_analyzer/
  • psla/
  • app/
  • templates/
  • queryLog.html
  • View
  • Commits
  • Open Download .zip Download (2 KB)
{% extends "base.html" %}

{% block content %}

<div id=psla class=analyze>

 <h1>Perforce Server Log Analyzer - Interactive Queries</h1>
    <p>Table schema/example SQL - you can copy this statement showing all columns, and edit it to
    suite your needs (or copy one from <a href='{{ url_for("analyzeLog") }}'>
   <span>analyzeLog</span></a> page.</p>
    <p>
        SELECT process.processKey, process.lineNumber, startTime, endTime, computedLapse, completedLapse,<br>
    &nbsp;&nbsp;&nbsp;&nbsp;pid, user, workspace, ip, app, cmd, args,<br>
    &nbsp;&nbsp;&nbsp;&nbsp;uCpu, sCpu, diskIn, diskOut, ipcIn, ipcOut, maxRss, pageFaults,<br>
    &nbsp;&nbsp;&nbsp;&nbsp;rpcMsgsIn, rpcMsgsOut, rpcSizeIn, rpcSizeOut, rpcHimarkFwd, rpcHimarkRev,<br>
    &nbsp;&nbsp;&nbsp;&nbsp;rpcSnd, rpcRcv, running, error,<br>
    &nbsp;&nbsp;&nbsp;&nbsp;pagesIn, pagesOut, pagesCached, readLocks, writeLocks,<br>
    &nbsp;&nbsp;&nbsp;&nbsp;getRows, posRows, scanRows, putRows, delRows,<br>
    &nbsp;&nbsp;&nbsp;&nbsp;totalReadWait, totalReadHeld, totalWriteWait, totalWriteHeld, <br>
    &nbsp;&nbsp;&nbsp;&nbsp;maxReadWait, maxReadHeld, maxWriteWait, maxWriteHeld, <br>
    &nbsp;&nbsp;&nbsp;&nbsp;peekCount, totalPeekWait, totalPeekHeld, maxPeekWait, maxPeekHeld, triggerLapse<br>
FROM tableUse JOIN process USING (processKey)<br>
LIMIT 10<br>
    </p>

     {% from "_formhelpers.html" import render_field %}
     <form action="{{ url_for('queryLog') }}" method="post" role="form">
        {{ form.csrf_token }}
        {{ render_field(form.sqlQuery, rows=20, cols=80) }}
        <p>{{ form.submit() }}</p>
    </form>

 {% if dbName %}
 <h2>Analyze Server Log: '{{ dbName }}'</h2>

    <h2>Query results</h2>
    <p>{{ data.sql }}</p>
    <p>Time to run query: {{ data.time_taken }}</p>
    {{ data.data|safe }}

 {% endif %}

</div>

{% endblock %}
# Change User Description Committed
#7 25220 Robert Cowham Moved project files to new location: //guest/perforce_software/log-analyzer/psla/...
Required by Swarm project structure for workshop.
#6 24989 Robert Cowham Expand schema help for tableuse
#5 24976 Robert Cowham Avoid trigger change event on page load
#4 24321 Robert Cowham Allow canned queries to be included
#3 23896 Robert Cowham Nicer formatting of help text
#2 23846 Robert Cowham Made sql field larger
#1 23845 Robert Cowham Basic query form working