explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fTLb

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 961.383 ↑ 1.9 39 1

Limit (cost=1,660,885.56..1,660,886.12 rows=75 width=49) (actual time=961.360..961.383 rows=39 loops=1)

  • Buffers: shared hit=404754
2. 0.017 961.377 ↑ 2.9 39 1

Unique (cost=1,660,885.56..1,660,886.40 rows=112 width=49) (actual time=961.357..961.377 rows=39 loops=1)

  • Buffers: shared hit=404754
3. 0.000 961.360 ↑ 2.6 43 1

Sort (cost=1,660,885.56..1,660,885.84 rows=112 width=49) (actual time=961.356..961.360 rows=43 loops=1)

  • Sort Key: businesspa3_.name, businesspa3_.c_bpartner_id
  • Sort Method: quicksort Memory: 29kB
  • Buffers: shared hit=404754
4. 69.678 1,013.548 ↑ 2.6 43 1

Gather (cost=49,431.21..1,660,881.74 rows=112 width=49) (actual time=528.752..1,013.548 rows=43 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=404754
5. 0.287 943.870 ↑ 3.4 14 3

Nested Loop Anti Join (cost=48,431.21..1,659,870.54 rows=47 width=49) (actual time=657.048..943.870 rows=14 loops=3)

  • Buffers: shared hit=404754
6. 0.694 943.569 ↑ 2.4 20 3

Nested Loop (cost=48,430.79..1,659,847.47 rows=47 width=82) (actual time=657.019..943.569 rows=20 loops=3)

  • Buffers: shared hit=404555
7. 2.636 942.840 ↑ 2.4 20 3

Nested Loop (cost=48,430.23..1,659,511.96 rows=47 width=66) (actual time=656.956..942.840 rows=20 loops=3)

  • Buffers: shared hit=404253
8. 4.212 940.178 ↑ 141.6 99 3

Hash Join (cost=48,429.67..1,557,621.23 rows=14,021 width=66) (actual time=615.093..940.178 rows=99 loops=3)

  • Hash Cond: ((orderline0_.m_product_id)::text = (product2_.m_product_id)::text)
  • Buffers: shared hit=402759
9. 298.994 376.720 ↑ 22.3 8,770 3

Parallel Bitmap Heap Scan on c_orderline orderline0_ (cost=29,323.31..1,537,641.41 rows=195,533 width=99) (actual time=43.186..376.720 rows=8,770 loops=3)

  • Recheck Cond: ((ad_org_id)::text = '9758FB33A4524765BA9F0C6C559A4A7D'::text)
  • Filter: (qtydelivered <> qtyordered)
  • Rows Removed by Filter: 121148
  • Heap Blocks: exact=92483
  • Buffers: shared hit=174751
10. 77.726 77.726 ↑ 1.2 392,690 1

Bitmap Index Scan on em_oborpre_ordline_org (cost=0.00..29,205.99 rows=471,639 width=0) (actual time=77.726..77.726 rows=392,690 loops=1)

  • Index Cond: ((ad_org_id)::text = '9758FB33A4524765BA9F0C6C559A4A7D'::text)
  • Buffers: shared hit=5286
11. 56.649 559.246 ↓ 1.0 193,115 3

Hash (cost=16,764.25..16,764.25 rows=187,369 width=33) (actual time=559.245..559.246 rows=193,115 loops=3)

  • Buckets: 262144 Batches: 1 Memory Usage: 14307kB
  • Buffers: shared hit=228008
12. 263.824 502.597 ↓ 1.0 193,115 3

Nested Loop (cost=198.70..16,764.25 rows=187,369 width=33) (actual time=72.769..502.597 rows=193,115 loops=3)

  • Buffers: shared hit=228008
13. 0.144 0.645 ↑ 1.0 2 3

HashAggregate (cost=25.30..25.32 rows=2 width=33) (actual time=0.641..0.645 rows=2 loops=3)

  • Group Key: (obre_resou4_.m_product_category_id)::text
  • Buffers: shared hit=63
14. 0.501 0.501 ↓ 1.0 350 3

Seq Scan on obre_resource obre_resou4_ (cost=0.00..24.44 rows=344 width=33) (actual time=0.045..0.501 rows=350 loops=3)

  • Buffers: shared hit=63
15. 211.451 238.128 ↓ 44.4 96,558 6

Bitmap Heap Scan on m_product product2_ (cost=173.40..8,347.73 rows=2,174 width=66) (actual time=36.222..238.128 rows=96,558 loops=6)

  • Recheck Cond: ((m_product_category_id)::text = (obre_resou4_.m_product_category_id)::text)
  • Heap Blocks: exact=73998
  • Buffers: shared hit=227945
16. 26.677 26.677 ↓ 44.4 96,558 6

Bitmap Index Scan on m_product_productcategory (cost=0.00..172.86 rows=2,174 width=0) (actual time=26.677..26.677 rows=96,558 loops=6)

  • Index Cond: ((m_product_category_id)::text = (obre_resou4_.m_product_category_id)::text)
  • Buffers: shared hit=5951
17. 0.026 0.026 ↓ 0.0 0 298

Index Scan using c_order_key on c_order order1_ (cost=0.56..7.27 rows=1 width=66) (actual time=0.026..0.026 rows=0 loops=298)

  • 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,5F3EA76D38834CD99E7DD5673CC06358}'::text[])))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=1494
18. 0.035 0.035 ↑ 1.0 1 60

Index Scan using c_bpartner_key on c_bpartner businesspa3_ (cost=0.56..7.14 rows=1 width=49) (actual time=0.035..0.035 rows=1 loops=60)

  • Index Cond: ((c_bpartner_id)::text = (order1_.c_bpartner_id)::text)
  • Buffers: shared hit=302
19. 0.014 0.014 ↓ 0.0 0 60

Index Scan using obre_reservation_cordline_idx on obre_reservation obre_reser5_ (cost=0.42..0.49 rows=1 width=33) (actual time=0.014..0.014 rows=0 loops=60)

  • Index Cond: ((c_orderline_id)::text = (orderline0_.c_orderline_id)::text)
  • Filter: ((obre_reservation_id)::text <> '3F5C299C34564BA6A2C2F780511A523C'::text)
  • Buffers: shared hit=199
Planning time : 6.424 ms
Execution time : 1,016.050 ms