Materialized View capturing root span level information for a trace
We should have a Materialized View that captures trace level information as inferred from root span. This will make certain queries much easier (improve tracing list rendering time).
See earlier discussions on https://gitlab.com/gitlab-org/opstrace/opstrace/-/issues/2582#note_1719899892 and https://gitlab.com/gitlab-org/opstrace/opstrace/-/issues/2381#note_1685708784 for example.
Edited by Sacha Guyon