![How to reason about Indexing your Postgres database - Webinar Cover Image](/static/85a67d71a8c82ffe2198953499def3ee/42e2a/how-to-reason-about-indexing-your-postgres-database.png)
Webinar: How To Reason About Indexing Your Postgres Database
See how Postgres chooses which index to use, and learn a methodology for analyzing queries & optimizing indexes.
Lukas Fittl
Founder & CEO, pganalyze
Founder & CEO, pganalyze
Learn about
- How Postgres chooses which index to use
- Background about indexing
- How Index Scans are made
- The cost model and how the planner uses it
- Index cardinality and selectivity
- Nested Loops and how they affect index usage
- What is a “good enough” index?
- A structured approach for finding the right indexes
- Break queries into scans
- Turn scans into potential index parameters
- Estimate the index write overhead and index size
- Analyze impact across multiple queries
- Thinking of indexing as a set covering problem
- Choose the best indexes to cover queries
- A look behind the scenes: The pganalyze Indexing Engine
Watch the Webinar Recording
Hundreds Of Companies Monitor Their Production PostgreSQL Databases With pganalyze
![Atlassian](/static/e2f030cddae3e00fc03bf3741b0de8cd/c2dfb/atlassian.png)
![DoorDash](/static/8e5c810a239a71c0c7c50dac21a8fff6/865c7/doordash.png)
![Moody's](/static/88824cdf6cf338e2528a766568f5aa60/fa0cd/moodys.png)
![fuboTv](/static/b4f541a54e2a187f4998da33e565b128/6245d/fubotv.png)
![SeniorLink](/static/37b9ca7eb397a1b1e90fa572cc5a118d/87a86/seniorlink.png)
![Salsify](/static/f26b06c796059745dd6a754a7402d318/3113b/salsify.png)
![CounterPath](/static/b0e2168929c9424b79774cd10d82d2be/95457/counterpath.png)
![Ipsy](/static/f83dc5ca2d428921e410a1ef66258cb3/42891/ipsy_white.png)