explain.depesz.com

PostgreSQL's explain analyze made readable

Result: E1wc

Settings
# exclusive inclusive rows x rows loops node
1. 24.234 25.825 ↑ 3.5 5,549 1

Bitmap Heap Scan on delivery_pack (cost=571.36..78,897.84 rows=19,451 width=4,440) (actual time=2.957..25.825 rows=5,549 loops=1)

  • Recheck Cond: ((pri_box_machine = '127470'::numeric) OR (sender_box_machine = '60950'::numeric))
  • Filter: ((carrier_id IS NULL) AND ((status)::text = 'Delivered'::text))
  • Rows Removed by Filter: 1,972
  • Heap Blocks: exact=7,132
2. 0.002 1.591 ↓ 0.0 0 1

BitmapOr (cost=571.36..571.36 rows=20,332 width=0) (actual time=1.590..1.591 rows=0 loops=1)

3. 0.362 0.362 ↑ 7.5 1,954 1

Bitmap Index Scan on dp_idx_pri_box_machine (cost=0.00..425.77 rows=14,560 width=0) (actual time=0.362..0.362 rows=1,954 loops=1)

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

  • Index Cond: (sender_box_machine = '60950'::numeric)
Planning time : 0.747 ms
Execution time : 26.209 ms