explain.depesz.com

PostgreSQL's explain analyze made readable

Result: knoF

Settings
# exclusive inclusive rows x rows loops node
1. 0.125 4.914 ↓ 0.0 0 1

Bitmap Heap Scan on delivery_pack (cost=5,887.42..6,011.84 rows=31 width=8) (actual time=4.914..4.914 rows=0 loops=1)

  • Recheck Cond: ((((status)::text = 'Stored'::text) AND (pri_box_machine = '127470'::numeric)) OR ((sender_box_machine = '60950'::numeric) AND ((status)::text = 'Dupa'::text)))
  • Filter: (carrier_id IS NULL)
  • Rows Removed by Filter: 10
  • Heap Blocks: exact=67
2. 0.002 4.789 ↓ 0.0 0 1

BitmapOr (cost=5,887.42..5,887.42 rows=31 width=0) (actual time=4.789..4.789 rows=0 loops=1)

3. 3.353 3.353 ↓ 4.4 97 1

Bitmap Index Scan on idx_delivery_pack_status_pri_box_machine (cost=0.00..4.64 rows=22 width=0) (actual time=3.353..3.353 rows=97 loops=1)

  • Index Cond: (((status)::text = 'Stored'::text) AND (pri_box_machine = '127470'::numeric))
4. 0.278 1.434 ↓ 0.0 0 1

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

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

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

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

  • Index Cond: ((status)::text = 'Dupa'::text)
Planning time : 0.653 ms
Execution time : 4.950 ms