PostgreSQL query plan explanation

PostgreSQL query plan explanation