explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Yg2M

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Limit (cost=233,189.33..233,198.08 rows=20 width=2,871) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Unique (cost=233,189.33..233,219.52 rows=69 width=2,871) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Sort (cost=233,189.33..233,189.51 rows=69 width=2,871) (actual rows= loops=)

  • Sort Key: transactions_order.submit_timestamp DESC, transactions_order.id, transactions_order.identifier, transactions_order.external_id, transactions_order.app_user_id, transactions_order.is_chargeback, transactions_order.credit_card_config_ (...)
4. 0.000 0.000 ↓ 0.0

HashAggregate (cost=104,488.09..233,187.23 rows=69 width=2,871) (actual rows= loops=)

  • Group Key: transactions_order.id, (SubPlan 1), (SubPlan 2), (SubPlan 3), (SubPlan 4), COALESCE((SubPlan 5), 0.00), COALESCE((SubPlan 6), 0.00), COALESCE((SubPlan 7), 0.00), COALESCE((SubPlan 8), 0.00), COALESCE((SubPlan 9), 0.00), (((CO (...)
5. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=563.24..104,477.40 rows=69 width=2,871) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=563.10..610.20 rows=69 width=2,632) (actual rows= loops=)

  • Hash Cond: (venues_pointofsale.revenue_center_id = venues_revenuecenter.id)
7. 0.000 0.000 ↓ 0.0

Nested Loop (cost=549.27..595.84 rows=69 width=2,188) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=549.12..580.32 rows=69 width=2,178) (actual rows= loops=)

  • Hash Cond: (venues_pointofsale.venue_id = venues_venue.id)
9. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=533.04..563.60 rows=69 width=1,912) (actual rows= loops=)

  • Hash Cond: (transactions_order.section_id = venues_section.id)
10. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=530.62..560.89 rows=69 width=1,867) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=530.48..548.66 rows=69 width=1,621) (actual rows= loops=)

  • Hash Cond: (transactions_order_sv_cards.svcard_id = sv_cards_svcard.id)
12. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=527.54..544.78 rows=69 width=1,617) (actual rows= loops=)

  • Hash Cond: (auth_user.id = userprofiles_userprofile.user_id)
13. 0.000 0.000 ↓ 0.0

Seq Scan on auth_user (cost=0.00..14.49 rows=549 width=93) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Hash (cost=526.68..526.68 rows=69 width=1,524) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=345.60..526.68 rows=69 width=1,524) (actual rows= loops=)

  • Hash Cond: (t15.user_id = userprofiles_userprofile.id)
16. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=330.25..510.76 rows=69 width=1,514) (actual rows= loops=)

17. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=329.97..488.15 rows=69 width=1,486) (actual rows= loops=)

18. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=329.70..461.31 rows=69 width=1,398) (actual rows= loops=)

19. 0.000 0.000 ↓ 0.0

Nested Loop (cost=329.42..439.96 rows=69 width=1,079) (actual rows= loops=)

20. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=329.13..409.44 rows=87 width=1,079) (actual rows= loops=)

21. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=328.86..382.87 rows=87 width=1,075) (actual rows= loops=)

22. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=328.57..344.87 rows=87 width=1,071) (actual rows= loops=)

  • Hash Cond: (offerings_offeringusage.order_id = transactions_order.id)
23. 0.000 0.000 ↓ 0.0

Seq Scan on offerings_offeringusage (cost=0.00..13.74 rows=674 width=8) (actual rows= loops=)

24. 0.000 0.000 ↓ 0.0

Hash (cost=327.48..327.48 rows=87 width=1,067) (actual rows= loops=)

25. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=314.21..327.48 rows=87 width=1,067) (actual rows= loops=)

  • Hash Cond: (transactions_order_sv_cards.order_id = transactions_order.id)
26. 0.000 0.000 ↓ 0.0

Seq Scan on transactions_order_sv_cards (cost=0.00..10.72 rows=672 width=8) (actual rows= loops=)

27. 0.000 0.000 ↓ 0.0

Hash (cost=313.12..313.12 rows=87 width=1,063) (actual rows= loops=)

28. 0.000 0.000 ↓ 0.0

Nested Loop (cost=4.63..313.12 rows=87 width=1,063) (actual rows= loops=)

  • -> Index Scan using transactions_order_point_of_sale_id_1cbcf3f0 on transactions_order (cost=0.29..278.93 ro (...)
29. 0.000 0.000 ↓ 0.0

Nested Loop (cost=4.35..24.79 rows=1 width=413) (actual rows= loops=)

  • Join Filter: (payments_merchantpaymentgatewaysettings.id = venues_pointofsale.payment_gateway_settings_i (...)
  • Index Cond: (point_of_sale_id = venues_pointofsale.id)
30. 0.000 0.000 ↓ 0.0

Seq Scan on venues_pointofsale (cost=0.00..1.27 rows=27 width=85) (actual rows= loops=)

31. 0.000 0.000 ↓ 0.0

Materialize (cost=4.35..21.91 rows=4 width=328) (actual rows= loops=)

32. 0.000 0.000 ↓ 0.0

Nested Loop (cost=4.35..21.89 rows=4 width=328) (actual rows= loops=)

  • -> Index Scan using merchants_merchantaccount_application_id_e364f0de on merchants_merchant (...)
  • Index Cond: (application_id = 8)
  • -> Bitmap Heap Scan on payments_merchantpaymentgatewaysettings (cost=4.20..13.67 rows=6 wi (...)
  • Recheck Cond: (merchant_id = merchants_merchantaccount.id)
  • -> Bitmap Index Scan on payments_merchantpayment_merchant_id_payment_gate_293b6c56_un (...)
  • Index Cond: (merchant_id = merchants_merchantaccount.id)
33. 0.000 0.000 ↓ 0.0

Index Scan using transactions_transaction_order_id_e7f281ee on transactions_transaction (cost=0.29..0.43 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (transactions_order.id = order_id)
34. 0.000 0.000 ↓ 0.0

Index Scan using sv_cards_svtransaction_order_id_c2882061 on sv_cards_svtransaction (cost=0.28..0.30 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (transactions_order.id = order_id)
35. 0.000 0.000 ↓ 0.0

Index Scan using mlc_mlcorder_order_id_key on mlc_mlcorder (cost=0.29..0.34 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (order_id = transactions_order.id)
  • Filter: (id IS NOT NULL)
36. 0.000 0.000 ↓ 0.0

Index Scan using payments_creditcardconfig_pkey on payments_creditcardconfig (cost=0.28..0.30 rows=1 width=319) (actual rows= loops=)

  • Index Cond: (transactions_order.credit_card_config_id = id)
37. 0.000 0.000 ↓ 0.0

Index Scan using payments_creditcard_pkey on payments_creditcard (cost=0.28..0.38 rows=1 width=88) (actual rows= loops=)

  • Index Cond: (payments_creditcardconfig.credit_card_id = id)
38. 0.000 0.000 ↓ 0.0

Index Scan using merchants_applicationuserprofile_pkey on merchants_applicationuserprofile t15 (cost=0.28..0.32 rows=1 width=28) (actual rows= loops=)

  • Index Cond: (payments_creditcard.app_user_id = id)
39. 0.000 0.000 ↓ 0.0

Hash (cost=8.49..8.49 rows=549 width=10) (actual rows= loops=)

40. 0.000 0.000 ↓ 0.0

Seq Scan on userprofiles_userprofile (cost=0.00..8.49 rows=549 width=10) (actual rows= loops=)

41. 0.000 0.000 ↓ 0.0

Hash (cost=1.86..1.86 rows=86 width=8) (actual rows= loops=)

42. 0.000 0.000 ↓ 0.0

Seq Scan on sv_cards_svcard (cost=0.00..1.86 rows=86 width=8) (actual rows= loops=)

43. 0.000 0.000 ↓ 0.0

Index Scan using venues_seat_pkey on venues_seat (cost=0.15..0.17 rows=1 width=246) (actual rows= loops=)

  • Index Cond: (transactions_order.seat_id = id)
44. 0.000 0.000 ↓ 0.0

Hash (cost=1.63..1.63 rows=63 width=45) (actual rows= loops=)

45. 0.000 0.000 ↓ 0.0

Seq Scan on venues_section (cost=0.00..1.63 rows=63 width=45) (actual rows= loops=)

46. 0.000 0.000 ↓ 0.0

Hash (cost=12.70..12.70 rows=270 width=266) (actual rows= loops=)

47. 0.000 0.000 ↓ 0.0

Seq Scan on venues_venue (cost=0.00..12.70 rows=270 width=266) (actual rows= loops=)

48. 0.000 0.000 ↓ 0.0

Index Scan using payments_paymentgateway_pkey on payments_paymentgateway (cost=0.15..0.21 rows=1 width=10) (actual rows= loops=)

  • Index Cond: (id = payments_merchantpaymentgatewaysettings.payment_gateway_id)
49. 0.000 0.000 ↓ 0.0

Hash (cost=11.70..11.70 rows=170 width=444) (actual rows= loops=)

50. 0.000 0.000 ↓ 0.0

Seq Scan on venues_revenuecenter (cost=0.00..11.70 rows=170 width=444) (actual rows= loops=)

51. 0.000 0.000 ↓ 0.0

Index Scan using venues_event_pkey on venues_event (cost=0.15..0.17 rows=1 width=239) (actual rows= loops=)

  • Index Cond: (transactions_order.event_id = id)
52.          

SubPlan (forNested Loop Left Join)

53. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=8.60..17.85 rows=1 width=14) (actual rows= loops=)

  • Group Key: u0.id
54. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=8.60..17.83 rows=1 width=14) (actual rows= loops=)

  • Join Filter: (u0.id = u1.order_id)
55. 0.000 0.000 ↓ 0.0

Index Only Scan using transactions_order_pkey on transactions_order u0 (cost=0.29..4.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
56. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=8.32..13.51 rows=1 width=14) (actual rows= loops=)

  • Hash Cond: (u2.transaction_id = u1.id)
57. 0.000 0.000 ↓ 0.0

Seq Scan on transactions_returntransaction u2 (cost=0.00..4.59 rows=159 width=14) (actual rows= loops=)

58. 0.000 0.000 ↓ 0.0

Hash (cost=8.30..8.30 rows=1 width=8) (actual rows= loops=)

59. 0.000 0.000 ↓ 0.0

Index Scan using transactions_transaction_order_id_e7f281ee on transactions_transaction u1 (cost=0.29..8.30 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (order_id = transactions_order.id)
60. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=8.60..17.85 rows=1 width=9) (actual rows= loops=)

  • Group Key: u0_1.id
61. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=8.60..17.83 rows=1 width=9) (actual rows= loops=)

  • Join Filter: (u0_1.id = u1_1.order_id)
62. 0.000 0.000 ↓ 0.0

Index Only Scan using transactions_order_pkey on transactions_order u0_1 (cost=0.29..4.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
63. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=8.32..13.51 rows=1 width=9) (actual rows= loops=)

  • Hash Cond: (u2_1.transaction_id = u1_1.id)
64. 0.000 0.000 ↓ 0.0

Seq Scan on transactions_returntransaction u2_1 (cost=0.00..4.59 rows=159 width=9) (actual rows= loops=)

65. 0.000 0.000 ↓ 0.0

Hash (cost=8.30..8.30 rows=1 width=8) (actual rows= loops=)

66. 0.000 0.000 ↓ 0.0

Index Scan using transactions_transaction_order_id_e7f281ee on transactions_transaction u1_1 (cost=0.29..8.30 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (order_id = transactions_order.id)
67. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=8.60..17.85 rows=1 width=9) (actual rows= loops=)

  • Group Key: u0_2.id
68. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=8.60..17.83 rows=1 width=9) (actual rows= loops=)

  • Join Filter: (u0_2.id = u1_2.order_id)
69. 0.000 0.000 ↓ 0.0

Index Only Scan using transactions_order_pkey on transactions_order u0_2 (cost=0.29..4.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
70. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=8.32..13.51 rows=1 width=9) (actual rows= loops=)

  • Hash Cond: (u2_2.transaction_id = u1_2.id)
71. 0.000 0.000 ↓ 0.0

Seq Scan on transactions_returntransaction u2_2 (cost=0.00..4.59 rows=159 width=9) (actual rows= loops=)

72. 0.000 0.000 ↓ 0.0

Hash (cost=8.30..8.30 rows=1 width=8) (actual rows= loops=)

73. 0.000 0.000 ↓ 0.0

Index Scan using transactions_transaction_order_id_e7f281ee on transactions_transaction u1_2 (cost=0.29..8.30 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (order_id = transactions_order.id)
74. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=8.60..17.85 rows=1 width=14) (actual rows= loops=)

  • Group Key: u0_3.id
75. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=8.60..17.83 rows=1 width=14) (actual rows= loops=)

  • Join Filter: (u0_3.id = u1_3.order_id)
76. 0.000 0.000 ↓ 0.0

Index Only Scan using transactions_order_pkey on transactions_order u0_3 (cost=0.29..4.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
77. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=8.32..13.51 rows=1 width=14) (actual rows= loops=)

  • Hash Cond: (u2_3.transaction_id = u1_3.id)
78. 0.000 0.000 ↓ 0.0

Seq Scan on transactions_returntransaction u2_3 (cost=0.00..4.59 rows=159 width=14) (actual rows= loops=)

79. 0.000 0.000 ↓ 0.0

Hash (cost=8.30..8.30 rows=1 width=8) (actual rows= loops=)

80. 0.000 0.000 ↓ 0.0

Index Scan using transactions_transaction_order_id_e7f281ee on transactions_transaction u1_3 (cost=0.29..8.30 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (order_id = transactions_order.id)
81. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=8.60..18.19 rows=1 width=9) (actual rows= loops=)

  • Group Key: u0_4.id
82. 0.000 0.000 ↓ 0.0

Nested Loop (cost=8.60..18.17 rows=1 width=9) (actual rows= loops=)

83. 0.000 0.000 ↓ 0.0

Hash Join (cost=8.32..13.85 rows=1 width=9) (actual rows= loops=)

  • Hash Cond: (u2_4.transaction_id = u1_4.id)
84. 0.000 0.000 ↓ 0.0

Seq Scan on transactions_returntransaction u2_4 (cost=0.00..4.99 rows=144 width=9) (actual rows= loops=)

  • Filter: (status = ANY ('{16,15}'::integer[]))
85. 0.000 0.000 ↓ 0.0

Hash (cost=8.30..8.30 rows=1 width=8) (actual rows= loops=)

86. 0.000 0.000 ↓ 0.0

Index Scan using transactions_transaction_order_id_e7f281ee on transactions_transaction u1_4 (cost=0.29..8.30 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (order_id = transactions_order.id)
87. 0.000 0.000 ↓ 0.0

Index Only Scan using transactions_order_pkey on transactions_order u0_4 (cost=0.29..4.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
88. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=0.29..6.16 rows=1 width=9) (actual rows= loops=)

  • Group Key: u0_5.id
89. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.29..6.14 rows=1 width=9) (actual rows= loops=)

90. 0.000 0.000 ↓ 0.0

Index Only Scan using transactions_order_pkey on transactions_order u0_5 (cost=0.29..4.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
91. 0.000 0.000 ↓ 0.0

Seq Scan on sv_cards_svloadtransaction u1_5 (cost=0.00..1.82 rows=1 width=9) (actual rows= loops=)

  • Filter: ((order_id = transactions_order.id) AND (status = 2))
92. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=0.29..10.16 rows=1 width=9) (actual rows= loops=)

  • Group Key: u0_6.id
93. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.29..10.14 rows=1 width=9) (actual rows= loops=)

