explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BDcA

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 4,689.801 ↓ 0.0 0 1

Limit (cost=147,451.11..147,451.11 rows=1 width=495) (actual time=4,689.801..4,689.801 rows=0 loops=1)

  • Buffers: shared hit=89723 read=1
2. 0.008 4,689.800 ↓ 0.0 0 1

Sort (cost=147,451.11..147,451.11 rows=1 width=495) (actual time=4,689.800..4,689.800 rows=0 loops=1)

  • Sort Key: order2_.documentno
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=89723 read=1
3. 0.000 4,689.792 ↓ 0.0 0 1

Nested Loop (cost=11,317.06..147,451.10 rows=1 width=495) (actual time=4,689.792..4,689.792 rows=0 loops=1)

  • Buffers: shared hit=89723 read=1
4. 0.001 4,689.792 ↓ 0.0 0 1

Nested Loop (cost=11,316.50..146,083.50 rows=1 width=505) (actual time=4,689.792..4,689.792 rows=0 loops=1)

  • Buffers: shared hit=89723 read=1
5. 0.000 4,689.791 ↓ 0.0 0 1

Nested Loop Left Join (cost=11,315.94..146,075.21 rows=1 width=515) (actual time=4,689.791..4,689.791 rows=0 loops=1)

  • Join Filter: ((location5_.c_country_id)::text = (country6_.c_country_id)::text)
  • Buffers: shared hit=89723 read=1
6. 0.000 4,689.791 ↓ 0.0 0 1

Nested Loop Left Join (cost=11,315.94..146,048.81 rows=1 width=508) (actual time=4,689.791..4,689.791 rows=0 loops=1)

  • Buffers: shared hit=89723 read=1
7. 0.000 4,689.791 ↓ 0.0 0 1

Nested Loop Left Join (cost=11,315.38..146,048.06 rows=1 width=455) (actual time=4,689.791..4,689.791 rows=0 loops=1)

  • Buffers: shared hit=89723 read=1
8. 0.002 4,689.791 ↓ 0.0 0 1

Nested Loop (cost=11,314.82..146,039.47 rows=1 width=455) (actual time=4,689.791..4,689.791 rows=0 loops=1)

  • Buffers: shared hit=89723 read=1
9. 0.000 4,689.789 ↓ 0.0 0 1

Nested Loop Left Join (cost=11,314.26..146,030.89 rows=1 width=427) (actual time=4,689.789..4,689.789 rows=0 loops=1)

  • Join Filter: ((product1_.m_brand_id)::text = (brand7_.m_brand_id)::text)
  • Buffers: shared hit=89723 read=1
10. 0.001 4,689.789 ↓ 0.0 0 1

Nested Loop (cost=11,314.26..145,989.32 rows=1 width=453) (actual time=4,689.789..4,689.789 rows=0 loops=1)

  • Buffers: shared hit=89723 read=1
11. 0.004 4,689.788 ↓ 0.0 0 1

Nested Loop (cost=11,313.70..145,981.85 rows=1 width=358) (actual time=4,689.788..4,689.788 rows=0 loops=1)

  • Buffers: shared hit=89723 read=1
12. 0.043 4,689.701 ↑ 83.0 1 1

Bitmap Heap Scan on c_order order2_ (cost=11,313.14..30,850.87 rows=83 width=146) (actual time=4,689.700..4,689.701 rows=1 loops=1)

  • Recheck Cond: (upper((documentno)::text) ~~ '%214.101/0020692%'::text)
  • Filter: ((em_obpos_applications_id IS NOT NULL) AND (em_obwpl_readypl <> 'Y'::bpchar) AND ((docstatus)::text = 'CO'::text) AND (em_obpos_isdeleted = 'N'::bpchar) AND (em_obpos_islayaway = 'N'::bpchar) AND ((c_doctypetarget_id)::text = ANY ('{4F94921D217F48A993FE766B8334B936,7CE7854395964A60A29EB3C5B7D46B40,116D158017A74901960473E3231FF91F,D457B6F9629240058922D59065FCC63A,D14BC7AD73FB4DD0B815E52DE3B31DFE,7C03FC3EE0FF40EEB1C07283E60E57F8,6BC35B437FF546299164FEEE30B3E950,2B0E8C61AD624AD291CE1D04384128DD}'::text[])))
  • Heap Blocks: exact=1
  • Buffers: shared hit=89719
