Analyzing user queries with Refinery's query log

The QR Query Log maintains a record of the queries that have been sent to the system throughout a given day. The Query Log can be viewed in the QR Query Log dashboard. The results can also be downloaded as a CSV file using the Download csv button at the top-right of the data grid.

The schema of the Query Log is:

Column name	Description
requestNum	Number of the request
requestTime	Time that the request was made
hostname	Hostname of the server on which the QR is running
ip	IP of the server on which the QR is running
user	User who send the request
handle	Handle that the request came from
status	Status of the request
executionTime	Time taken from requestTime until current status
returnRowCount	Number of rows returned in result
serversRequested	Processes that were requested
numberOfServersRequested	Number of processes
function	Function that was called
arguments	Arguments of the function
Debug	Debug messages in event of an error

Below is a sample extract of a QR Query Log:

There is also a dropdown list at the top of the Query Log where an administration user can select a DaaS Instance. In a hosted solution, this will allow the administration user to view the Query Log for a particular instance.

Note

This log only shows queries run through the QR/QP framework and not queries run through a gateway process.