After you use Log Service to collect NGINX access logs, you can use a query statement to view the numbers of page views (PVs) per minute. You can add a filter of the Filter type to query the numbers of PVs for a specific request method by using dynamic list items. In this topic, the NGINX access log dashboard is used as an example to describe how to add a filter of the Filter type to query the numbers of PVs for a specific request method.

Prerequisites

Procedure

The following figure shows how to add a filter of the Filter type on the NGINX access log dashboard.

Add a filter of the Filter type

Step 1: Query number of PVs

The following procedure describes how to query the numbers of PVs per minute by using a query statement:

  1. Log on to the Log Service console.
  2. In the Projects section, click the name of the project that you want to view.
  3. Choose Log Storage > Logstores. On the Logstores tab, click the Logstore that you want to view.
  4. Query the numbers of PVs.
    1. In the search box, enter a query statement.

      Enter the following query statement to query the numbers of PVs per minute:

      * | SELECT date_format(__time__ - __time__ % 60, '%H:%i:%s') as time, count(1) as count GROUP BY time ORDER BY time

      For more information about query and analysis, see Log search overview and Log analysis overview.

    2. Click 15 Minutes(Relative) to specify a time range for the query.
      You can select a relative time or a time frame, or customize a time range.
      Note The query results may contain logs that are generated 1 minute earlier or later than the specified time range.
    3. Click Search & Analyze.

      The following figure shows the query results.

      visualization_best_practice_variable_query_result

Step 2: Add a chart to a dashboard

The following procedure describes how to add a PV chart to the NGINX Access Log dashboard:

  1. On the Graph tab, click Add to New Dashboard.
  2. In the Add to New Dashboard dialog box, configure the following parameters and click OK.
    add_to_new_dashboard_cn
    For more information about dashboard parameters, see Add charts to a dashboard.

Step 3: Add a filter

To add a filter of the Filter type to query the numbers of PVs for a specific request method, perform the following steps:

  1. In the left navigation sidebar, click the  icon.
  2. In the Dashboard pane, click NGINX Access Log.

    The NGINX Access Log dashboard displays the numbers of PVs per minute.

    nginx access log dashboard cn
  3. In the upper-right corner of the NGINX Access Log page, click Edit. Then, click the Filter icon icon.
  4. In the Filter panel, configure the following parameters and click OK.
    request method filter

    The following code provides an example of the query statement by using dynamic list items:

    *|select distinct request_method

    For more information about the filter parameters, see Add a filter.

  5. Adjust the filter layout on the page and click Save.
  6. In the Save message, click OK.

    The NGINX Access Log dashboard displays the Method Filter filter.

    dashboard with filter

Step 4: Verify the results

In the Method Filter section of the NGINX Access Log page, set method to DELETE.
The following query statement is executed:
(*) and (request_method: DELETE) | SELECT date_format(__time__ - __time__ % 60, '%H:%i:%s') as time, count(1) as count GROUP BY time ORDER BY time 

The NGINX Access Log dashboard displays the numbers of PVs per minute for the DELETE method.

delete method