explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Xcem

Settings
# exclusive inclusive rows x rows loops node
1. 302.970 9,006.457 ↑ 1.7 401,052 1

Hash Join (cost=1,823.42..584,488.97 rows=666,670 width=4) (actual time=64.768..9,006.457 rows=401,052 loops=1)

  • Hash Cond: (u.task_id = t.id)
2. 8,639.624 8,639.624 ↑ 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.797..8,639.624 rows=401,052 loops=1)

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

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

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

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