explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4oeb

Settings
# exclusive inclusive rows x rows loops node
1. 1.236 472.208 ↓ 1.1 33 1

Bitmap Heap Scan on delivery_pack (cost=5,903.53..6,116.16 rows=31 width=8) (actual time=471.112..472.208 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.074 470.972 ↓ 0.0 0 1

BitmapOr (cost=5,903.53..5,903.53 rows=53 width=0) (actual time=470.972..470.972 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.421 470.879 ↓ 0.0 0 1

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

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

  • Index Cond: (sender_box_machine = '60950'::numeric)
6. 467.295 467.295 ↓ 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=467.295..467.295 rows=1,215,738 loops=1)

  • Index Cond: ((status)::text = 'CustomerDelivering'::text)
Planning time : 0.625 ms
Execution time : 472.273 ms