explain.depesz.com

PostgreSQL's explain analyze made readable

Result: zMri

Settings
# exclusive inclusive rows x rows loops node
1. 371.106 11,754.473 ↑ 1.7 401,052 1

Hash Join (cost=1,823.42..589,325.65 rows=666,488 width=4) (actual time=37.278..11,754.473 rows=401,052 loops=1)

  • Hash Cond: (u.task_id = t.id)
2. 11,346.145 11,346.145 ↑ 1.7 401,052 1

Seq Scan on units_new u (cost=0.00..578,323.11 rows=670,464 width=4) (actual time=0.019..11,346.145 rows=401,052 loops=1)

  • Filter: (((pworker_id <> 270) OR (pworker_id IS NULL)) AND (status = 'new'::text))
  • Rows Removed by Filter: 767187
3. 18.488 37.222 ↓ 11.2 78,567 1

Hash (cost=1,735.41..1,735.41 rows=7,041 width=4) (actual time=37.222..37.222 rows=78,567 loops=1)

  • Buckets: 131072 (originally 8192) Batches: 1 (originally 1) Memory Usage: 3787kB
4. 18.734 18.734 ↓ 11.2 78,567 1

Seq Scan on tasks t (cost=0.00..1,735.41 rows=7,041 width=4) (actual time=0.042..18.734 rows=78,567 loops=1)