Placeholder task to:
- figure out what we want to know about AQS usage
- measure it
- send it to prometheus or make a dashboard
Description
Description
Event Timeline
Comment Actions
If you run this query on presto:
select month,
if(split_part(uri_path, '/', 5) = 'unique-devices',
split_part(uri_path, '/', 5),
concat(split_part(uri_path, '/', 5), ' ', split_part(uri_path, '/', 6))
) as endpoint,
sum(request_count)
from aqs_hourly
where split_part(uri_path, '/', 4) = 'metrics'
and year = 2021
and http_status = '200'
group by month, if(split_part(uri_path, '/', 5) = 'unique-devices',
split_part(uri_path, '/', 5),
concat(split_part(uri_path, '/', 5), ' ', split_part(uri_path, '/', 6))
)
;| month | endpoint | _col2 |
| 1 | bytes-difference absolute | 6401 |
| 1 | bytes-difference net | 44437 |
| 1 | edited-pages aggregate | 44055 |
| 1 | edited-pages new | 7375 |
| 1 | edited-pages top-by-absolute-bytes-difference | 303 |
| 1 | edited-pages top-by-edits | 5934 |
| 1 | edited-pages top-by-net-bytes-difference | 303 |
| 1 | editors aggregate | 133841 |
| 1 | editors by-country | 743 |
| 1 | editors top-by-absolute-bytes-difference | 303 |
| 1 | editors top-by-edits | 2437 |
| 1 | editors top-by-net-bytes-difference | 306 |
| 1 | edits aggregate | 58933 |
| 1 | edits per-page | 104145 |
| 1 | legacy pagecounts | 2064 |
| 1 | mediarequests aggregate | 44532 |
| 1 | mediarequests per-file | 12385 |
| 1 | mediarequests top | 370 |
| 1 | pageviews per-article | 5927409521 |
| 1 | pageviews top | 730001 |
| 1 | pageviews top-by-country | 57031 |
| 1 | pageviews | 19 |
| 1 | unique-devices | 79881 |
| 2 | NULL | 11 |
| 2 | bytes-difference absolute | 5595 |
| 2 | bytes-difference net | 39849 |
| 2 | edited-pages aggregate | 39561 |
| 2 | edited-pages new | 7825 |
| 2 | edited-pages top-by-absolute-bytes-difference | 302 |
| 2 | edited-pages top-by-edits | 3512 |
| 2 | edited-pages top-by-net-bytes-difference | 301 |
| 2 | editors aggregate | 122057 |
| 2 | editors by-country | 658 |
| 2 | editors top-by-edits | 1985 |
| 2 | editors top-by-net-bytes-difference | 301 |
| 2 | editors | 1 |
| 2 | edits aggregate | 50770 |
| 2 | edits per-page | 85792 |
| 2 | legacy pagecounts | 2216 |
| 2 | mediarequests aggregate | 40067 |
| 2 | mediarequests per-file | 23979 |
| 2 | mediarequests top | 367 |
| 2 | pageviews aggregate | 112500 |
| 2 | pageviews top | 705808 |
| 2 | pageviews top-by-country | 78397 |
| 2 | registered-users new | 39874 |
| 2 | unique-devices | 60195 |
| 3 | NULL | 12 |
| 3 | bytes-difference absolute | 5920 |
| 3 | bytes-difference net | 42070 |
| 3 | edited-pages aggregate | 41083 |
| 3 | edited-pages new | 4479 |
| 3 | edited-pages top-by-absolute-bytes-difference | 307 |
| 3 | edited-pages top-by-edits | 2698 |
| 3 | edited-pages top-by-net-bytes-difference | 306 |
| 3 | edited-pages | 1 |
| 3 | editors aggregate | 118302 |
| 3 | editors by-country | 701 |
| 3 | editors top-by-absolute-bytes-difference | 307 |
| 3 | editors top-by-edits | 1761 |
| 3 | editors top-by-net-bytes-difference | 306 |
| 3 | editors | 1 |
| 3 | edits aggregate | 52519 |
| 3 | edits per-page | 83707 |
| 3 | legacy pagecounts | 2415 |
| 3 | mediarequests aggregate | 42607 |
| 3 | mediarequests per-file | 19568 |
| 3 | mediarequests top | 305 |
| 3 | pageviews aggregate | 124591 |
| 3 | pageviews per-article | 5738307463 |
| 3 | pageviews top | 828556 |
| 3 | pageviews top-by-country | 50757 |
| 3 | pageviews top-per-country | 956 |
| 3 | pageviews | 19 |
| 3 | registered-users new | 42003 |
| 3 | unique-devices | 59551 |
| 4 | NULL | 6 |
| 4 | bytes-difference absolute | 5543 |
| 4 | bytes-difference net | 43004 |
| 4 | edited-pages aggregate | 41018 |
| 4 | edited-pages new | 4405 |
| 4 | edited-pages top-by-absolute-bytes-difference | 6 |
| 4 | edited-pages top-by-edits | 2399 |
| 4 | edited-pages top-by-net-bytes-difference | 4 |
| 4 | editors aggregate | 121475 |
| 4 | editors by-country | 628 |
| 4 | editors top-by-absolute-bytes-difference | 10 |
| 4 | editors top-by-edits | 1474 |
| 4 | editors top-by-net-bytes-difference | 5 |
| 4 | editors | 1 |
| 4 | edits aggregate | 53949 |
| 4 | edits per-page | 208922 |
| 4 | legacy pagecounts | 1364 |
| 4 | mediarequests aggregate | 43525 |
| 4 | mediarequests per-file | 16279 |
| 4 | mediarequests top | 295 |
| 4 | pageviews aggregate | 228054 |
| 4 | pageviews per-article | 5559596928 |
| 4 | pageviews top | 779009 |
| 4 | pageviews top-by-country | 48800 |
| 4 | pageviews top-per-country | 1619 |
| 4 | registered-users new | 43107 |
| 4 | unique-devices | 53043 |
| 5 | NULL | 8 |
| 5 | bytes-difference absolute | 5884 |
| 5 | bytes-difference net | 57496 |
| 5 | edited-pages aggregate | 56650 |
| 5 | edited-pages new | 3802 |
| 5 | edited-pages top-by-absolute-bytes-difference | 3 |
| 5 | edited-pages top-by-edits | 1251 |
| 5 | edited-pages top-by-net-bytes-difference | 2 |
| 5 | editors aggregate | 160388 |
| 5 | editors by-country | 498 |
| 5 | editors top-by-absolute-bytes-difference | 466 |
| 5 | editors top-by-net-bytes-difference | 4 |
| 5 | editors | 2 |
| 5 | edits aggregate | 68165 |
| 5 | edits per-page | 498275 |
| 5 | legacy pagecounts | 2297 |
| 5 | legacy | 1 |
| 5 | mediarequests aggregate | 57914 |
| 5 | mediarequests per-file | 12993 |
| 5 | mediarequests top | 318 |
| 5 | pageviews aggregate | 152639 |
| 5 | pageviews per-article | 5686986849 |
| 5 | pageviews top | 776728 |
| 5 | pageviews top-by-country | 64816 |
| 5 | pageviews top-per-country | 3460 |
| 5 | pageviews | 4 |
| 5 | registered-users new | 57009 |
| 5 | unique-devices | 55410 |
| 6 | bytes-difference absolute | 1787 |
| 6 | bytes-difference net | 12502 |
| 6 | edited-pages aggregate | 13233 |
| 6 | edited-pages new | 2178 |
| 6 | edited-pages top-by-absolute-bytes-difference | 301 |
| 6 | edited-pages top-by-edits | 593 |
| 6 | edited-pages top-by-net-bytes-difference | 301 |
| 6 | editors aggregate | 34780 |
| 6 | editors by-country | 135 |
| 6 | editors top-by-absolute-bytes-difference | 341 |
| 6 | editors top-by-edits | 811 |
| 6 | editors top-by-net-bytes-difference | 301 |
| 6 | edits aggregate | 15099 |
| 6 | edits per-page | 18389 |
| 6 | legacy pagecounts | 694 |
| 6 | mediarequests aggregate | 12226 |
| 6 | mediarequests per-file | 4536 |
| 6 | mediarequests top | 47 |
| 6 | pageviews aggregate | 35223 |
| 6 | pageviews per-article | 1470113630 |
| 6 | pageviews top | 165355 |
| 6 | pageviews top-by-country | 14248 |
| 6 | registered-users new | 12161 |