Monitoring Quickstart
In this quickstart guide, you'll discover how to create and execute a query to visualize the most popular posts on your website.- Make sure you upgrade to Pro or Enterprise plan
- Pro teams should enable Monitoring from team Settings > Billing
- Enterprise teams should contact sales to get a customized plan based on their requirements
In the following guide you will learn how to view the most requested posts on your website.
- Navigate to the Monitoring tab from your Vercel dashboard
- Click the Create New Query button to open the query builder
- 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.


Was this helpful?