94. 0.000 0.000 ↓ 0.0

Index Scan using transactions_order_pkey on transactions_order u0_6 (cost=0.29..8.31 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
  • Filter: (flow_type = 1)
95. 0.000 0.000 ↓ 0.0

Seq Scan on sv_cards_svloadtransaction u1_6 (cost=0.00..1.82 rows=1 width=9) (actual rows= loops=)

  • Filter: ((order_id = transactions_order.id) AND (status = 2))
96. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=4.74..23.92 rows=1 width=20) (actual rows= loops=)

  • Group Key: u0_7.id
97. 0.000 0.000 ↓ 0.0

Nested Loop (cost=4.74..23.91 rows=1 width=20) (actual rows= loops=)

98. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.56..12.61 rows=1 width=8) (actual rows= loops=)

99. 0.000 0.000 ↓ 0.0

Index Only Scan using transactions_order_pkey on transactions_order u0_7 (cost=0.29..4.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
100. 0.000 0.000 ↓ 0.0

Index Scan using sv_cards_svtransaction_order_id_c2882061 on sv_cards_svtransaction u1_7 (cost=0.28..8.29 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (order_id = transactions_order.id)
101. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on sv_cards_svreturntransaction u2_5 (cost=4.17..11.29 rows=1 width=20) (actual rows= loops=)

  • Recheck Cond: (transaction_id = u1_7.id)
  • Filter: (status = ANY ('{16,15}'::integer[]))
102. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on sv_cards_svreturntransaction_sv_transaction_id_ffb7462d (cost=0.00..4.17 rows=3 width=0) (actual rows= loops=)

  • Index Cond: (transaction_id = u1_7.id)
103. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=4.47..16.98 rows=1 width=20) (actual rows= loops=)

  • Group Key: u0_8.id
104. 0.000 0.000 ↓ 0.0

Nested Loop (cost=4.47..16.97 rows=1 width=20) (actual rows= loops=)

105. 0.000 0.000 ↓ 0.0

Index Only Scan using transactions_order_pkey on transactions_order u0_8 (cost=0.29..4.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
106. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on transactions_externalreturntransaction u1_8 (cost=4.18..12.65 rows=1 width=20) (actual rows= loops=)

  • Recheck Cond: (order_id = transactions_order.id)
  • Filter: (status = 3)
107. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on transactions_externalreturntransaction_order_id_43ad2bf9 (cost=0.00..4.18 rows=4 width=0) (actual rows= loops=)

  • Index Cond: (order_id = transactions_order.id)
108. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=8.60..18.19 rows=1 width=9) (actual rows= loops=)

  • Group Key: u0_9.id
109. 0.000 0.000 ↓ 0.0

Nested Loop (cost=8.60..18.17 rows=1 width=9) (actual rows= loops=)

110. 0.000 0.000 ↓ 0.0

Hash Join (cost=8.32..13.85 rows=1 width=9) (actual rows= loops=)

  • Hash Cond: (u2_6.transaction_id = u1_9.id)
111. 0.000 0.000 ↓ 0.0

Seq Scan on transactions_returntransaction u2_6 (cost=0.00..4.99 rows=144 width=9) (actual rows= loops=)

  • Filter: (status = ANY ('{16,15}'::integer[]))
112. 0.000 0.000 ↓ 0.0

Hash (cost=8.30..8.30 rows=1 width=8) (actual rows= loops=)

113. 0.000 0.000 ↓ 0.0

Index Scan using transactions_transaction_order_id_e7f281ee on transactions_transaction u1_9 (cost=0.29..8.30 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (order_id = transactions_order.id)
114. 0.000 0.000 ↓ 0.0

Index Only Scan using transactions_order_pkey on transactions_order u0_9 (cost=0.29..4.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
115. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=4.74..23.92 rows=1 width=20) (actual rows= loops=)

  • Group Key: u0_10.id
116. 0.000 0.000 ↓ 0.0

Nested Loop (cost=4.74..23.91 rows=1 width=20) (actual rows= loops=)

117. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.56..12.61 rows=1 width=8) (actual rows= loops=)

118. 0.000 0.000 ↓ 0.0

Index Only Scan using transactions_order_pkey on transactions_order u0_10 (cost=0.29..4.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
119. 0.000 0.000 ↓ 0.0

Index Scan using sv_cards_svtransaction_order_id_c2882061 on sv_cards_svtransaction u1_10 (cost=0.28..8.29 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (order_id = transactions_order.id)
120. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on sv_cards_svreturntransaction u2_7 (cost=4.17..11.29 rows=1 width=20) (actual rows= loops=)

  • Recheck Cond: (transaction_id = u1_10.id)
  • Filter: (status = ANY ('{16,15}'::integer[]))
121. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on sv_cards_svreturntransaction_sv_transaction_id_ffb7462d (cost=0.00..4.17 rows=3 width=0) (actual rows= loops=)

  • Index Cond: (transaction_id = u1_10.id)
122. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=0.29..10.16 rows=1 width=9) (actual rows= loops=)

  • Group Key: u0_11.id
123. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.29..10.14 rows=1 width=9) (actual rows= loops=)

124. 0.000 0.000 ↓ 0.0

Index Scan using transactions_order_pkey on transactions_order u0_11 (cost=0.29..8.31 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
  • Filter: (flow_type = 1)
125. 0.000 0.000 ↓ 0.0

Seq Scan on sv_cards_svloadtransaction u1_11 (cost=0.00..1.82 rows=1 width=9) (actual rows= loops=)

  • Filter: ((order_id = transactions_order.id) AND (status = 2))
126. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=4.47..16.98 rows=1 width=20) (actual rows= loops=)

  • Group Key: u0_12.id
127. 0.000 0.000 ↓ 0.0

Nested Loop (cost=4.47..16.97 rows=1 width=20) (actual rows= loops=)

128. 0.000 0.000 ↓ 0.0

Index Only Scan using transactions_order_pkey on transactions_order u0_12 (cost=0.29..4.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
129. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on transactions_externalreturntransaction u1_12 (cost=4.18..12.65 rows=1 width=20) (actual rows= loops=)

  • Recheck Cond: (order_id = transactions_order.id)
  • Filter: (status = 3)
130. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on transactions_externalreturntransaction_order_id_43ad2bf9 (cost=0.00..4.18 rows=4 width=0) (actual rows= loops=)

  • Index Cond: (order_id = transactions_order.id)
131. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=17.23..55.88 rows=1 width=0) (actual rows= loops=)

  • Join Filter: (u0_13.id = u6.order_id)
  • Filter: ((u2_8.status = ANY ('{56,55}'::integer[])) OR (u3.status = 4) OR (u5.status = ANY ('{56,55}'::integer[])) OR (u6.status = 2))
132. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=13.05..43.15 rows=1 width=16) (actual rows= loops=)

133. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=8.88..31.84 rows=1 width=16) (actual rows= loops=)

  • Join Filter: (u0_13.id = u4.order_id)
134. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=8.60..23.53 rows=1 width=12) (actual rows= loops=)

  • Join Filter: (u0_13.id = u3.order_id)
135. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=8.60..21.83 rows=1 width=8) (actual rows= loops=)

  • Join Filter: (u0_13.id = u1_13.order_id)
136. 0.000 0.000 ↓ 0.0

Index Scan using transactions_order_pkey on transactions_order u0_13 (cost=0.29..8.31 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
  • Filter: (flow_type = 1)
137. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=8.32..13.51 rows=1 width=8) (actual rows= loops=)

  • Hash Cond: (u2_8.transaction_id = u1_13.id)
138. 0.000 0.000 ↓ 0.0

Seq Scan on transactions_returntransaction u2_8 (cost=0.00..4.59 rows=159 width=8) (actual rows= loops=)

139. 0.000 0.000 ↓ 0.0

Hash (cost=8.30..8.30 rows=1 width=8) (actual rows= loops=)

140. 0.000 0.000 ↓ 0.0

Index Scan using transactions_transaction_order_id_e7f281ee on transactions_transaction u1_13 (cost=0.29..8.30 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (order_id = transactions_order.id)
141. 0.000 0.000 ↓ 0.0

Seq Scan on sv_cards_svloadtransaction u3 (cost=0.00..1.69 rows=1 width=8) (actual rows= loops=)

  • Filter: (order_id = transactions_order.id)
142. 0.000 0.000 ↓ 0.0

Index Scan using sv_cards_svtransaction_order_id_c2882061 on sv_cards_svtransaction u4 (cost=0.28..8.29 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (order_id = transactions_order.id)
143. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on sv_cards_svreturntransaction u5 (cost=4.17..11.28 rows=3 width=8) (actual rows= loops=)

  • Recheck Cond: (u4.id = transaction_id)
144. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on sv_cards_svreturntransaction_sv_transaction_id_ffb7462d (cost=0.00..4.17 rows=3 width=0) (actual rows= loops=)

  • Index Cond: (u4.id = transaction_id)
145. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on transactions_externalreturntransaction u6 (cost=4.18..12.64 rows=4 width=8) (actual rows= loops=)

  • Recheck Cond: (order_id = transactions_order.id)
146. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on transactions_externalreturntransaction_order_id_43ad2bf9 (cost=0.00..4.18 rows=4 width=0) (actual rows= loops=)

  • Index Cond: (order_id = transactions_order.id)
147. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=3,359.74..4,819.71 rows=337 width=4) (actual rows= loops=)

  • Hash Cond: (u0_14.id = u4_1.order_id)
  • Filter: ((u2_9.status = ANY ('{56,55}'::integer[])) OR (u3_1.status = 4) OR (u5_1.status = ANY ('{56,55}'::integer[])) OR (u6_1.status = 2))
148. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=3,294.13..4,510.95 rows=22,553 width=16) (actual rows= loops=)

  • Hash Cond: (u1_14.order_id = u0_14.id)
149. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=6.58..937.71 rows=20,777 width=8) (actual rows= loops=)

  • Hash Cond: (u1_14.id = u2_9.transaction_id)
150. 0.000 0.000 ↓ 0.0

Seq Scan on transactions_transaction u1_14 (cost=0.00..721.77 rows=20,777 width=8) (actual rows= loops=)

151. 0.000 0.000 ↓ 0.0

Hash (cost=4.59..4.59 rows=159 width=8) (actual rows= loops=)

152. 0.000 0.000 ↓ 0.0

Seq Scan on transactions_returntransaction u2_9 (cost=0.00..4.59 rows=159 width=8) (actual rows= loops=)

153. 0.000 0.000 ↓ 0.0

Hash (cost=3,005.64..3,005.64 rows=22,553 width=12) (actual rows= loops=)

154. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=2,978.54..3,005.64 rows=22,553 width=12) (actual rows= loops=)

  • Hash Cond: (u6_1.order_id = u0_14.id)
155. 0.000 0.000 ↓ 0.0

Seq Scan on transactions_externalreturntransaction u6_1 (cost=0.00..17.20 rows=720 width=8) (actual rows= loops=)

156. 0.000 0.000 ↓ 0.0

Hash (cost=2,696.63..2,696.63 rows=22,553 width=8) (actual rows= loops=)

157. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=2,694.82..2,696.63 rows=22,553 width=8) (actual rows= loops=)

  • Hash Cond: (u3_1.order_id = u0_14.id)
158. 0.000 0.000 ↓ 0.0

Seq Scan on sv_cards_svloadtransaction u3_1 (cost=0.00..1.55 rows=55 width=8) (actual rows= loops=)

159. 0.000 0.000 ↓ 0.0

Hash (cost=2,412.91..2,412.91 rows=22,553 width=4) (actual rows= loops=)

160. 0.000 0.000 ↓ 0.0

Seq Scan on transactions_order u0_14 (cost=0.00..2,412.91 rows=22,553 width=4) (actual rows= loops=)

  • Filter: (flow_type = 1)
161. 0.000 0.000 ↓ 0.0

Hash (cost=54.60..54.60 rows=881 width=8) (actual rows= loops=)

162. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=30.82..54.60 rows=881 width=8) (actual rows= loops=)

  • Hash Cond: (u5_1.transaction_id = u4_1.id)
163. 0.000 0.000 ↓ 0.0

Seq Scan on sv_cards_svreturntransaction u5_1 (cost=0.00..15.80 rows=580 width=8) (actual rows= loops=)

164. 0.000 0.000 ↓ 0.0

Hash (cost=19.81..19.81 rows=881 width=8) (actual rows= loops=)

165. 0.000 0.000 ↓ 0.0

Seq Scan on sv_cards_svtransaction u4_1 (cost=0.00..19.81 rows=881 width=8) (actual rows= loops=)

166. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=0.56..12.63 rows=1 width=13) (actual rows= loops=)

  • Group Key: u0_15.id
167. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.56..12.61 rows=1 width=13) (actual rows= loops=)

  • Join Filter: (u0_15.id = u1_15.order_id)
168. 0.000 0.000 ↓ 0.0

Index Only Scan using transactions_order_pkey on transactions_order u0_15 (cost=0.29..4.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
169. 0.000 0.000 ↓ 0.0

Index Scan using offerings_offeringusage_order_id_6f067d93 on offerings_offeringusage u1_15 (cost=0.28..8.29 rows=1 width=13) (actual rows= loops=)

  • Index Cond: (order_id = transactions_order.id)
170. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=8.59..14.05 rows=1 width=17) (actual rows= loops=)

  • Group Key: u0_16.id
171. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=8.59..14.03 rows=1 width=17) (actual rows= loops=)

  • Join Filter: (u0_16.id = u1_16.order_id)
172. 0.000 0.000 ↓ 0.0

Index Only Scan using transactions_order_pkey on transactions_order u0_16 (cost=0.29..4.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
173. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=8.30..9.71 rows=1 width=17) (actual rows= loops=)

  • Hash Cond: (u2_10.id = u1_16.offering_id)
174. 0.000 0.000 ↓ 0.0

Seq Scan on offerings_offering u2_10 (cost=0.00..1.29 rows=29 width=8) (actual rows= loops=)

