messenger_attachment_jobs: query: | WITH statuses(status) AS ( VALUES ('queued'), ('processing'), ('failed') ) SELECT statuses.status, COUNT(j.id)::bigint AS count, COALESCE(EXTRACT(EPOCH FROM (clock_timestamp() - MIN(j.created_at))), 0)::double precision AS oldest_age_seconds FROM statuses LEFT JOIN attachment_jobs j ON j.status = statuses.status GROUP BY statuses.status metrics: - status: usage: LABEL description: Attachment job status. - count: usage: GAUGE description: Attachment jobs in this status. - oldest_age_seconds: usage: GAUGE description: Age of the oldest attachment job in this status. messenger_outbox: query: | SELECT COUNT(*) FILTER (WHERE published_at IS NULL)::bigint AS pending, COALESCE( EXTRACT(EPOCH FROM (clock_timestamp() - MIN(created_at) FILTER (WHERE published_at IS NULL))), 0 )::double precision AS oldest_pending_age_seconds FROM outbox_events metrics: - pending: usage: GAUGE description: Unpublished outbox events. - oldest_pending_age_seconds: usage: GAUGE description: Age of the oldest unpublished outbox event. messenger_attachment_terminal_transitions: query: | WITH statuses(status) AS ( VALUES ('ready'), ('failed') ) SELECT statuses.status, COUNT(events.job_id)::bigint AS total FROM statuses LEFT JOIN attachment_terminal_events events ON events.status = statuses.status GROUP BY statuses.status metrics: - status: usage: LABEL description: First terminal status recorded for a durable attachment job. - total: usage: COUNTER description: Durable attachment jobs whose first terminal outcome has this status. messenger_attachment_time_to_ready_seconds: query: | WITH bounds(le, upper_bound) AS ( VALUES ('0.05', 0.05::double precision), ('0.1', 0.1::double precision), ('0.25', 0.25::double precision), ('0.5', 0.5::double precision), ('1', 1::double precision), ('2.5', 2.5::double precision), ('5', 5::double precision), ('10', 10::double precision), ('15', 15::double precision), ('20', 20::double precision), ('30', 30::double precision), ('60', 60::double precision), ('+Inf', NULL::double precision) ) SELECT bounds.le, COUNT(events.job_id) FILTER ( WHERE events.status = 'ready' AND ( bounds.upper_bound IS NULL OR EXTRACT(EPOCH FROM (events.terminal_at - events.accepted_at)) <= bounds.upper_bound ) )::bigint AS bucket FROM bounds LEFT JOIN attachment_terminal_events events ON events.status = 'ready' GROUP BY bounds.le, bounds.upper_bound ORDER BY bounds.upper_bound NULLS LAST metrics: - le: usage: LABEL description: Upper bound of the durable time-to-ready bucket in seconds. - bucket: usage: COUNTER description: Durable attachment jobs reaching ready within the bucket bound.