Skip to main content
Grafana

Bookmarks

Starred

Dashboards

Explore

Alerting

Connections

Administration

Explore
OpenObserve logs and traces
Search...
ctrl+k
Explore
Outline
Split
Add
Queries
Traces
A
(OpenObserve logs and traces)
Logs
Traces
Service Map
Organization
Trace stream
Service Name
=
Span Name
=
Status
=
Duration
Tags
Run query
Results are listed as a table — open any trace to inspect its spans.
SQL
Reset to generated SQL

使用 str_match(field, '123') 比 LIKE '%123%' 更快；参考文档：https://openobserve.ai/docs/reference/sql-functions/

1
SELECT * FROM "messenger" WHERE "trace_id" = '13aa5cd043d490330a867149fc7f4dbf' ORDER BY "_timestamp" ASC
Add query
Query history
Query inspector
Trace
messenger-api
POST /api/v1/chats/{chat_id}/attachments
Trace ID
13aa5cd043d490330a867149fc7f4dbf
Start time
2026-11-16 02:34:19.655
(5 hours ago)
Duration
812.88ms
Services
2
Spans
42
Overview
0μs
203.22ms
406.44ms
609.66ms
812.88ms
Filters
Critical path
Errors
High latency
42 spans
Show all spans
Service & Operation
0μs
203.22ms
406.44ms
609.66ms
812.88ms
messenger-api POST /api/v1/chats/{chat_id}/attachments (129.79ms)
129.79ms
-
postgres.acquire (11.52μs)
11.52μs
-
postgres.query (269.82μs)
269.82μs
-
postgres.acquire (5.38μs)
5.38μs
-
postgres.query (292.61μs)
292.61μs
-
postgres.acquire (8.7μs)
8.7μs
-
postgres.query (364.29μs)
364.29μs
-
postgres.acquire (48.9μs)
48.9μs
-
postgres.query (116.48μs)
116.48μs
-
postgres.query (717.57μs)
717.57μs
-
postgres.query (1.07ms)
1.07ms
-
postgres.query (31.18ms)
31.18ms
-
s3.put (68.41ms)
68.41ms
-
postgres.acquire (13.82μs)
13.82μs
-
postgres.query (194.05μs)
194.05μs
-
postgres.query (717.82μs)
717.82μs
-
postgres.query (598.78μs)
598.78μs
-
postgres.query (21.76ms)
21.76ms
messenger-worker attachment.publish (69.22ms)
69.22ms
attachment.process (549.03ms)
549.03ms
-
postgres.acquire (12.8μs)
12.8μs
-
postgres.query (253.95μs)
253.95μs
-
postgres.query (23.97ms)
23.97ms
-
postgres.query (674.3μs)
674.3μs
-
postgres.query (7.45ms)
7.45ms
-
s3.get (5.7ms)
5.7ms
-
s3.put (62.95ms)
62.95ms
-
s3.put (189.1ms)
189.1ms
-
s3.put (127.93ms)
127.93ms
-
s3.put (50.61ms)
50.61ms
-
postgres.acquire (12.29μs)
12.29μs
-
postgres.query (225.02μs)
225.02μs
-
postgres.query (774.4μs)
774.4μs
-
postgres.query (323.07μs)
323.07μs
-
postgres.query (17.52ms)
17.52ms
-
postgres.acquire (5.63μs)
5.63μs
-
postgres.query (8.33ms)
8.33ms
-
s3.stat (1.04ms)
1.04ms
-
postgres.acquire (13.31μs)
13.31μs
-
postgres.query (5.11ms)
5.11ms
-
postgres.acquire (6.66μs)
6.66μs
-
postgres.query (24.06ms)
24.06ms