Using AppSignal to identify and fix slow Ecto queries in Phoenix applications. Covers how to navigate AppSignal's Performance section (Issue list, Actions, Slow queries) to detect bottlenecks, how to use the Timeline view and SQL EXPLAIN ANALYZE to diagnose root causes, and common fixes including adding missing indexes on foreign keys and sortable fields, constraining unbound queries with limit/offset, and identifying N+1 query patterns. Also shows how to verify fixes using deploy markers and production samples.
Table of contents
Finding the Slow Query in AppSignalUnderstanding Why It's SlowCommon Ecto FixesVerifying Our Changes WorkedWrap-UpSort: