explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IXFu

Settings
# exclusive inclusive rows x rows loops node
1. 271.246 8,127.113 ↑ 1.7 401,052 1

Hash Join (cost=1,823.42..584,488.97 rows=666,670 width=4) (actual time=59.802..8,127.113 rows=401,052 loops=1)

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

Seq Scan on units_new u (cost=0.00..573,483.93 rows=670,647 width=4) (actual time=0.017..7,796.126 rows=401,052 loops=1)

  • Filter: (status = 'new'::text)
  • Rows Removed by Filter: 767187
3. 30.184 59.741 ↓ 11.2 78,567 1

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

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

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