explain.depesz.com

PostgreSQL's explain analyze made readable

Result: B74b

Settings
# exclusive inclusive rows x rows loops node
1. 492.882 1,269.212 ↓ 1.1 330,998 1

Hash Join (cost=85,253.10..124,577.37 rows=310,106 width=8) (actual time=575.494..1,269.212 rows=330,998 loops=1)

  • Hash Cond: (pp.user_id = u.id)
2. 202.556 202.556 ↑ 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.004..202.556 rows=974,345 loops=1)

3. 149.718 573.774 ↑ 1.0 421,615 1

Hash (cost=79,936.96..79,936.96 rows=425,291 width=4) (actual time=573.774..573.774 rows=421,615 loops=1)

  • Buckets: 524288 Batches: 1 Memory Usage: 18919kB
4. 424.056 424.056 ↑ 1.0 421,615 1

Seq Scan on sermo_users u (cost=0.00..79,936.96 rows=425,291 width=4) (actual time=0.011..424.056 rows=421,615 loops=1)

  • Filter: ((NOT sermo_employee) AND ((country_of_practice_code)::text = 'US'::text))
  • Rows Removed by Filter: 943262