Postgres has some pretty great tooling around understanding slow queries — you can just ask the database to tell you what’s taking it so long.| pgMustard
In this article we’ll recap what exactly the buffers numbers mean, and go through four ways they can be used to help you optimize queries.| pgMustard
If you work with Postgres, it’s likely that at some point you’re going to wonder why it is not using an index that you think it should be.| pgMustard