explain.depesz.com

PostgreSQL's explain analyze made readable

Result: m3cX

Settings
# exclusive inclusive rows x rows loops node
1. 0.107 5,833.406 ↓ 2.1 19 1

HashAggregate (cost=45,283.12..45,283.21 rows=9 width=21) (actual time=5,833.401..5,833.406 rows=19 loops=1)

  • Group Key: soitem.sales_order_id_
2. 16.830 5,833.299 ↓ 5.2 47 1

Nested Loop (cost=19.50..45,283.10 rows=9 width=21) (actual time=804.490..5,833.299 rows=47 loops=1)

3. 11.766 992.889 ↓ 1.0 9,458 1

Nested Loop (cost=18.94..25,250.72 rows=9,360 width=58) (actual time=113.348..992.889 rows=9,458 loops=1)

4. 207.548 207.548 ↓ 148.1 2,813 1

Index Scan using order_info_idx02 on order_info orderinfo (cost=0.56..7,106.46 rows=19 width=37) (actual time=10.612..207.548 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. 81.577 773.575 ↑ 164.3 3 2,813

Bitmap Heap Scan on sales_order_item soitem (cost=18.38..950.03 rows=493 width=58) (actual time=0.272..0.275 rows=3 loops=2,813)

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

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

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

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

  • Index Cond: ((order_item_id_ = (soitem.order_item_id_)::text) AND (order_item_progress_type_id_ = 'C041ALLOCATEDQTY'::text))
  • Heap Fetches: 47
Planning time : 0.774 ms
Execution time : 5,833.484 ms