How AI is applied across API Evangelist and APIs.io. Read my AI disclosure →
API Evangelist API Evangelist
Discovery
Learnings
Guidance
Toolbox
Alignment
API Evangelist LLC

Fix a top cause of slow queries in PostgreSQL (no slow query log needed)

calendar_today December 12, 2024 person Eric Fritz domain render

Learn how to diagnose and fix a top cause of slow queries in PostgreSQL. Walk through a concrete scenario that illustrates how sluggish database performance can be caused by missing foreign key indexes and cascading deletes. See a real simulation with query execution times, and use the provided code to run the simulation yourself.

open_in_new Read original post