13. 4,689.658 4,689.658 ↑ 4,949.0 1 1

Bitmap Index Scan on em_obpos_order_docno_trgm (cost=0.00..11,313.12 rows=4,949 width=0) (actual time=4,689.658..4,689.658 rows=1 loops=1)

  • Index Cond: (upper((documentno)::text) ~~ '%214.101/0020692%'::text)
  • Buffers: shared hit=89718
14. 0.083 0.083 ↓ 0.0 0 1

Index Scan using c_orderline_order on c_orderline orderline0_ (cost=0.57..1,387.11 rows=1 width=245) (actual time=0.083..0.083 rows=0 loops=1)

  • Index Cond: ((c_order_id)::text = (order2_.c_order_id)::text)
  • Filter: (((em_obwpl_readypl IS NULL) OR (em_obwpl_readypl = 'N'::bpchar)) AND ((em_obrdc_delivery_condition)::text <> ALL ('{PickAndCarry,BUTECOM_PFL}'::text[])) AND ((ad_org_id)::text = 'C459182BF30B46FEAF1C91DE123CDB99'::text) AND (em_obpos_canbedelivered = 'Y'::bpchar) AND (((qtyordered - qtydelivered) - em_obwpl_qtyinpicking) > '0'::numeric))
  • Rows Removed by Filter: 2
  • Buffers: shared hit=4 read=1
15. 0.000 0.000 ↓ 0.0 0

Index Scan using m_product_key on m_product product1_ (cost=0.56..7.46 rows=1 width=128) (never executed)

  • Index Cond: ((m_product_id)::text = (orderline0_.m_product_id)::text)
  • Filter: ((producttype)::text = 'I'::text)
16. 0.000 0.000 ↓ 0.0 0

Seq Scan on m_brand brand7_ (cost=0.00..29.03 rows=1,003 width=40) (never executed)

17. 0.000 0.000 ↓ 0.0 0

Index Scan using c_bpartner_key on c_bpartner businesspa3_ (cost=0.56..8.58 rows=1 width=61) (never executed)

  • Index Cond: ((c_bpartner_id)::text = (order2_.c_bpartner_id)::text)
18. 0.000 0.000 ↓ 0.0 0

Index Scan using c_bpartner_location_key on c_bpartner_location businesspa4_ (cost=0.56..8.58 rows=1 width=66) (never executed)

  • Index Cond: ((order2_.c_bpartner_location_id)::text = (c_bpartner_location_id)::text)
19. 0.000 0.000 ↓ 0.0 0

Index Scan using c_location_key on c_location location5_ (cost=0.56..0.74 rows=1 width=86) (never executed)

  • Index Cond: ((businesspa4_.c_location_id)::text = (c_location_id)::text)
20. 0.000 0.000 ↓ 0.0 0

Seq Scan on c_country country6_ (cost=0.00..23.40 rows=240 width=15) (never executed)

21. 0.000 0.000 ↓ 0.0 0

Index Scan using ad_user_key on ad_user aduser21_ (cost=0.56..8.28 rows=1 width=56) (never executed)

  • Index Cond: ((ad_user_id)::text = (orderline0_.createdby)::text)
22. 0.000 0.000 ↓ 0.0 0

Index Scan using ad_user_key on ad_user aduser22_ (cost=0.56..8.28 rows=1 width=56) (never executed)

  • Index Cond: ((ad_user_id)::text = (orderline0_.updatedby)::text)
23.          

SubPlan (forNested Loop)

24. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=2.11..119.15 rows=1 width=0) (never executed)

25. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.54..110.56 rows=1 width=33) (never executed)

26. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.98..106.08 rows=1 width=99) (never executed)

27. 0.000 0.000 ↓ 0.0 0

