Something went wrong. Try again.
[READ-ONLY] Mirror of https://github.com/openstatusHQ/openstatus. 🫖 Status page with uptime monitoring & API monitoring as code 🫖 openstatus.dev
bun drizzle-orm monitoring monitoring-as-code nextjs observability on-call open-source shadcn-ui status-page statuspage synthetic-monitoring tinybird turso uptime uptime-checker uptime-monitor
Something went wrong. Try again.
1.7 kB · 54 lines
at incident-api
12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455NODE aggregateSQL > SELECT toDateTime(fromUnixTimestamp64Milli(cronTimestamp)) AS time, latency, region, trigger, statusCode, monitorId, workspaceId, requestStatus, -- Compute actual durations from timing phases if( isNull (JSONExtractInt(timing, 'dnsStart')) OR isNull (JSONExtractInt(timing, 'dnsDone')), NULL, JSONExtractInt(timing, 'dnsDone') - JSONExtractInt(timing, 'dnsStart') ) AS dns, if( isNull (JSONExtractInt(timing, 'connectStart')) OR isNull (JSONExtractInt(timing, 'connectDone')), NULL, JSONExtractInt(timing, 'connectDone') - JSONExtractInt(timing, 'connectStart') ) AS connect, if( isNull (JSONExtractInt(timing, 'tlsHandshakeStart')) OR isNull (JSONExtractInt(timing, 'tlsHandshakeDone')), NULL, JSONExtractInt(timing, 'tlsHandshakeDone') - JSONExtractInt(timing, 'tlsHandshakeStart') ) AS tls, if( isNull (JSONExtractInt(timing, 'firstByteStart')) OR isNull (JSONExtractInt(timing, 'firstByteDone')), NULL, JSONExtractInt(timing, 'firstByteDone') - JSONExtractInt(timing, 'firstByteStart') ) AS firstByte, if( isNull (JSONExtractInt(timing, 'transferStart')) OR isNull (JSONExtractInt(timing, 'transferDone')), NULL, JSONExtractInt(timing, 'transferDone') - JSONExtractInt(timing, 'transferStart') ) AS transfer FROM ping_response__v8TYPE materializedDATASOURCE mv__http_timing_phases_90d__v1