Query Log

Screenshot

On the Kx Monitoring dashboard the DeltaOps dxQueryLog screen shows summary statistics on queries running on each kdb+ process in the system that has the query logging turned on.

QueryLog Analysis

The QueryLog analysis displays queries that have been received by processes. Filter the tabulated information with the following controls:

control filters
Report a report from the dxQueryLog table
Date date of log
Start start time
End end time
Process process name
User user name

Set all filter criteria and click Submit. Among the information displayed:

column content
sym process name
Executed number of executed queries
Failed number of failed queries
>100ms number of queries taking more than 100ms to return
10-100ms number of queries taking between 10 to 100 ms to return
0-10ms number of queries taking between 0 to 10 ms to return
>10MB number of queries taking more that 10Mb memory
1kb_1MB number of queries taking between 1kb and 1Mb of memory
0_1KB number of queries taking less than 1kb memory

Process QueryLog Stats Bucketed Over Time

The Process QueryLog Stats Bucketed Over Time displays process-level statistics for all queries received by processes. Statistics are shown in a time-series grid, bucketed according to the grouping selected. this populates when a process is selected from the QueryLog Analysis section.

One Report option is TimeAndMemProfile, which displays QryTime (ms) and QryMemMB (Mb) grouped into small, medium and large buckets.

Filter the information displayed with the following controls:

control filters
Report a report from the dxQueryLog table
Date date of log
Start start time
End end time
Group By hour, minute, or second
Amount corresponding number for Group By; e.g. to group by 5 minutes, set Group By to minute, and Amount to 5
Process process name

Among the information displayed:

column content
time time the reading was taken
sym process name
Executed number of executed queries
Failed number of failed queries
>100ms number of queries taking more than 100ms to return
10-100ms number of queries taking 10 to 100 ms to return
0-10ms number of queries taking between 0 to 10 ms to return
>10MB number of queries taking more that 10Mb memory
1kb_1MB number of queries taking between 1Kb and 1Mb of memory
0_1KB number of queries taking less than 1Kb memory

Query Log

Details of all queries made for the selected period.

Filter the information displayed with the following controls:

control filters
Date date of query
Start start time of query peiod
End end time of query period
Process process instance name
Status Success/Failure of the query
Exectime minumum execution time for queries (ms)
User user name
QrySearch string to be found in queries

Set filter criteria and click Submit. The information displayed:

column content
date date query was made
sym process instance queried
time time query was made
id query ID
user user who made the query
query query that was made against process instance
exectime execution time for the query
querytype async or sync
ip IP address from which the query was made
status status of the query
memory memory in bytes required to execute the query
error if status is failed, the error message
execmemory memory required for the result set
handle handle query executed over
process name of process instance
host host name of the process instance
pid process ID