explain.depesz.com

PostgreSQL's explain analyze made readable

Result: J6j8

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 53,380.303 ↓ 0.0 0 1

Limit (cost=343,153.50..343,153.50 rows=1 width=498) (actual time=53,380.303..53,380.303 rows=0 loops=1)

  • Output: (CASE WHEN (SubPlan 1) THEN true ELSE false END), ((SubPlan 2)), ((SubPlan 3)), ((SubPlan 4)), aduser21_.firstname, aduser22_.firstname, ((SubPlan 5)), order2_.c_order_id, or
  • Buffers: shared hit=163114 read=122478
2. 0.029 53,380.302 ↓ 0.0 0 1

Sort (cost=343,153.50..343,153.50 rows=1 width=498) (actual time=53,380.302..53,380.302 rows=0 loops=1)

  • Output: (CASE WHEN (SubPlan 1) THEN true ELSE false END), ((SubPlan 2)), ((SubPlan 3)), ((SubPlan 4)), aduser21_.firstname, aduser22_.firstname, ((SubPlan 5)), order2_.c_order_
  • Sort Key: order2_.documentno
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=163114 read=122478
3. 0.000 53,380.273 ↓ 0.0 0 1

Nested Loop (cost=4.49..343,153.49 rows=1 width=498) (actual time=53,380.273..53,380.273 rows=0 loops=1)

  • Output: CASE WHEN (SubPlan 1) THEN true ELSE false END, (SubPlan 2), (SubPlan 3), (SubPlan 4), aduser21_.firstname, aduser22_.firstname, (SubPlan 5), order2_.c_order_id,
  • Buffers: shared hit=163111 read=122478
4. 0.000 53,380.273 ↓ 0.0 0 1

Nested Loop (cost=3.93..341,680.91 rows=1 width=507) (actual time=53,380.273..53,380.273 rows=0 loops=1)

  • Output: orderline0_.c_orderline_id, orderline0_.description, orderline0_.line, orderline0_.qtyordered, orderline0_.qtydelivered, orderline0_.em_obwpl_qtyinpicking,
  • Buffers: shared hit=163111 read=122478
5. 0.001 53,380.273 ↓ 0.0 0 1

Nested Loop Left Join (cost=3.37..341,672.51 rows=1 width=517) (actual time=53,380.273..53,380.273 rows=0 loops=1)

  • Output: orderline0_.c_orderline_id, orderline0_.description, orderline0_.line, orderline0_.qtyordered, orderline0_.qtydelivered, orderline0_.em_obwpl_qtyinpic
  • Join Filter: ((location5_.c_country_id)::text = (country6_.c_country_id)::text)
  • Buffers: shared hit=163111 read=122478
6. 0.000 53,380.272 ↓ 0.0 0 1

Nested Loop Left Join (cost=3.37..341,662.11 rows=1 width=510) (actual time=53,380.272..53,380.272 rows=0 loops=1)

  • Output: orderline0_.c_orderline_id, orderline0_.description, orderline0_.line, orderline0_.qtyordered, orderline0_.qtydelivered, orderline0_.em_obwpl_qt
  • Buffers: shared hit=163111 read=122478
7. 0.000 53,380.272 ↓ 0.0 0 1

Nested Loop Left Join (cost=2.81..341,654.96 rows=1 width=456) (actual time=53,380.272..53,380.272 rows=0 loops=1)

  • Output: orderline0_.c_orderline_id, orderline0_.description, orderline0_.line, orderline0_.qtyordered, orderline0_.qtydelivered, orderline0_.em_ob
  • Buffers: shared hit=163111 read=122478
8. 0.001 53,380.272 ↓ 0.0 0 1

Nested Loop (cost=2.25..341,646.39 rows=1 width=456) (actual time=53,380.272..53,380.272 rows=0 loops=1)

  • Output: orderline0_.c_orderline_id, orderline0_.description, orderline0_.line, orderline0_.qtyordered, orderline0_.qtydelivered, orderline0_
  • Buffers: shared hit=163111 read=122478
9. 0.000 53,380.271 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.69..341,637.83 rows=1 width=428) (actual time=53,380.271..53,380.271 rows=0 loops=1)

  • Output: orderline0_.c_orderline_id, orderline0_.description, orderline0_.line, orderline0_.qtyordered, orderline0_.qtydelivered, order
  • Join Filter: ((product1_.m_brand_id)::text = (brand7_.m_brand_id)::text)
  • Buffers: shared hit=163111 read=122478
