Query Optimization for Mere Humans in PostgreSQL
PostgreSQL: Query Optimization for Mere Humans
Today, users have high expectations for the programs they use. Users expect programs to have amazing features, to be fast, and to consume a reasonable amount of resources.
As developers, we should thrive to give our users the best experience possible. It's pretty common that the Database becomes the bottleneck, and optimizing queries and eliminating the bottlenecks is not an easy task. Unfortunately, as programs become more and more complex, and as the data become bigger, it becomes harder to write flawless SQL queries.
Today, I am going to focus on a technique to find those bottlenecks, using the Explain clause. My goal today is to show you that finding and eliminating those bottlenecks is not rocket science. Everyone can find their bottlenecks without breaking a sweat.
The code for this article can be found on GitHub.
Note: All images, unless otherwise noted, are by the author.
