explain.depesz.com

PostgreSQL's explain analyze made readable

Result: E6LY

Settings
# exclusive inclusive rows x rows loops node
1. 835.583 1,382.035 ↓ 1.1 92,045 1

Hash Join (cost=49,602.35..140,378.54 rows=86,554 width=8) (actual time=68.212..1,382.035 rows=92,045 loops=1)

  • Hash Cond: (one_off_pick_picks.one_off_pick_lines_id = one_off_pick_lines.id)
2. 478.341 478.341 ↑ 1.0 2,681,911 1

Seq Scan on one_off_pick_picks (cost=0.00..53,026.75 rows=2,682,465 width=8) (actual time=0.008..478.341 rows=2,681,911 loops=1)

  • Filter: active
  • Rows Removed by Filter: 2,164
3. 16.161 68.111 ↑ 1.0 70,243 1

Hash (cost=48,698.21..48,698.21 rows=72,331 width=4) (actual time=68.111..68.111 rows=70,243 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 2,470kB
4. 42.735 51.950 ↑ 1.0 70,243 1

Bitmap Heap Scan on one_off_pick_lines (cost=1,357.06..48,698.21 rows=72,331 width=4) (actual time=13.751..51.950 rows=70,243 loops=1)

  • Recheck Cond: (one_off_pick_id = 13,406)
5. 9.215 9.215 ↑ 1.0 70,264 1

Bitmap Index Scan on one_off_pick_lines_one_off_pick_id_idx (cost=0.00..1,338.98 rows=72,331 width=0) (actual time=9.215..9.215 rows=70,264 loops=1)

  • Index Cond: (one_off_pick_id = 13,406)