explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pOGE

Settings
# exclusive inclusive rows x rows loops node
1. 1.481 11,425.010 ↓ 1.1 33 1

Bitmap Heap Scan on delivery_pack (cost=5,903.53..6,116.16 rows=31 width=8) (actual time=11,423.670..11,425.010 rows=33 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) AND ((status)::text = 'CustomerDelivering'::text)))
  • Rows Removed by Index Recheck: 400
  • 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 = 'CustomerDelivering'::text))))
  • Heap Blocks: exact=508
2. 0.073 11,423.529 ↓ 0.0 0 1

BitmapOr (cost=5,903.53..5,903.53 rows=53 width=0) (actual time=11,423.529..11,423.529 rows=0 loops=1)

3. 0.019 0.019 ↓ 0.0 0 1

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

  • Index Cond: (pri_box_machine = '127470'::numeric)
4. 2.724 11,423.437 ↓ 0.0 0 1

BitmapAnd (cost=5,882.52..5,882.52 rows=9 width=0) (actual time=11,423.437..11,423.437 rows=0 loops=1)

5. 1.370 1.370 ↓ 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.369..1.370 rows=6,619 loops=1)

  • Index Cond: (sender_box_machine = '60950'::numeric)
6. 11,419.343 11,419.343 ↓ 5.9 1,215,738 1

Bitmap Index Scan on status_idx (cost=0.00..5,746.39 rows=205,576 width=0) (actual time=11,419.343..11,419.343 rows=1,215,738 loops=1)

  • Index Cond: ((status)::text = 'CustomerDelivering'::text)
Planning time : 0.865 ms
Execution time : 11,425.072 ms