10. 0.001 53,380.271 ↓ 0.0 0 1

Nested Loop (cost=1.69..341,596.26 rows=1 width=454) (actual time=53,380.271..53,380.271 rows=0 loops=1)

  • Output: orderline0_.c_orderline_id, orderline0_.description, orderline0_.line, orderline0_.qtyordered, orderline0_.qtydelivered,
  • Buffers: shared hit=163111 read=122478
11. 53,380.270 53,380.270 ↓ 0.0 0 1

Nested Loop (cost=1.13..341,588.33 rows=1 width=359) (actual time=53,380.270..53,380.270 rows=0 loops=1)

  • Output: orderline0_.c_orderline_id, orderline0_.description, orderline0_.line, orderline0_.qtyordered, orderline0_.qtydeli
  • Buffers: shared hit=163111 read=122478
  • -> Index Scan using em_obpos_canbedelivered on public.c_orderline orderline0_ (cost=0.57..208945.26 rows=15558 width=245
  • Output: orderline0_.c_orderline_id, orderline0_.ad_client_id, orderline0_.ad_org_id, orderline0_.isactive, orderline
  • Index Cond: ((orderline0_.em_obpos_canbedelivered = 'Y'::bpchar) AND ((orderline0_.ad_org_id)::text = 'C459182BF30B4
  • Filter: (((orderline0_.em_obwpl_readypl IS NULL) OR (orderline0_.em_obwpl_readypl = 'N'::bpchar)) AND ((orderline0_.
  • Rows Removed by Filter: 165588
  • Buffers: shared hit=479 read=99909
  • -> Index Scan using c_order_key on public.c_order order2_ (cost=0.56..8.52 rows=1 width=147) (actual time=0.310..0.310 r
  • Output: order2_.c_order_id, order2_.ad_client_id, order2_.ad_org_id, order2_.isactive, order2_.created, order2_.crea
  • Index Cond: ((order2_.c_order_id)::text = (orderline0_.c_order_id)::text)
  • Filter: ((order2_.em_obpos_applications_id IS NOT NULL) AND (order2_.em_obwpl_readypl <> 'Y'::bpchar) AND ((order2_.
  • Rows Removed by Filter: 1
  • Buffers: shared hit=162632 read=22569
12. 0.000 0.000 ↓ 0.0 0

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

  • Output: product1_.m_product_id, product1_.ad_client_id, product1_.ad_org_id, product1_.isactive, product1_.created, produc
  • Index Cond: ((product1_.m_product_id)::text = (orderline0_.m_product_id)::text)
  • Filter: ((product1_.producttype)::text = 'I'::text)
13. 0.000 0.000 ↓ 0.0 0

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

  • Output: brand7_.m_brand_id, brand7_.ad_client_id, brand7_.ad_org_id, brand7_.isactive, brand7_.created, brand7_.createdby, brand
14. 0.000 0.000 ↓ 0.0 0

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

  • Output: businesspa3_.c_bpartner_id, businesspa3_.ad_client_id, businesspa3_.ad_org_id, businesspa3_.isactive, businesspa3_.created, bu
  • Index Cond: ((businesspa3_.c_bpartner_id)::text = (order2_.c_bpartner_id)::text)
15. 0.000 0.000 ↓ 0.0 0

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

  • Output: businesspa4_.c_bpartner_location_id, businesspa4_.ad_client_id, businesspa4_.ad_org_id, businesspa4_.isactive, businesspa4_.created,
  • Index Cond: ((order2_.c_bpartner_location_id)::text = (businesspa4_.c_bpartner_location_id)::text)
16. 0.000 0.000 ↓ 0.0 0

Index Scan using c_location_key on public.c_location location5_ (cost=0.56..7.14 rows=1 width=87) (never executed)

  • Output: location5_.c_location_id, location5_.ad_client_id, location5_.ad_org_id, location5_.isactive, location5_.created, location5_.createdby, lo
  • Index Cond: ((businesspa4_.c_location_id)::text = (location5_.c_location_id)::text)
17. 0.000 0.000 ↓ 0.0 0

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

  • Output: country6_.c_country_id, country6_.ad_client_id, country6_.ad_org_id, country6_.isactive, country6_.created, country6_.createdby, country6_.updat
18. 0.000 0.000 ↓ 0.0 0

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

  • Output: aduser21_.ad_user_id, aduser21_.ad_client_id, aduser21_.ad_org_id, aduser21_.isactive, aduser21_.created, aduser21_.createdby, aduser21_.updated, adus
  • Index Cond: ((aduser21_.ad_user_id)::text = (orderline0_.createdby)::text)
19. 0.000 0.000 ↓ 0.0 0

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

  • Output: aduser22_.ad_user_id, aduser22_.ad_client_id, aduser22_.ad_org_id, aduser22_.isactive, aduser22_.created, aduser22_.createdby, aduser22_.updated, aduser22_.
  • Index Cond: ((aduser22_.ad_user_id)::text = (orderline0_.updatedby)::text)
20.          

SubPlan (forNested Loop)

21. 0.000 0.000 ↓ 0.0 0

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

22. 0.000 0.000 ↓ 0.0 0

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

  • Output: orderlines10_.c_orderline_related_id
23. 0.000 0.000 ↓ 0.0 0

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

  • Output: obre_reser8_.c_orderline_id, orderlines10_.c_orderline_id, orderlines10_.c_orderline_related_id
  • -> Index Scan using c_orderline_servrel_relord_idx on public.c_orderline_servicerelation orderlines10_ (cost=0.56..52.77 rows=12 width=66) (never ex
  • Output: orderlines10_.c_orderline_servicerelation_id, orderlines10_.ad_client_id, orderlines10_.ad_org_id, orderlines10_.isactive, orderlines10_
  • Index Cond: ((orderlines10_.c_orderline_related_id)::text = (orderline0_.c_orderline_id)::text)
24. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

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

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

  • Output: characteri13_.name
28. 0.000 0.000 ↓ 0.0 0

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

  • Output: productcha12_.m_ch_value_id
29. 0.000 0.000 ↓ 0.0 0

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

  • Output: characteri14_.m_characteristic_id, characteri14_.ad_client_id, characteri14_.ad_org_id, characteri14_.isactive, characteri14_.created, charact
  • Index Cond: ((characteri14_.name)::text = 'Produit.RefFournisseur'::text)
  • Filter: ((characteri14_.name)::text ~~ 'Produit.RefFournisseur'::text)
30. 0.000 0.000 ↓ 0.0 0

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

  • Output: productcha12_.m_product_ch_value_id, productcha12_.ad_client_id, productcha12_.ad_org_id, productcha12_.isactive, productcha12_.created, produ
  • Index Cond: (((productcha12_.m_product_id)::text = (product1_.m_product_id)::text) AND ((productcha12_.m_characteristic_id)::text = (characteri14_.m_c
31. 0.000 0.000 ↓ 0.0 0

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

  • Output: characteri13_.m_ch_value_id, characteri13_.ad_client_id, characteri13_.ad_org_id, characteri13_.isactive, characteri13_.created, characteri13_.creat
  • Index Cond: ((characteri13_.m_ch_value_id)::text = (productcha12_.m_ch_value_id)::text)
32. 0.000 0.000 ↓ 0.0 0

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

  • Output: characteri16_.name
33. 0.000 0.000 ↓ 0.0 0

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

  • Output: productcha15_.m_ch_value_id
34. 0.000 0.000 ↓ 0.0 0

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

  • Output: characteri17_.m_characteristic_id, characteri17_.ad_client_id, characteri17_.ad_org_id, characteri17_.isactive, characteri17_.created, charact
  • Index Cond: ((characteri17_.name)::text = 'Produit.Fournisseur'::text)
  • Filter: ((characteri17_.name)::text ~~ 'Produit.Fournisseur'::text)
35. 0.000 0.000 ↓ 0.0 0

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

  • Output: productcha15_.m_product_ch_value_id, productcha15_.ad_client_id, productcha15_.ad_org_id, productcha15_.isactive, productcha15_.created, produ
  • Index Cond: (((productcha15_.m_product_id)::text = (product1_.m_product_id)::text) AND ((productcha15_.m_characteristic_id)::text = (characteri17_.m_c
36. 0.000 0.000 ↓ 0.0 0

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

  • Output: characteri16_.m_ch_value_id, characteri16_.ad_client_id, characteri16_.ad_org_id, characteri16_.isactive, characteri16_.created, characteri16_.creat
  • Index Cond: ((characteri16_.m_ch_value_id)::text = (productcha15_.m_ch_value_id)::text)
37. 0.000 0.000 ↓ 0.0 0

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

  • Output: characteri19_.name
38. 0.000 0.000 ↓ 0.0 0

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

  • Output: productcha18_.m_ch_value_id
39. 0.000 0.000 ↓ 0.0 0

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

  • Output: characteri20_.m_characteristic_id, characteri20_.ad_client_id, characteri20_.ad_org_id, characteri20_.isactive, characteri20_.created, charact
  • Index Cond: ((characteri20_.name)::text = 'Colis.Nombre de colis'::text)
  • Filter: ((characteri20_.name)::text ~~ 'Colis.Nombre de colis'::text)
40. 0.000 0.000 ↓ 0.0 0

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

  • Output: productcha18_.m_product_ch_value_id, productcha18_.ad_client_id, productcha18_.ad_org_id, productcha18_.isactive, productcha18_.created, produ
  • Index Cond: (((productcha18_.m_product_id)::text = (product1_.m_product_id)::text) AND ((productcha18_.m_characteristic_id)::text = (characteri20_.m_c
41. 0.000 0.000 ↓ 0.0 0

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

  • Output: characteri19_.m_ch_value_id, characteri19_.ad_client_id, characteri19_.ad_org_id, characteri19_.isactive, characteri19_.created, characteri19_.creat
  • Index Cond: ((characteri19_.m_ch_value_id)::text = (productcha18_.m_ch_value_id)::text)
42. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=247.29..247.31 rows=1 width=20) (never executed)

  • Output: array_to_string(array_agg(product25_.name), ','::text)
43. 0.000 0.000 ↓ 0.0 0

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

  • Output: product25_.name
44. 0.000 0.000 ↓ 0.0 0

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

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

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

  • Output: orderlines23_.c_orderline_related_id, product25_.name
46. 0.000 0.000 ↓ 0.0 0

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

  • Output: orderlines23_.c_orderline_related_id, orderline24_.m_product_id
  • -> Index Scan using c_orderline_servrel_relord_idx on public.c_orderline_servicerelation orderlines23_ (cost=0.56..52.77 rows=12 width=66) (ne
  • Output: orderlines23_.c_orderline_servicerelation_id, orderlines23_.ad_client_id, orderlines23_.ad_org_id, orderlines23_.isactive, orderli
  • Index Cond: ((orderlines23_.c_orderline_related_id)::text = (orderline0_.c_orderline_id)::text)
47. 0.000 0.000 ↓ 0.0 0

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

  • Output: orderline24_.c_orderline_id, orderline24_.ad_client_id, orderline24_.ad_org_id, orderline24_.isactive, orderline24_.created, order
  • Index Cond: ((orderline24_.c_orderline_id)::text = (orderlines23_.c_orderline_id)::text)
48. 0.000 0.000 ↓ 0.0 0

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

  • Output: product25_.m_product_id, product25_.ad_client_id, product25_.ad_org_id, product25_.isactive, product25_.created, product25_.createdby, p
  • Index Cond: ((product25_.m_product_id)::text = (orderline24_.m_product_id)::text)
49. 0.000 0.000 ↓ 0.0 0

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

  • Output: max((aduser27_.phone)::text)
50. 0.000 0.000 ↓ 0.0 0

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

  • Output: aduser27_.ad_user_id, aduser27_.ad_client_id, aduser27_.ad_org_id, aduser27_.isactive, aduser27_.created, aduser27_.createdby, aduser27_.updated, ad
  • Index Cond: ((aduser27_.c_bpartner_id)::text = (businesspa3_.c_bpartner_id)::text)
  • Filter: (aduser27_.isactive = 'Y'::bpchar)
51. 0.000 0.000 ↓ 0.0 0

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

  • Output: greetingtr30_.name
52. 0.000 0.000 ↓ 0.0 0

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

  • Output: greetingtr30_.name, greetingtr30_.ad_language
  • Join Filter: ((businesspa28_.c_greeting_id)::text = (greetingtr30_.c_greeting_id)::text)
53. 0.000 0.000 ↓ 0.0 0

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

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

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

  • Output: businesspa28_.c_bpartner_id, businesspa28_.ad_client_id, businesspa28_.ad_org_id, businesspa28_.isactive, businesspa28_.created, busines
  • Index Cond: ((businesspa3_.c_bpartner_id)::text = (businesspa28_.c_bpartner_id)::text)
55. 0.000 0.000 ↓ 0.0 0

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

  • Output: greeting29_.c_greeting_id, greeting29_.ad_client_id, greeting29_.ad_org_id, greeting29_.isactive, greeting29_.created, greeting29_.creat
56. 0.000 0.000 ↓ 0.0 0

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

  • Output: greetingtr30_.c_greeting_trl_id, greetingtr30_.ad_language, greetingtr30_.c_greeting_id, greetingtr30_.ad_client_id, greetingtr30_.ad_org_id,
  • Filter: ((greetingtr30_.ad_language)::text = 'fr_FR'::text)
57. 0.000 0.000 ↓ 0.0 0

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

  • Output: adlanguage31_.ad_language_id, adlanguage31_.ad_language, adlanguage31_.ad_client_id, adlanguage31_.ad_org_id, adlanguage31_.isactive, adlanguage31_.
  • Filter: ((adlanguage31_.ad_language)::text = 'fr_FR'::text)
58. 0.000 0.000 ↓ 0.0 0

HashAggregate (cost=473.52..473.53 rows=1 width=12) (never executed)

  • Output: (fin_paymen35_.amount - sum(fin_paymen34_.amount)), fin_paymen35_.amount
  • Group Key: fin_paymen35_.amount
59. 0.000 0.000 ↓ 0.0 0

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

  • Output: fin_paymen34_.amount, fin_paymen35_.amount
60. 0.000 0.000 ↓ 0.0 0

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

  • Output: fin_paymen34_.amount, fin_paymen34_.fin_payment_detail_id, fin_paymen35_.amount
  • -> Index Scan using fin_pay_scheduledetail_or on public.fin_payment_scheduledetail fin_paymen34_ (cost=0.56..458.53 rows=111 width=72) (never execut
61. 0.000 0.000 ↓ 0.0 0

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

  • Output: fin_paymen35_.fin_payment_schedule_id, fin_paymen35_.ad_client_id, fin_paymen35_.ad_org_id, fin_paymen35_.created, fin_paymen35_.created
  • Index Cond: ((fin_paymen35_.c_order_id)::text = (order2_.c_order_id)::text)
  • Output: fin_paymen34_.fin_payment_scheduledetail_id, fin_paymen34_.ad_client_id, fin_paymen34_.ad_org_id, fin_paymen34_.created, fin_paymen34_.c
  • Index Cond: ((fin_paymen34_.fin_payment_schedule_order)::text = (fin_paymen35_.fin_payment_schedule_id)::text)
  • Filter: (fin_paymen34_.fin_payment_detail_id IS NOT NULL)
62. 0.000 0.000 ↓ 0.0 0

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

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

Aggregate (cost=473.52..473.53 rows=1 width=6) (never executed)

  • Output: COALESCE(sum(fin_paymen39_.amount), '0'::numeric)
64. 0.000 0.000 ↓ 0.0 0

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

  • Output: fin_paymen39_.amount
65. 0.000 0.000 ↓ 0.0 0

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

  • Output: fin_paymen39_.amount, fin_paymen39_.fin_payment_detail_id
  • -> Index Scan using fin_pay_scheduledetail_or on public.fin_payment_scheduledetail fin_paymen39_ (cost=0.56..458.53 rows=111 width=72) (never execut
66. 0.000 0.000 ↓ 0.0 0

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

  • Output: fin_paymen40_.fin_payment_schedule_id, fin_paymen40_.ad_client_id, fin_paymen40_.ad_org_id, fin_paymen40_.created, fin_paymen40_.created
  • Index Cond: ((fin_paymen40_.c_order_id)::text = (order2_.c_order_id)::text)
  • Output: fin_paymen39_.fin_payment_scheduledetail_id, fin_paymen39_.ad_client_id, fin_paymen39_.ad_org_id, fin_paymen39_.created, fin_paymen39_.c
  • Index Cond: ((fin_paymen39_.fin_payment_schedule_order)::text = (fin_paymen40_.fin_payment_schedule_id)::text)
  • Filter: (fin_paymen39_.fin_payment_detail_id IS NOT NULL)
67. 0.000 0.000 ↓ 0.0 0

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

  • Output: fin_paymen41_.fin_payment_detail_id
  • Index Cond: (fin_paymen41_.fin_payment_detail_id = (fin_paymen39_.fin_payment_detail_id)::text)
  • Heap Fetches: 0
Planning time : 275.603 ms
Execution time : 53,381.331 ms