explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1vW9

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 1.480 ↓ 0.0 0 1

Bitmap Heap Scan on delivery_pack (cost=5,903.53..6,116.16 rows=31 width=8) (actual time=1.480..1.480 rows=0 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 = 'Dupa'::text)))
  • 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 = 'Dupa'::text))))
2. 0.001 1.479 ↓ 0.0 0 1

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

3. 0.029 0.029 ↓ 0.0 0 1

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

  • Index Cond: (pri_box_machine = '127470'::numeric)
4. 0.287 1.449 ↓ 0.0 0 1

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

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

  • Index Cond: (sender_box_machine = '60950'::numeric)
6. 0.020 0.020 ↓ 0.0 0 1

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

  • Index Cond: ((status)::text = 'Dupa'::text)
Planning time : 0.643 ms
Execution time : 1.522 ms