explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8RNb

Settings
# exclusive inclusive rows x rows loops node
1. 20.846 22.658 ↑ 3.5 5,549 1

Bitmap Heap Scan on delivery_pack (cost=571.36..78,897.84 rows=19,451 width=4,440) (actual time=3.007..22.658 rows=5,549 loops=1)

  • Recheck Cond: ((pri_box_machine = '127470'::numeric) OR (sender_box_machine = '60950'::numeric))
  • Filter: ((carrier_id IS NULL) AND ((status)::text = 'Delivered'::text))
  • Rows Removed by Filter: 1,972
  • Heap Blocks: exact=7,132
2. 0.001 1.812 ↓ 0.0 0 1

BitmapOr (cost=571.36..571.36 rows=20,332 width=0) (actual time=1.812..1.812 rows=0 loops=1)

3. 0.436 0.436 ↑ 7.5 1,954 1

Bitmap Index Scan on dp_idx_pri_box_machine (cost=0.00..425.77 rows=14,560 width=0) (actual time=0.436..0.436 rows=1,954 loops=1)

  • Index Cond: (pri_box_machine = '127470'::numeric)
4. 1.375 1.375 ↓ 1.1 6,619 1

Bitmap Index Scan on idx_dp_sender_box_machine (cost=0.00..135.86 rows=5,772 width=0) (actual time=1.375..1.375 rows=6,619 loops=1)

  • Index Cond: (sender_box_machine = '60950'::numeric)
Planning time : 0.834 ms
Execution time : 23.000 ms