explain.depesz.com

PostgreSQL's explain analyze made readable

Result: byIo

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

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

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

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

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

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

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