Indexes in PostgresSQL - Part 1 Indexes in PotstgresSQL - Part 2 Queries in PostgreSQL: 1. Query Execution Stages Queries in PostgreSQL: 2. Statistics : Postgres Professional Queries in PostgreSQL: 3. Sequential scan : Postgres Professional Queries in PostgresSQL: 4. Index Scan : Postgres Professional Queries in PostgresSQL: 5: Nested-loop join Queries in PostgreSQL: 6. Hash join Queries in PostgreSQL: 7. Merge join