explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pbMp

Settings
# exclusive inclusive rows x rows loops node
1. 22.057 24.292 ↑ 3.5 5,549 1

Bitmap Heap Scan on delivery_pack (cost=571.36..78,897.84 rows=19,451 width=8) (actual time=3.631..24.292 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.000 2.235 ↓ 0.0 0 1

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

3. 0.366 0.366 ↑ 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.365..0.366 rows=1,954 loops=1)

  • Index Cond: (pri_box_machine = '127470'::numeric)
4. 1.870 1.870 ↓ 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.869..1.870 rows=6,619 loops=1)

  • Index Cond: (sender_box_machine = '60950'::numeric)
Planning time : 0.658 ms
Execution time : 24.652 ms