175. 0.000 0.000 ↓ 0.0

Hash (cost=8.29..8.29 rows=1 width=17) (actual rows= loops=)

176. 0.000 0.000 ↓ 0.0

Index Scan using offerings_offeringusage_order_id_6f067d93 on offerings_offeringusage u1_16 (cost=0.28..8.29 rows=1 width=17) (actual rows= loops=)

  • Index Cond: (order_id = transactions_order.id)
177. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=8.59..14.05 rows=1 width=17) (actual rows= loops=)

  • Group Key: u0_17.id
178. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=8.59..14.03 rows=1 width=17) (actual rows= loops=)

  • Join Filter: (u0_17.id = u1_17.order_id)
179. 0.000 0.000 ↓ 0.0

Index Only Scan using transactions_order_pkey on transactions_order u0_17 (cost=0.29..4.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
180. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=8.30..9.71 rows=1 width=17) (actual rows= loops=)

  • Hash Cond: (u2_11.id = u1_17.offering_id)
181. 0.000 0.000 ↓ 0.0

Seq Scan on offerings_offering u2_11 (cost=0.00..1.29 rows=29 width=8) (actual rows= loops=)

182. 0.000 0.000 ↓ 0.0

Hash (cost=8.29..8.29 rows=1 width=17) (actual rows= loops=)

183. 0.000 0.000 ↓ 0.0

Index Scan using offerings_offeringusage_order_id_6f067d93 on offerings_offeringusage u1_17 (cost=0.28..8.29 rows=1 width=17) (actual rows= loops=)

  • Index Cond: (order_id = transactions_order.id)
184. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=8.59..14.05 rows=1 width=17) (actual rows= loops=)

  • Group Key: u0_18.id
185. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=8.59..14.03 rows=1 width=17) (actual rows= loops=)

  • Join Filter: (u0_18.id = u1_18.order_id)
186. 0.000 0.000 ↓ 0.0

Index Only Scan using transactions_order_pkey on transactions_order u0_18 (cost=0.29..4.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
187. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=8.30..9.71 rows=1 width=17) (actual rows= loops=)

  • Hash Cond: (u2_12.id = u1_18.offering_id)
188. 0.000 0.000 ↓ 0.0

Seq Scan on offerings_offering u2_12 (cost=0.00..1.29 rows=29 width=8) (actual rows= loops=)

189. 0.000 0.000 ↓ 0.0

Hash (cost=8.29..8.29 rows=1 width=17) (actual rows= loops=)

190. 0.000 0.000 ↓ 0.0

Index Scan using offerings_offeringusage_order_id_6f067d93 on offerings_offeringusage u1_18 (cost=0.28..8.29 rows=1 width=17) (actual rows= loops=)

  • Index Cond: (order_id = transactions_order.id)
191. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=4.74..25.31 rows=1 width=28) (actual rows= loops=)

  • Group Key: u0_19.id
192. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=4.74..25.29 rows=1 width=28) (actual rows= loops=)

193. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.56..12.61 rows=1 width=8) (actual rows= loops=)

  • Join Filter: (u0_19.id = u1_19.order_id)
194. 0.000 0.000 ↓ 0.0

Index Only Scan using transactions_order_pkey on transactions_order u0_19 (cost=0.29..4.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
195. 0.000 0.000 ↓ 0.0

Index Scan using offerings_offeringusage_order_id_6f067d93 on offerings_offeringusage u1_19 (cost=0.28..8.29 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (order_id = transactions_order.id)
196. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on offerings_offeringusagereturn u2_13 (cost=4.18..12.64 rows=4 width=28) (actual rows= loops=)

  • Recheck Cond: (u1_19.id = offering_usage_id)
197. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on offerings_offeringusagereturn_offering_usage_id_9101d4da (cost=0.00..4.18 rows=4 width=0) (actual rows= loops=)

  • Index Cond: (u1_19.id = offering_usage_id)
198. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=4.74..26.97 rows=1 width=32) (actual rows= loops=)

  • Group Key: u0_20.id
199. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=4.74..26.94 rows=1 width=32) (actual rows= loops=)

  • Join Filter: (u1_20.offering_id = u3_2.id)
200. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=4.74..25.29 rows=1 width=32) (actual rows= loops=)

201. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.56..12.61 rows=1 width=12) (actual rows= loops=)

  • Join Filter: (u0_20.id = u1_20.order_id)
202. 0.000 0.000 ↓ 0.0

Index Only Scan using transactions_order_pkey on transactions_order u0_20 (cost=0.29..4.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
203. 0.000 0.000 ↓ 0.0

Index Scan using offerings_offeringusage_order_id_6f067d93 on offerings_offeringusage u1_20 (cost=0.28..8.29 rows=1 width=12) (actual rows= loops=)

  • Index Cond: (order_id = transactions_order.id)
204. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on offerings_offeringusagereturn u2_14 (cost=4.18..12.64 rows=4 width=28) (actual rows= loops=)

  • Recheck Cond: (u1_20.id = offering_usage_id)
205. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on offerings_offeringusagereturn_offering_usage_id_9101d4da (cost=0.00..4.18 rows=4 width=0) (actual rows= loops=)

  • Index Cond: (u1_20.id = offering_usage_id)
206. 0.000 0.000 ↓ 0.0

Seq Scan on offerings_offering u3_2 (cost=0.00..1.29 rows=29 width=8) (actual rows= loops=)

207. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=8.60..17.85 rows=1 width=14) (actual rows= loops=)

  • Group Key: u0_21.id
208. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=8.60..17.83 rows=1 width=14) (actual rows= loops=)

  • Join Filter: (u0_21.id = u1_21.order_id)
209. 0.000 0.000 ↓ 0.0

Index Only Scan using transactions_order_pkey on transactions_order u0_21 (cost=0.29..4.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
210. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=8.32..13.51 rows=1 width=14) (actual rows= loops=)

  • Hash Cond: (u2_15.transaction_id = u1_21.id)
211. 0.000 0.000 ↓ 0.0

Seq Scan on transactions_returntransaction u2_15 (cost=0.00..4.59 rows=159 width=14) (actual rows= loops=)

212. 0.000 0.000 ↓ 0.0

Hash (cost=8.30..8.30 rows=1 width=8) (actual rows= loops=)

213. 0.000 0.000 ↓ 0.0

Index Scan using transactions_transaction_order_id_e7f281ee on transactions_transaction u1_21 (cost=0.29..8.30 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (order_id = transactions_order.id)
214. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=8.60..18.19 rows=1 width=9) (actual rows= loops=)

  • Group Key: u0_22.id
215. 0.000 0.000 ↓ 0.0

Nested Loop (cost=8.60..18.17 rows=1 width=9) (actual rows= loops=)

216. 0.000 0.000 ↓ 0.0

Hash Join (cost=8.32..13.85 rows=1 width=9) (actual rows= loops=)

  • Hash Cond: (u2_16.transaction_id = u1_22.id)
217. 0.000 0.000 ↓ 0.0

Seq Scan on transactions_returntransaction u2_16 (cost=0.00..4.99 rows=144 width=9) (actual rows= loops=)

  • Filter: (status = ANY ('{16,15}'::integer[]))
218. 0.000 0.000 ↓ 0.0

Hash (cost=8.30..8.30 rows=1 width=8) (actual rows= loops=)

219. 0.000 0.000 ↓ 0.0

Index Scan using transactions_transaction_order_id_e7f281ee on transactions_transaction u1_22 (cost=0.29..8.30 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (order_id = transactions_order.id)
220. 0.000 0.000 ↓ 0.0

Index Only Scan using transactions_order_pkey on transactions_order u0_22 (cost=0.29..4.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
221. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=4.74..23.92 rows=1 width=20) (actual rows= loops=)

  • Group Key: u0_23.id
222. 0.000 0.000 ↓ 0.0

Nested Loop (cost=4.74..23.91 rows=1 width=20) (actual rows= loops=)

223. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.56..12.61 rows=1 width=8) (actual rows= loops=)

224. 0.000 0.000 ↓ 0.0

Index Only Scan using transactions_order_pkey on transactions_order u0_23 (cost=0.29..4.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
225. 0.000 0.000 ↓ 0.0

Index Scan using sv_cards_svtransaction_order_id_c2882061 on sv_cards_svtransaction u1_23 (cost=0.28..8.29 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (order_id = transactions_order.id)
226. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on sv_cards_svreturntransaction u2_17 (cost=4.17..11.29 rows=1 width=20) (actual rows= loops=)

  • Recheck Cond: (transaction_id = u1_23.id)
  • Filter: (status = ANY ('{16,15}'::integer[]))
227. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on sv_cards_svreturntransaction_sv_transaction_id_ffb7462d (cost=0.00..4.17 rows=3 width=0) (actual rows= loops=)

  • Index Cond: (transaction_id = u1_23.id)
228. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=0.29..10.16 rows=1 width=9) (actual rows= loops=)

  • Group Key: u0_24.id
229. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.29..10.14 rows=1 width=9) (actual rows= loops=)

230. 0.000 0.000 ↓ 0.0

Index Scan using transactions_order_pkey on transactions_order u0_24 (cost=0.29..8.31 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
  • Filter: (flow_type = 1)
231. 0.000 0.000 ↓ 0.0

Seq Scan on sv_cards_svloadtransaction u1_24 (cost=0.00..1.82 rows=1 width=9) (actual rows= loops=)

  • Filter: ((order_id = transactions_order.id) AND (status = 2))
232. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=4.47..16.98 rows=1 width=20) (actual rows= loops=)

  • Group Key: u0_25.id
233. 0.000 0.000 ↓ 0.0

Nested Loop (cost=4.47..16.97 rows=1 width=20) (actual rows= loops=)

234. 0.000 0.000 ↓ 0.0

Index Only Scan using transactions_order_pkey on transactions_order u0_25 (cost=0.29..4.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
235. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on transactions_externalreturntransaction u1_25 (cost=4.18..12.65 rows=1 width=20) (actual rows= loops=)

  • Recheck Cond: (order_id = transactions_order.id)
  • Filter: (status = 3)
236. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on transactions_externalreturntransaction_order_id_43ad2bf9 (cost=0.00..4.18 rows=4 width=0) (actual rows= loops=)

  • Index Cond: (order_id = transactions_order.id)
237. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=8.60..18.19 rows=1 width=9) (actual rows= loops=)

  • Group Key: u0_26.id
238. 0.000 0.000 ↓ 0.0

Nested Loop (cost=8.60..18.17 rows=1 width=9) (actual rows= loops=)

239. 0.000 0.000 ↓ 0.0

Hash Join (cost=8.32..13.85 rows=1 width=9) (actual rows= loops=)

  • Hash Cond: (u2_18.transaction_id = u1_26.id)
240. 0.000 0.000 ↓ 0.0

Seq Scan on transactions_returntransaction u2_18 (cost=0.00..4.99 rows=144 width=9) (actual rows= loops=)

  • Filter: (status = ANY ('{16,15}'::integer[]))
241. 0.000 0.000 ↓ 0.0

Hash (cost=8.30..8.30 rows=1 width=8) (actual rows= loops=)

242. 0.000 0.000 ↓ 0.0