Index Scan using c_orderline_servrel_relord_idx on c_orderline_servicerelation orderlines10_ (cost=0.56..52.77 rows=12 width=66) (never executed)

  • Index Cond: ((c_orderline_related_id)::text = (orderline0_.c_orderline_id)::text)
28. 0.000 0.000 ↓ 0.0 0

Index Only Scan using obre_reservation_cordline_idx on obre_reservation obre_reser8_ (cost=0.41..4.43 rows=1 width=33) (never executed)

  • Index Cond: (c_orderline_id = (orderlines10_.c_orderline_id)::text)
  • Heap Fetches: 0
29. 0.000 0.000 ↓ 0.0 0

Index Only Scan using c_orderline_key on c_orderline orderline9_ (cost=0.57..4.47 rows=1 width=33) (never executed)

  • Index Cond: (c_orderline_id = (obre_reser8_.c_orderline_id)::text)
  • Heap Fetches: 0
30. 0.000 0.000 ↓ 0.0 0

Index Only Scan using c_orderline_key on c_orderline orderline11_ (cost=0.57..8.59 rows=1 width=33) (never executed)

  • Index Cond: (c_orderline_id = (orderline0_.c_orderline_id)::text)
  • Heap Fetches: 0
31. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=2.11..841,931.45 rows=590,264 width=33) (never executed)

32. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.54..339,864.31 rows=590,264 width=33) (never executed)

  • Join Filter: ((obre_reser8__1.c_orderline_id)::text = (orderlines10__1.c_orderline_id)::text)
33. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.98..285,663.03 rows=62,306 width=66) (never executed)

34. 0.000 0.000 ↓ 0.0 0

Index Only Scan using obre_reservation_cordline_idx on obre_reservation obre_reser8__1 (cost=0.41..3,924.55 rows=62,942 width=33) (never executed)

  • Heap Fetches: 0
35. 0.000 0.000 ↓ 0.0 0

Index Only Scan using c_orderline_key on c_orderline orderline9__1 (cost=0.57..4.47 rows=1 width=33) (never executed)

  • Index Cond: (c_orderline_id = (obre_reser8__1.c_orderline_id)::text)
  • Heap Fetches: 0
36. 0.000 0.000 ↓ 0.0 0

Index Only Scan using c_ordlinservrel_unique on c_orderline_servicerelation orderlines10__1 (cost=0.56..0.74 rows=10 width=66) (never executed)

  • Index Cond: (c_orderline_id = (orderline9__1.c_orderline_id)::text)
  • Heap Fetches: 0
37. 0.000 0.000 ↓ 0.0 0

Index Only Scan using c_orderline_key on c_orderline orderline11__1 (cost=0.57..0.84 rows=1 width=33) (never executed)

  • Index Cond: (c_orderline_id = (orderlines10__1.c_orderline_related_id)::text)
  • Heap Fetches: 0
38. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.26..25.26 rows=1 width=13) (never executed)

39. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.83..16.89 rows=1 width=33) (never executed)

40. 0.000 0.000 ↓ 0.0 0

Index Scan using em_butintp_ch_name_client on m_characteristic characteri14_ (cost=0.28..8.30 rows=1 width=33) (never executed)

  • Index Cond: ((name)::text = 'Produit.RefFournisseur'::text)
  • Filter: ((name)::text ~~ 'Produit.RefFournisseur'::text)
41. 0.000 0.000 ↓ 0.0 0

Index Scan using em_repdf_product_ch_rep on m_product_ch_value productcha12_ (cost=0.56..8.58 rows=1 width=66) (never executed)

  • Index Cond: (((m_product_id)::text = (product1_.m_product_id)::text) AND ((m_characteristic_id)::text = (characteri14_.m_characteristic_id)::text))
42. 0.000 0.000 ↓ 0.0 0

Index Scan using m_ch_value_key on m_ch_value characteri13_ (cost=0.42..8.37 rows=1 width=46) (never executed)

  • Index Cond: ((m_ch_value_id)::text = (productcha12_.m_ch_value_id)::text)
43. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.26..25.26 rows=1 width=13) (never executed)

44. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.83..16.89 rows=1 width=33) (never executed)

