It is known from
MODINVSTOR-256 that querying instance with location filter need performance improvement. This ticket is take a quick analysis to see if there are any low hanging fruits that we can tweak. For example, missing indexes. Also with recent RMB-301 work, it might help performance as well.