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 
2 Likes