Index Scan using transactions_transaction_order_id_e7f281ee on transactions_transaction u1_26 (cost=0.29..8.30 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (order_id = transactions_order.id)
243. 0.000 0.000 ↓ 0.0

Index Only Scan using transactions_order_pkey on transactions_order u0_26 (cost=0.29..4.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
244. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=8.60..18.19 rows=1 width=9) (actual rows= loops=)

  • Group Key: u0_27.id
245. 0.000 0.000 ↓ 0.0

Nested Loop (cost=8.60..18.17 rows=1 width=9) (actual rows= loops=)

246. 0.000 0.000 ↓ 0.0

Hash Join (cost=8.32..13.85 rows=1 width=9) (actual rows= loops=)

  • Hash Cond: (u2_19.transaction_id = u1_27.id)
247. 0.000 0.000 ↓ 0.0

Seq Scan on transactions_returntransaction u2_19 (cost=0.00..4.99 rows=144 width=9) (actual rows= loops=)

  • Filter: (status = ANY ('{16,15}'::integer[]))
248. 0.000 0.000 ↓ 0.0

Hash (cost=8.30..8.30 rows=1 width=8) (actual rows= loops=)

249. 0.000 0.000 ↓ 0.0

Index Scan using transactions_transaction_order_id_e7f281ee on transactions_transaction u1_27 (cost=0.29..8.30 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (order_id = transactions_order.id)
250. 0.000 0.000 ↓ 0.0

Index Only Scan using transactions_order_pkey on transactions_order u0_27 (cost=0.29..4.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
251. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=4.74..23.92 rows=1 width=20) (actual rows= loops=)

  • Group Key: u0_28.id
252. 0.000 0.000 ↓ 0.0

Nested Loop (cost=4.74..23.91 rows=1 width=20) (actual rows= loops=)

253. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.56..12.61 rows=1 width=8) (actual rows= loops=)

254. 0.000 0.000 ↓ 0.0

Index Only Scan using transactions_order_pkey on transactions_order u0_28 (cost=0.29..4.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
255. 0.000 0.000 ↓ 0.0

Index Scan using sv_cards_svtransaction_order_id_c2882061 on sv_cards_svtransaction u1_28 (cost=0.28..8.29 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (order_id = transactions_order.id)
256. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on sv_cards_svreturntransaction u2_20 (cost=4.17..11.29 rows=1 width=20) (actual rows= loops=)

  • Recheck Cond: (transaction_id = u1_28.id)
  • Filter: (status = ANY ('{16,15}'::integer[]))
257. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on sv_cards_svreturntransaction_sv_transaction_id_ffb7462d (cost=0.00..4.17 rows=3 width=0) (actual rows= loops=)

  • Index Cond: (transaction_id = u1_28.id)
258. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=0.29..10.16 rows=1 width=9) (actual rows= loops=)

  • Group Key: u0_29.id
259. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.29..10.14 rows=1 width=9) (actual rows= loops=)

260. 0.000 0.000 ↓ 0.0

Index Scan using transactions_order_pkey on transactions_order u0_29 (cost=0.29..8.31 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
  • Filter: (flow_type = 1)
261. 0.000 0.000 ↓ 0.0

Seq Scan on sv_cards_svloadtransaction u1_29 (cost=0.00..1.82 rows=1 width=9) (actual rows= loops=)

  • Filter: ((order_id = transactions_order.id) AND (status = 2))
262. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=4.47..16.98 rows=1 width=20) (actual rows= loops=)

  • Group Key: u0_30.id
263. 0.000 0.000 ↓ 0.0

Nested Loop (cost=4.47..16.97 rows=1 width=20) (actual rows= loops=)

264. 0.000 0.000 ↓ 0.0

Index Only Scan using transactions_order_pkey on transactions_order u0_30 (cost=0.29..4.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
265. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on transactions_externalreturntransaction u1_30 (cost=4.18..12.65 rows=1 width=20) (actual rows= loops=)

  • Recheck Cond: (order_id = transactions_order.id)
  • Filter: (status = 3)
266. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on transactions_externalreturntransaction_order_id_43ad2bf9 (cost=0.00..4.18 rows=4 width=0) (actual rows= loops=)

  • Index Cond: (order_id = transactions_order.id)
267. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=4.47..16.98 rows=1 width=20) (actual rows= loops=)

  • Group Key: u0_31.id
268. 0.000 0.000 ↓ 0.0

Nested Loop (cost=4.47..16.97 rows=1 width=20) (actual rows= loops=)

269. 0.000 0.000 ↓ 0.0

Index Only Scan using transactions_order_pkey on transactions_order u0_31 (cost=0.29..4.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
270. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on transactions_externalreturntransaction u1_31 (cost=4.18..12.65 rows=1 width=20) (actual rows= loops=)

  • Recheck Cond: (order_id = transactions_order.id)
  • Filter: (status = 3)
271. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on transactions_externalreturntransaction_order_id_43ad2bf9 (cost=0.00..4.18 rows=4 width=0) (actual rows= loops=)

  • Index Cond: (order_id = transactions_order.id)
272. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=8.60..18.19 rows=1 width=9) (actual rows= loops=)

  • Group Key: u0_32.id
273. 0.000 0.000 ↓ 0.0

Nested Loop (cost=8.60..18.17 rows=1 width=9) (actual rows= loops=)

274. 0.000 0.000 ↓ 0.0

Hash Join (cost=8.32..13.85 rows=1 width=9) (actual rows= loops=)

  • Hash Cond: (u2_21.transaction_id = u1_32.id)
275. 0.000 0.000 ↓ 0.0

Seq Scan on transactions_returntransaction u2_21 (cost=0.00..4.99 rows=144 width=9) (actual rows= loops=)

  • Filter: (status = ANY ('{16,15}'::integer[]))
276. 0.000 0.000 ↓ 0.0

Hash (cost=8.30..8.30 rows=1 width=8) (actual rows= loops=)

277. 0.000 0.000 ↓ 0.0

Index Scan using transactions_transaction_order_id_e7f281ee on transactions_transaction u1_32 (cost=0.29..8.30 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (order_id = transactions_order.id)
278. 0.000 0.000 ↓ 0.0

Index Only Scan using transactions_order_pkey on transactions_order u0_32 (cost=0.29..4.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
279. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=8.60..18.19 rows=1 width=9) (actual rows= loops=)

  • Group Key: u0_33.id
280. 0.000 0.000 ↓ 0.0

Nested Loop (cost=8.60..18.17 rows=1 width=9) (actual rows= loops=)

281. 0.000 0.000 ↓ 0.0

Hash Join (cost=8.32..13.85 rows=1 width=9) (actual rows= loops=)

  • Hash Cond: (u2_22.transaction_id = u1_33.id)
282. 0.000 0.000 ↓ 0.0

Seq Scan on transactions_returntransaction u2_22 (cost=0.00..4.99 rows=144 width=9) (actual rows= loops=)

  • Filter: (status = ANY ('{16,15}'::integer[]))
283. 0.000 0.000 ↓ 0.0

Hash (cost=8.30..8.30 rows=1 width=8) (actual rows= loops=)

284. 0.000 0.000 ↓ 0.0

Index Scan using transactions_transaction_order_id_e7f281ee on transactions_transaction u1_33 (cost=0.29..8.30 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (order_id = transactions_order.id)
285. 0.000 0.000 ↓ 0.0

Index Only Scan using transactions_order_pkey on transactions_order u0_33 (cost=0.29..4.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
286. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=4.74..23.92 rows=1 width=20) (actual rows= loops=)

  • Group Key: u0_34.id
287. 0.000 0.000 ↓ 0.0

Nested Loop (cost=4.74..23.91 rows=1 width=20) (actual rows= loops=)

288. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.56..12.61 rows=1 width=8) (actual rows= loops=)

289. 0.000 0.000 ↓ 0.0

Index Only Scan using transactions_order_pkey on transactions_order u0_34 (cost=0.29..4.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
290. 0.000 0.000 ↓ 0.0

Index Scan using sv_cards_svtransaction_order_id_c2882061 on sv_cards_svtransaction u1_34 (cost=0.28..8.29 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (order_id = transactions_order.id)
291. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on sv_cards_svreturntransaction u2_23 (cost=4.17..11.29 rows=1 width=20) (actual rows= loops=)

  • Recheck Cond: (transaction_id = u1_34.id)
  • Filter: (status = ANY ('{16,15}'::integer[]))
292. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on sv_cards_svreturntransaction_sv_transaction_id_ffb7462d (cost=0.00..4.17 rows=3 width=0) (actual rows= loops=)

  • Index Cond: (transaction_id = u1_34.id)
293. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=0.29..10.16 rows=1 width=9) (actual rows= loops=)

  • Group Key: u0_35.id
294. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.29..10.14 rows=1 width=9) (actual rows= loops=)

295. 0.000 0.000 ↓ 0.0

Index Scan using transactions_order_pkey on transactions_order u0_35 (cost=0.29..8.31 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
  • Filter: (flow_type = 1)
296. 0.000 0.000 ↓ 0.0

Seq Scan on sv_cards_svloadtransaction u1_35 (cost=0.00..1.82 rows=1 width=9) (actual rows= loops=)

  • Filter: ((order_id = transactions_order.id) AND (status = 2))
297. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=4.47..16.98 rows=1 width=20) (actual rows= loops=)

  • Group Key: u0_36.id
298. 0.000 0.000 ↓ 0.0

Nested Loop (cost=4.47..16.97 rows=1 width=20) (actual rows= loops=)

299. 0.000 0.000 ↓ 0.0

Index Only Scan using transactions_order_pkey on transactions_order u0_36 (cost=0.29..4.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
300. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on transactions_externalreturntransaction u1_36 (cost=4.18..12.65 rows=1 width=20) (actual rows= loops=)

  • Recheck Cond: (order_id = transactions_order.id)
  • Filter: (status = 3)
301. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on transactions_externalreturntransaction_order_id_43ad2bf9 (cost=0.00..4.18 rows=4 width=0) (actual rows= loops=)

  • Index Cond: (order_id = transactions_order.id)
302. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=8.60..18.19 rows=1 width=9) (actual rows= loops=)

  • Group Key: u0_37.id
303. 0.000 0.000 ↓ 0.0

Nested Loop (cost=8.60..18.17 rows=1 width=9) (actual rows= loops=)

304. 0.000 0.000 ↓ 0.0

Hash Join (cost=8.32..13.85 rows=1 width=9) (actual rows= loops=)

  • Hash Cond: (u2_24.transaction_id = u1_37.id)
305. 0.000 0.000 ↓ 0.0

Seq Scan on transactions_returntransaction u2_24 (cost=0.00..4.99 rows=144 width=9) (actual rows= loops=)

  • Filter: (status = ANY ('{16,15}'::integer[]))
306. 0.000 0.000 ↓ 0.0

Hash (cost=8.30..8.30 rows=1 width=8) (actual rows= loops=)

307. 0.000 0.000 ↓ 0.0

Index Scan using transactions_transaction_order_id_e7f281ee on transactions_transaction u1_37 (cost=0.29..8.30 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (order_id = transactions_order.id)
308. 0.000 0.000 ↓ 0.0

Index Only Scan using transactions_order_pkey on transactions_order u0_37 (cost=0.29..4.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
309. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=4.74..23.92 rows=1 width=20) (actual rows= loops=)

  • Group Key: u0_38.id
310. 0.000 0.000 ↓ 0.0

Nested Loop (cost=4.74..23.91 rows=1 width=20) (actual rows= loops=)

311. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.56..12.61 rows=1 width=8) (actual rows= loops=)

312. 0.000 0.000 ↓ 0.0

Index Only Scan using transactions_order_pkey on transactions_order u0_38 (cost=0.29..4.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
313. 0.000 0.000 ↓ 0.0

Index Scan using sv_cards_svtransaction_order_id_c2882061 on sv_cards_svtransaction u1_38 (cost=0.28..8.29 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (order_id = transactions_order.id)
314. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on sv_cards_svreturntransaction u2_25 (cost=4.17..11.29 rows=1 width=20) (actual rows= loops=)

  • Recheck Cond: (transaction_id = u1_38.id)
  • Filter: (status = ANY ('{16,15}'::integer[]))
315. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on sv_cards_svreturntransaction_sv_transaction_id_ffb7462d (cost=0.00..4.17 rows=3 width=0) (actual rows= loops=)

  • Index Cond: (transaction_id = u1_38.id)
316. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=0.29..10.16 rows=1 width=9) (actual rows= loops=)

  • Group Key: u0_39.id
317. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.29..10.14 rows=1 width=9) (actual rows= loops=)

318. 0.000 0.000 ↓ 0.0

Index Scan using transactions_order_pkey on transactions_order u0_39 (cost=0.29..8.31 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
  • Filter: (flow_type = 1)
319. 0.000 0.000 ↓ 0.0

Seq Scan on sv_cards_svloadtransaction u1_39 (cost=0.00..1.82 rows=1 width=9) (actual rows= loops=)

  • Filter: ((order_id = transactions_order.id) AND (status = 2))
320. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=4.47..16.98 rows=1 width=20) (actual rows= loops=)

  • Group Key: u0_40.id
321. 0.000 0.000 ↓ 0.0

Nested Loop (cost=4.47..16.97 rows=1 width=20) (actual rows= loops=)

322. 0.000 0.000 ↓ 0.0

Index Only Scan using transactions_order_pkey on transactions_order u0_40 (cost=0.29..4.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
323. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on transactions_externalreturntransaction u1_40 (cost=4.18..12.65 rows=1 width=20) (actual rows= loops=)

  • Recheck Cond: (order_id = transactions_order.id)
  • Filter: (status = 3)
324. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on transactions_externalreturntransaction_order_id_43ad2bf9 (cost=0.00..4.18 rows=4 width=0) (actual rows= loops=)

  • Index Cond: (order_id = transactions_order.id)
325. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=4.74..23.92 rows=1 width=20) (actual rows= loops=)

  • Group Key: u0_51.id
326. 0.000 0.000 ↓ 0.0

Nested Loop (cost=4.74..23.91 rows=1 width=20) (actual rows= loops=)

327. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.56..12.61 rows=1 width=8) (actual rows= loops=)

328. 0.000 0.000 ↓ 0.0

Index Only Scan using transactions_order_pkey on transactions_order u0_51 (cost=0.29..4.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
329. 0.000 0.000 ↓ 0.0

Index Scan using sv_cards_svtransaction_order_id_c2882061 on sv_cards_svtransaction u1_51 (cost=0.28..8.29 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (order_id = transactions_order.id)
330. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on sv_cards_svreturntransaction u2_31 (cost=4.17..11.29 rows=1 width=20) (actual rows= loops=)

  • Recheck Cond: (transaction_id = u1_51.id)
  • Filter: (status = ANY ('{16,15}'::integer[]))
331. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on sv_cards_svreturntransaction_sv_transaction_id_ffb7462d (cost=0.00..4.17 rows=3 width=0) (actual rows= loops=)

  • Index Cond: (transaction_id = u1_51.id)
332. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=0.29..10.16 rows=1 width=9) (actual rows= loops=)

  • Group Key: u0_52.id
333. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.29..10.14 rows=1 width=9) (actual rows= loops=)

334. 0.000 0.000 ↓ 0.0

Index Scan using transactions_order_pkey on transactions_order u0_52 (cost=0.29..8.31 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
  • Filter: (flow_type = 1)
335. 0.000 0.000 ↓ 0.0

Seq Scan on sv_cards_svloadtransaction u1_52 (cost=0.00..1.82 rows=1 width=9) (actual rows= loops=)

  • Filter: ((order_id = transactions_order.id) AND (status = 2))
336. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=8.60..18.19 rows=1 width=9) (actual rows= loops=)

  • Group Key: u0_53.id
337. 0.000 0.000 ↓ 0.0

Nested Loop (cost=8.60..18.17 rows=1 width=9) (actual rows= loops=)

338. 0.000 0.000 ↓ 0.0

Hash Join (cost=8.32..13.85 rows=1 width=9) (actual rows= loops=)

  • Hash Cond: (u2_32.transaction_id = u1_53.id)
339. 0.000 0.000 ↓ 0.0

Seq Scan on transactions_returntransaction u2_32 (cost=0.00..4.99 rows=144 width=9) (actual rows= loops=)

  • Filter: (status = ANY ('{16,15}'::integer[]))
340. 0.000 0.000 ↓ 0.0

Hash (cost=8.30..8.30 rows=1 width=8) (actual rows= loops=)

341. 0.000 0.000 ↓ 0.0

Index Scan using transactions_transaction_order_id_e7f281ee on transactions_transaction u1_53 (cost=0.29..8.30 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (order_id = transactions_order.id)
342. 0.000 0.000 ↓ 0.0

Index Only Scan using transactions_order_pkey on transactions_order u0_53 (cost=0.29..4.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
343. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=4.74..23.92 rows=1 width=20) (actual rows= loops=)

  • Group Key: u0_54.id
344. 0.000 0.000 ↓ 0.0

Nested Loop (cost=4.74..23.91 rows=1 width=20) (actual rows= loops=)

345. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.56..12.61 rows=1 width=8) (actual rows= loops=)

346. 0.000 0.000 ↓ 0.0

Index Only Scan using transactions_order_pkey on transactions_order u0_54 (cost=0.29..4.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
347. 0.000 0.000 ↓ 0.0

Index Scan using sv_cards_svtransaction_order_id_c2882061 on sv_cards_svtransaction u1_54 (cost=0.28..8.29 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (order_id = transactions_order.id)
348. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on sv_cards_svreturntransaction u2_33 (cost=4.17..11.29 rows=1 width=20) (actual rows= loops=)

  • Recheck Cond: (transaction_id = u1_54.id)
  • Filter: (status = ANY ('{16,15}'::integer[]))
349. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on sv_cards_svreturntransaction_sv_transaction_id_ffb7462d (cost=0.00..4.17 rows=3 width=0) (actual rows= loops=)

  • Index Cond: (transaction_id = u1_54.id)
350. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=0.29..10.16 rows=1 width=9) (actual rows= loops=)

  • Group Key: u0_55.id
351. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.29..10.14 rows=1 width=9) (actual rows= loops=)

352. 0.000 0.000 ↓ 0.0

Index Scan using transactions_order_pkey on transactions_order u0_55 (cost=0.29..8.31 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
  • Filter: (flow_type = 1)
353. 0.000 0.000 ↓ 0.0

Seq Scan on sv_cards_svloadtransaction u1_55 (cost=0.00..1.82 rows=1 width=9) (actual rows= loops=)

  • Filter: ((order_id = transactions_order.id) AND (status = 2))
354. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=4.47..16.98 rows=1 width=20) (actual rows= loops=)

  • Group Key: u0_56.id
355. 0.000 0.000 ↓ 0.0

Nested Loop (cost=4.47..16.97 rows=1 width=20) (actual rows= loops=)

356. 0.000 0.000 ↓ 0.0

Index Only Scan using transactions_order_pkey on transactions_order u0_56 (cost=0.29..4.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
357. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on transactions_externalreturntransaction u1_56 (cost=4.18..12.65 rows=1 width=20) (actual rows= loops=)

  • Recheck Cond: (order_id = transactions_order.id)
  • Filter: (status = 3)
358. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on transactions_externalreturntransaction_order_id_43ad2bf9 (cost=0.00..4.18 rows=4 width=0) (actual rows= loops=)

  • Index Cond: (order_id = transactions_order.id)
359. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=4.47..16.98 rows=1 width=20) (actual rows= loops=)

  • Group Key: u0_67.id
360. 0.000 0.000 ↓ 0.0

Nested Loop (cost=4.47..16.97 rows=1 width=20) (actual rows= loops=)

361. 0.000 0.000 ↓ 0.0

Index Only Scan using transactions_order_pkey on transactions_order u0_67 (cost=0.29..4.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
362. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on transactions_externalreturntransaction u1_67 (cost=4.18..12.65 rows=1 width=20) (actual rows= loops=)

  • Recheck Cond: (order_id = transactions_order.id)
  • Filter: (status = 3)
363. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on transactions_externalreturntransaction_order_id_43ad2bf9 (cost=0.00..4.18 rows=4 width=0) (actual rows= loops=)

  • Index Cond: (order_id = transactions_order.id)
364. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=8.60..18.19 rows=1 width=9) (actual rows= loops=)

  • Group Key: u0_68.id
365. 0.000 0.000 ↓ 0.0

Nested Loop (cost=8.60..18.17 rows=1 width=9) (actual rows= loops=)

366. 0.000 0.000 ↓ 0.0

Hash Join (cost=8.32..13.85 rows=1 width=9) (actual rows= loops=)

  • Hash Cond: (u2_39.transaction_id = u1_68.id)
367. 0.000 0.000 ↓ 0.0

Seq Scan on transactions_returntransaction u2_39 (cost=0.00..4.99 rows=144 width=9) (actual rows= loops=)

  • Filter: (status = ANY ('{16,15}'::integer[]))
368. 0.000 0.000 ↓ 0.0

Hash (cost=8.30..8.30 rows=1 width=8) (actual rows= loops=)

369. 0.000 0.000 ↓ 0.0

Index Scan using transactions_transaction_order_id_e7f281ee on transactions_transaction u1_68 (cost=0.29..8.30 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (order_id = transactions_order.id)
370. 0.000 0.000 ↓ 0.0

Index Only Scan using transactions_order_pkey on transactions_order u0_68 (cost=0.29..4.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
371. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=8.60..18.19 rows=1 width=9) (actual rows= loops=)

  • Group Key: u0_69.id
372. 0.000 0.000 ↓ 0.0

Nested Loop (cost=8.60..18.17 rows=1 width=9) (actual rows= loops=)

373. 0.000 0.000 ↓ 0.0

Hash Join (cost=8.32..13.85 rows=1 width=9) (actual rows= loops=)

  • Hash Cond: (u2_40.transaction_id = u1_69.id)
374. 0.000 0.000 ↓ 0.0

Seq Scan on transactions_returntransaction u2_40 (cost=0.00..4.99 rows=144 width=9) (actual rows= loops=)

  • Filter: (status = ANY ('{16,15}'::integer[]))
375. 0.000 0.000 ↓ 0.0

Hash (cost=8.30..8.30 rows=1 width=8) (actual rows= loops=)

376. 0.000 0.000 ↓ 0.0

Index Scan using transactions_transaction_order_id_e7f281ee on transactions_transaction u1_69 (cost=0.29..8.30 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (order_id = transactions_order.id)
377. 0.000 0.000 ↓ 0.0

Index Only Scan using transactions_order_pkey on transactions_order u0_69 (cost=0.29..4.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
378. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=4.74..23.92 rows=1 width=20) (actual rows= loops=)

  • Group Key: u0_70.id
379. 0.000 0.000 ↓ 0.0

Nested Loop (cost=4.74..23.91 rows=1 width=20) (actual rows= loops=)

380. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.56..12.61 rows=1 width=8) (actual rows= loops=)

381. 0.000 0.000 ↓ 0.0

Index Only Scan using transactions_order_pkey on transactions_order u0_70 (cost=0.29..4.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
382. 0.000 0.000 ↓ 0.0

Index Scan using sv_cards_svtransaction_order_id_c2882061 on sv_cards_svtransaction u1_70 (cost=0.28..8.29 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (order_id = transactions_order.id)
383. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on sv_cards_svreturntransaction u2_41 (cost=4.17..11.29 rows=1 width=20) (actual rows= loops=)

  • Recheck Cond: (transaction_id = u1_70.id)
  • Filter: (status = ANY ('{16,15}'::integer[]))
384. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on sv_cards_svreturntransaction_sv_transaction_id_ffb7462d (cost=0.00..4.17 rows=3 width=0) (actual rows= loops=)

  • Index Cond: (transaction_id = u1_70.id)
385. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=0.29..10.16 rows=1 width=9) (actual rows= loops=)

  • Group Key: u0_71.id
386. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.29..10.14 rows=1 width=9) (actual rows= loops=)

387. 0.000 0.000 ↓ 0.0

Index Scan using transactions_order_pkey on transactions_order u0_71 (cost=0.29..8.31 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
  • Filter: (flow_type = 1)
388. 0.000 0.000 ↓ 0.0

Seq Scan on sv_cards_svloadtransaction u1_71 (cost=0.00..1.82 rows=1 width=9) (actual rows= loops=)

  • Filter: ((order_id = transactions_order.id) AND (status = 2))
389. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=4.47..16.98 rows=1 width=20) (actual rows= loops=)

  • Group Key: u0_72.id
390. 0.000 0.000 ↓ 0.0

Nested Loop (cost=4.47..16.97 rows=1 width=20) (actual rows= loops=)

391. 0.000 0.000 ↓ 0.0

Index Only Scan using transactions_order_pkey on transactions_order u0_72 (cost=0.29..4.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
392. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on transactions_externalreturntransaction u1_72 (cost=4.18..12.65 rows=1 width=20) (actual rows= loops=)

  • Recheck Cond: (order_id = transactions_order.id)
  • Filter: (status = 3)
393. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on transactions_externalreturntransaction_order_id_43ad2bf9 (cost=0.00..4.18 rows=4 width=0) (actual rows= loops=)

  • Index Cond: (order_id = transactions_order.id)
394. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=8.60..18.19 rows=1 width=9) (actual rows= loops=)

  • Group Key: u0_73.id
395. 0.000 0.000 ↓ 0.0

Nested Loop (cost=8.60..18.17 rows=1 width=9) (actual rows= loops=)

396. 0.000 0.000 ↓ 0.0

Hash Join (cost=8.32..13.85 rows=1 width=9) (actual rows= loops=)

  • Hash Cond: (u2_42.transaction_id = u1_73.id)
397. 0.000 0.000 ↓ 0.0

Seq Scan on transactions_returntransaction u2_42 (cost=0.00..4.99 rows=144 width=9) (actual rows= loops=)

  • Filter: (status = ANY ('{16,15}'::integer[]))
398. 0.000 0.000 ↓ 0.0

Hash (cost=8.30..8.30 rows=1 width=8) (actual rows= loops=)

399. 0.000 0.000 ↓ 0.0

Index Scan using transactions_transaction_order_id_e7f281ee on transactions_transaction u1_73 (cost=0.29..8.30 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (order_id = transactions_order.id)
400. 0.000 0.000 ↓ 0.0

Index Only Scan using transactions_order_pkey on transactions_order u0_73 (cost=0.29..4.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
401. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=4.74..23.92 rows=1 width=20) (actual rows= loops=)

  • Group Key: u0_74.id
402. 0.000 0.000 ↓ 0.0

Nested Loop (cost=4.74..23.91 rows=1 width=20) (actual rows= loops=)

403. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.56..12.61 rows=1 width=8) (actual rows= loops=)

404. 0.000 0.000 ↓ 0.0

Index Only Scan using transactions_order_pkey on transactions_order u0_74 (cost=0.29..4.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
405. 0.000 0.000 ↓ 0.0

Index Scan using sv_cards_svtransaction_order_id_c2882061 on sv_cards_svtransaction u1_74 (cost=0.28..8.29 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (order_id = transactions_order.id)
406. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on sv_cards_svreturntransaction u2_43 (cost=4.17..11.29 rows=1 width=20) (actual rows= loops=)

  • Recheck Cond: (transaction_id = u1_74.id)
  • Filter: (status = ANY ('{16,15}'::integer[]))
407. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on sv_cards_svreturntransaction_sv_transaction_id_ffb7462d (cost=0.00..4.17 rows=3 width=0) (actual rows= loops=)

  • Index Cond: (transaction_id = u1_74.id)
408. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=0.29..10.16 rows=1 width=9) (actual rows= loops=)

  • Group Key: u0_75.id
409. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.29..10.14 rows=1 width=9) (actual rows= loops=)

410. 0.000 0.000 ↓ 0.0

Index Scan using transactions_order_pkey on transactions_order u0_75 (cost=0.29..8.31 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
  • Filter: (flow_type = 1)
411. 0.000 0.000 ↓ 0.0

Seq Scan on sv_cards_svloadtransaction u1_75 (cost=0.00..1.82 rows=1 width=9) (actual rows= loops=)

  • Filter: ((order_id = transactions_order.id) AND (status = 2))
412. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=4.47..16.98 rows=1 width=20) (actual rows= loops=)

  • Group Key: u0_76.id
413. 0.000 0.000 ↓ 0.0

Nested Loop (cost=4.47..16.97 rows=1 width=20) (actual rows= loops=)

414. 0.000 0.000 ↓ 0.0

Index Only Scan using transactions_order_pkey on transactions_order u0_76 (cost=0.29..4.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
415. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on transactions_externalreturntransaction u1_76 (cost=4.18..12.65 rows=1 width=20) (actual rows= loops=)

  • Recheck Cond: (order_id = transactions_order.id)
  • Filter: (status = 3)
416. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on transactions_externalreturntransaction_order_id_43ad2bf9 (cost=0.00..4.18 rows=4 width=0) (actual rows= loops=)

  • Index Cond: (order_id = transactions_order.id)
417. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=4.74..23.92 rows=1 width=20) (actual rows= loops=)

  • Group Key: u0_77.id
418. 0.000 0.000 ↓ 0.0

Nested Loop (cost=4.74..23.91 rows=1 width=20) (actual rows= loops=)

419. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.56..12.61 rows=1 width=8) (actual rows= loops=)

420. 0.000 0.000 ↓ 0.0

Index Only Scan using transactions_order_pkey on transactions_order u0_77 (cost=0.29..4.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
421. 0.000 0.000 ↓ 0.0

Index Scan using sv_cards_svtransaction_order_id_c2882061 on sv_cards_svtransaction u1_77 (cost=0.28..8.29 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (order_id = transactions_order.id)
422. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on sv_cards_svreturntransaction u2_44 (cost=4.17..11.29 rows=1 width=20) (actual rows= loops=)

  • Recheck Cond: (transaction_id = u1_77.id)
  • Filter: (status = ANY ('{16,15}'::integer[]))
423. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on sv_cards_svreturntransaction_sv_transaction_id_ffb7462d (cost=0.00..4.17 rows=3 width=0) (actual rows= loops=)

  • Index Cond: (transaction_id = u1_77.id)
424. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=0.29..10.16 rows=1 width=9) (actual rows= loops=)

  • Group Key: u0_78.id
425. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.29..10.14 rows=1 width=9) (actual rows= loops=)

426. 0.000 0.000 ↓ 0.0

Index Scan using transactions_order_pkey on transactions_order u0_78 (cost=0.29..8.31 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
  • Filter: (flow_type = 1)
427. 0.000 0.000 ↓ 0.0

Seq Scan on sv_cards_svloadtransaction u1_78 (cost=0.00..1.82 rows=1 width=9) (actual rows= loops=)

  • Filter: ((order_id = transactions_order.id) AND (status = 2))
428. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=8.60..18.19 rows=1 width=9) (actual rows= loops=)

  • Group Key: u0_79.id
429. 0.000 0.000 ↓ 0.0

Nested Loop (cost=8.60..18.17 rows=1 width=9) (actual rows= loops=)

430. 0.000 0.000 ↓ 0.0

Hash Join (cost=8.32..13.85 rows=1 width=9) (actual rows= loops=)

  • Hash Cond: (u2_45.transaction_id = u1_79.id)
431. 0.000 0.000 ↓ 0.0

Seq Scan on transactions_returntransaction u2_45 (cost=0.00..4.99 rows=144 width=9) (actual rows= loops=)

  • Filter: (status = ANY ('{16,15}'::integer[]))
432. 0.000 0.000 ↓ 0.0

Hash (cost=8.30..8.30 rows=1 width=8) (actual rows= loops=)

433. 0.000 0.000 ↓ 0.0

Index Scan using transactions_transaction_order_id_e7f281ee on transactions_transaction u1_79 (cost=0.29..8.30 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (order_id = transactions_order.id)
434. 0.000 0.000 ↓ 0.0

Index Only Scan using transactions_order_pkey on transactions_order u0_79 (cost=0.29..4.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
435. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=4.74..23.92 rows=1 width=20) (actual rows= loops=)

  • Group Key: u0_80.id
436. 0.000 0.000 ↓ 0.0

Nested Loop (cost=4.74..23.91 rows=1 width=20) (actual rows= loops=)

437. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.56..12.61 rows=1 width=8) (actual rows= loops=)

438. 0.000 0.000 ↓ 0.0

Index Only Scan using transactions_order_pkey on transactions_order u0_80 (cost=0.29..4.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
439. 0.000 0.000 ↓ 0.0

Index Scan using sv_cards_svtransaction_order_id_c2882061 on sv_cards_svtransaction u1_80 (cost=0.28..8.29 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (order_id = transactions_order.id)
440. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on sv_cards_svreturntransaction u2_46 (cost=4.17..11.29 rows=1 width=20) (actual rows= loops=)

  • Recheck Cond: (transaction_id = u1_80.id)
  • Filter: (status = ANY ('{16,15}'::integer[]))
441. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on sv_cards_svreturntransaction_sv_transaction_id_ffb7462d (cost=0.00..4.17 rows=3 width=0) (actual rows= loops=)

  • Index Cond: (transaction_id = u1_80.id)
442. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=0.29..10.16 rows=1 width=9) (actual rows= loops=)

  • Group Key: u0_81.id
443. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.29..10.14 rows=1 width=9) (actual rows= loops=)

444. 0.000 0.000 ↓ 0.0

Index Scan using transactions_order_pkey on transactions_order u0_81 (cost=0.29..8.31 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
  • Filter: (flow_type = 1)
445. 0.000 0.000 ↓ 0.0

Seq Scan on sv_cards_svloadtransaction u1_81 (cost=0.00..1.82 rows=1 width=9) (actual rows= loops=)

  • Filter: ((order_id = transactions_order.id) AND (status = 2))
446. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=4.47..16.98 rows=1 width=20) (actual rows= loops=)

  • Group Key: u0_82.id
447. 0.000 0.000 ↓ 0.0

Nested Loop (cost=4.47..16.97 rows=1 width=20) (actual rows= loops=)

448. 0.000 0.000 ↓ 0.0

Index Only Scan using transactions_order_pkey on transactions_order u0_82 (cost=0.29..4.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
449. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on transactions_externalreturntransaction u1_82 (cost=4.18..12.65 rows=1 width=20) (actual rows= loops=)

  • Recheck Cond: (order_id = transactions_order.id)
  • Filter: (status = 3)
450. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on transactions_externalreturntransaction_order_id_43ad2bf9 (cost=0.00..4.18 rows=4 width=0) (actual rows= loops=)

  • Index Cond: (order_id = transactions_order.id)
451. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=8.59..14.05 rows=1 width=17) (actual rows= loops=)

  • Group Key: u0_83.id
452. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=8.59..14.03 rows=1 width=17) (actual rows= loops=)

  • Join Filter: (u0_83.id = u1_83.order_id)
