It's all about the answers!

Ask a question

How to find active queries running in LQE?

Krzysztof Ka┼║mierczyk (7.4k35097) | asked Sep 09 '15, 10:44 a.m.
When LQE crashes it displays the query ID for which it crashed. I would like to know what exactly the query looks like. I would like to know how to find list of active queries ran on LQE server.

How to do that?

One answer

permanent link
Krzysztof Ka┼║mierczyk (7.4k35097) | answered Sep 09 '15, 10:45 a.m.
There are several ways to monitor queries:

  1. At the top of the Stats page , the last 500 queries are shown as bubbles in a graph. When a user hovers over a bubble, more information about the query is shown as popup text. The most recent queries are shown in the right hand side of this graph.

  2. At the top of the statistics page to the right of the Completed Queries graph is a link called "View As List". Select "View as List"
    • The most recent Queries are listed in a table.  Each column can be sorted to change the order, but the most recent is defaulted.  More details about each query can be found by clicking "More Details" next to the query of interest.

    • There is a tab called Running Queries which shows a list of queries that are currently executing.

    • There is a tab to show any Blocked Queries which may have been blocked by the admin.

Your answer

Register or to post your answer.