Monitoring QuickstartIn 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.
% 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 via the Group By clause.
Set the Group By clause to
With Visualize, Where, and Group By fields set, the Monitoring chart now shows the sum of
requests that are filtered based on the
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.