453. 0.000 0.000 ↓ 0.0

Index Only Scan using transactions_order_pkey on transactions_order u0_83 (cost=0.29..4.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
454. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=8.30..9.71 rows=1 width=17) (actual rows= loops=)

  • Hash Cond: (u2_47.id = u1_83.offering_id)
455. 0.000 0.000 ↓ 0.0

Seq Scan on offerings_offering u2_47 (cost=0.00..1.29 rows=29 width=8) (actual rows= loops=)

456. 0.000 0.000 ↓ 0.0

Hash (cost=8.29..8.29 rows=1 width=17) (actual rows= loops=)

457. 0.000 0.000 ↓ 0.0

Index Scan using offerings_offeringusage_order_id_6f067d93 on offerings_offeringusage u1_83 (cost=0.28..8.29 rows=1 width=17) (actual rows= loops=)

  • Index Cond: (order_id = transactions_order.id)
458. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=4.74..26.97 rows=1 width=32) (actual rows= loops=)

  • Group Key: u0_84.id
459. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=4.74..26.94 rows=1 width=32) (actual rows= loops=)

  • Join Filter: (u1_84.offering_id = u3_3.id)
460. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=4.74..25.29 rows=1 width=32) (actual rows= loops=)

461. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.56..12.61 rows=1 width=12) (actual rows= loops=)

  • Join Filter: (u0_84.id = u1_84.order_id)
