search

timescale / promscale

[DEPRECATED] Promscale is a unified metric and trace observability backend for Prometheus, Jaeger and OpenTelemetry built on PostgreSQL and TimescaleDB.
https://www.timescale.com/promscale
Apache License 2.0
1.33k stars 169 forks source link

Can't create continuous aggregate on ps_trace.span #1835

Open StarpTech opened 1 year ago

StarpTech commented 1 year ago

Describe the bug

Span table is growing very fast. How can I make use of continuous aggregate (realtime) to optimize aggregates as described in https://docs.timescale.com/timescaledb/latest/how-to-guides/hyperfunctions/percentile-approx/approximate-percentile/ ?

This is not possible because ps_trace.span is a postgres view not a hypertable or another continuous aggregate.

Error:

Error occurred during SQL query execution

Reason:
SQL Error [0A000]: ERROR: invalid continuous aggregate query
  Hint: continuous aggregate needs to query hypertable or another continuous aggregate

With that limitation in mind, what's the way to optimize resource-intensive queries?

To Reproduce

**Expected behavior** I expected that it is possible **Configuration (as applicable)** Using Timescaledb Cloud **Version** - Promscale: Latest (0.17.0) - TimescaleDB: Cloud **Additional context** Support Case #: 00012349