explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aiqM

Settings
# exclusive inclusive rows x rows loops node
1. 19.255 20.809 ↑ 2.7 7,074 1

Bitmap Heap Scan on delivery_pack (cost=571.36..78,897.84 rows=19,451 width=4,440) (actual time=2.661..20.809 rows=7,074 loops=1)

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

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

3. 0.340 0.340 ↑ 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.339..0.340 rows=1,954 loops=1)

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

  • Index Cond: (sender_box_machine = '60950'::numeric)
Planning time : 0.669 ms
Execution time : 21.212 ms