Lindorm TSDB provides the Time Series Insights feature. This allows you to save and manage queries. Then, you can modify saved queries to query data in a more efficient manner.

This topic describes how to use the Time Series Insights feature of Lindorm TSDB to create, modify, delete, and display queries.

Notice The queries are stored in your on-premises browser. If you clear data from your browser, the queries that are automatically saved in the browser are deleted.

Create a query

Procedure

  1. Log on to the ApsaraDB for Lindorm (Lindorm) console. Find the instance that you want to manage, and click the instance ID to go to the Instance Details page. In the left-side navigation pane, choose Time Series Engine > Time Series Insight.
  2. On the Time Series Insight page, click Create to create a query. Create a query
  3. In the Edit Query Data dialog box, configure the query criteria.
    • Edit Query Data: Required. Select the start time and the end time of the query.
      Note If you need to query the data that is collected at a specified point in time, set the start time and the end time to the same value.
    • Metric: Required. Select a monitoring metric.
    • Spatial Aggregate Function: Required. Select an aggregation method for time series. If a metric is contained in multiple time series that are generated for multiple devices, perform spatial aggregation on these time series to display the data of multiple spatial dimensions in one time series. You can select one of the following aggregation methods: avg, count, sum, max, min, and none.
    • Tag: Required. Click Add. Then, select a tag key and a tag value. If you want to add another tag, click Add again.
      Note
      • The logical relationship between the values of the tags with the same tag key is OR. For example, if you add two tags that have the city tag key, the logical relationship between the Beijing and Shanghai tag values is OR.
      • The logical relationship between the values of the tags with different tag keys is AND. For example, if you add a tag that has the city tag key and another tag that has the region tag key, the logical relationship between the Beijing and Haidian tag values is AND.
    • Group: Optional. You can group time series by tag key or tag value and compare time series in different groups.
      Note
      • The time series that have a common tag key are grouped by tag value.
      • The time series that have different tag keys are grouped by Cartesian product.
    • Downsampling: Optional. The raw data collected by Lindorm TSDB is accurate to seconds. By default, the downsampling feature is disabled, and the data is displayed based on the sampling precision. If you need to reduce the sampling precision or view the data at a coarse granularity, such as 30 minutes or 12 hours, enable the downsampling feature.
      • Downsampling Aggregate Function: You can select an aggregation method for downsampled time series.
      • Downsampling Interval: You can select an interval at which data is sampled.
  4. After you configure all the query criteria, click OK. Create a query

Modify a query

Procedure

  1. On the Time Series Insight page, find the query that you want to modify, and click the Edit icon Modify a query in the Query Item section.
  2. In the Edit Query Data dialog box, configure the query criteria. For more information, see Create a query.

Delete a query

Procedure

  1. On the Time Series Insight page, find the query that you want to delete, and click the Delete icon Delete in the Query Item section.
  2. In the Confirm to delete the configuration information? message, click OK to delete the query.

View a query

Procedure

  1. On the Time Series Insight page, find the query that you want to view, and click the View icon View in the Query Item section.
  2. In the section that displays data, perform the following operations:
    • In the Timing Information section, move the pointer in the current time series to view data at different points in time.
    • In the Query Item section, view the data of different time series.
    Display the data returned for a specified query