462. 0.000 0.000 ↓ 0.0

Index Only Scan using transactions_order_pkey on transactions_order u0_84 (cost=0.29..4.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
463. 0.000 0.000 ↓ 0.0

Index Scan using offerings_offeringusage_order_id_6f067d93 on offerings_offeringusage u1_84 (cost=0.28..8.29 rows=1 width=12) (actual rows= loops=)

  • Index Cond: (order_id = transactions_order.id)
464. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on offerings_offeringusagereturn u2_48 (cost=4.18..12.64 rows=4 width=28) (actual rows= loops=)

  • Recheck Cond: (u1_84.id = offering_usage_id)
465. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on offerings_offeringusagereturn_offering_usage_id_9101d4da (cost=0.00..4.18 rows=4 width=0) (actual rows= loops=)

  • Index Cond: (u1_84.id = offering_usage_id)
466. 0.000 0.000 ↓ 0.0

Seq Scan on offerings_offering u3_3 (cost=0.00..1.29 rows=29 width=8) (actual rows= loops=)

467. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=4.47..16.98 rows=1 width=20) (actual rows= loops=)

  • Group Key: u0_85.id
468. 0.000 0.000 ↓ 0.0

Nested Loop (cost=4.47..16.97 rows=1 width=20) (actual rows= loops=)

469. 0.000 0.000 ↓ 0.0

Index Only Scan using transactions_order_pkey on transactions_order u0_85 (cost=0.29..4.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
470. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on transactions_externalreturntransaction u1_85 (cost=4.18..12.65 rows=1 width=20) (actual rows= loops=)

  • Recheck Cond: (order_id = transactions_order.id)
  • Filter: (status = 3)
471. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on transactions_externalreturntransaction_order_id_43ad2bf9 (cost=0.00..4.18 rows=4 width=0) (actual rows= loops=)

  • Index Cond: (order_id = transactions_order.id)
472. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=8.60..18.19 rows=1 width=9) (actual rows= loops=)

  • Group Key: u0_86.id
473. 0.000 0.000 ↓ 0.0

Nested Loop (cost=8.60..18.17 rows=1 width=9) (actual rows= loops=)

474. 0.000 0.000 ↓ 0.0

Hash Join (cost=8.32..13.85 rows=1 width=9) (actual rows= loops=)

  • Hash Cond: (u2_49.transaction_id = u1_86.id)
475. 0.000 0.000 ↓ 0.0

Seq Scan on transactions_returntransaction u2_49 (cost=0.00..4.99 rows=144 width=9) (actual rows= loops=)

  • Filter: (status = ANY ('{16,15}'::integer[]))
476. 0.000 0.000 ↓ 0.0

Hash (cost=8.30..8.30 rows=1 width=8) (actual rows= loops=)

477. 0.000 0.000 ↓ 0.0

Index Scan using transactions_transaction_order_id_e7f281ee on transactions_transaction u1_86 (cost=0.29..8.30 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (order_id = transactions_order.id)
478. 0.000 0.000 ↓ 0.0

Index Only Scan using transactions_order_pkey on transactions_order u0_86 (cost=0.29..4.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
479. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=8.60..18.19 rows=1 width=9) (actual rows= loops=)

  • Group Key: u0_87.id
480. 0.000 0.000 ↓ 0.0

Nested Loop (cost=8.60..18.17 rows=1 width=9) (actual rows= loops=)

481. 0.000 0.000 ↓ 0.0

Hash Join (cost=8.32..13.85 rows=1 width=9) (actual rows= loops=)

  • Hash Cond: (u2_50.transaction_id = u1_87.id)
482. 0.000 0.000 ↓ 0.0

Seq Scan on transactions_returntransaction u2_50 (cost=0.00..4.99 rows=144 width=9) (actual rows= loops=)

  • Filter: (status = ANY ('{16,15}'::integer[]))
483. 0.000 0.000 ↓ 0.0

Hash (cost=8.30..8.30 rows=1 width=8) (actual rows= loops=)

484. 0.000 0.000 ↓ 0.0

Index Scan using transactions_transaction_order_id_e7f281ee on transactions_transaction u1_87 (cost=0.29..8.30 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (order_id = transactions_order.id)
485. 0.000 0.000 ↓ 0.0

Index Only Scan using transactions_order_pkey on transactions_order u0_87 (cost=0.29..4.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
486. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=4.74..23.92 rows=1 width=20) (actual rows= loops=)

  • Group Key: u0_88.id
487. 0.000 0.000 ↓ 0.0

Nested Loop (cost=4.74..23.91 rows=1 width=20) (actual rows= loops=)

488. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.56..12.61 rows=1 width=8) (actual rows= loops=)

489. 0.000 0.000 ↓ 0.0

Index Only Scan using transactions_order_pkey on transactions_order u0_88 (cost=0.29..4.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
490. 0.000 0.000 ↓ 0.0

Index Scan using sv_cards_svtransaction_order_id_c2882061 on sv_cards_svtransaction u1_88 (cost=0.28..8.29 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (order_id = transactions_order.id)
491. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on sv_cards_svreturntransaction u2_51 (cost=4.17..11.29 rows=1 width=20) (actual rows= loops=)

  • Recheck Cond: (transaction_id = u1_88.id)
  • Filter: (status = ANY ('{16,15}'::integer[]))
492. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on sv_cards_svreturntransaction_sv_transaction_id_ffb7462d (cost=0.00..4.17 rows=3 width=0) (actual rows= loops=)

  • Index Cond: (transaction_id = u1_88.id)
493. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=0.29..10.16 rows=1 width=9) (actual rows= loops=)

  • Group Key: u0_89.id
494. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.29..10.14 rows=1 width=9) (actual rows= loops=)

495. 0.000 0.000 ↓ 0.0

Index Scan using transactions_order_pkey on transactions_order u0_89 (cost=0.29..8.31 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
  • Filter: (flow_type = 1)
496. 0.000 0.000 ↓ 0.0

Seq Scan on sv_cards_svloadtransaction u1_89 (cost=0.00..1.82 rows=1 width=9) (actual rows= loops=)

  • Filter: ((order_id = transactions_order.id) AND (status = 2))
497. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=4.47..16.98 rows=1 width=20) (actual rows= loops=)

  • Group Key: u0_90.id
498. 0.000 0.000 ↓ 0.0

Nested Loop (cost=4.47..16.97 rows=1 width=20) (actual rows= loops=)

499. 0.000 0.000 ↓ 0.0

Index Only Scan using transactions_order_pkey on transactions_order u0_90 (cost=0.29..4.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
500. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on transactions_externalreturntransaction u1_90 (cost=4.18..12.65 rows=1 width=20) (actual rows= loops=)

  • Recheck Cond: (order_id = transactions_order.id)
  • Filter: (status = 3)
501. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on transactions_externalreturntransaction_order_id_43ad2bf9 (cost=0.00..4.18 rows=4 width=0) (actual rows= loops=)

  • Index Cond: (order_id = transactions_order.id)
502. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=8.60..18.19 rows=1 width=9) (actual rows= loops=)

  • Group Key: u0_91.id
503. 0.000 0.000 ↓ 0.0

Nested Loop (cost=8.60..18.17 rows=1 width=9) (actual rows= loops=)

504. 0.000 0.000 ↓ 0.0

Hash Join (cost=8.32..13.85 rows=1 width=9) (actual rows= loops=)

  • Hash Cond: (u2_52.transaction_id = u1_91.id)
505. 0.000 0.000 ↓ 0.0

Seq Scan on transactions_returntransaction u2_52 (cost=0.00..4.99 rows=144 width=9) (actual rows= loops=)

  • Filter: (status = ANY ('{16,15}'::integer[]))
506. 0.000 0.000 ↓ 0.0

Hash (cost=8.30..8.30 rows=1 width=8) (actual rows= loops=)

507. 0.000 0.000 ↓ 0.0

Index Scan using transactions_transaction_order_id_e7f281ee on transactions_transaction u1_91 (cost=0.29..8.30 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (order_id = transactions_order.id)
508. 0.000 0.000 ↓ 0.0

Index Only Scan using transactions_order_pkey on transactions_order u0_91 (cost=0.29..4.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
509. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=4.74..23.92 rows=1 width=20) (actual rows= loops=)

  • Group Key: u0_92.id
510. 0.000 0.000 ↓ 0.0

Nested Loop (cost=4.74..23.91 rows=1 width=20) (actual rows= loops=)

511. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.56..12.61 rows=1 width=8) (actual rows= loops=)

512. 0.000 0.000 ↓ 0.0

Index Only Scan using transactions_order_pkey on transactions_order u0_92 (cost=0.29..4.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
513. 0.000 0.000 ↓ 0.0

Index Scan using sv_cards_svtransaction_order_id_c2882061 on sv_cards_svtransaction u1_92 (cost=0.28..8.29 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (order_id = transactions_order.id)
514. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on sv_cards_svreturntransaction u2_53 (cost=4.17..11.29 rows=1 width=20) (actual rows= loops=)

  • Recheck Cond: (transaction_id = u1_92.id)
  • Filter: (status = ANY ('{16,15}'::integer[]))
515. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on sv_cards_svreturntransaction_sv_transaction_id_ffb7462d (cost=0.00..4.17 rows=3 width=0) (actual rows= loops=)

  • Index Cond: (transaction_id = u1_92.id)
516. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=0.29..10.16 rows=1 width=9) (actual rows= loops=)

  • Group Key: u0_93.id
517. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.29..10.14 rows=1 width=9) (actual rows= loops=)

518. 0.000 0.000 ↓ 0.0

Index Scan using transactions_order_pkey on transactions_order u0_93 (cost=0.29..8.31 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
  • Filter: (flow_type = 1)
519. 0.000 0.000 ↓ 0.0

Seq Scan on sv_cards_svloadtransaction u1_93 (cost=0.00..1.82 rows=1 width=9) (actual rows= loops=)

  • Filter: ((order_id = transactions_order.id) AND (status = 2))
520. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=4.47..16.98 rows=1 width=20) (actual rows= loops=)

  • Group Key: u0_94.id
521. 0.000 0.000 ↓ 0.0

Nested Loop (cost=4.47..16.97 rows=1 width=20) (actual rows= loops=)

522. 0.000 0.000 ↓ 0.0

Index Only Scan using transactions_order_pkey on transactions_order u0_94 (cost=0.29..4.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
523. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on transactions_externalreturntransaction u1_94 (cost=4.18..12.65 rows=1 width=20) (actual rows= loops=)

  • Recheck Cond: (order_id = transactions_order.id)
  • Filter: (status = 3)
524. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on transactions_externalreturntransaction_order_id_43ad2bf9 (cost=0.00..4.18 rows=4 width=0) (actual rows= loops=)

  • Index Cond: (order_id = transactions_order.id)
525. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=8.59..14.05 rows=1 width=17) (actual rows= loops=)

  • Group Key: u0_95.id
526. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=8.59..14.03 rows=1 width=17) (actual rows= loops=)

  • Join Filter: (u0_95.id = u1_95.order_id)
527. 0.000 0.000 ↓ 0.0

Index Only Scan using transactions_order_pkey on transactions_order u0_95 (cost=0.29..4.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
528. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=8.30..9.71 rows=1 width=17) (actual rows= loops=)

  • Hash Cond: (u2_54.id = u1_95.offering_id)
529. 0.000 0.000 ↓ 0.0

Seq Scan on offerings_offering u2_54 (cost=0.00..1.29 rows=29 width=8) (actual rows= loops=)

530. 0.000 0.000 ↓ 0.0

Hash (cost=8.29..8.29 rows=1 width=17) (actual rows= loops=)

531. 0.000 0.000 ↓ 0.0

