explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 0aXL

Settings
# exclusive inclusive rows x rows loops node
1. 290.836 1,391.064 ↑ 1.3 330,998 1

Hash Join (cost=121,605.35..135,958.92 rows=425,291 width=8) (actual time=690.804..1,391.064 rows=330,998 loops=1)

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

CTE user_ids

3. 217.495 262.034 ↑ 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=53.303..262.034 rows=421,615 loops=1)

  • Recheck Cond: ((country_of_practice_code)::text = 'US'::text)
  • Filter: (NOT sermo_employee)
  • Heap Blocks: exact=47208
4. 44.539 44.539 ↑ 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=44.539..44.539 rows=421,615 loops=1)

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

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

6. 323.913 633.219 ↑ 1.0 974,345 1

Hash (cost=32,282.45..32,282.45 rows=974,345 width=8) (actual time=633.219..633.219 rows=974,345 loops=1)

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

Seq Scan on sermo_physician_profiles pp (cost=0.00..32,282.45 rows=974,345 width=8) (actual time=0.006..309.306 rows=974,345 loops=1)