I was just wondering if there was a postgresql specific version of https://use-the-index-luke.com i could send a coworker who seems oblivious to the perf penalties of missing indicies. Certainly a good start!
Very optimistic of you to assume that someone who doesn’t understand why DB indices in general are important would care enough to read a detailed explanation about them.
One hopes that "you cant ship any more features until your test suite stops failing due to timeouts" would motivate them.