The slowest requests on our API were the ones that found nothing

On 9 September 2026, asking our API for the most recent port event of a vessel took 28 ms if the vessel had one and 2.0 to 2.5 s if it had none. Asking for the ETA of a vessel whose IMO we could not map to an MMSI took 12 s on a quiet database and 30 s or more on a busy one, until the statement timeout ended it. Over one night, requests that ended...