Monitoring Quickstart

1. Navigate to the Monitoring tab from your Vercel dashboard
2. Click the Create New Query button to open the query builder
3. Click the Edit Query button to configure your query with clauses

The Visualize clause specifies which field in your query will be calculated. Set the Visualize clause to requests to monitor the most popular posts on your website.

Click the Run Query button, and the Monitoring chart will display the total number of requests made.

To filter the query data, use the Where clause and specify the conditions you want to match against. You can use a combination of variables and operators to fetch the most requested posts. Add the following query statement to the Where clause:

host = 'my-site.com' and like(request_path, '/posts%')

This query retrieves data with a host field of my-site.com and a request_path field that starts with /posts.

The % character can be used as a wildcard to match any sequence of characters after /posts, allowing you to capture all request_path values that start with that substring.

Define a criteria that groups the data based on the selected attributes. The grouping mechanism is supported through the Group By clause.

Set the Group By clause to request_path.

With Visualize, Where, and Group By fields set, the Monitoring chart now shows the sum of requests that are filtered based on the request_path.

To control the number of results returned by the query, use the Limit clause and specify the desired number of results. You can choose from a few options, such as 5, 10, 25, 50, or 100 query results. For this example, set the limit to 5 query results.

Save your query and click the Run Query button to generate the final results. The Monitoring chart will display a comprehensive view of the top 5 most requested posts on your website.