Bosch IoT Insights

Query History

The Query History lists all user-specific queries along with their details.

The following query statuses exist:

Status

Description

Icon

Pending

The query request is waiting to be handled.

images/confluence/download/thumbnails/1096710267/icon-pending.png

Incorrect

The query failed due to incorrect syntax or missing information.

images/confluence/download/thumbnails/1096710267/icon-incorrect.png

Queued

The query is waiting for a read ticket to become available.

images/confluence/download/thumbnails/1096710267/icon-queued.png

Running

The query was sent to the database and is executed, waiting until the the data is available.

images/confluence/download/thumbnails/1096710267/icon-running.png

Failed

The query execution failed due to an unforeseen error or a database exception.

images/confluence/download/thumbnails/1096710267/icon-error.png

Successful

The query result is ready to be downloaded (DB cursor is ready).

images/confluence/download/thumbnails/1096710267/icon-success.png

Expired

The query result was not downloaded by the client in the pre-defined time frame.

images/confluence/download/thumbnails/1096710267/icon-expired.png

Interrupted

The download of the query result failed, was aborted, or interrupted. The may be due to network issues or other unforeseen infrastructure problems.

images/confluence/download/thumbnails/1096710267/icon-error.png

Finished

The query result was downloaded completely and the query is finished.

images/confluence/download/thumbnails/1096710267/icon-finished.png

Cancelled

The query got manually canceled before it was finished.

images/confluence/download/attachments/1096710267/icon_canceled.png

No Ticket

No free read ticket available.

images/confluence/download/thumbnails/1096710267/icon-no-ticket.png

Queries that are in state Running can be canceled by an Admin with the Cancel query images/confluence/download/thumbnails/1096710267/cancel_action.png icon. Canceled queries cannot be resumed!

Prerequisites

To execute the following actions, you have to be assigned to the User role or higher.

Proceed as follows

  1. Click the Query History menu item.
    → The Query History is displayed.
    images/confluence/download/attachments/1096710267/explore_query_history_2020_11_19.png

  2. Open any query in the Query column to view the whole query and the details.
    images/confluence/download/attachments/1096710267/explore_query_history_details_2021_09_14.png

    • The cursor preparation is the time it takes for the MongoDB cursor to be available.
      This time is highly influenced by the query logic and complexity, e.g. if the query is written without any usage of indices, this will highly increase the cursor preparation time.

    • The wait duration defines the time how long it took the client to start retrieving the first bytes after they were available.
      This timing is highly influenced by network infrastructure and client side application logic, which can lead to large variations on the numbers, e.g. if the client network connection has a bad latency the wait time can increase significantly.

    • The download time defines the time it took the client to retrieve all content.
      This timing is highly influenced by network infrastructure, client side application logic, and also server side computations, which can all lead to large variations on the numbers, e.g. if the client network connection has a bad download speed the download time can increase significantly.

    • The read ticket duration represents the sum of all others and stands for the time how long the service was occupied with the client request.
      During this time resources were reserved for the client.

  3. Optionally, click the Open in Data Analyzer button to view the query in the Data Analyzer.

General functions

Filtering the query history

Proceed as follows

  1. Click the Add Filter drop-down list.

  2. Select a filter category.
    → A dialog is displayed in which you can define the filter.

  3. Click the Save button.
    → The filter is applied to the query history.

Paging

Proceed as follows

Use the images/confluence/download/thumbnails/1096710267/icon_page_beginning.png and images/confluence/download/thumbnails/1096710267/icon_page_end.png icons to jump to either the first page or the last page of the displayed data.

Use the images/confluence/download/thumbnails/1096710267/icon_page_back.png and images/confluence/download/thumbnails/1096710267/icon_page_next.png icons to go back a page or forward.

Refreshing the entries

Proceed as follows

Click the images/confluence/download/thumbnails/1096710267/icon_refresh.png icon to refresh the entries.

Limiting the number of displayed entries

Proceed as follows

  1. Click the Settings drop-down list.

  2. Select the number of processed data entries to be displayed per page.
    → The number of displayed entries per page is adjusted accordingly.

Deleting the query history

Click the Delete All button to delete the query history.