About Bitmap Heap Scan on Postgresql query plan

Today I was looking for the culprit of the performance issue that was affecting a Django Admin page that wasn’t loading. I know from experience that most of the time this is a problem of unoptimized queries, and the best weapon I know to have a look into those in a Django app is to use the Django Debug Toolbar.

Continue reading →