explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KcUg : Optimization for: plan #PXpZ

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.151 106.093 ↑ 1.0 1 1

Aggregate (cost=25,379.34..25,379.35 rows=1 width=21) (actual time=106.093..106.093 rows=1 loops=1)

2. 2.092 105.942 ↓ 135.0 135 1

Nested Loop (cost=19.51..25,379.34 rows=1 width=21) (actual time=18.658..105.942 rows=135 loops=1)

3. 3.267 47.102 ↓ 859.8 9,458 1

Nested Loop (cost=18.95..25,355.70 rows=11 width=58) (actual time=18.111..47.102 rows=9,458 loops=1)

4. 21.331 21.331 ↓ 148.1 2,813 1

Index Scan using order_info_idx02 on order_info orderinfo (cost=0.56..7,173.96 rows=19 width=37) (actual time=1.042..21.331 rows=2,813 loops=1)

  • Index Cond: (((site_id_)::text = 'JA0004'::text) AND ((non_serial_item_flag_)::text = '1'::text) AND ((order_date_)::text >= '20190601'::text) AND ((order_date_)::text <= '20190701'::text))
  • Filter: ((delivery_facility_)::text = 'af2ff7d0-ece9-463f-9c62-52fe4a627520'::text)
5. 5.626 22.504 ↑ 164.7 3 2,813

Bitmap Heap Scan on sales_order_item soitem (cost=18.39..951.99 rows=494 width=58) (actual time=0.008..0.008 rows=3 loops=2,813)

  • Recheck Cond: ((sales_order_id_)::text = (orderinfo.order_id_)::text)
  • Heap Blocks: exact=2713
6. 16.878 16.878 ↑ 164.7 3 2,813

Bitmap Index Scan on sales_order_item_idx02 (cost=0.00..18.26 rows=494 width=0) (actual time=0.006..0.006 rows=3 loops=2,813)

  • Index Cond: ((sales_order_id_)::text = (orderinfo.order_id_)::text)
7. 56.748 56.748 ↓ 0.0 0 9,458

Index Only Scan using order_item_progress_idx01 on order_item_progress itemprogress (cost=0.56..2.14 rows=1 width=37) (actual time=0.006..0.006 rows=0 loops=9,458)

  • Index Cond: ((order_item_id_ = (soitem.order_item_id_)::text) AND (order_item_progress_type_id_ = 'C041BACKORDERQTY'::text))
  • Heap Fetches: 135
Planning time : 0.692 ms
Execution time : 106.164 ms