Add cache hit and miss detection to performance tests

Problem/Motivation

This is possible following 📌 Separate cache operations from database queries in OpenTelemetry and assertions Fixed . We could add assertions, or just extra span attributes in OpenTelemetry.

Steps to reproduce

Proposed resolution

Merge request link

Remaining tasks

User interface changes

API changes

Data model changes

Release notes snippet