- {% extends "base.html" %}
- {% block content %}
- <script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.min.js"></script>
- <script type="text/javascript">
- $(document).ready(function(){
- $('#queryOptions').change(function() {
- $("#sqlQuery").empty();
- query_sql = $("#queryOptions option:selected").val();
- $('#sqlQuery').val(query_sql);
- });
- });
- </script>
- <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>
- <a class=btn href='{{ url_for("schema") }}'>
- <span>Table schema with explanations</span></a>
- <a class=btn href='{{ url_for("chartLog") }}'>
- <span>Single Chart for Log DB</span></a>
- <p>
- SELECT process.processKey, process.lineNumber, startTime, endTime, computedLapse, completedLapse,<br>
- pid, user, workspace, ip, app, cmd, args,<br>
- uCpu, sCpu, diskIn, diskOut, ipcIn, ipcOut, maxRss, pageFaults,<br>
- rpcMsgsIn, rpcMsgsOut, rpcSizeIn, rpcSizeOut, rpcHimarkFwd, rpcHimarkRev,<br>
- rpcSnd, rpcRcv, running, error,<br>
- pagesIn, pagesOut, pagesCached,<br>
- pagesSplitInternal, pagesSplitLeaf,<br>
- readLocks, writeLocks,<br>
- getRows, posRows, scanRows, putRows, delRows,<br>
- totalReadWait, totalReadHeld, totalWriteWait, totalWriteHeld, <br>
- maxReadWait, maxReadHeld, maxWriteWait, maxWriteHeld, <br>
- 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.logFile) }}
- {{ render_field(form.queryOptions) }}
- {{ 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 | |
---|---|---|---|---|---|
#1 | 29582 | kluo | "Forking branch psla of perforce-software-log-analyzer to kluo-log-analyzer." | 2 years ago | |
//guest/perforce_software/log-analyzer/psla/psla/app/templates/queryLog.html | |||||
#2 | 26269 | Robert Cowham | Added new table fields parsed: pagesSplitInternal, pagesSplitLeaf Indicates possible high... CPU due to tabl expansion « |
5 years ago | |
#1 | 25216 | Robert Cowham | Branch files to Workshop mandated path for project | 6 years ago | |
//guest/perforce_software/utils/log_analyzer/psla/app/templates/queryLog.html | |||||
#6 | 24989 | Robert Cowham | Expand schema help for tableuse | 6 years ago | |
#5 | 24976 | Robert Cowham | Avoid trigger change event on page load | 6 years ago | |
#4 | 24321 | Robert Cowham | Allow canned queries to be included | 7 years ago | |
#3 | 23896 | Robert Cowham | Nicer formatting of help text | 7 years ago | |
#2 | 23846 | Robert Cowham | Made sql field larger | 7 years ago | |
#1 | 23845 | Robert Cowham | Basic query form working | 7 years ago |