explain.depesz.com

PostgreSQL's explain analyze made readable

Result: eH2o : test

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Hash Join (cost=4,707.82..6,464.87 rows=60,043 width=21) (actual rows= loops=)

  • Hash Cond: (p.userid = u.id)
2. 0.000 0.000 ↓ 0.0

Seq Scan on patient p (cost=0.00..1,599.43 rows=60,043 width=12) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Hash (cost=3929.03..3929.03 rows=62303 width=21)" -> Seq Scan on "user" u (cost=0.00..3,929.03 rows=62,303 width=21) (actual rows= loops=)