FileCheck base count query too slow

We had a downtime today because an SQL query was taking too long while it was locking other queries.

This query was a filecheck query and actually one that was only counting.

It appears that this query is requesting to order and this is potentially the only reason I can imagine a big duration.