neon-postgres-egress-optimizer

Diagnoses and fixes Postgres query patterns that cause excessive data transfer from a database to an application. Works by analyzing pg_stat_statements output to find queries returning too many rows, too many columns, or running too frequently. Covers SELECT * abuse, missing pagination, JOIN duplication, and application-side aggregation. Running pg_stat_statements diagnostics manually and mapping high-row queries back to application code takes hours; this skill walks through the exact SQL, the interpretation, and the fix for each pattern in one pass.