hyperdx
hyperdx copied to clipboard
UI: Can't open log detailed info
Some messsages contains quotes, and it cannot be opened because the query can't find it.
The query looks like below. A commented part queries non-existent data.
Btw, might be better to search using Body here?
Fields ScopeAttributes and LogAttributes have JSON type.
SELECT *
,Timestamp AS "__hdx_timestamp"
,Body AS "__hdx_body"
,TraceId AS "__hdx_trace_id"
,SpanId AS "__hdx_span_id"
,SeverityText AS "__hdx_severity_text"
,ServiceName AS "__hdx_service_name"
,ResourceAttributes AS "__hdx_resource_attributes"
,LogAttributes AS "__hdx_event_attributes" FROM otel_distributed.otel_logs
WHERE (Timestamp=parseDateTime64BestEffort('2025-08-28T09:53:47.737000000Z', 9)
AND ServiceName='postgresql' AND SeverityText='fatal'
------
--AND toString(LogAttributes.message)='pg_hba.conf rejects connection for host \\\"10.8.7.20\\\", user \\\"hidden_user\\\", database \\\"hidden\\\", no encryption'
-------
AND toString(ResourceAttributes.service.instance.id)='hidden:5432'
AND toDateTime(Timestamp)=parseDateTime64BestEffort('2025-08-28T09:53:47Z', 9)) LIMIT 1