Index Scan using offerings_offeringusage_order_id_6f067d93 on offerings_offeringusage u1_95 (cost=0.28..8.29 rows=1 width=17) (actual rows= loops=)

  • Index Cond: (order_id = transactions_order.id)
532. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=4.74..26.97 rows=1 width=32) (actual rows= loops=)

  • Group Key: u0_96.id
533. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=4.74..26.94 rows=1 width=32) (actual rows= loops=)

  • Join Filter: (u1_96.offering_id = u3_4.id)
534. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=4.74..25.29 rows=1 width=32) (actual rows= loops=)

535. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.56..12.61 rows=1 width=12) (actual rows= loops=)

  • Join Filter: (u0_96.id = u1_96.order_id)
536. 0.000 0.000 ↓ 0.0

Index Only Scan using transactions_order_pkey on transactions_order u0_96 (cost=0.29..4.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
537. 0.000 0.000 ↓ 0.0

Index Scan using offerings_offeringusage_order_id_6f067d93 on offerings_offeringusage u1_96 (cost=0.28..8.29 rows=1 width=12) (actual rows= loops=)

  • Index Cond: (order_id = transactions_order.id)
538. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on offerings_offeringusagereturn u2_55 (cost=4.18..12.64 rows=4 width=28) (actual rows= loops=)

  • Recheck Cond: (u1_96.id = offering_usage_id)
539. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on offerings_offeringusagereturn_offering_usage_id_9101d4da (cost=0.00..4.18 rows=4 width=0) (actual rows= loops=)

  • Index Cond: (u1_96.id = offering_usage_id)
540. 0.000 0.000 ↓ 0.0

Seq Scan on offerings_offering u3_4 (cost=0.00..1.29 rows=29 width=8) (actual rows= loops=)

541. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=4.74..23.92 rows=1 width=20) (actual rows= loops=)

  • Group Key: u0_97.id
542. 0.000 0.000 ↓ 0.0

Nested Loop (cost=4.74..23.91 rows=1 width=20) (actual rows= loops=)

543. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.56..12.61 rows=1 width=8) (actual rows= loops=)

544. 0.000 0.000 ↓ 0.0

Index Only Scan using transactions_order_pkey on transactions_order u0_97 (cost=0.29..4.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
545. 0.000 0.000 ↓ 0.0

Index Scan using sv_cards_svtransaction_order_id_c2882061 on sv_cards_svtransaction u1_97 (cost=0.28..8.29 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (order_id = transactions_order.id)
546. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on sv_cards_svreturntransaction u2_56 (cost=4.17..11.29 rows=1 width=20) (actual rows= loops=)

  • Recheck Cond: (transaction_id = u1_97.id)
  • Filter: (status = ANY ('{16,15}'::integer[]))
547. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on sv_cards_svreturntransaction_sv_transaction_id_ffb7462d (cost=0.00..4.17 rows=3 width=0) (actual rows= loops=)

  • Index Cond: (transaction_id = u1_97.id)
548. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=0.29..10.16 rows=1 width=9) (actual rows= loops=)

  • Group Key: u0_98.id
549. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.29..10.14 rows=1 width=9) (actual rows= loops=)

550. 0.000 0.000 ↓ 0.0

Index Scan using transactions_order_pkey on transactions_order u0_98 (cost=0.29..8.31 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
  • Filter: (flow_type = 1)
551. 0.000 0.000 ↓ 0.0

Seq Scan on sv_cards_svloadtransaction u1_98 (cost=0.00..1.82 rows=1 width=9) (actual rows= loops=)

  • Filter: ((order_id = transactions_order.id) AND (status = 2))
552. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=8.60..18.19 rows=1 width=9) (actual rows= loops=)

  • Group Key: u0_99.id
553. 0.000 0.000 ↓ 0.0

Nested Loop (cost=8.60..18.17 rows=1 width=9) (actual rows= loops=)

554. 0.000 0.000 ↓ 0.0

Hash Join (cost=8.32..13.85 rows=1 width=9) (actual rows= loops=)

  • Hash Cond: (u2_57.transaction_id = u1_99.id)
555. 0.000 0.000 ↓ 0.0

Seq Scan on transactions_returntransaction u2_57 (cost=0.00..4.99 rows=144 width=9) (actual rows= loops=)

  • Filter: (status = ANY ('{16,15}'::integer[]))
556. 0.000 0.000 ↓ 0.0

Hash (cost=8.30..8.30 rows=1 width=8) (actual rows= loops=)

557. 0.000 0.000 ↓ 0.0

Index Scan using transactions_transaction_order_id_e7f281ee on transactions_transaction u1_99 (cost=0.29..8.30 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (order_id = transactions_order.id)
558. 0.000 0.000 ↓ 0.0

Index Only Scan using transactions_order_pkey on transactions_order u0_99 (cost=0.29..4.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
559. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=4.74..23.92 rows=1 width=20) (actual rows= loops=)

  • Group Key: u0_100.id
560. 0.000 0.000 ↓ 0.0

Nested Loop (cost=4.74..23.91 rows=1 width=20) (actual rows= loops=)

561. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.56..12.61 rows=1 width=8) (actual rows= loops=)

562. 0.000 0.000 ↓ 0.0

Index Only Scan using transactions_order_pkey on transactions_order u0_100 (cost=0.29..4.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
563. 0.000 0.000 ↓ 0.0

Index Scan using sv_cards_svtransaction_order_id_c2882061 on sv_cards_svtransaction u1_100 (cost=0.28..8.29 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (order_id = transactions_order.id)
564. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on sv_cards_svreturntransaction u2_58 (cost=4.17..11.29 rows=1 width=20) (actual rows= loops=)

  • Recheck Cond: (transaction_id = u1_100.id)
  • Filter: (status = ANY ('{16,15}'::integer[]))
565. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on sv_cards_svreturntransaction_sv_transaction_id_ffb7462d (cost=0.00..4.17 rows=3 width=0) (actual rows= loops=)

  • Index Cond: (transaction_id = u1_100.id)
566. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=0.29..10.16 rows=1 width=9) (actual rows= loops=)

  • Group Key: u0_101.id
567. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.29..10.14 rows=1 width=9) (actual rows= loops=)

568. 0.000 0.000 ↓ 0.0

Index Scan using transactions_order_pkey on transactions_order u0_101 (cost=0.29..8.31 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
  • Filter: (flow_type = 1)
569. 0.000 0.000 ↓ 0.0

Seq Scan on sv_cards_svloadtransaction u1_101 (cost=0.00..1.82 rows=1 width=9) (actual rows= loops=)

  • Filter: ((order_id = transactions_order.id) AND (status = 2))
570. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=4.47..16.98 rows=1 width=20) (actual rows= loops=)

  • Group Key: u0_102.id
571. 0.000 0.000 ↓ 0.0

Nested Loop (cost=4.47..16.97 rows=1 width=20) (actual rows= loops=)

572. 0.000 0.000 ↓ 0.0

Index Only Scan using transactions_order_pkey on transactions_order u0_102 (cost=0.29..4.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
573. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on transactions_externalreturntransaction u1_102 (cost=4.18..12.65 rows=1 width=20) (actual rows= loops=)

  • Recheck Cond: (order_id = transactions_order.id)
  • Filter: (status = 3)
574. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on transactions_externalreturntransaction_order_id_43ad2bf9 (cost=0.00..4.18 rows=4 width=0) (actual rows= loops=)

  • Index Cond: (order_id = transactions_order.id)
575. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=4.48..22.71 rows=1 width=8) (actual rows= loops=)

  • Group Key: u0_103.id
576. 0.000 0.000 ↓ 0.0

Nested Loop (cost=4.48..22.69 rows=1 width=8) (actual rows= loops=)

577. 0.000 0.000 ↓ 0.0

Index Only Scan using merchants_applicationuserprofile_pkey on merchants_applicationuserprofile u0_103 (cost=0.28..8.29 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.app_user_id)
578. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on badges_usertag u1_103 (cost=4.21..14.39 rows=1 width=8) (actual rows= loops=)

  • Recheck Cond: (app_user_id = transactions_order.app_user_id)
  • Filter: (((archived_at >= transactions_order.submit_timestamp) OR (archived_at IS NULL)) AND (created_at <= transactions_order.submit_timestamp))
579. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on badges_usertag_app_user_id_tag_id_archi_0e88207c_uniq (cost=0.00..4.21 rows=7 width=0) (actual rows= loops=)

  • Index Cond: (app_user_id = transactions_order.app_user_id)
580. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=4.44..15.62 rows=1 width=8) (actual rows= loops=)

  • Group Key: u0_104.id
581. 0.000 0.000 ↓ 0.0

Nested Loop (cost=4.44..15.60 rows=1 width=8) (actual rows= loops=)

582. 0.000 0.000 ↓ 0.0

Index Only Scan using merchants_applicationuserprofile_pkey on merchants_applicationuserprofile u0_104 (cost=0.28..8.29 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.app_user_id)
583. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on badges_userbadge u1_104 (cost=4.16..7.30 rows=1 width=8) (actual rows= loops=)

  • Recheck Cond: (app_user_id = transactions_order.app_user_id)
  • Filter: (((archived_at >= transactions_order.submit_timestamp) OR (archived_at IS NULL)) AND (created_at <= transactions_order.submit_timestamp))
584. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on badges_userbadge_user_id_77032e2b (cost=0.00..4.16 rows=2 width=0) (actual rows= loops=)

  • Index Cond: (app_user_id = transactions_order.app_user_id)
585.          

SubPlan (forHashAggregate)

586. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=4.47..16.98 rows=1 width=20) (actual rows= loops=)

  • Group Key: u0_41.id
587. 0.000 0.000 ↓ 0.0

Nested Loop (cost=4.47..16.97 rows=1 width=20) (actual rows= loops=)

588. 0.000 0.000 ↓ 0.0

Index Only Scan using transactions_order_pkey on transactions_order u0_41 (cost=0.29..4.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
589. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on transactions_externalreturntransaction u1_41 (cost=4.18..12.65 rows=1 width=20) (actual rows= loops=)

  • Recheck Cond: (order_id = transactions_order.id)
  • Filter: (status = 3)
590. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on transactions_externalreturntransaction_order_id_43ad2bf9 (cost=0.00..4.18 rows=4 width=0) (actual rows= loops=)

  • Index Cond: (order_id = transactions_order.id)
591. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=8.60..18.19 rows=1 width=9) (actual rows= loops=)

  • Group Key: u0_42.id
592. 0.000 0.000 ↓ 0.0

Nested Loop (cost=8.60..18.17 rows=1 width=9) (actual rows= loops=)

593. 0.000 0.000 ↓ 0.0

Hash Join (cost=8.32..13.85 rows=1 width=9) (actual rows= loops=)

  • Hash Cond: (u2_26.transaction_id = u1_42.id)
594. 0.000 0.000 ↓ 0.0

Seq Scan on transactions_returntransaction u2_26 (cost=0.00..4.99 rows=144 width=9) (actual rows= loops=)

  • Filter: (status = ANY ('{16,15}'::integer[]))
595. 0.000 0.000 ↓ 0.0

Hash (cost=8.30..8.30 rows=1 width=8) (actual rows= loops=)

596. 0.000 0.000 ↓ 0.0

