explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xIyQ

Settings
# exclusive inclusive rows x rows loops node
1. 79.877 1,153.078 ↑ 1.0 75 1

Limit (cost=4,398,737.29..4,398,737.85 rows=75 width=49) (actual time=1,073.183..1,153.078 rows=75 loops=1)

  • Buffers: shared hit=502255, temp read=3565 written=3565
2. 0.016 1,073.201 ↑ 16.7 75 1

Unique (cost=4,398,737.29..4,398,746.69 rows=1,253 width=49) (actual time=1,073.181..1,073.201 rows=75 loops=1)

  • Buffers: shared hit=502255, temp read=3565 written=3565
3. 0.000 1,073.185 ↑ 15.3 82 1

Sort (cost=4,398,737.29..4,398,740.42 rows=1,253 width=49) (actual time=1,073.180..1,073.185 rows=82 loops=1)

  • Sort Key: businesspa3_.name, businesspa3_.c_bpartner_id
  • Sort Method: quicksort Memory: 48kB
  • Buffers: shared hit=502255, temp read=3565 written=3565
4. 86.618 1,152.814 ↑ 5.7 221 1

Gather (cost=68,453.81..4,398,672.82 rows=1,253 width=49) (actual time=320.125..1,152.814 rows=221 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=502255, temp read=3565 written=3565
5. 0.621 1,066.196 ↑ 7.1 74 3

Nested Loop Anti Join (cost=67,453.81..4,397,547.52 rows=522 width=49) (actual time=305.573..1,066.196 rows=74 loops=3)

  • Buffers: shared hit=502255, temp read=3565 written=3565
6. 1.177 1,065.568 ↑ 6.4 81 3

Nested Loop (cost=67,453.39..4,394,011.09 rows=522 width=82) (actual time=305.549..1,065.568 rows=81 loops=3)

  • Buffers: shared hit=501505, temp read=3565 written=3565
7. 4.309 1,064.378 ↑ 6.4 81 3

Nested Loop (cost=67,452.83..4,390,319.71 rows=522 width=66) (actual time=305.516..1,064.378 rows=81 loops=3)

  • Buffers: shared hit=500292, temp read=3565 written=3565
8. 27.470 1,060.056 ↑ 121.3 316 3

Hash Join (cost=67,452.27..4,105,707.42 rows=38,335 width=66) (actual time=295.594..1,060.056 rows=316 loops=3)

  • Hash Cond: ((orderline0_.m_product_id)::text = (product2_.m_product_id)::text)
  • Buffers: shared hit=495546, temp read=3565 written=3565
9. 739.215 859.088 ↑ 19.6 27,314 3

Parallel Bitmap Heap Scan on c_orderline orderline0_ (cost=47,258.61..4,064,955.82 rows=535,356 width=99) (actual time=92.834..859.088 rows=27,314 loops=3)

  • Recheck Cond: ((ad_org_id)::text = '392FC5F103F442A597F2F4C07698A9A9'::text)
  • Rows Removed by Index Recheck: 1159457
  • Filter: (qtydelivered <> qtyordered)
  • Rows Removed by Filter: 438492
  • Heap Blocks: exact=19328 lossy=135851
  • Buffers: shared hit=414253
10. 119.873 119.873 ↓ 1.1 1,397,419 1

Bitmap Index Scan on em_oborpre_ordline_org (cost=0.00..46,937.39 rows=1,291,310 width=0) (actual time=119.873..119.873 rows=1,397,419 loops=1)

  • Index Cond: ((ad_org_id)::text = '392FC5F103F442A597F2F4C07698A9A9'::text)
  • Buffers: shared hit=9985
11. 46.424 173.498 ↓ 1.0 188,948 3

Hash (cost=16,458.06..16,458.06 rows=183,888 width=33) (actual time=173.497..173.498 rows=188,948 loops=3)

  • Buckets: 131072 Batches: 4 Memory Usage: 4034kB
  • Buffers: shared hit=81161, temp written=2745
12. 74.518 127.074 ↓ 1.0 188,948 3

Nested Loop (cost=110.09..16,458.06 rows=183,888 width=33) (actual time=17.542..127.074 rows=188,948 loops=3)

  • Buffers: shared hit=81161
13. 0.074 0.242 ↑ 1.0 2 3

HashAggregate (cost=24.29..24.31 rows=2 width=33) (actual time=0.239..0.242 rows=2 loops=3)

  • Group Key: (obre_resou4_.m_product_category_id)::text
  • Buffers: shared hit=60
14. 0.168 0.168 ↑ 1.0 343 3

Seq Scan on obre_resource obre_resou4_ (cost=0.00..23.43 rows=343 width=33) (actual time=0.016..0.168 rows=343 loops=3)

  • Buffers: shared hit=60
15. 45.389 52.314 ↓ 42.5 94,474 6

Bitmap Heap Scan on m_product product2_ (cost=85.80..8,194.63 rows=2,225 width=66) (actual time=8.740..52.314 rows=94,474 loops=6)

  • Recheck Cond: ((m_product_category_id)::text = (obre_resou4_.m_product_category_id)::text)
  • Heap Blocks: exact=25675
  • Buffers: shared hit=81101
16. 6.925 6.925 ↓ 42.5 94,474 6

Bitmap Index Scan on m_product_productcategory (cost=0.00..85.24 rows=2,225 width=0) (actual time=6.925..6.925 rows=94,474 loops=6)

  • Index Cond: ((m_product_category_id)::text = (obre_resou4_.m_product_category_id)::text)
  • Buffers: shared hit=4076
17. 0.013 0.013 ↓ 0.0 0 947

Index Scan using c_order_key on c_order order1_ (cost=0.56..7.42 rows=1 width=66) (actual time=0.013..0.013 rows=0 loops=947)

  • Index Cond: ((c_order_id)::text = (orderline0_.c_order_id)::text)
  • Filter: (((docstatus)::text = 'CO'::text) AND ((c_doctype_id)::text = ANY ('{4F94921D217F48A993FE766B8334B936,7CE7854395964A60A29EB3C5B7D46B40,116D158017A74901960473E3231FF91F,D457B6F9629240058922D59065FCC63A,D14BC7AD73FB4DD0B815E52DE3B31DFE,7C03FC3EE0FF40EEB1C07283E60E57F8,6BC35B437FF546299164FEEE30B3E950,B475D71C30534BF2912C039F1770785E}'::text[])))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=4746
18. 0.013 0.013 ↑ 1.0 1 242

Index Scan using c_bpartner_key on c_bpartner businesspa3_ (cost=0.56..7.07 rows=1 width=49) (actual time=0.013..0.013 rows=1 loops=242)

  • Index Cond: ((c_bpartner_id)::text = (order1_.c_bpartner_id)::text)
  • Buffers: shared hit=1213
19. 0.007 0.007 ↓ 0.0 0 242

Index Only Scan using obre_reservation_cordline_idx on obre_reservation obre_reser5_ (cost=0.42..6.76 rows=1 width=33) (actual time=0.007..0.007 rows=0 loops=242)

  • Index Cond: (c_orderline_id = (orderline0_.c_orderline_id)::text)
  • Heap Fetches: 21
  • Buffers: shared hit=750
Planning time : 2.178 ms
Execution time : 1,153.216 ms