Observability: Collections Implement end-to-end traces #1006

Is your feature request related to a problem?
We lack end-to-end traces for the collections and document endpoints, making it difficult to identify bottlenecks and latency issues. This hampers our ability to optimize the collections and document module effectively.

Describe the solution you'd like
Implement end-to-end traces for collections and document endpoints using a waterfall model, similar to the llm-call traces, to gain insights into performance issues.