Skip to content

Add per day counter of views for analysis

Ernst van Nierop requested to merge evn-add-count-to-views-and-more into master

I'd like to be able to make a tabular overview of which view type is built, how often, how long it takes, etc. similar to the tabular overview of git timings and cache timings.

I would subsequently add a table to performance.gitlab.net with the following query

SELECT "action", "count" as "Amount", "duration_mean" AS "Mean", "duration_50th" AS "50th Percentile", "duration_95th" AS "95th Percentile", "duration_99th" as "99th Percentile" FROM downsampled."[[process_type]]_view_timings_per_action_and_view_per_day" WHERE $timeFilter AND action =~ /[[action]]/ ORDER BY time DESC

Obviously, this may reveal a limited understanding on my part on how many "different" kinds of views are called... I am assuming they are not unique per user, i.e. it is a manageable set, just like the git timings (169 elements) and the cache timings (550 timings).

I'm assuming we can not do this for the postgresql timings, because those are unique to the user who calls them. (?)

Edited by Ernst van Nierop

Merge request reports