Egress problems and where to find them
May 14, 2026Simeon Griggs

Summary
This post details strategies to minimize data transfer out of the database by optimizing query responses (fetching specific columns, using JSON filtering, pagination) and reducing request frequency (caching, CDNs). It also highlights the benefits of private connections (AWS PrivateLink, GCP Private Service Connect) for reducing egress costs and improving security. The post explains how to identify egress usage using `EXPLAIN` and PlanetScale Insights, and emphasizes the trade-offs between CPU overhead and reduced egress.