2026/11/01 16:15:23 [WARN] slow statement: 2363ms (over 1s): SELECT id, layer, fingerprint, approved_at, approved_by, packages_json, test, cancelled_at, cancel_reason FROM os_releases r WHERE r.layer = ? AND r.test = 1 AND r.cancelled_at = '' AND r.approved_at >= COALESCE((SELECT MAX(approved_at) FROM os_releases WHERE layer = r.layer AND test = 0 AND cancell…
2026/11/01 16:15:25 [WARN] slow statement: 1317ms (over 1s): DELETE FROM host_reports WHERE received_at < ?
2026/11/01 16:15:35 [WARN] slow statement: 10436ms (over 1s): DELETE FROM events WHERE created_at < ?
2026/11/01 16:15:36 [WARN] slow statement: 1045ms (over 1s): DELETE FROM app_telemetry WHERE reported_at < ?
2026/11/01 16:15:58 [WARN] slow statement: 21154ms (over 1s): DELETE FROM app_log_issues WHERE last_seen < ?
2026/11/01 16:16:10 [WARN] slow statement: 12811ms (over 1s): SELECT r.customer_id, r.received_at, r.report_json, r.health_status, r.cpu_percent, r.memory_percent, r.container_total, r.container_running, r.backup_last_snapshot, r.controller_version, r.controller_url FROM reports r INNER JOIN ( SELECT customer_id, MAX(id) as max_id FROM reports GROUP BY custome…
2026/11/01 16:16:25 [WARN] slow statement: 1914ms (over 1s): SELECT host_id, customer_id, api_key, agent_version, last_report_at, desired_json, desired_generation, recovery_mode_until, created_at, updated_at, deliberate_off_at FROM hosts ORDER BY host_id
2026/11/01 16:16:25 [WARN] slow statement: 1685ms (over 1s): SELECT id, customer_id, path, requested_at, due_at, cancelled_at, cancelled_by, deleted_at, last_error FROM offsite_abandon_requests WHERE cancelled_at IS NULL AND deleted_at IS NULL AND due_at <= datetime('now')
2026/11/01 16:16:27 [WARN] slow statement: 1610ms (over 1s): SELECT id, host_id, layer, received_at, trigger, mode, outcome, healthy, release_id, report_json FROM os_reports WHERE host_id = ? AND layer = ? ORDER BY id DESC LIMIT 1
2026/11/01 16:16:28 [WARN] slow statement: 1180ms (over 1s): SELECT id, host_id, layer, received_at, trigger, mode, outcome, healthy, release_id, report_json FROM os_reports WHERE host_id = ? AND layer = ? ORDER BY id DESC LIMIT 1
2026/11/01 16:16:33 [WARN] slow statement: 22029ms (over 1s): SELECT hr.host_id, hr.customer_id, hr.report_json FROM host_reports hr JOIN (SELECT host_id, MAX(id) AS mx FROM host_reports GROUP BY host_id) latest ON hr.id = latest.mx
2026/11/01 16:16:42 [WARN] slow statement: 13636ms (over 1s): SELECT id, host_id, layer, received_at, trigger, mode, outcome, healthy, release_id, report_json FROM os_reports WHERE host_id = ? AND layer = ? AND received_at >= ? ORDER BY id
2026/11/01 16:16:53 [WARN] slow statement: 10984ms (over 1s): SELECT id, host_id, layer, received_at, trigger, mode, outcome, healthy, release_id, report_json FROM os_reports WHERE host_id = ? AND layer = ? AND received_at >= ? ORDER BY id
2026/11/01 16:17:03 [WARN] slow statement: 9059ms (over 1s): SELECT id, host_id, layer, received_at, trigger, mode, outcome, healthy, release_id, report_json FROM os_reports WHERE host_id = ? AND layer = ? ORDER BY id DESC LIMIT ?
2026/11/01 16:17:59 [WARN] slow statement: 26606ms (over 1s): SELECT received_at, report_json FROM host_reports WHERE customer_id = ? AND received_at >= ? ORDER BY received_at DESC
2026/11/01 16:18:18 [WARN] slow statement: 18204ms (over 1s): SELECT received_at, report_json FROM host_reports WHERE customer_id = ? AND received_at >= ? ORDER BY received_at DESC
2026/11/01 16:18:32 [WARN] slow statement: 13023ms (over 1s): SELECT received_at, report_json FROM host_reports WHERE customer_id = ? AND received_at >= ? ORDER BY received_at DESC
2026/11/01 16:30:24 [WARN] slow statement: 1028ms (over 1s): SELECT id, report_json FROM reports WHERE customer_id = ? ORDER BY id DESC LIMIT 1
2026/11/01 20:01:36 [WARN] slow statement: 96729ms (over 1s): VACUUM INTO ?
2026/11/01 23:20:24 [WARN] slow statement: 1212ms (over 1s): SELECT id, report_json FROM reports WHERE customer_id = ? ORDER BY id DESC LIMIT 1
2026/11/02 02:01:37 [WARN] slow statement: 4062ms (over 1s): SELECT received_at, report_json FROM host_reports WHERE customer_id = ? AND received_at >= ? ORDER BY received_at DESC
2026/11/02 02:01:39 [WARN] slow statement: 1067ms (over 1s): SELECT received_at, report_json FROM host_reports WHERE customer_id = ? AND received_at >= ? ORDER BY received_at DESC
2026/11/02 02:01:43 [WARN] slow statement: 3316ms (over 1s): SELECT received_at, report_json FROM host_reports WHERE customer_id = ? AND received_at >= ? ORDER BY received_at DESC
2026/11/02 02:02:03 [WARN] slow statement: 123110ms (over 1s): VACUUM INTO ?
2026/11/02 02:38:37 [WARN] slow statement: 1015ms (over 1s): SELECT received_at, report_json FROM reports WHERE customer_id = ? ORDER BY id DESC LIMIT 1
2026/11/02 04:30:06 [WARN] slow statement: 4381ms (over 1s): DELETE FROM app_log_issues WHERE last_seen < ?
2026/11/02 07:10:04 [WARN] slow statement: 2110ms (over 1s): SELECT report_json FROM reports WHERE customer_id = ? AND received_at > ? ORDER BY id LIMIT 5000
2026/11/02 07:10:06 [WARN] slow statement: 1078ms (over 1s): SELECT report_json FROM reports WHERE customer_id = ? AND received_at > ? ORDER BY id LIMIT 5000
2026/11/02 07:25:24 [WARN] slow statement: 1103ms (over 1s): SELECT id, report_json FROM reports WHERE customer_id = ? ORDER BY id DESC LIMIT 1
2026/11/02 08:01:35 [WARN] slow statement: 1975ms (over 1s): SELECT received_at, report_json FROM host_reports WHERE customer_id = ? AND received_at >= ? ORDER BY received_at DESC
2026/11/02 08:01:37 [WARN] slow statement: 1110ms (over 1s): SELECT received_at, report_json FROM host_reports WHERE customer_id = ? AND received_at >= ? ORDER BY received_at DESC
2026/11/02 08:01:51 [WARN] slow statement: 111549ms (over 1s): VACUUM INTO ?
2026/11/02 14:01:34 [WARN] slow statement: 1562ms (over 1s): SELECT received_at, report_json FROM host_reports WHERE customer_id = ? AND received_at >= ? ORDER BY received_at DESC
2026/11/02 14:01:50 [WARN] slow statement: 110377ms (over 1s): VACUUM INTO ?
2026/11/02 20:01:50 [WARN] slow statement: 110209ms (over 1s): VACUUM INTO ?
