Performance Tuning PostgreSQL

…understand the life cycle of a query. Here are the steps of a query:

1. Transmission of query string to database backend

2. Parsing of query string

3. Planning of query to optimize retrieval of data

4. Retrieval of data from hardware

5. Transmission of results to client