When a database query is unexpectedly slow

In this micro post, I would like to share my experience in improving database query time. I have recently encountered an issue that my PostgreSQL database query was surprisingly slow. I have an Offer table that has a foreign key to the Customer table...