Topk Values in Logql

Elena Rostova
Elena Rostova
• • 1 min read

I Need Some Help with Loki. I`ve Got Json Logs Like Following {"Message": {"Reason": "Reason1". .. }} {"Message": {"Reason": "Reason2". .. }} and I Need to...

Topk Values in Logql

I need some help with Loki. I`ve got json logs like following

{"message": {"reason": "reason1"...}}
{"message": {"reason": "reason2"...}}

And I need to print top N reasons. How can I do this?

1 Answer

Try the following LogQL

topk(N, sum by (reason) (count_over_time({filename="xxxxx"} | json [1d])))
5

Must Read

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Elena Rostova

Elena Rostova

Lead Health, Wellness & Medical Journalist
Instagram Linkedin Twitter

Elena Rostova holds a Master's degree in Public Health Journalism. She covers groundbreaking medical research, holistic wellness trends, mental health awareness, and nutritional science.

Share this article
Twitter Facebook Pinterest