Trying to figure out Page Views queries

So I’m reviewing the page views, and trying to identify queries for “Content Views” vs “User Visits” so I can gather some metrics around those 2, and the only thing I can figure out is using the application_requests table based on the Dashboard sql being ran (e.g. /admin/reports/page_view_total_reqs and others). What I am unsure of is this req_type field in the application_requests table and what the available values mean?

1 Like

The req_types are from this list:

https://github.com/discourse/discourse/blob/master/app/models/application_request.rb#L4-L14

The first one maps to 0, second one 1, etc.

http_total (0) is the total requests, http_2xx (1), http_3xx, etc. are requests that return those status codes.

page_view_crawler counts requests that were from web crawlers, based on their user agents.

6 Likes

Perfect - thanks! Now I gotta decide if any of the http_* are worth using :smiley:

2 Likes

This topic was automatically closed after 2264 days. New replies are no longer allowed.