explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SqV

Settings
# exclusive inclusive rows x rows loops node
1. 71.690 1,007.560 ↑ 1.0 75 1

Limit (cost=5,074,063.15..5,074,063.71 rows=75 width=49) (actual time=935.850..1,007.560 rows=75 loops=1)

  • Buffers: shared hit=433173 read=2, temp read=3511 written=3511
2. 0.017 935.870 ↑ 21.5 75 1

Unique (cost=5,074,063.15..5,074,075.26 rows=1,615 width=49) (actual time=935.849..935.870 rows=75 loops=1)

  • Buffers: shared hit=433173 read=2, temp read=3511 written=3511
3. 0.000 935.853 ↑ 18.8 86 1

Sort (cost=5,074,063.15..5,074,067.19 rows=1,615 width=49) (actual time=935.848..935.853 rows=86 loops=1)

  • Sort Key: businesspa3_.name, businesspa3_.c_bpartner_id
  • Sort Method: quicksort Memory: 38kB
  • Buffers: shared hit=433173 read=2, temp read=3511 written=3511
4. 77.773 1,007.371 ↑ 13.0 124 1

Gather (cost=80,399.14..5,073,977.09 rows=1,615 width=49) (actual time=277.219..1,007.371 rows=124 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=433173 read=2, temp read=3511 written=3511
5. 0.423 929.598 ↑ 16.4 41 3

Nested Loop Anti Join (cost=79,399.14..5,072,815.59 rows=673 width=49) (actual time=271.187..929.598 rows=41 loops=3)

  • Buffers: shared hit=433173 read=2, temp read=3511 written=3511
6. 0.757 929.168 ↑ 13.5 50 3

Nested Loop (cost=79,398.72..5,068,264.40 rows=673 width=82) (actual time=271.164..929.168 rows=50 loops=3)

  • Buffers: shared hit=432692 read=1, temp read=3511 written=3511
7. 5.199 928.397 ↑ 13.5 50 3

Nested Loop (cost=79,398.16..5,063,508.09 rows=673 width=66) (actual time=271.132..928.397 rows=50 loops=3)

  • Buffers: shared hit=431934, temp read=3511 written=3511
8. 25.521 923.187 ↑ 104.9 458 3

Hash Join (cost=79,397.59..4,711,234.02 rows=48,025 width=66) (actual time=271.093..923.187 rows=458 loops=3)

  • Hash Cond: ((orderline0_.m_product_id)::text = (product2_.m_product_id)::text)
  • Buffers: shared hit=425038, temp read=3511 written=3511
9. 602.590 723.658 ↑ 26.4 25,395 3

Parallel Bitmap Heap Scan on c_orderline orderline0_ (cost=59,203.91..4,665,648.03 rows=670,682 width=99) (actual time=95.944..723.658 rows=25,395 loops=3)

  • Recheck Cond: ((ad_org_id)::text = '82ADB3546EDC4EAA8AACF09A3B458702'::text)
  • Rows Removed by Index Recheck: 809045
  • Filter: (qtydelivered <> qtyordered)
  • Rows Removed by Filter: 468800
  • Heap Blocks: exact=28328 lossy=104803
  • Buffers: shared hit=343745
10. 121.068 121.068 ↑ 1.1 1,482,586 1

Bitmap Index Scan on em_oborpre_ordline_org (cost=0.00..58,801.50 rows=1,617,725 width=0) (actual time=121.068..121.068 rows=1,482,586 loops=1)

  • Index Cond: ((ad_org_id)::text = '82ADB3546EDC4EAA8AACF09A3B458702'::text)
  • Buffers: shared hit=10593
11. 46.533 174.008 ↓ 1.0 188,948 3

Hash (cost=16,458.07..16,458.07 rows=183,889 width=33) (actual time=174.008..174.008 rows=188,948 loops=3)

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

Nested Loop (cost=110.09..16,458.07 rows=183,889 width=33) (actual time=17.452..127.475 rows=188,948 loops=3)

  • Buffers: shared hit=81161
13. 0.065 0.231 ↑ 1.0 2 3

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

  • Group Key: (obre_resou4_.m_product_category_id)::text
  • Buffers: shared hit=60
14. 0.166 0.166 ↑ 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.166 rows=343 loops=3)

  • Buffers: shared hit=60
15. 45.800 52.682 ↓ 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.700..52.682 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.882 6.882 ↓ 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.882..6.882 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.011 0.011 ↓ 0.0 0 1,373

Index Scan using c_order_key on c_order order1_ (cost=0.56..7.34 rows=1 width=66) (actual time=0.011..0.011 rows=0 loops=1,373)

  • 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,48F585FE5BE04EAD8961DDD29A500F3D}'::text[])))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=6896
18. 0.014 0.014 ↑ 1.0 1 151

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

  • Index Cond: ((c_bpartner_id)::text = (order1_.c_bpartner_id)::text)
  • Buffers: shared hit=758 read=1
19. 0.007 0.007 ↓ 0.0 0 151

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=151)

  • Index Cond: (c_orderline_id = (orderline0_.c_orderline_id)::text)
  • Heap Fetches: 27
  • Buffers: shared hit=481 read=1
Planning time : 2.130 ms
Execution time : 1,007.927 ms