explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PbjU

Settings
# exclusive inclusive rows x rows loops node
1. 60.923 1,472.880 ↑ 1.3 66,938 1

HashAggregate (cost=140,811.31..141,676.85 rows=86,554 width=8) (actual time=1,455.923..1,472.880 rows=66,938 loops=1)

2. 870.916 1,411.957 ↓ 1.1 92,048 1

Hash Join (cost=49,602.35..140,378.54 rows=86,554 width=8) (actual time=61.791..1,411.957 rows=92,048 loops=1)

  • Hash Cond: (one_off_pick_picks.one_off_pick_lines_id = one_off_pick_lines.id)
3. 479.353 479.353 ↑ 1.0 2,681,915 1

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

  • Filter: active
  • Rows Removed by Filter: 2,164
4. 12.824 61.688 ↑ 1.0 70,243 1

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

  • Buckets: 8,192 Batches: 1 Memory Usage: 2,470kB
5. 40.487 48.864 ↑ 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=12.834..48.864 rows=70,243 loops=1)

  • Recheck Cond: (one_off_pick_id = 13,406)
6. 8.377 8.377 ↑ 1.0 70,272 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=8.377..8.377 rows=70,272 loops=1)

  • Index Cond: (one_off_pick_id = 13,406)