Hi All, I have a report running every 6 hour with below search query. This is fetching hourly availability of haproxy backends based on http response code as shown below. I need to accelerate this report, but I think the bucket section of the search is disqualifying this for report acceleration. Can someone help with modifying this search so that it can be accelerated or are there any other work arounds to do this to get the exact same table as shown? index=haproxy (backend="backend1" OR backend="backend2")
| bucket _time span=1h
| eval result=if(status >= 500, "Failure", "Success")
| stats count(result) as totalcount, count(eval(result="Success")) as success, count(eval(result="Failure")) as failure by backend, _time
| eval availability=tostring(round((success/totalcount)*100,3)) + "%"
| fields _time, backend, success, failure, totalcount, availability _time backend success failure totalcount availability 2024-06-07 04:00 backend1 28666 0 28666 100.000% 2024-06-07 05:00 backend1 28666 0 28666 100.000% 2024-06-07 06:00 backend1 28712 0 28712 100.000% 2024-06-07 07:00 backend1 28697 0 28697 100.000% 2024-06-07 08:00 backend1 28678 0 28678 100.000% 2024-06-07 09:00 backend1 28714 0 28714 100.000% 2024-06-07 04:00 backend2 618 0 618 100.000% 2024-06-07 05:00 backend2 179 0 179 100.000% 2024-06-07 06:00 backend2 555 0 555 100.000% 2024-06-07 07:00 backend2 103 0 103 100.000% 2024-06-07 08:00 backend2 1039 0 1039 100.000%
... View more