explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4Jnf

Settings
# exclusive inclusive rows x rows loops node
1. 15.639 20.601 ↓ 1.0 5,549 1

Bitmap Heap Scan on delivery_pack (cost=159.39..23,038.33 rows=5,545 width=8) (actual time=5.904..20.601 rows=5,549 loops=1)

  • Recheck Cond: (((pri_box_machine = '127470'::numeric) AND ((status)::text = ANY ('{InTransit,CustomerDelivering}'::text[])) AND (carrier_id IS NULL)) OR (sender_box_machine = '60950'::numeric))
  • Filter: ((carrier_id IS NULL) AND (((pri_box_machine = '127470'::numeric) AND ((status)::text = 'InTransit'::text)) OR ((sender_box_machine = '60950'::numeric) AND ((status)::text = 'Delivered'::text))))
  • Rows Removed by Filter: 314
  • Heap Blocks: exact=5,749
2. 0.002 4.962 ↓ 0.0 0 1

BitmapOr (cost=159.39..159.39 rows=5,817 width=0) (actual time=4.962..4.962 rows=0 loops=1)

3. 3.357 3.357 ↓ 0.0 0 1

Bitmap Index Scan on idx_incoming_parcel (cost=0.00..20.76 rows=45 width=0) (actual time=3.357..3.357 rows=0 loops=1)

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

  • Index Cond: (sender_box_machine = '60950'::numeric)
Planning time : 0.773 ms
Execution time : 20.875 ms