Ectoing around: Speeding up Queries with Ecto and Postgres - Filipe Fróes | ElixirConf EU 2024

✨This talk was recorded at ElixirConf EU in April 2024. If you're curious about our upcoming event, check elixirconf.eu ✨
A deep-dive into some of the Postgres internals and features focusing on speeding up queries. Using Ecto for practical examples and other visualizations, the aim is to provide a clear understanding of how to analyze, identify issues and finally optimize your queries. We'll also dabble into the details of how indexes lookups, lateral joins and other features of Postgres work to help fixate the knowledge.