45. 0.000 0.000 ↓ 0.0 0

Index Scan using em_butintp_ch_name_client on m_characteristic characteri17_ (cost=0.28..8.30 rows=1 width=33) (never executed)

  • Index Cond: ((name)::text = 'Produit.Fournisseur'::text)
  • Filter: ((name)::text ~~ 'Produit.Fournisseur'::text)
46. 0.000 0.000 ↓ 0.0 0

Index Scan using em_repdf_product_ch_rep on m_product_ch_value productcha15_ (cost=0.56..8.58 rows=1 width=66) (never executed)

  • Index Cond: (((m_product_id)::text = (product1_.m_product_id)::text) AND ((m_characteristic_id)::text = (characteri17_.m_characteristic_id)::text))
47. 0.000 0.000 ↓ 0.0 0

Index Scan using m_ch_value_key on m_ch_value characteri16_ (cost=0.42..8.37 rows=1 width=46) (never executed)

  • Index Cond: ((m_ch_value_id)::text = (productcha15_.m_ch_value_id)::text)
48. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.26..25.26 rows=1 width=13) (never executed)

49. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.83..16.89 rows=1 width=33) (never executed)

50. 0.000 0.000 ↓ 0.0 0

Index Scan using em_butintp_ch_name_client on m_characteristic characteri20_ (cost=0.28..8.30 rows=1 width=33) (never executed)

  • Index Cond: ((name)::text = 'Colis.Nombre de colis'::text)
  • Filter: ((name)::text ~~ 'Colis.Nombre de colis'::text)
51. 0.000 0.000 ↓ 0.0 0

Index Scan using em_repdf_product_ch_rep on m_product_ch_value productcha18_ (cost=0.56..8.58 rows=1 width=66) (never executed)

  • Index Cond: (((m_product_id)::text = (product1_.m_product_id)::text) AND ((m_characteristic_id)::text = (characteri20_.m_characteristic_id)::text))
52. 0.000 0.000 ↓ 0.0 0

Index Scan using m_ch_value_key on m_ch_value characteri19_ (cost=0.42..8.37 rows=1 width=46) (never executed)

  • Index Cond: ((m_ch_value_id)::text = (productcha18_.m_ch_value_id)::text)
53. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=171.74..171.76 rows=1 width=20) (never executed)

54. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=2.25..171.71 rows=12 width=20) (never executed)

55. 0.000 0.000 ↓ 0.0 0

Index Only Scan using c_orderline_key on c_orderline orderline26_ (cost=0.57..8.59 rows=1 width=33) (never executed)

  • Index Cond: (c_orderline_id = (orderline0_.c_orderline_id)::text)
  • Heap Fetches: 0
56. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.68..163.01 rows=12 width=53) (never executed)

57. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.13..155.91 rows=12 width=66) (never executed)

58. 0.000 0.000 ↓ 0.0 0

Index Scan using c_orderline_servrel_relord_idx on c_orderline_servicerelation orderlines23_ (cost=0.56..52.77 rows=12 width=66) (never executed)

  • Index Cond: ((c_orderline_related_id)::text = (orderline0_.c_orderline_id)::text)
59. 0.000 0.000 ↓ 0.0 0

Index Scan using c_orderline_key on c_orderline orderline24_ (cost=0.57..8.59 rows=1 width=66) (never executed)

  • Index Cond: ((c_orderline_id)::text = (orderlines23_.c_orderline_id)::text)
60. 0.000 0.000 ↓ 0.0 0

Index Scan using m_product_key on m_product product25_ (cost=0.56..0.58 rows=1 width=53) (never executed)

  • Index Cond: ((m_product_id)::text = (orderline24_.m_product_id)::text)
61. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=8.58..8.59 rows=1 width=11) (never executed)

62. 0.000 0.000 ↓ 0.0 0

Index Scan using ad_user_partner on ad_user aduser27_ (cost=0.56..8.58 rows=1 width=11) (never executed)

  • Index Cond: ((c_bpartner_id)::text = (businesspa3_.c_bpartner_id)::text)
  • Filter: (isactive = 'Y'::bpchar)
63. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.56..14.11 rows=1 width=10) (never executed)

64. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.56..10.88 rows=1 width=16) (never executed)

  • Join Filter: ((businesspa28_.c_greeting_id)::text = (greetingtr30_.c_greeting_id)::text)
65. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.56..9.69 rows=1 width=66) (never executed)

  • Join Filter: ((businesspa28_.c_greeting_id)::text = (greeting29_.c_greeting_id)::text)
66. 0.000 0.000 ↓ 0.0 0

Index Scan using c_bpartner_key on c_bpartner businesspa28_ (cost=0.56..8.58 rows=1 width=33) (never executed)

  • Index Cond: ((businesspa3_.c_bpartner_id)::text = (c_bpartner_id)::text)
67. 0.000 0.000 ↓ 0.0 0

Seq Scan on c_greeting greeting29_ (cost=0.00..1.05 rows=5 width=33) (never executed)

68. 0.000 0.000 ↓ 0.0 0

Seq Scan on c_greeting_trl greetingtr30_ (cost=0.00..1.12 rows=5 width=49) (never executed)

  • Filter: ((ad_language)::text = 'fr_FR'::text)
69. 0.000 0.000 ↓ 0.0 0

Seq Scan on ad_language adlanguage31_ (cost=0.00..3.23 rows=1 width=6) (never executed)

  • Filter: ((ad_language)::text = 'fr_FR'::text)
70. 0.000 0.000 ↓ 0.0 0

HashAggregate (cost=484.94..484.95 rows=1 width=12) (never executed)

  • Group Key: fin_paymen35_.amount
71. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.69..484.93 rows=1 width=12) (never executed)

72. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.13..484.30 rows=1 width=45) (never executed)

73. 0.000 0.000 ↓ 0.0 0

Index Scan using fin_paym_sch_ord_idx on fin_payment_schedule fin_paymen35_ (cost=0.56..8.58 rows=1 width=39) (never executed)

  • Index Cond: ((c_order_id)::text = (order2_.c_order_id)::text)
74. 0.000 0.000 ↓ 0.0 0

Index Scan using fin_pay_scheduledetail_or on fin_payment_scheduledetail fin_paymen34_ (cost=0.56..474.59 rows=113 width=72) (never executed)

  • Index Cond: ((fin_payment_schedule_order)::text = (fin_paymen35_.fin_payment_schedule_id)::text)
  • Filter: (fin_payment_detail_id IS NOT NULL)
75. 0.000 0.000 ↓ 0.0 0

Index Only Scan using fin_payment_detail_key on fin_payment_detail fin_paymen37_ (cost=0.56..0.62 rows=1 width=33) (never executed)

  • Index Cond: (fin_payment_detail_id = (fin_paymen34_.fin_payment_detail_id)::text)
  • Heap Fetches: 0
76. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=484.94..484.95 rows=1 width=6) (never executed)

77. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.69..484.93 rows=1 width=6) (never executed)

78. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.13..484.30 rows=1 width=39) (never executed)

79. 0.000 0.000 ↓ 0.0 0

Index Scan using fin_paym_sch_ord_idx on fin_payment_schedule fin_paymen40_ (cost=0.56..8.58 rows=1 width=33) (never executed)

  • Index Cond: ((c_order_id)::text = (order2_.c_order_id)::text)
80. 0.000 0.000 ↓ 0.0 0

Index Scan using fin_pay_scheduledetail_or on fin_payment_scheduledetail fin_paymen39_ (cost=0.56..474.59 rows=113 width=72) (never executed)

  • Index Cond: ((fin_payment_schedule_order)::text = (fin_paymen40_.fin_payment_schedule_id)::text)
  • Filter: (fin_payment_detail_id IS NOT NULL)
81. 0.000 0.000 ↓ 0.0 0

Index Only Scan using fin_payment_detail_key on fin_payment_detail fin_paymen41_ (cost=0.56..0.62 rows=1 width=33) (never executed)

  • Index Cond: (fin_payment_detail_id = (fin_paymen39_.fin_payment_detail_id)::text)
  • Heap Fetches: 0