explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DDBr : Optimization for: plan #yUoW

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 2,580,626.137 2,684,863.524 ↑ 71.2 90 1

Bitmap Heap Scan on orders (cost=199,746.92..6,470,898.19 rows=6,404 width=41) (actual time=142,971.265..2,684,863.524 rows=90 loops=1)

  • Recheck Cond: ((itop_id)::text = '021'::text)
  • Rows Removed by Index Recheck: 2,363,505
  • Filter: ((state <> 7) AND (external_order_id = ANY ('{7239,8338,8705,13138,16128,18027,19461,19557,26913,26918,30680,31690,33571,34746,37129,37786,40187,41282,42300,42324,50393,53733,54675,64913,86908,87168,87691,88119,99301,103608,107
  • Rows Removed by Filter: 8,254,533
  • Heap Blocks: exact=218,668 lossy=2,119,129
2. 104,237.387 104,237.387 ↓ 1.0 8,535,463 1

Bitmap Index Scan on eqnx_idx_11 (cost=0.00..199,745.32 rows=8,259,745 width=0) (actual time=104,237.387..104,237.387 rows=8,535,463 loops=1)

  • Index Cond: ((itop_id)::text = '021'::text)
Planning time : 1.518 ms
Execution time : 2,684,876.865 ms