explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DzMW

Settings
# exclusive inclusive rows x rows loops node
1. 38,205.587 65,587.081 ↓ 0.0 0 1

Hash Join (cost=33.56..950,706.17 rows=5,286,330 width=48) (actual time=65,587.081..65,587.081 rows=0 loops=1)

  • Hash Cond: (r.patient_id = p.id)
  • Join Filter: ((r.pulse > (SubPlan 1)) AND (r.presure > (SubPlan 2)))
  • Rows Removed by Join Filter: 47,576,965
2. 27,381.053 27,381.053 ↑ 1.0 47,576,966 1

Seq Scan on reading r (cost=0.00..825,600.68 rows=47,576,968 width=20) (actual time=3.929..27,381.053 rows=47,576,966 loops=1)

3. 0.227 0.441 ↓ 1.0 1,049 1

Hash (cost=20.47..20.47 rows=1,047 width=48) (actual time=0.441..0.441 rows=1,049 loops=1)

  • Buckets: 2,048 Batches: 1 Memory Usage: 98kB
4. 0.214 0.214 ↓ 1.0 1,049 1

Seq Scan on patient p (cost=0.00..20.47 rows=1,047 width=48) (actual time=0.014..0.214 rows=1,049 loops=1)

5.          

SubPlan (for Hash Join)

6. 0.000 0.000 ↑ 1.0 1 47,576,965

Result (cost=0.00..0.01 rows=1 width=4) (actual time=0.000..0.000 rows=1 loops=47,576,965)

7. 0.000 0.000 ↑ 1.0 1 7,136,545

Result (cost=0.00..0.01 rows=1 width=4) (actual time=0.000..0.000 rows=1 loops=7,136,545)

Planning time : 0.550 ms
Execution time : 65,587.120 ms