Index Scan using transactions_transaction_order_id_e7f281ee on transactions_transaction u1_42 (cost=0.29..8.30 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (order_id = transactions_order.id)
597. 0.000 0.000 ↓ 0.0

Index Only Scan using transactions_order_pkey on transactions_order u0_42 (cost=0.29..4.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
598. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=8.60..18.19 rows=1 width=9) (actual rows= loops=)

  • Group Key: u0_43.id
599. 0.000 0.000 ↓ 0.0

Nested Loop (cost=8.60..18.17 rows=1 width=9) (actual rows= loops=)

600. 0.000 0.000 ↓ 0.0

Hash Join (cost=8.32..13.85 rows=1 width=9) (actual rows= loops=)

  • Hash Cond: (u2_27.transaction_id = u1_43.id)
601. 0.000 0.000 ↓ 0.0

Seq Scan on transactions_returntransaction u2_27 (cost=0.00..4.99 rows=144 width=9) (actual rows= loops=)

  • Filter: (status = ANY ('{16,15}'::integer[]))
602. 0.000 0.000 ↓ 0.0

Hash (cost=8.30..8.30 rows=1 width=8) (actual rows= loops=)

603. 0.000 0.000 ↓ 0.0

Index Scan using transactions_transaction_order_id_e7f281ee on transactions_transaction u1_43 (cost=0.29..8.30 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (order_id = transactions_order.id)
604. 0.000 0.000 ↓ 0.0

Index Only Scan using transactions_order_pkey on transactions_order u0_43 (cost=0.29..4.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
605. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=4.74..23.92 rows=1 width=20) (actual rows= loops=)

  • Group Key: u0_44.id
606. 0.000 0.000 ↓ 0.0

Nested Loop (cost=4.74..23.91 rows=1 width=20) (actual rows= loops=)

607. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.56..12.61 rows=1 width=8) (actual rows= loops=)

608. 0.000 0.000 ↓ 0.0

Index Only Scan using transactions_order_pkey on transactions_order u0_44 (cost=0.29..4.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
609. 0.000 0.000 ↓ 0.0

Index Scan using sv_cards_svtransaction_order_id_c2882061 on sv_cards_svtransaction u1_44 (cost=0.28..8.29 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (order_id = transactions_order.id)
610. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on sv_cards_svreturntransaction u2_28 (cost=4.17..11.29 rows=1 width=20) (actual rows= loops=)

  • Recheck Cond: (transaction_id = u1_44.id)
  • Filter: (status = ANY ('{16,15}'::integer[]))
611. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on sv_cards_svreturntransaction_sv_transaction_id_ffb7462d (cost=0.00..4.17 rows=3 width=0) (actual rows= loops=)

  • Index Cond: (transaction_id = u1_44.id)
612. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=0.29..10.16 rows=1 width=9) (actual rows= loops=)

  • Group Key: u0_45.id
613. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.29..10.14 rows=1 width=9) (actual rows= loops=)

614. 0.000 0.000 ↓ 0.0

Index Scan using transactions_order_pkey on transactions_order u0_45 (cost=0.29..8.31 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
  • Filter: (flow_type = 1)
615. 0.000 0.000 ↓ 0.0

Seq Scan on sv_cards_svloadtransaction u1_45 (cost=0.00..1.82 rows=1 width=9) (actual rows= loops=)

  • Filter: ((order_id = transactions_order.id) AND (status = 2))
616. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=4.47..16.98 rows=1 width=20) (actual rows= loops=)

  • Group Key: u0_46.id
617. 0.000 0.000 ↓ 0.0

Nested Loop (cost=4.47..16.97 rows=1 width=20) (actual rows= loops=)

618. 0.000 0.000 ↓ 0.0

Index Only Scan using transactions_order_pkey on transactions_order u0_46 (cost=0.29..4.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
619. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on transactions_externalreturntransaction u1_46 (cost=4.18..12.65 rows=1 width=20) (actual rows= loops=)

  • Recheck Cond: (order_id = transactions_order.id)
  • Filter: (status = 3)
620. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on transactions_externalreturntransaction_order_id_43ad2bf9 (cost=0.00..4.18 rows=4 width=0) (actual rows= loops=)

  • Index Cond: (order_id = transactions_order.id)
621. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=8.60..18.19 rows=1 width=9) (actual rows= loops=)

  • Group Key: u0_47.id
622. 0.000 0.000 ↓ 0.0

Nested Loop (cost=8.60..18.17 rows=1 width=9) (actual rows= loops=)

623. 0.000 0.000 ↓ 0.0

Hash Join (cost=8.32..13.85 rows=1 width=9) (actual rows= loops=)

  • Hash Cond: (u2_29.transaction_id = u1_47.id)
624. 0.000 0.000 ↓ 0.0

Seq Scan on transactions_returntransaction u2_29 (cost=0.00..4.99 rows=144 width=9) (actual rows= loops=)

  • Filter: (status = ANY ('{16,15}'::integer[]))
625. 0.000 0.000 ↓ 0.0

Hash (cost=8.30..8.30 rows=1 width=8) (actual rows= loops=)

626. 0.000 0.000 ↓ 0.0

Index Scan using transactions_transaction_order_id_e7f281ee on transactions_transaction u1_47 (cost=0.29..8.30 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (order_id = transactions_order.id)
627. 0.000 0.000 ↓ 0.0

Index Only Scan using transactions_order_pkey on transactions_order u0_47 (cost=0.29..4.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
628. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=4.74..23.92 rows=1 width=20) (actual rows= loops=)

  • Group Key: u0_48.id
629. 0.000 0.000 ↓ 0.0

Nested Loop (cost=4.74..23.91 rows=1 width=20) (actual rows= loops=)

630. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.56..12.61 rows=1 width=8) (actual rows= loops=)

631. 0.000 0.000 ↓ 0.0

Index Only Scan using transactions_order_pkey on transactions_order u0_48 (cost=0.29..4.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
632. 0.000 0.000 ↓ 0.0

Index Scan using sv_cards_svtransaction_order_id_c2882061 on sv_cards_svtransaction u1_48 (cost=0.28..8.29 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (order_id = transactions_order.id)
633. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on sv_cards_svreturntransaction u2_30 (cost=4.17..11.29 rows=1 width=20) (actual rows= loops=)

  • Recheck Cond: (transaction_id = u1_48.id)
  • Filter: (status = ANY ('{16,15}'::integer[]))
634. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on sv_cards_svreturntransaction_sv_transaction_id_ffb7462d (cost=0.00..4.17 rows=3 width=0) (actual rows= loops=)

  • Index Cond: (transaction_id = u1_48.id)
635. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=0.29..10.16 rows=1 width=9) (actual rows= loops=)

  • Group Key: u0_49.id
636. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.29..10.14 rows=1 width=9) (actual rows= loops=)

637. 0.000 0.000 ↓ 0.0

Index Scan using transactions_order_pkey on transactions_order u0_49 (cost=0.29..8.31 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
  • Filter: (flow_type = 1)
638. 0.000 0.000 ↓ 0.0

Seq Scan on sv_cards_svloadtransaction u1_49 (cost=0.00..1.82 rows=1 width=9) (actual rows= loops=)

  • Filter: ((order_id = transactions_order.id) AND (status = 2))
639. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=4.47..16.98 rows=1 width=20) (actual rows= loops=)

  • Group Key: u0_50.id
640. 0.000 0.000 ↓ 0.0

Nested Loop (cost=4.47..16.97 rows=1 width=20) (actual rows= loops=)

641. 0.000 0.000 ↓ 0.0

Index Only Scan using transactions_order_pkey on transactions_order u0_50 (cost=0.29..4.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
642. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on transactions_externalreturntransaction u1_50 (cost=4.18..12.65 rows=1 width=20) (actual rows= loops=)

  • Recheck Cond: (order_id = transactions_order.id)
  • Filter: (status = 3)
643. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on transactions_externalreturntransaction_order_id_43ad2bf9 (cost=0.00..4.18 rows=4 width=0) (actual rows= loops=)

  • Index Cond: (order_id = transactions_order.id)
644. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=4.47..16.98 rows=1 width=20) (actual rows= loops=)

  • Group Key: u0_57.id
645. 0.000 0.000 ↓ 0.0

Nested Loop (cost=4.47..16.97 rows=1 width=20) (actual rows= loops=)

646. 0.000 0.000 ↓ 0.0

Index Only Scan using transactions_order_pkey on transactions_order u0_57 (cost=0.29..4.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
647. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on transactions_externalreturntransaction u1_57 (cost=4.18..12.65 rows=1 width=20) (actual rows= loops=)

  • Recheck Cond: (order_id = transactions_order.id)
  • Filter: (status = 3)
648. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on transactions_externalreturntransaction_order_id_43ad2bf9 (cost=0.00..4.18 rows=4 width=0) (actual rows= loops=)

  • Index Cond: (order_id = transactions_order.id)
649. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=8.60..18.19 rows=1 width=9) (actual rows= loops=)

  • Group Key: u0_58.id
650. 0.000 0.000 ↓ 0.0

Nested Loop (cost=8.60..18.17 rows=1 width=9) (actual rows= loops=)

651. 0.000 0.000 ↓ 0.0

Hash Join (cost=8.32..13.85 rows=1 width=9) (actual rows= loops=)

  • Hash Cond: (u2_34.transaction_id = u1_58.id)
652. 0.000 0.000 ↓ 0.0

Seq Scan on transactions_returntransaction u2_34 (cost=0.00..4.99 rows=144 width=9) (actual rows= loops=)

  • Filter: (status = ANY ('{16,15}'::integer[]))
653. 0.000 0.000 ↓ 0.0

Hash (cost=8.30..8.30 rows=1 width=8) (actual rows= loops=)

654. 0.000 0.000 ↓ 0.0

Index Scan using transactions_transaction_order_id_e7f281ee on transactions_transaction u1_58 (cost=0.29..8.30 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (order_id = transactions_order.id)
655. 0.000 0.000 ↓ 0.0

Index Only Scan using transactions_order_pkey on transactions_order u0_58 (cost=0.29..4.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
656. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=8.60..18.19 rows=1 width=9) (actual rows= loops=)

  • Group Key: u0_59.id
657. 0.000 0.000 ↓ 0.0

Nested Loop (cost=8.60..18.17 rows=1 width=9) (actual rows= loops=)

658. 0.000 0.000 ↓ 0.0

Hash Join (cost=8.32..13.85 rows=1 width=9) (actual rows= loops=)

  • Hash Cond: (u2_35.transaction_id = u1_59.id)
659. 0.000 0.000 ↓ 0.0

Seq Scan on transactions_returntransaction u2_35 (cost=0.00..4.99 rows=144 width=9) (actual rows= loops=)

  • Filter: (status = ANY ('{16,15}'::integer[]))
660. 0.000 0.000 ↓ 0.0

Hash (cost=8.30..8.30 rows=1 width=8) (actual rows= loops=)

661. 0.000 0.000 ↓ 0.0

Index Scan using transactions_transaction_order_id_e7f281ee on transactions_transaction u1_59 (cost=0.29..8.30 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (order_id = transactions_order.id)
662. 0.000 0.000 ↓ 0.0

Index Only Scan using transactions_order_pkey on transactions_order u0_59 (cost=0.29..4.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
663. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=4.74..23.92 rows=1 width=20) (actual rows= loops=)

  • Group Key: u0_60.id
664. 0.000 0.000 ↓ 0.0

Nested Loop (cost=4.74..23.91 rows=1 width=20) (actual rows= loops=)

665. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.56..12.61 rows=1 width=8) (actual rows= loops=)

666. 0.000 0.000 ↓ 0.0

Index Only Scan using transactions_order_pkey on transactions_order u0_60 (cost=0.29..4.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
667. 0.000 0.000 ↓ 0.0

Index Scan using sv_cards_svtransaction_order_id_c2882061 on sv_cards_svtransaction u1_60 (cost=0.28..8.29 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (order_id = transactions_order.id)
668. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on sv_cards_svreturntransaction u2_36 (cost=4.17..11.29 rows=1 width=20) (actual rows= loops=)

  • Recheck Cond: (transaction_id = u1_60.id)
  • Filter: (status = ANY ('{16,15}'::integer[]))
669. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on sv_cards_svreturntransaction_sv_transaction_id_ffb7462d (cost=0.00..4.17 rows=3 width=0) (actual rows= loops=)

  • Index Cond: (transaction_id = u1_60.id)
670. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=0.29..10.16 rows=1 width=9) (actual rows= loops=)

  • Group Key: u0_61.id
671. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.29..10.14 rows=1 width=9) (actual rows= loops=)

672. 0.000 0.000 ↓ 0.0

Index Scan using transactions_order_pkey on transactions_order u0_61 (cost=0.29..8.31 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
  • Filter: (flow_type = 1)
673. 0.000 0.000 ↓ 0.0

Seq Scan on sv_cards_svloadtransaction u1_61 (cost=0.00..1.82 rows=1 width=9) (actual rows= loops=)

  • Filter: ((order_id = transactions_order.id) AND (status = 2))
674. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=4.47..16.98 rows=1 width=20) (actual rows= loops=)

  • Group Key: u0_62.id
675. 0.000 0.000 ↓ 0.0

Nested Loop (cost=4.47..16.97 rows=1 width=20) (actual rows= loops=)

676. 0.000 0.000 ↓ 0.0

Index Only Scan using transactions_order_pkey on transactions_order u0_62 (cost=0.29..4.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
677. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on transactions_externalreturntransaction u1_62 (cost=4.18..12.65 rows=1 width=20) (actual rows= loops=)

  • Recheck Cond: (order_id = transactions_order.id)
  • Filter: (status = 3)
678. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on transactions_externalreturntransaction_order_id_43ad2bf9 (cost=0.00..4.18 rows=4 width=0) (actual rows= loops=)

  • Index Cond: (order_id = transactions_order.id)
679. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=8.60..18.19 rows=1 width=9) (actual rows= loops=)

  • Group Key: u0_63.id
680. 0.000 0.000 ↓ 0.0

Nested Loop (cost=8.60..18.17 rows=1 width=9) (actual rows= loops=)

681. 0.000 0.000 ↓ 0.0

Hash Join (cost=8.32..13.85 rows=1 width=9) (actual rows= loops=)

  • Hash Cond: (u2_37.transaction_id = u1_63.id)
682. 0.000 0.000 ↓ 0.0

Seq Scan on transactions_returntransaction u2_37 (cost=0.00..4.99 rows=144 width=9) (actual rows= loops=)

  • Filter: (status = ANY ('{16,15}'::integer[]))
683. 0.000 0.000 ↓ 0.0

Hash (cost=8.30..8.30 rows=1 width=8) (actual rows= loops=)

684. 0.000 0.000 ↓ 0.0

Index Scan using transactions_transaction_order_id_e7f281ee on transactions_transaction u1_63 (cost=0.29..8.30 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (order_id = transactions_order.id)
685. 0.000 0.000 ↓ 0.0

Index Only Scan using transactions_order_pkey on transactions_order u0_63 (cost=0.29..4.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
686. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=4.74..23.92 rows=1 width=20) (actual rows= loops=)

  • Group Key: u0_64.id
687. 0.000 0.000 ↓ 0.0

Nested Loop (cost=4.74..23.91 rows=1 width=20) (actual rows= loops=)

688. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.56..12.61 rows=1 width=8) (actual rows= loops=)

689. 0.000 0.000 ↓ 0.0

Index Only Scan using transactions_order_pkey on transactions_order u0_64 (cost=0.29..4.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
690. 0.000 0.000 ↓ 0.0

Index Scan using sv_cards_svtransaction_order_id_c2882061 on sv_cards_svtransaction u1_64 (cost=0.28..8.29 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (order_id = transactions_order.id)
691. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on sv_cards_svreturntransaction u2_38 (cost=4.17..11.29 rows=1 width=20) (actual rows= loops=)

  • Recheck Cond: (transaction_id = u1_64.id)
  • Filter: (status = ANY ('{16,15}'::integer[]))
692. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on sv_cards_svreturntransaction_sv_transaction_id_ffb7462d (cost=0.00..4.17 rows=3 width=0) (actual rows= loops=)

  • Index Cond: (transaction_id = u1_64.id)
693. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=0.29..10.16 rows=1 width=9) (actual rows= loops=)

  • Group Key: u0_65.id
694. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.29..10.14 rows=1 width=9) (actual rows= loops=)

695. 0.000 0.000 ↓ 0.0

Index Scan using transactions_order_pkey on transactions_order u0_65 (cost=0.29..8.31 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
  • Filter: (flow_type = 1)
696. 0.000 0.000 ↓ 0.0

Seq Scan on sv_cards_svloadtransaction u1_65 (cost=0.00..1.82 rows=1 width=9) (actual rows= loops=)

  • Filter: ((order_id = transactions_order.id) AND (status = 2))
697. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=4.47..16.98 rows=1 width=20) (actual rows= loops=)

  • Group Key: u0_66.id
698. 0.000 0.000 ↓ 0.0

Nested Loop (cost=4.47..16.97 rows=1 width=20) (actual rows= loops=)

699. 0.000 0.000 ↓ 0.0

Index Only Scan using transactions_order_pkey on transactions_order u0_66 (cost=0.29..4.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
700. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on transactions_externalreturntransaction u1_66 (cost=4.18..12.65 rows=1 width=20) (actual rows= loops=)

  • Recheck Cond: (order_id = transactions_order.id)
  • Filter: (status = 3)
701. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on transactions_externalreturntransaction_order_id_43ad2bf9 (cost=0.00..4.18 rows=4 width=0) (actual rows= loops=)

  • Index Cond: (order_id = transactions_order.id)
702. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=0.56..12.63 rows=1 width=13) (actual rows= loops=)

  • Group Key: u0_105.id
703. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.56..12.61 rows=1 width=13) (actual rows= loops=)

  • Join Filter: (u0_105.id = u1_105.order_id)
704. 0.000 0.000 ↓ 0.0

Index Only Scan using transactions_order_pkey on transactions_order u0_105 (cost=0.29..4.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = transactions_order.id)
705. 0.000 0.000 ↓ 0.0

Index Scan using offerings_offeringusage_order_id_6f067d93 on offerings_offeringusage u1_105 (cost=0.28..8.29 rows=1 width=13) (actual rows= loops=)

  • Index Cond: (order_id = transactions_order.id)