Improving PostgreSQL queries

Michiel Hendriks on April 30, 2019

A while ago I commented that my big win was improving a query which took over an hour to execute to just 30 seconds. In fact, for the client this q... [Read Full]
markdown guide
 

Great article, thanks!
I want to share my experience too, hope it can be useful for somebody.
I'd like to add one more tool for query improvement - Query Profiler in dbForge Studio for PostgreSQL. This visual analyzer helps me a lot and is easy to use.

 
 

This is super! Fantastic advice; I had no idea about all the flexibility you can get out of indexes.

 
 
code of conduct - report abuse