OPopenobserve
Traces

Database Monitoring: top queries

Top query fingerprints with merged stats and _other remainder, merged with a bounded live tail over the un-rolled-up spans.

get/api/{org_id}/db_monitoring/queries

Request

Path parameters

org_idstring required

Organization name

Query parameters

start_timeinteger

Start time (microseconds)

end_timeinteger

End time (microseconds)

streamstring

Trace stream filter

systemstring

Database system filter

instancestring

Database instance filter

namespacestring

Database namespace filter

envstring

Environment filter

servicestring

Calling service filter

stmt_classstring

Statement class filter (default 'query'; 'all' disables)

sortstring

Sort key (whitelist; default total_time_ns)

limitinteger

Max rows (default 100)

searchstring

Free-text search over normalized query text

include_server_fallbackboolean

When the client-vantage answer is an exact zero, also run the database-reported list and return it as server_fallback (with per-section forbidden/read-failed flags)

fingerprintstring

Narrows the server_fallback section to one statement (the query-detail row lookup). Does not filter the client-vantage rows.

baseline_start_timeinteger

Δ baseline window start (microseconds); returns baseline_hits under the same filters and sort

baseline_end_timeinteger

Δ baseline window end (microseconds)

Response

Success

object required

Changes

No recorded changes to this operation across all 1 revision of this API.