explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UqDQ

Settings
# exclusive inclusive rows x rows loops node
1. 295.653 1,398.560 ↑ 1.3 330,998 1

Hash Join (cost=122,074.92..136,428.49 rows=425,291 width=8) (actual time=685.789..1,398.560 rows=330,998 loops=1)

  • Hash Cond: (u.id = pp.user_id)
2.          

CTE user_ids

3. 220.492 265.980 ↑ 1.0 421,615 1

Bitmap Heap Scan on sermo_users u_1 (cost=8,958.90..77,143.58 rows=425,291 width=4) (actual time=54.468..265.980 rows=421,615 loops=1)

  • Recheck Cond: ((country_of_practice_code)::text = 'US'::text)
  • Filter: (NOT sermo_employee)
  • Heap Blocks: exact=47208
4. 45.488 45.488 ↑ 1.0 421,615 1

Bitmap Index Scan on ix_sermo_users_country_code_us (cost=0.00..8,852.57 rows=424,695 width=0) (actual time=45.488..45.488 rows=421,615 loops=1)

  • Index Cond: (((country_of_practice_code)::text = 'US'::text) AND (sermo_employee = false))
5. 476.104 476.104 ↑ 1.0 421,615 1

CTE Scan on user_ids u (cost=0.00..8,505.82 rows=425,291 width=4) (actual time=54.472..476.104 rows=421,615 loops=1)

6. 316.190 626.803 ↑ 1.0 974,345 1

Hash (cost=32,491.15..32,491.15 rows=995,215 width=8) (actual time=626.803..626.803 rows=974,345 loops=1)

  • Buckets: 1048576 Batches: 1 Memory Usage: 46253kB
7. 310.613 310.613 ↑ 1.0 974,345 1

Seq Scan on sermo_physician_profiles pp (cost=0.00..32,491.15 rows=995,215 width=8) (actual time=0.005..310.613 rows=974,345 loops=1)