Top10 queries with group by clause

Hi everyone,

I’m logging all apache logs in graylog with extra “loadtime” field which is processed with extractors as an independent field for every line (same for URI field).

I’m able to easily make graphs based on mean loadtime for example, this is fine.

But can I query TOP-x queries based on load-time (DESC) and grouped by URI ? My target would be to easily identify slow pages on websites with their average loadtime for each.

Thanks,

Gaëtan

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