Which tables is the data for consolidated pageviews report stored?

Data & reporting
1

Does anyone know which postgres table is the data seen in Consolidated Pageviews report ( */admin/reports/consolidated_page_views) stored?

1 Like
2

The consolidated page views report gets its data from the application_requests table.

3 Likes
3

@simon thank you so much! Do the numbers in req_type column correspond to the following request types like so?

0 = http_total
1 = http_2xx
2 = http_background
3 = http_3xx
4 = http_4xx
5 = http_5xx
6 = page_view_crawler
7 = page_view_logged_in
8 = page_view_anon
9 = page_view_logged_in_mobile
10 = page_view_anon_mobile

1 Like
4

Yes, those are the meanings of the req_type numbers. This can be found from the Rails console by running: ApplicationRequest.req_types

3 Likes
5

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.