explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BR2X : v3

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 31,866.463 ↑ 1.0 20 1

Limit (cost=33,620,095.86..33,620,104.76 rows=20 width=2,863) (actual time=31,866.402..31,866.463 rows=20 loops=1)

2. 0.055 31,866.458 ↑ 900.5 20 1

Unique (cost=33,620,095.86..33,628,110.31 rows=18,010 width=2,863) (actual time=31,866.400..31,866.458 rows=20 loops=1)

3. 137.217 31,866.403 ↑ 900.5 20 1

Sort (cost=33,620,095.86..33,620,140.89 rows=18,010 width=2,863) (actual time=31,866.399..31,866.403 rows=20 loops=1)

  • 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_ (...)
  • Sort Method: external merge Disk: 15560kB
4. 2,673.066 31,729.186 ↑ 1.0 18,010 1

Hash Left Join (cost=941.77..33,596,597.87 rows=18,010 width=2,863) (actual time=59.720..31,729.186 rows=18,010 loops=1)

  • Hash Cond: (transactions_order.event_id = venues_event.id)
5. 26.083 194.607 ↑ 1.0 18,010 1

Hash Left Join (cost=926.05..4,388.61 rows=18,010 width=2,624) (actual time=11.976..194.607 rows=18,010 loops=1)

  • Hash Cond: (venues_pointofsale.revenue_center_id = venues_revenuecenter.id)
6. 16.266 168.513 ↑ 1.0 18,010 1

Hash Left Join (cost=912.22..4,233.87 rows=18,010 width=2,180) (actual time=11.960..168.513 rows=18,010 loops=1)

  • Hash Cond: (transactions_order.spot_id = venues_spot.id)
7. 17.303 152.221 ↑ 1.0 18,010 1

Hash Left Join (cost=909.67..4,159.18 rows=18,010 width=2,168) (actual time=11.931..152.221 rows=18,010 loops=1)

  • Hash Cond: (transactions_order.section_id = venues_section.id)
8. 30.910 134.895 ↑ 1.0 18,010 1

Hash Join (cost=907.25..4,077.84 rows=18,010 width=2,123) (actual time=11.905..134.895 rows=18,010 loops=1)

  • Hash Cond: (transactions_order.point_of_sale_id = venues_pointofsale.id)
9. 15.424 103.849 ↑ 1.0 18,010 1

Hash Left Join (cost=841.58..3,764.52 rows=18,010 width=1,434) (actual time=11.762..103.849 rows=18,010 loops=1)

  • Hash Cond: (transactions_order.seat_id = venues_seat.id)
10. 32.486 88.418 ↑ 1.0 18,010 1

Hash Left Join (cost=825.05..3,680.41 rows=18,010 width=1,188) (actual time=11.741..88.418 rows=18,010 loops=1)

  • Hash Cond: (transactions_order.credit_card_config_id = payments_creditcardconfig.id)
11. 25.965 49.255 ↑ 1.0 18,010 1

Hash Join (cost=555.23..3,176.43 rows=18,010 width=650) (actual time=5.051..49.255 rows=18,010 loops=1)

  • Hash Cond: (transactions_order.id = mlc_mlcorder.order_id)
12. 18.448 18.448 ↑ 1.0 22,553 1

Seq Scan on transactions_order (cost=0.00..2,356.53 rows=22,553 width=650) (actual time=0.058..18.448 rows=22,553 loops=1)

13. 2.144 4.842 ↑ 1.0 18,010 1

Hash (cost=330.10..330.10 rows=18,010 width=4) (actual time=4.842..4.842 rows=18,010 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 890kB
14. 2.698 2.698 ↑ 1.0 18,010 1

Seq Scan on mlc_mlcorder (cost=0.00..330.10 rows=18,010 width=4) (actual time=0.005..2.698 rows=18,010 loops=1)

  • Filter: (id IS NOT NULL)
15. 0.915 6.677 ↑ 1.0 1,858 1

Hash (cost=246.60..246.60 rows=1,858 width=538) (actual time=6.677..6.677 rows=1,858 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 554kB
16. 0.744 5.762 ↑ 1.0 1,858 1

Hash Left Join (cost=158.92..246.60 rows=1,858 width=538) (actual time=2.035..5.762 rows=1,858 loops=1)

  • Hash Cond: (payments_creditcard.app_user_id = t6.id)
17. 2.814 3.941 ↑ 1.0 1,858 1

Hash Left Join (cost=74.67..136.80 rows=1,858 width=407) (actual time=0.952..3.941 rows=1,858 loops=1)

  • Hash Cond: (payments_creditcardconfig.credit_card_id = payments_creditcard.id)
18. 0.184 0.184 ↑ 1.0 1,858 1

Seq Scan on payments_creditcardconfig (cost=0.00..36.58 rows=1,858 width=319) (actual time=0.004..0.184 rows=1,858 loops=1)

19. 0.452 0.943 ↑ 1.0 1,941 1

Hash (cost=50.41..50.41 rows=1,941 width=88) (actual time=0.943..0.943 rows=1,941 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 257kB
20. 0.491 0.491 ↑ 1.0 1,941 1

Seq Scan on payments_creditcard (cost=0.00..50.41 rows=1,941 width=88) (actual time=0.004..0.491 rows=1,941 loops=1)

21. 0.216 1.077 ↓ 1.0 1,108 1

Hash (cost=70.41..70.41 rows=1,107 width=131) (actual time=1.077..1.077 rows=1,108 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 120kB
22. 0.277 0.861 ↓ 1.0 1,108 1

Hash Left Join (cost=44.25..70.41 rows=1,107 width=131) (actual time=0.513..0.861 rows=1,108 loops=1)

  • Hash Cond: (t6.user_id = userprofiles_userprofile.id)
23. 0.079 0.079 ↓ 1.0 1,108 1

Seq Scan on merchants_applicationuserprofile t6 (cost=0.00..17.07 rows=1,107 width=28) (actual time=0.004..0.079 rows=1,108 loops=1)

24. 0.143 0.505 ↓ 1.0 551 1

Hash (cost=37.39..37.39 rows=549 width=103) (actual time=0.505..0.505 rows=551 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 86kB
25. 0.178 0.362 ↓ 1.0 551 1

Hash Right Join (cost=15.35..37.39 rows=549 width=103) (actual time=0.147..0.362 rows=551 loops=1)

  • Hash Cond: (auth_user.id = userprofiles_userprofile.user_id)
26. 0.043 0.043 ↓ 1.0 551 1

Seq Scan on auth_user (cost=0.00..14.49 rows=549 width=93) (actual time=0.002..0.043 rows=551 loops=1)

27. 0.065 0.141 ↓ 1.0 551 1

Hash (cost=8.49..8.49 rows=549 width=10) (actual time=0.141..0.141 rows=551 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 31kB
28. 0.076 0.076 ↓ 1.0 551 1

Seq Scan on userprofiles_userprofile (cost=0.00..8.49 rows=549 width=10) (actual time=0.005..0.076 rows=551 loops=1)

29. 0.001 0.007 ↑ 26.4 11 1

Hash (cost=12.90..12.90 rows=290 width=246) (actual time=0.007..0.007 rows=11 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
30. 0.006 0.006 ↑ 26.4 11 1

Seq Scan on venues_seat (cost=0.00..12.90 rows=290 width=246) (actual time=0.003..0.006 rows=11 loops=1)

31. 0.016 0.136 ↓ 1.0 28 1

Hash (cost=65.34..65.34 rows=27 width=689) (actual time=0.136..0.136 rows=28 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 15kB
32. 0.004 0.120 ↓ 1.0 28 1

Nested Loop (cost=51.80..65.34 rows=27 width=689) (actual time=0.042..0.120 rows=28 loops=1)

33. 0.015 0.088 ↓ 1.0 28 1

Nested Loop (cost=51.65..59.26 rows=27 width=679) (actual time=0.039..0.088 rows=28 loops=1)

34. 0.010 0.045 ↓ 1.0 28 1

Hash Join (cost=51.50..53.39 rows=27 width=395) (actual time=0.028..0.045 rows=28 loops=1)

  • Hash Cond: (venues_pointofsale.payment_gateway_settings_id = payments_merchantpaymentgatewaysettings.id)
35. 0.010 0.029 ↓ 1.0 28 1

Hash Left Join (cost=16.07..17.60 rows=27 width=351) (actual time=0.020..0.029 rows=28 loops=1)

  • Hash Cond: (venues_pointofsale.venue_id = venues_venue.id)
36. 0.011 0.011 ↓ 1.0 28 1

Seq Scan on venues_pointofsale (cost=0.00..1.27 rows=27 width=85) (actual time=0.007..0.011 rows=28 loops=1)

37. 0.005 0.008 ↑ 38.6 7 1

Hash (cost=12.70..12.70 rows=270 width=266) (actual time=0.008..0.008 rows=7 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
38. 0.003 0.003 ↑ 38.6 7 1

Seq Scan on venues_venue (cost=0.00..12.70 rows=270 width=266) (actual time=0.002..0.003 rows=7 loops=1)

39. 0.002 0.006 ↑ 80.7 14 1

Hash (cost=21.30..21.30 rows=1,130 width=44) (actual time=0.006..0.006 rows=14 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 18kB
40. 0.004 0.004 ↑ 80.7 14 1

Seq Scan on payments_merchantpaymentgatewaysettings (cost=0.00..21.30 rows=1,130 width=44) (actual time=0.001..0.004 rows=14 loops=1)

41. 0.028 0.028 ↑ 1.0 1 28

Index Scan using merchants_merchantaccount_pkey on merchants_merchantaccount (cost=0.15..0.21 rows=1 width=284) (actual time=0.001..0.001 rows=1 loops=28)

  • Index Cond: (id = payments_merchantpaymentgatewaysettings.merchant_id)
42. 0.028 0.028 ↑ 1.0 1 28

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

  • Index Cond: (id = payments_merchantpaymentgatewaysettings.payment_gateway_id)
43. 0.009 0.023 ↑ 1.0 63 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 13kB
44. 0.014 0.014 ↑ 1.0 63 1

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

45. 0.018 0.026 ↑ 1.0 69 1

Hash (cost=1.69..1.69 rows=69 width=12) (actual time=0.026..0.026 rows=69 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
46. 0.008 0.008 ↑ 1.0 69 1

Seq Scan on venues_spot (cost=0.00..1.69 rows=69 width=12) (actual time=0.003..0.008 rows=69 loops=1)

47. 0.003 0.011 ↑ 8.1 21 1

Hash (cost=11.70..11.70 rows=170 width=444) (actual time=0.011..0.011 rows=21 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
48. 0.008 0.008 ↑ 8.1 21 1

Seq Scan on venues_revenuecenter (cost=0.00..11.70 rows=170 width=444) (actual time=0.002..0.008 rows=21 loops=1)

49. 0.076 0.164 ↑ 1.0 299 1

Hash (cost=11.99..11.99 rows=299 width=239) (actual time=0.164..0.164 rows=299 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 78kB
50. 0.088 0.088 ↑ 1.0 299 1

Seq Scan on venues_event (cost=0.00..11.99 rows=299 width=239) (actual time=0.003..0.088 rows=299 loops=1)

51.          

SubPlan (forHash Left Join)

52. 54.030 756.420 ↑ 1.0 1 18,010

GroupAggregate (cost=8.60..17.85 rows=1 width=14) (actual time=0.042..0.042 rows=1 loops=18,010)

  • Group Key: u0.id
53. 72.040 702.390 ↑ 1.0 1 18,010

Nested Loop Left Join (cost=8.60..17.83 rows=1 width=14) (actual time=0.038..0.039 rows=1 loops=18,010)

  • Join Filter: (u0.id = u1.order_id)
54. 18.010 18.010 ↑ 1.0 1 18,010

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
55. 364.281 612.340 ↑ 1.0 1 18,010

Hash Right Join (cost=8.32..13.51 rows=1 width=14) (actual time=0.033..0.034 rows=1 loops=18,010)

  • Hash Cond: (u2.transaction_id = u1.id)
56. 194.029 194.029 ↑ 1.0 159 17,639

Seq Scan on transactions_returntransaction u2 (cost=0.00..4.59 rows=159 width=14) (actual time=0.001..0.011 rows=159 loops=17,639)

57. 18.010 54.030 ↑ 1.0 1 18,010

Hash (cost=8.30..8.30 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=18,010)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
58. 36.020 36.020 ↑ 1.0 1 18,010

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

  • Index Cond: (order_id = transactions_order.id)
59. 36.020 702.390 ↑ 1.0 1 18,010

GroupAggregate (cost=8.60..17.85 rows=1 width=9) (actual time=0.039..0.039 rows=1 loops=18,010)

  • Group Key: u0_1.id
60. 54.030 666.370 ↑ 1.0 1 18,010

Nested Loop Left Join (cost=8.60..17.83 rows=1 width=9) (actual time=0.036..0.037 rows=1 loops=18,010)

  • Join Filter: (u0_1.id = u1_1.order_id)
61. 18.010 18.010 ↑ 1.0 1 18,010

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
62. 363.910 594.330 ↑ 1.0 1 18,010

Hash Right Join (cost=8.32..13.51 rows=1 width=9) (actual time=0.032..0.033 rows=1 loops=18,010)

  • Hash Cond: (u2_1.transaction_id = u1_1.id)
63. 176.390 176.390 ↑ 1.0 159 17,639

Seq Scan on transactions_returntransaction u2_1 (cost=0.00..4.59 rows=159 width=9) (actual time=0.001..0.010 rows=159 loops=17,639)

64. 18.010 54.030 ↑ 1.0 1 18,010

Hash (cost=8.30..8.30 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=18,010)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
65. 36.020 36.020 ↑ 1.0 1 18,010

Index Scan using transactions_transaction_order_id_e7f281ee on transactions_transaction u1_1 (cost=0.29..8.30 rows=1 width=8) (actual time=0.001..0.002 rows=1 loops=18,010)

  • Index Cond: (order_id = transactions_order.id)
66. 36.020 702.390 ↑ 1.0 1 18,010

GroupAggregate (cost=8.60..17.85 rows=1 width=9) (actual time=0.039..0.039 rows=1 loops=18,010)

  • Group Key: u0_2.id
67. 54.030 666.370 ↑ 1.0 1 18,010

Nested Loop Left Join (cost=8.60..17.83 rows=1 width=9) (actual time=0.036..0.037 rows=1 loops=18,010)

  • Join Filter: (u0_2.id = u1_2.order_id)
68. 18.010 18.010 ↑ 1.0 1 18,010

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
69. 363.910 594.330 ↑ 1.0 1 18,010

Hash Right Join (cost=8.32..13.51 rows=1 width=9) (actual time=0.032..0.033 rows=1 loops=18,010)

  • Hash Cond: (u2_2.transaction_id = u1_2.id)
70. 176.390 176.390 ↑ 1.0 159 17,639

Seq Scan on transactions_returntransaction u2_2 (cost=0.00..4.59 rows=159 width=9) (actual time=0.001..0.010 rows=159 loops=17,639)

71. 18.010 54.030 ↑ 1.0 1 18,010

Hash (cost=8.30..8.30 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=18,010)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
72. 36.020 36.020 ↑ 1.0 1 18,010

Index Scan using transactions_transaction_order_id_e7f281ee on transactions_transaction u1_2 (cost=0.29..8.30 rows=1 width=8) (actual time=0.001..0.002 rows=1 loops=18,010)

  • Index Cond: (order_id = transactions_order.id)
73. 36.020 702.390 ↑ 1.0 1 18,010

GroupAggregate (cost=8.60..17.85 rows=1 width=14) (actual time=0.039..0.039 rows=1 loops=18,010)

  • Group Key: u0_3.id
74. 54.030 666.370 ↑ 1.0 1 18,010

Nested Loop Left Join (cost=8.60..17.83 rows=1 width=14) (actual time=0.035..0.037 rows=1 loops=18,010)

  • Join Filter: (u0_3.id = u1_3.order_id)
75. 18.010 18.010 ↑ 1.0 1 18,010

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
76. 363.910 594.330 ↑ 1.0 1 18,010

Hash Right Join (cost=8.32..13.51 rows=1 width=14) (actual time=0.032..0.033 rows=1 loops=18,010)

  • Hash Cond: (u2_3.transaction_id = u1_3.id)
77. 176.390 176.390 ↑ 1.0 159 17,639

Seq Scan on transactions_returntransaction u2_3 (cost=0.00..4.59 rows=159 width=14) (actual time=0.001..0.010 rows=159 loops=17,639)

78. 18.010 54.030 ↑ 1.0 1 18,010

Hash (cost=8.30..8.30 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=18,010)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
79. 36.020 36.020 ↑ 1.0 1 18,010

Index Scan using transactions_transaction_order_id_e7f281ee on transactions_transaction u1_3 (cost=0.29..8.30 rows=1 width=8) (actual time=0.001..0.002 rows=1 loops=18,010)

  • Index Cond: (order_id = transactions_order.id)
80. 0.000 720.400 ↓ 0.0 0 18,010

GroupAggregate (cost=8.60..18.19 rows=1 width=9) (actual time=0.040..0.040 rows=0 loops=18,010)

  • Group Key: u0_4.id
81. 36.016 720.400 ↓ 0.0 0 18,010

Nested Loop (cost=8.60..18.17 rows=1 width=9) (actual time=0.040..0.040 rows=0 loops=18,010)

82. 259.931 684.380 ↓ 0.0 0 18,010

Hash Join (cost=8.32..13.85 rows=1 width=9) (actual time=0.038..0.038 rows=0 loops=18,010)

  • Hash Cond: (u2_4.transaction_id = u1_4.id)
83. 370.419 370.419 ↑ 1.0 144 17,639

Seq Scan on transactions_returntransaction u2_4 (cost=0.00..4.99 rows=144 width=9) (actual time=0.002..0.021 rows=144 loops=17,639)

  • Filter: (status = ANY ('{16,15}'::integer[]))
  • Rows Removed by Filter: 15
84. 18.010 54.030 ↑ 1.0 1 18,010

Hash (cost=8.30..8.30 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=18,010)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
85. 36.020 36.020 ↑ 1.0 1 18,010

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

  • Index Cond: (order_id = transactions_order.id)
86. 0.004 0.004 ↑ 1.0 1 2

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
87. 18.010 144.080 ↓ 0.0 0 18,010

GroupAggregate (cost=0.29..6.16 rows=1 width=9) (actual time=0.008..0.008 rows=0 loops=18,010)

  • Group Key: u0_5.id
88. 18.010 126.070 ↓ 0.0 0 18,010

Nested Loop (cost=0.29..6.14 rows=1 width=9) (actual time=0.007..0.007 rows=0 loops=18,010)

89. 18.010 18.010 ↑ 1.0 1 18,010

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
90. 90.050 90.050 ↓ 0.0 0 18,010

Seq Scan on sv_cards_svloadtransaction u1_5 (cost=0.00..1.82 rows=1 width=9) (actual time=0.005..0.005 rows=0 loops=18,010)

  • Filter: ((order_id = transactions_order.id) AND (status = 2))
  • Rows Removed by Filter: 55
91. 0.000 144.080 ↓ 0.0 0 18,010

GroupAggregate (cost=0.29..10.16 rows=1 width=9) (actual time=0.008..0.008 rows=0 loops=18,010)

  • Group Key: u0_6.id
92. 36.020 144.080 ↓ 0.0 0 18,010

Nested Loop (cost=0.29..10.14 rows=1 width=9) (actual time=0.008..0.008 rows=0 loops=18,010)

93. 36.020 36.020 ↑ 1.0 1 18,010

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

  • Index Cond: (id = transactions_order.id)
  • Filter: (flow_type = 1)
94. 72.040 72.040 ↓ 0.0 0 18,010

Seq Scan on sv_cards_svloadtransaction u1_6 (cost=0.00..1.82 rows=1 width=9) (actual time=0.004..0.004 rows=0 loops=18,010)

  • Filter: ((order_id = transactions_order.id) AND (status = 2))
  • Rows Removed by Filter: 55
95. 0.000 72.040 ↓ 0.0 0 18,010

GroupAggregate (cost=4.74..23.92 rows=1 width=20) (actual time=0.004..0.004 rows=0 loops=18,010)

  • Group Key: u0_7.id
96. 17.810 72.040 ↓ 0.0 0 18,010

Nested Loop (cost=4.74..23.91 rows=1 width=20) (actual time=0.004..0.004 rows=0 loops=18,010)

97. 18.010 54.030 ↓ 0.0 0 18,010

Nested Loop (cost=0.56..12.61 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=18,010)

98. 18.010 18.010 ↑ 1.0 1 18,010

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
99. 18.010 18.010 ↓ 0.0 0 18,010

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 time=0.001..0.001 rows=0 loops=18,010)

  • Index Cond: (order_id = transactions_order.id)
100. 0.000 0.200 ↓ 0.0 0 200

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

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

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

  • Index Cond: (transaction_id = u1_7.id)
102. 0.000 72.040 ↓ 0.0 0 18,010

GroupAggregate (cost=4.47..16.98 rows=1 width=20) (actual time=0.004..0.004 rows=0 loops=18,010)

  • Group Key: u0_8.id
103. 36.020 72.040 ↓ 0.0 0 18,010

Nested Loop (cost=4.47..16.97 rows=1 width=20) (actual time=0.004..0.004 rows=0 loops=18,010)

104. 18.010 18.010 ↑ 1.0 1 18,010

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
105. 0.000 18.010 ↓ 0.0 0 18,010

Bitmap Heap Scan on transactions_externalreturntransaction u1_8 (cost=4.18..12.65 rows=1 width=20) (actual time=0.001..0.001 rows=0 loops=18,010)

  • Recheck Cond: (order_id = transactions_order.id)
  • Filter: (status = 3)
106. 18.010 18.010 ↓ 0.0 0 18,010

Bitmap Index Scan on transactions_externalreturntransaction_order_id_43ad2bf9 (cost=0.00..4.18 rows=4 width=0) (actual time=0.001..0.001 rows=0 loops=18,010)

  • Index Cond: (order_id = transactions_order.id)
107. 18.010 738.410 ↓ 0.0 0 18,010

GroupAggregate (cost=8.60..18.19 rows=1 width=9) (actual time=0.041..0.041 rows=0 loops=18,010)

  • Group Key: u0_9.id
108. 36.018 720.400 ↓ 0.0 0 18,010

Nested Loop (cost=8.60..18.17 rows=1 width=9) (actual time=0.040..0.040 rows=0 loops=18,010)

109. 259.931 684.380 ↓ 0.0 0 18,010

Hash Join (cost=8.32..13.85 rows=1 width=9) (actual time=0.038..0.038 rows=0 loops=18,010)

  • Hash Cond: (u2_6.transaction_id = u1_9.id)
110. 370.419 370.419 ↑ 1.0 144 17,639

Seq Scan on transactions_returntransaction u2_6 (cost=0.00..4.99 rows=144 width=9) (actual time=0.002..0.021 rows=144 loops=17,639)

  • Filter: (status = ANY ('{16,15}'::integer[]))
  • Rows Removed by Filter: 15
111. 18.010 54.030 ↑ 1.0 1 18,010

Hash (cost=8.30..8.30 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=18,010)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
112. 36.020 36.020 ↑ 1.0 1 18,010

Index Scan using transactions_transaction_order_id_e7f281ee on transactions_transaction u1_9 (cost=0.29..8.30 rows=1 width=8) (actual time=0.001..0.002 rows=1 loops=18,010)

  • Index Cond: (order_id = transactions_order.id)
113. 0.002 0.002 ↑ 1.0 1 2

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
114. 18.010 72.040 ↓ 0.0 0 18,010

GroupAggregate (cost=4.74..23.92 rows=1 width=20) (actual time=0.004..0.004 rows=0 loops=18,010)

  • Group Key: u0_10.id
115. 0.000 54.030 ↓ 0.0 0 18,010

Nested Loop (cost=4.74..23.91 rows=1 width=20) (actual time=0.003..0.003 rows=0 loops=18,010)

116. 18.010 54.030 ↓ 0.0 0 18,010

Nested Loop (cost=0.56..12.61 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=18,010)

117. 18.010 18.010 ↑ 1.0 1 18,010

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
118. 18.010 18.010 ↓ 0.0 0 18,010

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 time=0.001..0.001 rows=0 loops=18,010)

  • Index Cond: (order_id = transactions_order.id)
119. 0.200 0.200 ↓ 0.0 0 200

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

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

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

  • Index Cond: (transaction_id = u1_10.id)
121. 0.000 144.080 ↓ 0.0 0 18,010

GroupAggregate (cost=0.29..10.16 rows=1 width=9) (actual time=0.008..0.008 rows=0 loops=18,010)

  • Group Key: u0_11.id
122. 36.020 144.080 ↓ 0.0 0 18,010

Nested Loop (cost=0.29..10.14 rows=1 width=9) (actual time=0.008..0.008 rows=0 loops=18,010)

123. 36.020 36.020 ↑ 1.0 1 18,010

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

  • Index Cond: (id = transactions_order.id)
  • Filter: (flow_type = 1)
124. 72.040 72.040 ↓ 0.0 0 18,010

Seq Scan on sv_cards_svloadtransaction u1_11 (cost=0.00..1.82 rows=1 width=9) (actual time=0.004..0.004 rows=0 loops=18,010)

  • Filter: ((order_id = transactions_order.id) AND (status = 2))
  • Rows Removed by Filter: 55
125. 0.000 72.040 ↓ 0.0 0 18,010

GroupAggregate (cost=4.47..16.98 rows=1 width=20) (actual time=0.004..0.004 rows=0 loops=18,010)

  • Group Key: u0_12.id
126. 36.020 72.040 ↓ 0.0 0 18,010

Nested Loop (cost=4.47..16.97 rows=1 width=20) (actual time=0.004..0.004 rows=0 loops=18,010)

127. 18.010 18.010 ↑ 1.0 1 18,010

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
128. 18.010 18.010 ↓ 0.0 0 18,010

Bitmap Heap Scan on transactions_externalreturntransaction u1_12 (cost=4.18..12.65 rows=1 width=20) (actual time=0.001..0.001 rows=0 loops=18,010)

  • Recheck Cond: (order_id = transactions_order.id)
  • Filter: (status = 3)
129. 0.000 0.000 ↓ 0.0 0 18,010

Bitmap Index Scan on transactions_externalreturntransaction_order_id_43ad2bf9 (cost=0.00..4.18 rows=4 width=0) (actual time=0.000..0.000 rows=0 loops=18,010)

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

Nested Loop Left Join (cost=17.23..55.88 rows=1 width=0) (never executed)

  • 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))
131. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=13.05..43.15 rows=1 width=16) (never executed)

132. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=8.88..31.84 rows=1 width=16) (never executed)

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

Nested Loop Left Join (cost=8.60..23.53 rows=1 width=12) (never executed)

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

Nested Loop Left Join (cost=8.60..21.83 rows=1 width=8) (never executed)

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

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

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

Hash Right Join (cost=8.32..13.51 rows=1 width=8) (never executed)

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

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

138. 0.000 0.000 ↓ 0.0 0

Hash (cost=8.30..8.30 rows=1 width=8) (never executed)

139. 0.000 0.000 ↓ 0.0 0

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

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

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

  • Filter: (order_id = transactions_order.id)
141. 0.000 0.000 ↓ 0.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) (never executed)

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

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

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

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

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

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

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

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

  • Index Cond: (order_id = transactions_order.id)
146. 4.383 45.349 ↓ 0.0 0 1

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

  • 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))
  • Rows Removed by Filter: 22826
147. 8.679 40.569 ↓ 1.0 22,593 1

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

  • Hash Cond: (u1_14.order_id = u0_14.id)
148. 2.349 6.556 ↓ 1.0 20,799 1

Hash Left Join (cost=6.58..937.71 rows=20,777 width=8) (actual time=0.294..6.556 rows=20,799 loops=1)

  • Hash Cond: (u1_14.id = u2_9.transaction_id)
149. 4.159 4.159 ↑ 1.0 20,777 1

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

150. 0.019 0.048 ↑ 1.0 159 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 15kB
151. 0.029 0.029 ↑ 1.0 159 1

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

152. 2.651 25.334 ↓ 1.0 22,555 1

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

  • Buckets: 32768 Batches: 1 Memory Usage: 1049kB
153. 2.101 22.683 ↓ 1.0 22,555 1

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

  • Hash Cond: (u6_1.order_id = u0_14.id)
154. 0.005 0.005 ↑ 144.0 5 1

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

155. 3.041 20.577 ↓ 1.0 22,554 1

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

  • Buckets: 32768 Batches: 1 Memory Usage: 1049kB
156. 4.834 17.536 ↓ 1.0 22,554 1

Hash Right Join (cost=2,694.82..2,696.63 rows=22,553 width=8) (actual time=12.718..17.536 rows=22,554 loops=1)

  • Hash Cond: (u3_1.order_id = u0_14.id)
157. 0.007 0.007 ↑ 1.0 55 1

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

158. 3.669 12.695 ↑ 1.0 22,553 1

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

  • Buckets: 32768 Batches: 1 Memory Usage: 1049kB
159. 9.026 9.026 ↑ 1.0 22,553 1

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

  • Filter: (flow_type = 1)
160. 0.101 0.397 ↑ 1.0 881 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 39kB
161. 0.073 0.296 ↑ 1.0 881 1

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

  • Hash Cond: (u5_1.transaction_id = u4_1.id)
162. 0.000 0.000 ↓ 0.0 0 1

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

163. 0.093 0.223 ↑ 1.0 881 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 43kB
164. 0.130 0.130 ↑ 1.0 881 1

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

165. 36.020 90.050 ↑ 1.0 1 18,010

GroupAggregate (cost=0.56..12.63 rows=1 width=13) (actual time=0.005..0.005 rows=1 loops=18,010)

  • Group Key: u0_15.id
166. 18.010 54.030 ↑ 1.0 1 18,010

Nested Loop Left Join (cost=0.56..12.61 rows=1 width=13) (actual time=0.003..0.003 rows=1 loops=18,010)

  • Join Filter: (u0_15.id = u1_15.order_id)
167. 18.010 18.010 ↑ 1.0 1 18,010

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
168. 18.010 18.010 ↓ 0.0 0 18,010

Index Scan using offerings_offeringusage_order_id_6f067d93 on offerings_offeringusage u1_15 (cost=0.28..8.29 rows=1 width=13) (actual time=0.001..0.001 rows=0 loops=18,010)

  • Index Cond: (order_id = transactions_order.id)
169. 36.020 162.090 ↑ 1.0 1 18,010

GroupAggregate (cost=8.59..14.05 rows=1 width=17) (actual time=0.009..0.009 rows=1 loops=18,010)

  • Group Key: u0_16.id
170. 54.030 126.070 ↑ 1.0 1 18,010

Nested Loop Left Join (cost=8.59..14.03 rows=1 width=17) (actual time=0.007..0.007 rows=1 loops=18,010)

  • Join Filter: (u0_16.id = u1_16.order_id)
171. 18.010 18.010 ↑ 1.0 1 18,010

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
172. 36.020 54.030 ↓ 0.0 0 18,010

Hash Right Join (cost=8.30..9.71 rows=1 width=17) (actual time=0.003..0.003 rows=0 loops=18,010)

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

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

174. 0.000 18.010 ↓ 0.0 0 18,010

Hash (cost=8.29..8.29 rows=1 width=17) (actual time=0.001..0.001 rows=0 loops=18,010)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
175. 18.010 18.010 ↓ 0.0 0 18,010

Index Scan using offerings_offeringusage_order_id_6f067d93 on offerings_offeringusage u1_16 (cost=0.28..8.29 rows=1 width=17) (actual time=0.001..0.001 rows=0 loops=18,010)

  • Index Cond: (order_id = transactions_order.id)
176. 36.020 162.090 ↑ 1.0 1 18,010

GroupAggregate (cost=8.59..14.05 rows=1 width=17) (actual time=0.009..0.009 rows=1 loops=18,010)

  • Group Key: u0_17.id
177. 54.030 126.070 ↑ 1.0 1 18,010

Nested Loop Left Join (cost=8.59..14.03 rows=1 width=17) (actual time=0.007..0.007 rows=1 loops=18,010)

  • Join Filter: (u0_17.id = u1_17.order_id)
178. 18.010 18.010 ↑ 1.0 1 18,010

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
179. 18.010 54.030 ↓ 0.0 0 18,010

Hash Right Join (cost=8.30..9.71 rows=1 width=17) (actual time=0.003..0.003 rows=0 loops=18,010)

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

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

181. 18.010 36.020 ↓ 0.0 0 18,010

Hash (cost=8.29..8.29 rows=1 width=17) (actual time=0.002..0.002 rows=0 loops=18,010)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
182. 18.010 18.010 ↓ 0.0 0 18,010

Index Scan using offerings_offeringusage_order_id_6f067d93 on offerings_offeringusage u1_17 (cost=0.28..8.29 rows=1 width=17) (actual time=0.001..0.001 rows=0 loops=18,010)

  • Index Cond: (order_id = transactions_order.id)
183. 36.020 144.080 ↑ 1.0 1 18,010

GroupAggregate (cost=8.59..14.05 rows=1 width=17) (actual time=0.008..0.008 rows=1 loops=18,010)

  • Group Key: u0_18.id
184. 36.020 108.060 ↑ 1.0 1 18,010

Nested Loop Left Join (cost=8.59..14.03 rows=1 width=17) (actual time=0.006..0.006 rows=1 loops=18,010)

  • Join Filter: (u0_18.id = u1_18.order_id)
185. 18.010 18.010 ↑ 1.0 1 18,010

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
186. 36.020 54.030 ↓ 0.0 0 18,010

Hash Right Join (cost=8.30..9.71 rows=1 width=17) (actual time=0.003..0.003 rows=0 loops=18,010)

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

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

188. 0.000 18.010 ↓ 0.0 0 18,010

Hash (cost=8.29..8.29 rows=1 width=17) (actual time=0.001..0.001 rows=0 loops=18,010)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
189. 18.010 18.010 ↓ 0.0 0 18,010

Index Scan using offerings_offeringusage_order_id_6f067d93 on offerings_offeringusage u1_18 (cost=0.28..8.29 rows=1 width=17) (actual time=0.001..0.001 rows=0 loops=18,010)

  • Index Cond: (order_id = transactions_order.id)
190. 36.020 144.080 ↑ 1.0 1 18,010

GroupAggregate (cost=4.74..25.31 rows=1 width=28) (actual time=0.008..0.008 rows=1 loops=18,010)

  • Group Key: u0_19.id
191. 36.020 108.060 ↑ 1.0 1 18,010

Nested Loop Left Join (cost=4.74..25.29 rows=1 width=28) (actual time=0.006..0.006 rows=1 loops=18,010)

192. 18.010 54.030 ↑ 1.0 1 18,010

Nested Loop Left Join (cost=0.56..12.61 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=18,010)

  • Join Filter: (u0_19.id = u1_19.order_id)
193. 18.010 18.010 ↑ 1.0 1 18,010

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
194. 18.010 18.010 ↓ 0.0 0 18,010

Index Scan using offerings_offeringusage_order_id_6f067d93 on offerings_offeringusage u1_19 (cost=0.28..8.29 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=18,010)

  • Index Cond: (order_id = transactions_order.id)
195. 18.010 18.010 ↓ 0.0 0 18,010

Bitmap Heap Scan on offerings_offeringusagereturn u2_13 (cost=4.18..12.64 rows=4 width=28) (actual time=0.001..0.001 rows=0 loops=18,010)

  • Recheck Cond: (u1_19.id = offering_usage_id)
196. 0.000 0.000 ↓ 0.0 0 18,010

Bitmap Index Scan on offerings_offeringusagereturn_offering_usage_id_9101d4da (cost=0.00..4.18 rows=4 width=0) (actual time=0.000..0.000 rows=0 loops=18,010)

  • Index Cond: (u1_19.id = offering_usage_id)
197. 36.020 288.160 ↑ 1.0 1 18,010

GroupAggregate (cost=4.74..26.97 rows=1 width=32) (actual time=0.015..0.016 rows=1 loops=18,010)

  • Group Key: u0_20.id
198. 72.040 252.140 ↑ 1.0 1 18,010

Nested Loop Left Join (cost=4.74..26.94 rows=1 width=32) (actual time=0.013..0.014 rows=1 loops=18,010)

  • Join Filter: (u1_20.offering_id = u3_2.id)
  • Rows Removed by Join Filter: 32
199. 36.020 108.060 ↑ 1.0 1 18,010

Nested Loop Left Join (cost=4.74..25.29 rows=1 width=32) (actual time=0.006..0.006 rows=1 loops=18,010)

200. 18.010 54.030 ↑ 1.0 1 18,010

Nested Loop Left Join (cost=0.56..12.61 rows=1 width=12) (actual time=0.003..0.003 rows=1 loops=18,010)

  • Join Filter: (u0_20.id = u1_20.order_id)
201. 18.010 18.010 ↑ 1.0 1 18,010

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
202. 18.010 18.010 ↓ 0.0 0 18,010

Index Scan using offerings_offeringusage_order_id_6f067d93 on offerings_offeringusage u1_20 (cost=0.28..8.29 rows=1 width=12) (actual time=0.001..0.001 rows=0 loops=18,010)

  • Index Cond: (order_id = transactions_order.id)
203. 18.010 18.010 ↓ 0.0 0 18,010

Bitmap Heap Scan on offerings_offeringusagereturn u2_14 (cost=4.18..12.64 rows=4 width=28) (actual time=0.001..0.001 rows=0 loops=18,010)

  • Recheck Cond: (u1_20.id = offering_usage_id)
204. 0.000 0.000 ↓ 0.0 0 18,010

Bitmap Index Scan on offerings_offeringusagereturn_offering_usage_id_9101d4da (cost=0.00..4.18 rows=4 width=0) (actual time=0.000..0.000 rows=0 loops=18,010)

  • Index Cond: (u1_20.id = offering_usage_id)
205. 72.040 72.040 ↓ 1.1 32 18,010

Seq Scan on offerings_offering u3_2 (cost=0.00..1.29 rows=29 width=8) (actual time=0.001..0.004 rows=32 loops=18,010)

206. 36.020 720.400 ↑ 1.0 1 18,010

GroupAggregate (cost=8.60..17.85 rows=1 width=14) (actual time=0.040..0.040 rows=1 loops=18,010)

  • Group Key: u0_21.id
207. 54.030 684.380 ↑ 1.0 1 18,010

Nested Loop Left Join (cost=8.60..17.83 rows=1 width=14) (actual time=0.037..0.038 rows=1 loops=18,010)

  • Join Filter: (u0_21.id = u1_21.order_id)
208. 18.010 18.010 ↑ 1.0 1 18,010

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
209. 364.281 612.340 ↑ 1.0 1 18,010

Hash Right Join (cost=8.32..13.51 rows=1 width=14) (actual time=0.033..0.034 rows=1 loops=18,010)

  • Hash Cond: (u2_15.transaction_id = u1_21.id)
210. 194.029 194.029 ↑ 1.0 159 17,639

Seq Scan on transactions_returntransaction u2_15 (cost=0.00..4.59 rows=159 width=14) (actual time=0.001..0.011 rows=159 loops=17,639)

211. 18.010 54.030 ↑ 1.0 1 18,010

Hash (cost=8.30..8.30 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=18,010)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
212. 36.020 36.020 ↑ 1.0 1 18,010

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

  • Index Cond: (order_id = transactions_order.id)
213. 0.000 720.400 ↓ 0.0 0 18,010

GroupAggregate (cost=8.60..18.19 rows=1 width=9) (actual time=0.040..0.040 rows=0 loops=18,010)

  • Group Key: u0_22.id
214. 36.016 720.400 ↓ 0.0 0 18,010

Nested Loop (cost=8.60..18.17 rows=1 width=9) (actual time=0.040..0.040 rows=0 loops=18,010)

215. 277.941 684.380 ↓ 0.0 0 18,010

Hash Join (cost=8.32..13.85 rows=1 width=9) (actual time=0.038..0.038 rows=0 loops=18,010)

  • Hash Cond: (u2_16.transaction_id = u1_22.id)
216. 370.419 370.419 ↑ 1.0 144 17,639

Seq Scan on transactions_returntransaction u2_16 (cost=0.00..4.99 rows=144 width=9) (actual time=0.002..0.021 rows=144 loops=17,639)

  • Filter: (status = ANY ('{16,15}'::integer[]))
  • Rows Removed by Filter: 15
217. 0.000 36.020 ↑ 1.0 1 18,010

Hash (cost=8.30..8.30 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=18,010)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
218. 36.020 36.020 ↑ 1.0 1 18,010

Index Scan using transactions_transaction_order_id_e7f281ee on transactions_transaction u1_22 (cost=0.29..8.30 rows=1 width=8) (actual time=0.001..0.002 rows=1 loops=18,010)

  • Index Cond: (order_id = transactions_order.id)
219. 0.004 0.004 ↑ 1.0 1 2

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
220. 0.000 72.040 ↓ 0.0 0 18,010

GroupAggregate (cost=4.74..23.92 rows=1 width=20) (actual time=0.004..0.004 rows=0 loops=18,010)

  • Group Key: u0_23.id
221. 17.810 72.040 ↓ 0.0 0 18,010

Nested Loop (cost=4.74..23.91 rows=1 width=20) (actual time=0.004..0.004 rows=0 loops=18,010)

222. 18.010 54.030 ↓ 0.0 0 18,010

Nested Loop (cost=0.56..12.61 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=18,010)

223. 18.010 18.010 ↑ 1.0 1 18,010

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
224. 18.010 18.010 ↓ 0.0 0 18,010

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 time=0.001..0.001 rows=0 loops=18,010)

  • Index Cond: (order_id = transactions_order.id)
225. 0.200 0.200 ↓ 0.0 0 200

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

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

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

  • Index Cond: (transaction_id = u1_23.id)
227. 0.000 144.080 ↓ 0.0 0 18,010

GroupAggregate (cost=0.29..10.16 rows=1 width=9) (actual time=0.008..0.008 rows=0 loops=18,010)

  • Group Key: u0_24.id
228. 36.020 144.080 ↓ 0.0 0 18,010

Nested Loop (cost=0.29..10.14 rows=1 width=9) (actual time=0.008..0.008 rows=0 loops=18,010)

229. 36.020 36.020 ↑ 1.0 1 18,010

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

  • Index Cond: (id = transactions_order.id)
  • Filter: (flow_type = 1)
230. 72.040 72.040 ↓ 0.0 0 18,010

Seq Scan on sv_cards_svloadtransaction u1_24 (cost=0.00..1.82 rows=1 width=9) (actual time=0.004..0.004 rows=0 loops=18,010)

  • Filter: ((order_id = transactions_order.id) AND (status = 2))
  • Rows Removed by Filter: 55
231. 18.010 90.050 ↓ 0.0 0 18,010

GroupAggregate (cost=4.47..16.98 rows=1 width=20) (actual time=0.005..0.005 rows=0 loops=18,010)

  • Group Key: u0_25.id
232. 36.020 72.040 ↓ 0.0 0 18,010

Nested Loop (cost=4.47..16.97 rows=1 width=20) (actual time=0.004..0.004 rows=0 loops=18,010)

233. 18.010 18.010 ↑ 1.0 1 18,010

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
234. 0.000 18.010 ↓ 0.0 0 18,010

Bitmap Heap Scan on transactions_externalreturntransaction u1_25 (cost=4.18..12.65 rows=1 width=20) (actual time=0.001..0.001 rows=0 loops=18,010)

  • Recheck Cond: (order_id = transactions_order.id)
  • Filter: (status = 3)
235. 18.010 18.010 ↓ 0.0 0 18,010

Bitmap Index Scan on transactions_externalreturntransaction_order_id_43ad2bf9 (cost=0.00..4.18 rows=4 width=0) (actual time=0.001..0.001 rows=0 loops=18,010)

  • Index Cond: (order_id = transactions_order.id)
236. 18.010 738.410 ↓ 0.0 0 18,010

GroupAggregate (cost=8.60..18.19 rows=1 width=9) (actual time=0.041..0.041 rows=0 loops=18,010)

  • Group Key: u0_26.id
237. 36.018 720.400 ↓ 0.0 0 18,010

Nested Loop (cost=8.60..18.17 rows=1 width=9) (actual time=0.040..0.040 rows=0 loops=18,010)

238. 259.931 684.380 ↓ 0.0 0 18,010

Hash Join (cost=8.32..13.85 rows=1 width=9) (actual time=0.038..0.038 rows=0 loops=18,010)

  • Hash Cond: (u2_18.transaction_id = u1_26.id)
239. 370.419 370.419 ↑ 1.0 144 17,639

Seq Scan on transactions_returntransaction u2_18 (cost=0.00..4.99 rows=144 width=9) (actual time=0.002..0.021 rows=144 loops=17,639)

  • Filter: (status = ANY ('{16,15}'::integer[]))
  • Rows Removed by Filter: 15
240. 18.010 54.030 ↑ 1.0 1 18,010

Hash (cost=8.30..8.30 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=18,010)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
241. 36.020 36.020 ↑ 1.0 1 18,010

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

  • Index Cond: (order_id = transactions_order.id)
242. 0.002 0.002 ↑ 1.0 1 2

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
243. 18.010 720.400 ↓ 0.0 0 18,010

GroupAggregate (cost=8.60..18.19 rows=1 width=9) (actual time=0.040..0.040 rows=0 loops=18,010)

  • Group Key: u0_27.id
244. 18.006 702.390 ↓ 0.0 0 18,010

Nested Loop (cost=8.60..18.17 rows=1 width=9) (actual time=0.039..0.039 rows=0 loops=18,010)

245. 277.941 684.380 ↓ 0.0 0 18,010

Hash Join (cost=8.32..13.85 rows=1 width=9) (actual time=0.038..0.038 rows=0 loops=18,010)

  • Hash Cond: (u2_19.transaction_id = u1_27.id)
246. 370.419 370.419 ↑ 1.0 144 17,639

Seq Scan on transactions_returntransaction u2_19 (cost=0.00..4.99 rows=144 width=9) (actual time=0.002..0.021 rows=144 loops=17,639)

  • Filter: (status = ANY ('{16,15}'::integer[]))
  • Rows Removed by Filter: 15
247. 0.000 36.020 ↑ 1.0 1 18,010

Hash (cost=8.30..8.30 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=18,010)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
248. 36.020 36.020 ↑ 1.0 1 18,010

Index Scan using transactions_transaction_order_id_e7f281ee on transactions_transaction u1_27 (cost=0.29..8.30 rows=1 width=8) (actual time=0.001..0.002 rows=1 loops=18,010)

  • Index Cond: (order_id = transactions_order.id)
249. 0.004 0.004 ↑ 1.0 1 2

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
250. 0.000 72.040 ↓ 0.0 0 18,010

GroupAggregate (cost=4.74..23.92 rows=1 width=20) (actual time=0.004..0.004 rows=0 loops=18,010)

  • Group Key: u0_28.id
251. 17.810 72.040 ↓ 0.0 0 18,010

Nested Loop (cost=4.74..23.91 rows=1 width=20) (actual time=0.004..0.004 rows=0 loops=18,010)

252. 18.010 54.030 ↓ 0.0 0 18,010

Nested Loop (cost=0.56..12.61 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=18,010)

253. 18.010 18.010 ↑ 1.0 1 18,010

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
254. 18.010 18.010 ↓ 0.0 0 18,010

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 time=0.001..0.001 rows=0 loops=18,010)

  • Index Cond: (order_id = transactions_order.id)
255. 0.200 0.200 ↓ 0.0 0 200

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

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

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

  • Index Cond: (transaction_id = u1_28.id)
257. 0.000 144.080 ↓ 0.0 0 18,010

GroupAggregate (cost=0.29..10.16 rows=1 width=9) (actual time=0.008..0.008 rows=0 loops=18,010)

  • Group Key: u0_29.id
258. 36.020 144.080 ↓ 0.0 0 18,010

Nested Loop (cost=0.29..10.14 rows=1 width=9) (actual time=0.008..0.008 rows=0 loops=18,010)

259. 36.020 36.020 ↑ 1.0 1 18,010

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

  • Index Cond: (id = transactions_order.id)
  • Filter: (flow_type = 1)
260. 72.040 72.040 ↓ 0.0 0 18,010

Seq Scan on sv_cards_svloadtransaction u1_29 (cost=0.00..1.82 rows=1 width=9) (actual time=0.004..0.004 rows=0 loops=18,010)

  • Filter: ((order_id = transactions_order.id) AND (status = 2))
  • Rows Removed by Filter: 55
261. 0.000 72.040 ↓ 0.0 0 18,010

GroupAggregate (cost=4.47..16.98 rows=1 width=20) (actual time=0.004..0.004 rows=0 loops=18,010)

  • Group Key: u0_30.id
262. 36.020 72.040 ↓ 0.0 0 18,010

Nested Loop (cost=4.47..16.97 rows=1 width=20) (actual time=0.004..0.004 rows=0 loops=18,010)

263. 18.010 18.010 ↑ 1.0 1 18,010

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
264. 18.010 18.010 ↓ 0.0 0 18,010

Bitmap Heap Scan on transactions_externalreturntransaction u1_30 (cost=4.18..12.65 rows=1 width=20) (actual time=0.001..0.001 rows=0 loops=18,010)

  • Recheck Cond: (order_id = transactions_order.id)
  • Filter: (status = 3)
265. 0.000 0.000 ↓ 0.0 0 18,010

Bitmap Index Scan on transactions_externalreturntransaction_order_id_43ad2bf9 (cost=0.00..4.18 rows=4 width=0) (actual time=0.000..0.000 rows=0 loops=18,010)

  • Index Cond: (order_id = transactions_order.id)
266. 0.000 72.040 ↓ 0.0 0 18,010

GroupAggregate (cost=4.47..16.98 rows=1 width=20) (actual time=0.004..0.004 rows=0 loops=18,010)

  • Group Key: u0_31.id
267. 36.020 72.040 ↓ 0.0 0 18,010

Nested Loop (cost=4.47..16.97 rows=1 width=20) (actual time=0.004..0.004 rows=0 loops=18,010)

268. 18.010 18.010 ↑ 1.0 1 18,010

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
269. 18.010 18.010 ↓ 0.0 0 18,010

Bitmap Heap Scan on transactions_externalreturntransaction u1_31 (cost=4.18..12.65 rows=1 width=20) (actual time=0.001..0.001 rows=0 loops=18,010)

  • Recheck Cond: (order_id = transactions_order.id)
  • Filter: (status = 3)
270. 0.000 0.000 ↓ 0.0 0 18,010

Bitmap Index Scan on transactions_externalreturntransaction_order_id_43ad2bf9 (cost=0.00..4.18 rows=4 width=0) (actual time=0.000..0.000 rows=0 loops=18,010)

  • Index Cond: (order_id = transactions_order.id)
271. 0.000 720.400 ↓ 0.0 0 18,010

GroupAggregate (cost=8.60..18.19 rows=1 width=9) (actual time=0.040..0.040 rows=0 loops=18,010)

  • Group Key: u0_32.id
272. 36.016 720.400 ↓ 0.0 0 18,010

Nested Loop (cost=8.60..18.17 rows=1 width=9) (actual time=0.040..0.040 rows=0 loops=18,010)

273. 259.931 684.380 ↓ 0.0 0 18,010

Hash Join (cost=8.32..13.85 rows=1 width=9) (actual time=0.038..0.038 rows=0 loops=18,010)

  • Hash Cond: (u2_21.transaction_id = u1_32.id)
274. 370.419 370.419 ↑ 1.0 144 17,639

Seq Scan on transactions_returntransaction u2_21 (cost=0.00..4.99 rows=144 width=9) (actual time=0.002..0.021 rows=144 loops=17,639)

  • Filter: (status = ANY ('{16,15}'::integer[]))
  • Rows Removed by Filter: 15
275. 18.010 54.030 ↑ 1.0 1 18,010

Hash (cost=8.30..8.30 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=18,010)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
276. 36.020 36.020 ↑ 1.0 1 18,010

Index Scan using transactions_transaction_order_id_e7f281ee on transactions_transaction u1_32 (cost=0.29..8.30 rows=1 width=8) (actual time=0.001..0.002 rows=1 loops=18,010)

  • Index Cond: (order_id = transactions_order.id)
277. 0.004 0.004 ↑ 1.0 1 2

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
278. 18.010 738.410 ↓ 0.0 0 18,010

GroupAggregate (cost=8.60..18.19 rows=1 width=9) (actual time=0.041..0.041 rows=0 loops=18,010)

  • Group Key: u0_33.id
279. 36.016 720.400 ↓ 0.0 0 18,010

Nested Loop (cost=8.60..18.17 rows=1 width=9) (actual time=0.040..0.040 rows=0 loops=18,010)

280. 259.931 684.380 ↓ 0.0 0 18,010

Hash Join (cost=8.32..13.85 rows=1 width=9) (actual time=0.038..0.038 rows=0 loops=18,010)

  • Hash Cond: (u2_22.transaction_id = u1_33.id)
281. 370.419 370.419 ↑ 1.0 144 17,639

Seq Scan on transactions_returntransaction u2_22 (cost=0.00..4.99 rows=144 width=9) (actual time=0.002..0.021 rows=144 loops=17,639)

  • Filter: (status = ANY ('{16,15}'::integer[]))
  • Rows Removed by Filter: 15
282. 18.010 54.030 ↑ 1.0 1 18,010

Hash (cost=8.30..8.30 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=18,010)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
283. 36.020 36.020 ↑ 1.0 1 18,010

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

  • Index Cond: (order_id = transactions_order.id)
284. 0.004 0.004 ↑ 1.0 1 2

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
285. 0.000 72.040 ↓ 0.0 0 18,010

GroupAggregate (cost=4.74..23.92 rows=1 width=20) (actual time=0.004..0.004 rows=0 loops=18,010)

  • Group Key: u0_34.id
286. 17.810 72.040 ↓ 0.0 0 18,010

Nested Loop (cost=4.74..23.91 rows=1 width=20) (actual time=0.004..0.004 rows=0 loops=18,010)

287. 18.010 54.030 ↓ 0.0 0 18,010

Nested Loop (cost=0.56..12.61 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=18,010)

288. 18.010 18.010 ↑ 1.0 1 18,010

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
289. 18.010 18.010 ↓ 0.0 0 18,010

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 time=0.001..0.001 rows=0 loops=18,010)

  • Index Cond: (order_id = transactions_order.id)
290. 0.200 0.200 ↓ 0.0 0 200

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

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

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

  • Index Cond: (transaction_id = u1_34.id)
292. 0.000 144.080 ↓ 0.0 0 18,010

GroupAggregate (cost=0.29..10.16 rows=1 width=9) (actual time=0.008..0.008 rows=0 loops=18,010)

  • Group Key: u0_35.id
293. 36.020 144.080 ↓ 0.0 0 18,010

Nested Loop (cost=0.29..10.14 rows=1 width=9) (actual time=0.008..0.008 rows=0 loops=18,010)

294. 36.020 36.020 ↑ 1.0 1 18,010

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

  • Index Cond: (id = transactions_order.id)
  • Filter: (flow_type = 1)
295. 72.040 72.040 ↓ 0.0 0 18,010

Seq Scan on sv_cards_svloadtransaction u1_35 (cost=0.00..1.82 rows=1 width=9) (actual time=0.004..0.004 rows=0 loops=18,010)

  • Filter: ((order_id = transactions_order.id) AND (status = 2))
  • Rows Removed by Filter: 55
296. 18.010 72.040 ↓ 0.0 0 18,010

GroupAggregate (cost=4.47..16.98 rows=1 width=20) (actual time=0.004..0.004 rows=0 loops=18,010)

  • Group Key: u0_36.id
297. 18.010 54.030 ↓ 0.0 0 18,010

Nested Loop (cost=4.47..16.97 rows=1 width=20) (actual time=0.003..0.003 rows=0 loops=18,010)

298. 18.010 18.010 ↑ 1.0 1 18,010

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
299. 18.010 18.010 ↓ 0.0 0 18,010

Bitmap Heap Scan on transactions_externalreturntransaction u1_36 (cost=4.18..12.65 rows=1 width=20) (actual time=0.001..0.001 rows=0 loops=18,010)

  • Recheck Cond: (order_id = transactions_order.id)
  • Filter: (status = 3)
300. 0.000 0.000 ↓ 0.0 0 18,010

Bitmap Index Scan on transactions_externalreturntransaction_order_id_43ad2bf9 (cost=0.00..4.18 rows=4 width=0) (actual time=0.000..0.000 rows=0 loops=18,010)

  • Index Cond: (order_id = transactions_order.id)
301. 18.010 738.410 ↓ 0.0 0 18,010

GroupAggregate (cost=8.60..18.19 rows=1 width=9) (actual time=0.041..0.041 rows=0 loops=18,010)

  • Group Key: u0_37.id
302. 36.016 720.400 ↓ 0.0 0 18,010

Nested Loop (cost=8.60..18.17 rows=1 width=9) (actual time=0.040..0.040 rows=0 loops=18,010)

303. 259.931 684.380 ↓ 0.0 0 18,010

Hash Join (cost=8.32..13.85 rows=1 width=9) (actual time=0.038..0.038 rows=0 loops=18,010)

  • Hash Cond: (u2_24.transaction_id = u1_37.id)
304. 370.419 370.419 ↑ 1.0 144 17,639

Seq Scan on transactions_returntransaction u2_24 (cost=0.00..4.99 rows=144 width=9) (actual time=0.002..0.021 rows=144 loops=17,639)

  • Filter: (status = ANY ('{16,15}'::integer[]))
  • Rows Removed by Filter: 15
305. 18.010 54.030 ↑ 1.0 1 18,010

Hash (cost=8.30..8.30 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=18,010)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
306. 36.020 36.020 ↑ 1.0 1 18,010

Index Scan using transactions_transaction_order_id_e7f281ee on transactions_transaction u1_37 (cost=0.29..8.30 rows=1 width=8) (actual time=0.001..0.002 rows=1 loops=18,010)

  • Index Cond: (order_id = transactions_order.id)
307. 0.004 0.004 ↑ 1.0 1 2

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
308. 0.000 72.040 ↓ 0.0 0 18,010

GroupAggregate (cost=4.74..23.92 rows=1 width=20) (actual time=0.004..0.004 rows=0 loops=18,010)

  • Group Key: u0_38.id
309. 17.810 72.040 ↓ 0.0 0 18,010

Nested Loop (cost=4.74..23.91 rows=1 width=20) (actual time=0.004..0.004 rows=0 loops=18,010)

310. 18.010 54.030 ↓ 0.0 0 18,010

Nested Loop (cost=0.56..12.61 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=18,010)

311. 18.010 18.010 ↑ 1.0 1 18,010

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
312. 18.010 18.010 ↓ 0.0 0 18,010

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 time=0.001..0.001 rows=0 loops=18,010)

  • Index Cond: (order_id = transactions_order.id)
313. 0.200 0.200 ↓ 0.0 0 200

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

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

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

  • Index Cond: (transaction_id = u1_38.id)
315. 0.000 144.080 ↓ 0.0 0 18,010

GroupAggregate (cost=0.29..10.16 rows=1 width=9) (actual time=0.008..0.008 rows=0 loops=18,010)

  • Group Key: u0_39.id
316. 36.020 144.080 ↓ 0.0 0 18,010

Nested Loop (cost=0.29..10.14 rows=1 width=9) (actual time=0.008..0.008 rows=0 loops=18,010)

317. 36.020 36.020 ↑ 1.0 1 18,010

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

  • Index Cond: (id = transactions_order.id)
  • Filter: (flow_type = 1)
318. 72.040 72.040 ↓ 0.0 0 18,010

Seq Scan on sv_cards_svloadtransaction u1_39 (cost=0.00..1.82 rows=1 width=9) (actual time=0.004..0.004 rows=0 loops=18,010)

  • Filter: ((order_id = transactions_order.id) AND (status = 2))
  • Rows Removed by Filter: 55
319. 0.000 72.040 ↓ 0.0 0 18,010

GroupAggregate (cost=4.47..16.98 rows=1 width=20) (actual time=0.004..0.004 rows=0 loops=18,010)

  • Group Key: u0_40.id
320. 36.020 72.040 ↓ 0.0 0 18,010

Nested Loop (cost=4.47..16.97 rows=1 width=20) (actual time=0.004..0.004 rows=0 loops=18,010)

321. 18.010 18.010 ↑ 1.0 1 18,010

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
322. 0.000 18.010 ↓ 0.0 0 18,010

Bitmap Heap Scan on transactions_externalreturntransaction u1_40 (cost=4.18..12.65 rows=1 width=20) (actual time=0.001..0.001 rows=0 loops=18,010)

  • Recheck Cond: (order_id = transactions_order.id)
  • Filter: (status = 3)
323. 18.010 18.010 ↓ 0.0 0 18,010

Bitmap Index Scan on transactions_externalreturntransaction_order_id_43ad2bf9 (cost=0.00..4.18 rows=4 width=0) (actual time=0.001..0.001 rows=0 loops=18,010)

  • Index Cond: (order_id = transactions_order.id)
324. 0.000 72.040 ↓ 0.0 0 18,010

GroupAggregate (cost=4.47..16.98 rows=1 width=20) (actual time=0.004..0.004 rows=0 loops=18,010)

  • Group Key: u0_41.id
325. 36.020 72.040 ↓ 0.0 0 18,010

Nested Loop (cost=4.47..16.97 rows=1 width=20) (actual time=0.004..0.004 rows=0 loops=18,010)

326. 18.010 18.010 ↑ 1.0 1 18,010

Index Only Scan using transactions_order_pkey on transactions_order u0_41 (cost=0.29..4.30 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=18,010)

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
327. 18.010 18.010 ↓ 0.0 0 18,010

Bitmap Heap Scan on transactions_externalreturntransaction u1_41 (cost=4.18..12.65 rows=1 width=20) (actual time=0.001..0.001 rows=0 loops=18,010)

  • Recheck Cond: (order_id = transactions_order.id)
  • Filter: (status = 3)
328. 0.000 0.000 ↓ 0.0 0 18,010

Bitmap Index Scan on transactions_externalreturntransaction_order_id_43ad2bf9 (cost=0.00..4.18 rows=4 width=0) (actual time=0.000..0.000 rows=0 loops=18,010)

  • Index Cond: (order_id = transactions_order.id)
329. 18.010 738.410 ↓ 0.0 0 18,010

GroupAggregate (cost=8.60..18.19 rows=1 width=9) (actual time=0.041..0.041 rows=0 loops=18,010)

  • Group Key: u0_42.id
330. 36.018 720.400 ↓ 0.0 0 18,010

Nested Loop (cost=8.60..18.17 rows=1 width=9) (actual time=0.040..0.040 rows=0 loops=18,010)

331. 259.931 684.380 ↓ 0.0 0 18,010

Hash Join (cost=8.32..13.85 rows=1 width=9) (actual time=0.038..0.038 rows=0 loops=18,010)

  • Hash Cond: (u2_26.transaction_id = u1_42.id)
332. 370.419 370.419 ↑ 1.0 144 17,639

Seq Scan on transactions_returntransaction u2_26 (cost=0.00..4.99 rows=144 width=9) (actual time=0.002..0.021 rows=144 loops=17,639)

  • Filter: (status = ANY ('{16,15}'::integer[]))
  • Rows Removed by Filter: 15
333. 18.010 54.030 ↑ 1.0 1 18,010

Hash (cost=8.30..8.30 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=18,010)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
334. 36.020 36.020 ↑ 1.0 1 18,010

Index Scan using transactions_transaction_order_id_e7f281ee on transactions_transaction u1_42 (cost=0.29..8.30 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=18,010)

  • Index Cond: (order_id = transactions_order.id)
335. 0.002 0.002 ↑ 1.0 1 2

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
336. 0.000 720.400 ↓ 0.0 0 18,010

GroupAggregate (cost=8.60..18.19 rows=1 width=9) (actual time=0.040..0.040 rows=0 loops=18,010)

  • Group Key: u0_43.id
337. 36.016 720.400 ↓ 0.0 0 18,010

Nested Loop (cost=8.60..18.17 rows=1 width=9) (actual time=0.040..0.040 rows=0 loops=18,010)

338. 277.941 684.380 ↓ 0.0 0 18,010

Hash Join (cost=8.32..13.85 rows=1 width=9) (actual time=0.038..0.038 rows=0 loops=18,010)

  • Hash Cond: (u2_27.transaction_id = u1_43.id)
339. 370.419 370.419 ↑ 1.0 144 17,639

Seq Scan on transactions_returntransaction u2_27 (cost=0.00..4.99 rows=144 width=9) (actual time=0.002..0.021 rows=144 loops=17,639)

  • Filter: (status = ANY ('{16,15}'::integer[]))
  • Rows Removed by Filter: 15
340. 0.000 36.020 ↑ 1.0 1 18,010

Hash (cost=8.30..8.30 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=18,010)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
341. 36.020 36.020 ↑ 1.0 1 18,010

Index Scan using transactions_transaction_order_id_e7f281ee on transactions_transaction u1_43 (cost=0.29..8.30 rows=1 width=8) (actual time=0.001..0.002 rows=1 loops=18,010)

  • Index Cond: (order_id = transactions_order.id)
342. 0.004 0.004 ↑ 1.0 1 2

Index Only Scan using transactions_order_pkey on transactions_order u0_43 (cost=0.29..4.30 rows=1 width=4) (actual time=0.001..0.002 rows=1 loops=2)

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
343. 0.000 72.040 ↓ 0.0 0 18,010

GroupAggregate (cost=4.74..23.92 rows=1 width=20) (actual time=0.004..0.004 rows=0 loops=18,010)

  • Group Key: u0_44.id
344. 17.810 72.040 ↓ 0.0 0 18,010

Nested Loop (cost=4.74..23.91 rows=1 width=20) (actual time=0.004..0.004 rows=0 loops=18,010)

345. 18.010 54.030 ↓ 0.0 0 18,010

Nested Loop (cost=0.56..12.61 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=18,010)

346. 18.010 18.010 ↑ 1.0 1 18,010

Index Only Scan using transactions_order_pkey on transactions_order u0_44 (cost=0.29..4.30 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=18,010)

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
347. 18.010 18.010 ↓ 0.0 0 18,010

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 time=0.001..0.001 rows=0 loops=18,010)

  • Index Cond: (order_id = transactions_order.id)
348. 0.200 0.200 ↓ 0.0 0 200

Bitmap Heap Scan on sv_cards_svreturntransaction u2_28 (cost=4.17..11.29 rows=1 width=20) (actual time=0.001..0.001 rows=0 loops=200)

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

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

  • Index Cond: (transaction_id = u1_44.id)
350. 18.010 162.090 ↓ 0.0 0 18,010

GroupAggregate (cost=0.29..10.16 rows=1 width=9) (actual time=0.009..0.009 rows=0 loops=18,010)

  • Group Key: u0_45.id
351. 36.020 144.080 ↓ 0.0 0 18,010

Nested Loop (cost=0.29..10.14 rows=1 width=9) (actual time=0.008..0.008 rows=0 loops=18,010)

352. 36.020 36.020 ↑ 1.0 1 18,010

Index Scan using transactions_order_pkey on transactions_order u0_45 (cost=0.29..8.31 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=18,010)

  • Index Cond: (id = transactions_order.id)
  • Filter: (flow_type = 1)
353. 72.040 72.040 ↓ 0.0 0 18,010

Seq Scan on sv_cards_svloadtransaction u1_45 (cost=0.00..1.82 rows=1 width=9) (actual time=0.004..0.004 rows=0 loops=18,010)

  • Filter: ((order_id = transactions_order.id) AND (status = 2))
  • Rows Removed by Filter: 55
354. 0.000 72.040 ↓ 0.0 0 18,010

GroupAggregate (cost=4.47..16.98 rows=1 width=20) (actual time=0.004..0.004 rows=0 loops=18,010)

  • Group Key: u0_46.id
355. 36.020 72.040 ↓ 0.0 0 18,010

Nested Loop (cost=4.47..16.97 rows=1 width=20) (actual time=0.004..0.004 rows=0 loops=18,010)

356. 18.010 18.010 ↑ 1.0 1 18,010

Index Only Scan using transactions_order_pkey on transactions_order u0_46 (cost=0.29..4.30 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=18,010)

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
357. 0.000 18.010 ↓ 0.0 0 18,010

Bitmap Heap Scan on transactions_externalreturntransaction u1_46 (cost=4.18..12.65 rows=1 width=20) (actual time=0.001..0.001 rows=0 loops=18,010)

  • Recheck Cond: (order_id = transactions_order.id)
  • Filter: (status = 3)
358. 18.010 18.010 ↓ 0.0 0 18,010

Bitmap Index Scan on transactions_externalreturntransaction_order_id_43ad2bf9 (cost=0.00..4.18 rows=4 width=0) (actual time=0.001..0.001 rows=0 loops=18,010)

  • Index Cond: (order_id = transactions_order.id)
359. 18.010 738.410 ↓ 0.0 0 18,010

GroupAggregate (cost=8.60..18.19 rows=1 width=9) (actual time=0.041..0.041 rows=0 loops=18,010)

  • Group Key: u0_47.id
360. 36.016 720.400 ↓ 0.0 0 18,010

Nested Loop (cost=8.60..18.17 rows=1 width=9) (actual time=0.040..0.040 rows=0 loops=18,010)

361. 259.931 684.380 ↓ 0.0 0 18,010

Hash Join (cost=8.32..13.85 rows=1 width=9) (actual time=0.038..0.038 rows=0 loops=18,010)

  • Hash Cond: (u2_29.transaction_id = u1_47.id)
362. 370.419 370.419 ↑ 1.0 144 17,639

Seq Scan on transactions_returntransaction u2_29 (cost=0.00..4.99 rows=144 width=9) (actual time=0.002..0.021 rows=144 loops=17,639)

  • Filter: (status = ANY ('{16,15}'::integer[]))
  • Rows Removed by Filter: 15
363. 18.010 54.030 ↑ 1.0 1 18,010

Hash (cost=8.30..8.30 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=18,010)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
364. 36.020 36.020 ↑ 1.0 1 18,010

Index Scan using transactions_transaction_order_id_e7f281ee on transactions_transaction u1_47 (cost=0.29..8.30 rows=1 width=8) (actual time=0.001..0.002 rows=1 loops=18,010)

  • Index Cond: (order_id = transactions_order.id)
365. 0.004 0.004 ↑ 1.0 1 2

Index Only Scan using transactions_order_pkey on transactions_order u0_47 (cost=0.29..4.30 rows=1 width=4) (actual time=0.001..0.002 rows=1 loops=2)

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
366. 0.000 72.040 ↓ 0.0 0 18,010

GroupAggregate (cost=4.74..23.92 rows=1 width=20) (actual time=0.004..0.004 rows=0 loops=18,010)

  • Group Key: u0_48.id
367. 17.810 72.040 ↓ 0.0 0 18,010

Nested Loop (cost=4.74..23.91 rows=1 width=20) (actual time=0.004..0.004 rows=0 loops=18,010)

368. 18.010 54.030 ↓ 0.0 0 18,010

Nested Loop (cost=0.56..12.61 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=18,010)

369. 18.010 18.010 ↑ 1.0 1 18,010

Index Only Scan using transactions_order_pkey on transactions_order u0_48 (cost=0.29..4.30 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=18,010)

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
370. 18.010 18.010 ↓ 0.0 0 18,010

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 time=0.001..0.001 rows=0 loops=18,010)

  • Index Cond: (order_id = transactions_order.id)
371. 0.200 0.200 ↓ 0.0 0 200

Bitmap Heap Scan on sv_cards_svreturntransaction u2_30 (cost=4.17..11.29 rows=1 width=20) (actual time=0.001..0.001 rows=0 loops=200)

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

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

  • Index Cond: (transaction_id = u1_48.id)
373. 0.000 144.080 ↓ 0.0 0 18,010

GroupAggregate (cost=0.29..10.16 rows=1 width=9) (actual time=0.008..0.008 rows=0 loops=18,010)

  • Group Key: u0_49.id
374. 36.020 144.080 ↓ 0.0 0 18,010

Nested Loop (cost=0.29..10.14 rows=1 width=9) (actual time=0.008..0.008 rows=0 loops=18,010)

375. 36.020 36.020 ↑ 1.0 1 18,010

Index Scan using transactions_order_pkey on transactions_order u0_49 (cost=0.29..8.31 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=18,010)

  • Index Cond: (id = transactions_order.id)
  • Filter: (flow_type = 1)
376. 72.040 72.040 ↓ 0.0 0 18,010

Seq Scan on sv_cards_svloadtransaction u1_49 (cost=0.00..1.82 rows=1 width=9) (actual time=0.004..0.004 rows=0 loops=18,010)

  • Filter: ((order_id = transactions_order.id) AND (status = 2))
  • Rows Removed by Filter: 55
377. 0.000 72.040 ↓ 0.0 0 18,010

GroupAggregate (cost=4.47..16.98 rows=1 width=20) (actual time=0.004..0.004 rows=0 loops=18,010)

  • Group Key: u0_50.id
378. 36.020 72.040 ↓ 0.0 0 18,010

Nested Loop (cost=4.47..16.97 rows=1 width=20) (actual time=0.004..0.004 rows=0 loops=18,010)

379. 18.010 18.010 ↑ 1.0 1 18,010

Index Only Scan using transactions_order_pkey on transactions_order u0_50 (cost=0.29..4.30 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=18,010)

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
380. 18.010 18.010 ↓ 0.0 0 18,010

Bitmap Heap Scan on transactions_externalreturntransaction u1_50 (cost=4.18..12.65 rows=1 width=20) (actual time=0.001..0.001 rows=0 loops=18,010)

  • Recheck Cond: (order_id = transactions_order.id)
  • Filter: (status = 3)
381. 0.000 0.000 ↓ 0.0 0 18,010

Bitmap Index Scan on transactions_externalreturntransaction_order_id_43ad2bf9 (cost=0.00..4.18 rows=4 width=0) (actual time=0.000..0.000 rows=0 loops=18,010)

  • Index Cond: (order_id = transactions_order.id)
382. 18.010 72.040 ↓ 0.0 0 18,010

GroupAggregate (cost=4.74..23.92 rows=1 width=20) (actual time=0.004..0.004 rows=0 loops=18,010)

  • Group Key: u0_51.id
383. 0.000 54.030 ↓ 0.0 0 18,010

Nested Loop (cost=4.74..23.91 rows=1 width=20) (actual time=0.003..0.003 rows=0 loops=18,010)

384. 18.010 54.030 ↓ 0.0 0 18,010

Nested Loop (cost=0.56..12.61 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=18,010)

385. 18.010 18.010 ↑ 1.0 1 18,010

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
386. 18.010 18.010 ↓ 0.0 0 18,010

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 time=0.001..0.001 rows=0 loops=18,010)

  • Index Cond: (order_id = transactions_order.id)
387. 0.200 0.200 ↓ 0.0 0 200

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

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

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

  • Index Cond: (transaction_id = u1_51.id)
389. 18.010 144.080 ↓ 0.0 0 18,010

GroupAggregate (cost=0.29..10.16 rows=1 width=9) (actual time=0.008..0.008 rows=0 loops=18,010)

  • Group Key: u0_52.id
390. 18.010 126.070 ↓ 0.0 0 18,010

Nested Loop (cost=0.29..10.14 rows=1 width=9) (actual time=0.007..0.007 rows=0 loops=18,010)

391. 36.020 36.020 ↑ 1.0 1 18,010

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

  • Index Cond: (id = transactions_order.id)
  • Filter: (flow_type = 1)
392. 72.040 72.040 ↓ 0.0 0 18,010

Seq Scan on sv_cards_svloadtransaction u1_52 (cost=0.00..1.82 rows=1 width=9) (actual time=0.004..0.004 rows=0 loops=18,010)

  • Filter: ((order_id = transactions_order.id) AND (status = 2))
  • Rows Removed by Filter: 55
393. 0.000 738.410 ↓ 0.0 0 18,010

GroupAggregate (cost=8.60..18.19 rows=1 width=9) (actual time=0.041..0.041 rows=0 loops=18,010)

  • Group Key: u0_53.id
394. 36.018 738.410 ↓ 0.0 0 18,010

Nested Loop (cost=8.60..18.17 rows=1 width=9) (actual time=0.041..0.041 rows=0 loops=18,010)

395. 277.941 702.390 ↓ 0.0 0 18,010

Hash Join (cost=8.32..13.85 rows=1 width=9) (actual time=0.039..0.039 rows=0 loops=18,010)

  • Hash Cond: (u2_32.transaction_id = u1_53.id)
396. 370.419 370.419 ↑ 1.0 144 17,639

Seq Scan on transactions_returntransaction u2_32 (cost=0.00..4.99 rows=144 width=9) (actual time=0.002..0.021 rows=144 loops=17,639)

  • Filter: (status = ANY ('{16,15}'::integer[]))
  • Rows Removed by Filter: 15
397. 18.010 54.030 ↑ 1.0 1 18,010

Hash (cost=8.30..8.30 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=18,010)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
398. 36.020 36.020 ↑ 1.0 1 18,010

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

  • Index Cond: (order_id = transactions_order.id)
399. 0.002 0.002 ↑ 1.0 1 2

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
400. 18.010 72.040 ↓ 0.0 0 18,010

GroupAggregate (cost=4.74..23.92 rows=1 width=20) (actual time=0.004..0.004 rows=0 loops=18,010)

  • Group Key: u0_54.id
401. 0.000 54.030 ↓ 0.0 0 18,010

Nested Loop (cost=4.74..23.91 rows=1 width=20) (actual time=0.003..0.003 rows=0 loops=18,010)

402. 18.010 54.030 ↓ 0.0 0 18,010

Nested Loop (cost=0.56..12.61 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=18,010)

403. 18.010 18.010 ↑ 1.0 1 18,010

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
404. 18.010 18.010 ↓ 0.0 0 18,010

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 time=0.001..0.001 rows=0 loops=18,010)

  • Index Cond: (order_id = transactions_order.id)
405. 0.200 0.200 ↓ 0.0 0 200

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

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

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

  • Index Cond: (transaction_id = u1_54.id)
407. 0.000 144.080 ↓ 0.0 0 18,010

GroupAggregate (cost=0.29..10.16 rows=1 width=9) (actual time=0.008..0.008 rows=0 loops=18,010)

  • Group Key: u0_55.id
408. 36.020 144.080 ↓ 0.0 0 18,010

Nested Loop (cost=0.29..10.14 rows=1 width=9) (actual time=0.008..0.008 rows=0 loops=18,010)

409. 36.020 36.020 ↑ 1.0 1 18,010

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

  • Index Cond: (id = transactions_order.id)
  • Filter: (flow_type = 1)
410. 72.040 72.040 ↓ 0.0 0 18,010

Seq Scan on sv_cards_svloadtransaction u1_55 (cost=0.00..1.82 rows=1 width=9) (actual time=0.004..0.004 rows=0 loops=18,010)

  • Filter: ((order_id = transactions_order.id) AND (status = 2))
  • Rows Removed by Filter: 55
411. 0.000 72.040 ↓ 0.0 0 18,010

GroupAggregate (cost=4.47..16.98 rows=1 width=20) (actual time=0.004..0.004 rows=0 loops=18,010)

  • Group Key: u0_56.id
412. 36.020 72.040 ↓ 0.0 0 18,010

Nested Loop (cost=4.47..16.97 rows=1 width=20) (actual time=0.004..0.004 rows=0 loops=18,010)

413. 18.010 18.010 ↑ 1.0 1 18,010

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
414. 0.000 18.010 ↓ 0.0 0 18,010

Bitmap Heap Scan on transactions_externalreturntransaction u1_56 (cost=4.18..12.65 rows=1 width=20) (actual time=0.001..0.001 rows=0 loops=18,010)

  • Recheck Cond: (order_id = transactions_order.id)
  • Filter: (status = 3)
415. 18.010 18.010 ↓ 0.0 0 18,010

Bitmap Index Scan on transactions_externalreturntransaction_order_id_43ad2bf9 (cost=0.00..4.18 rows=4 width=0) (actual time=0.001..0.001 rows=0 loops=18,010)

  • Index Cond: (order_id = transactions_order.id)
416. 0.000 72.040 ↓ 0.0 0 18,010

GroupAggregate (cost=4.47..16.98 rows=1 width=20) (actual time=0.004..0.004 rows=0 loops=18,010)

  • Group Key: u0_57.id
417. 36.020 72.040 ↓ 0.0 0 18,010

Nested Loop (cost=4.47..16.97 rows=1 width=20) (actual time=0.004..0.004 rows=0 loops=18,010)

418. 18.010 18.010 ↑ 1.0 1 18,010

Index Only Scan using transactions_order_pkey on transactions_order u0_57 (cost=0.29..4.30 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=18,010)

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
419. 18.010 18.010 ↓ 0.0 0 18,010

Bitmap Heap Scan on transactions_externalreturntransaction u1_57 (cost=4.18..12.65 rows=1 width=20) (actual time=0.001..0.001 rows=0 loops=18,010)

  • Recheck Cond: (order_id = transactions_order.id)
  • Filter: (status = 3)
420. 0.000 0.000 ↓ 0.0 0 18,010

Bitmap Index Scan on transactions_externalreturntransaction_order_id_43ad2bf9 (cost=0.00..4.18 rows=4 width=0) (actual time=0.000..0.000 rows=0 loops=18,010)

  • Index Cond: (order_id = transactions_order.id)
421. 18.010 738.410 ↓ 0.0 0 18,010

GroupAggregate (cost=8.60..18.19 rows=1 width=9) (actual time=0.041..0.041 rows=0 loops=18,010)

  • Group Key: u0_58.id
422. 36.016 720.400 ↓ 0.0 0 18,010

Nested Loop (cost=8.60..18.17 rows=1 width=9) (actual time=0.040..0.040 rows=0 loops=18,010)

423. 259.931 684.380 ↓ 0.0 0 18,010

Hash Join (cost=8.32..13.85 rows=1 width=9) (actual time=0.038..0.038 rows=0 loops=18,010)

  • Hash Cond: (u2_34.transaction_id = u1_58.id)
424. 370.419 370.419 ↑ 1.0 144 17,639

Seq Scan on transactions_returntransaction u2_34 (cost=0.00..4.99 rows=144 width=9) (actual time=0.002..0.021 rows=144 loops=17,639)

  • Filter: (status = ANY ('{16,15}'::integer[]))
  • Rows Removed by Filter: 15
425. 18.010 54.030 ↑ 1.0 1 18,010

Hash (cost=8.30..8.30 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=18,010)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
426. 36.020 36.020 ↑ 1.0 1 18,010

Index Scan using transactions_transaction_order_id_e7f281ee on transactions_transaction u1_58 (cost=0.29..8.30 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=18,010)

  • Index Cond: (order_id = transactions_order.id)
427. 0.004 0.004 ↑ 1.0 1 2

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
428. 18.010 720.400 ↓ 0.0 0 18,010

GroupAggregate (cost=8.60..18.19 rows=1 width=9) (actual time=0.040..0.040 rows=0 loops=18,010)

  • Group Key: u0_59.id
429. 36.016 702.390 ↓ 0.0 0 18,010

Nested Loop (cost=8.60..18.17 rows=1 width=9) (actual time=0.039..0.039 rows=0 loops=18,010)

430. 259.931 666.370 ↓ 0.0 0 18,010

Hash Join (cost=8.32..13.85 rows=1 width=9) (actual time=0.037..0.037 rows=0 loops=18,010)

  • Hash Cond: (u2_35.transaction_id = u1_59.id)
431. 370.419 370.419 ↑ 1.0 144 17,639

Seq Scan on transactions_returntransaction u2_35 (cost=0.00..4.99 rows=144 width=9) (actual time=0.002..0.021 rows=144 loops=17,639)

  • Filter: (status = ANY ('{16,15}'::integer[]))
  • Rows Removed by Filter: 15
432. 0.000 36.020 ↑ 1.0 1 18,010

Hash (cost=8.30..8.30 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=18,010)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
433. 36.020 36.020 ↑ 1.0 1 18,010

Index Scan using transactions_transaction_order_id_e7f281ee on transactions_transaction u1_59 (cost=0.29..8.30 rows=1 width=8) (actual time=0.001..0.002 rows=1 loops=18,010)

  • Index Cond: (order_id = transactions_order.id)
434. 0.004 0.004 ↑ 1.0 1 2

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
435. 0.000 72.040 ↓ 0.0 0 18,010

GroupAggregate (cost=4.74..23.92 rows=1 width=20) (actual time=0.004..0.004 rows=0 loops=18,010)

  • Group Key: u0_60.id
436. 17.810 72.040 ↓ 0.0 0 18,010

Nested Loop (cost=4.74..23.91 rows=1 width=20) (actual time=0.004..0.004 rows=0 loops=18,010)

437. 18.010 54.030 ↓ 0.0 0 18,010

Nested Loop (cost=0.56..12.61 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=18,010)

438. 18.010 18.010 ↑ 1.0 1 18,010

Index Only Scan using transactions_order_pkey on transactions_order u0_60 (cost=0.29..4.30 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=18,010)

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
439. 18.010 18.010 ↓ 0.0 0 18,010

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 time=0.001..0.001 rows=0 loops=18,010)

  • Index Cond: (order_id = transactions_order.id)
440. 0.200 0.200 ↓ 0.0 0 200

Bitmap Heap Scan on sv_cards_svreturntransaction u2_36 (cost=4.17..11.29 rows=1 width=20) (actual time=0.001..0.001 rows=0 loops=200)

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

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

  • Index Cond: (transaction_id = u1_60.id)
442. 0.000 144.080 ↓ 0.0 0 18,010

GroupAggregate (cost=0.29..10.16 rows=1 width=9) (actual time=0.008..0.008 rows=0 loops=18,010)

  • Group Key: u0_61.id
443. 36.020 144.080 ↓ 0.0 0 18,010

Nested Loop (cost=0.29..10.14 rows=1 width=9) (actual time=0.008..0.008 rows=0 loops=18,010)

444. 36.020 36.020 ↑ 1.0 1 18,010

Index Scan using transactions_order_pkey on transactions_order u0_61 (cost=0.29..8.31 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=18,010)

  • Index Cond: (id = transactions_order.id)
  • Filter: (flow_type = 1)
445. 72.040 72.040 ↓ 0.0 0 18,010

Seq Scan on sv_cards_svloadtransaction u1_61 (cost=0.00..1.82 rows=1 width=9) (actual time=0.004..0.004 rows=0 loops=18,010)

  • Filter: ((order_id = transactions_order.id) AND (status = 2))
  • Rows Removed by Filter: 55
446. 0.000 72.040 ↓ 0.0 0 18,010

GroupAggregate (cost=4.47..16.98 rows=1 width=20) (actual time=0.004..0.004 rows=0 loops=18,010)

  • Group Key: u0_62.id
447. 36.020 72.040 ↓ 0.0 0 18,010

Nested Loop (cost=4.47..16.97 rows=1 width=20) (actual time=0.004..0.004 rows=0 loops=18,010)

448. 18.010 18.010 ↑ 1.0 1 18,010

Index Only Scan using transactions_order_pkey on transactions_order u0_62 (cost=0.29..4.30 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=18,010)

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
449. 18.010 18.010 ↓ 0.0 0 18,010

Bitmap Heap Scan on transactions_externalreturntransaction u1_62 (cost=4.18..12.65 rows=1 width=20) (actual time=0.001..0.001 rows=0 loops=18,010)

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

Bitmap Index Scan on transactions_externalreturntransaction_order_id_43ad2bf9 (cost=0.00..4.18 rows=4 width=0) (actual time=0.000..0.000 rows=0 loops=18,010)

  • Index Cond: (order_id = transactions_order.id)
451. 18.010 738.410 ↓ 0.0 0 18,010

GroupAggregate (cost=8.60..18.19 rows=1 width=9) (actual time=0.041..0.041 rows=0 loops=18,010)

  • Group Key: u0_63.id
452. 36.016 720.400 ↓ 0.0 0 18,010

Nested Loop (cost=8.60..18.17 rows=1 width=9) (actual time=0.040..0.040 rows=0 loops=18,010)

453. 259.931 684.380 ↓ 0.0 0 18,010

Hash Join (cost=8.32..13.85 rows=1 width=9) (actual time=0.038..0.038 rows=0 loops=18,010)

  • Hash Cond: (u2_37.transaction_id = u1_63.id)
454. 370.419 370.419 ↑ 1.0 144 17,639

Seq Scan on transactions_returntransaction u2_37 (cost=0.00..4.99 rows=144 width=9) (actual time=0.002..0.021 rows=144 loops=17,639)

  • Filter: (status = ANY ('{16,15}'::integer[]))
  • Rows Removed by Filter: 15
455. 18.010 54.030 ↑ 1.0 1 18,010

Hash (cost=8.30..8.30 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=18,010)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
456. 36.020 36.020 ↑ 1.0 1 18,010

Index Scan using transactions_transaction_order_id_e7f281ee on transactions_transaction u1_63 (cost=0.29..8.30 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=18,010)

  • Index Cond: (order_id = transactions_order.id)
457. 0.004 0.004 ↑ 1.0 1 2

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
458. 18.010 72.040 ↓ 0.0 0 18,010

GroupAggregate (cost=4.74..23.92 rows=1 width=20) (actual time=0.004..0.004 rows=0 loops=18,010)

  • Group Key: u0_64.id
459. 0.000 54.030 ↓ 0.0 0 18,010

Nested Loop (cost=4.74..23.91 rows=1 width=20) (actual time=0.003..0.003 rows=0 loops=18,010)

460. 18.010 54.030 ↓ 0.0 0 18,010

Nested Loop (cost=0.56..12.61 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=18,010)

461. 18.010 18.010 ↑ 1.0 1 18,010

Index Only Scan using transactions_order_pkey on transactions_order u0_64 (cost=0.29..4.30 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=18,010)

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
462. 18.010 18.010 ↓ 0.0 0 18,010

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 time=0.001..0.001 rows=0 loops=18,010)

  • Index Cond: (order_id = transactions_order.id)
463. 0.200 0.200 ↓ 0.0 0 200

Bitmap Heap Scan on sv_cards_svreturntransaction u2_38 (cost=4.17..11.29 rows=1 width=20) (actual time=0.001..0.001 rows=0 loops=200)

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

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

  • Index Cond: (transaction_id = u1_64.id)
465. 0.000 144.080 ↓ 0.0 0 18,010

GroupAggregate (cost=0.29..10.16 rows=1 width=9) (actual time=0.008..0.008 rows=0 loops=18,010)

  • Group Key: u0_65.id
466. 36.020 144.080 ↓ 0.0 0 18,010

Nested Loop (cost=0.29..10.14 rows=1 width=9) (actual time=0.008..0.008 rows=0 loops=18,010)

467. 36.020 36.020 ↑ 1.0 1 18,010

Index Scan using transactions_order_pkey on transactions_order u0_65 (cost=0.29..8.31 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=18,010)

  • Index Cond: (id = transactions_order.id)
  • Filter: (flow_type = 1)
468. 72.040 72.040 ↓ 0.0 0 18,010

Seq Scan on sv_cards_svloadtransaction u1_65 (cost=0.00..1.82 rows=1 width=9) (actual time=0.004..0.004 rows=0 loops=18,010)

  • Filter: ((order_id = transactions_order.id) AND (status = 2))
  • Rows Removed by Filter: 55
469. 0.000 72.040 ↓ 0.0 0 18,010

GroupAggregate (cost=4.47..16.98 rows=1 width=20) (actual time=0.004..0.004 rows=0 loops=18,010)

  • Group Key: u0_66.id
470. 36.020 72.040 ↓ 0.0 0 18,010

Nested Loop (cost=4.47..16.97 rows=1 width=20) (actual time=0.004..0.004 rows=0 loops=18,010)

471. 18.010 18.010 ↑ 1.0 1 18,010

Index Only Scan using transactions_order_pkey on transactions_order u0_66 (cost=0.29..4.30 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=18,010)

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
472. 0.000 18.010 ↓ 0.0 0 18,010

Bitmap Heap Scan on transactions_externalreturntransaction u1_66 (cost=4.18..12.65 rows=1 width=20) (actual time=0.001..0.001 rows=0 loops=18,010)

  • Recheck Cond: (order_id = transactions_order.id)
  • Filter: (status = 3)
473. 18.010 18.010 ↓ 0.0 0 18,010

Bitmap Index Scan on transactions_externalreturntransaction_order_id_43ad2bf9 (cost=0.00..4.18 rows=4 width=0) (actual time=0.001..0.001 rows=0 loops=18,010)

  • Index Cond: (order_id = transactions_order.id)
474. 0.000 72.040 ↓ 0.0 0 18,010

GroupAggregate (cost=4.47..16.98 rows=1 width=20) (actual time=0.004..0.004 rows=0 loops=18,010)

  • Group Key: u0_67.id
475. 36.020 72.040 ↓ 0.0 0 18,010

Nested Loop (cost=4.47..16.97 rows=1 width=20) (actual time=0.004..0.004 rows=0 loops=18,010)

476. 18.010 18.010 ↑ 1.0 1 18,010

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
477. 18.010 18.010 ↓ 0.0 0 18,010

Bitmap Heap Scan on transactions_externalreturntransaction u1_67 (cost=4.18..12.65 rows=1 width=20) (actual time=0.001..0.001 rows=0 loops=18,010)

  • Recheck Cond: (order_id = transactions_order.id)
  • Filter: (status = 3)
478. 0.000 0.000 ↓ 0.0 0 18,010

Bitmap Index Scan on transactions_externalreturntransaction_order_id_43ad2bf9 (cost=0.00..4.18 rows=4 width=0) (actual time=0.000..0.000 rows=0 loops=18,010)

  • Index Cond: (order_id = transactions_order.id)
479. 18.010 738.410 ↓ 0.0 0 18,010

GroupAggregate (cost=8.60..18.19 rows=1 width=9) (actual time=0.041..0.041 rows=0 loops=18,010)

  • Group Key: u0_68.id
480. 36.018 720.400 ↓ 0.0 0 18,010

Nested Loop (cost=8.60..18.17 rows=1 width=9) (actual time=0.040..0.040 rows=0 loops=18,010)

481. 259.931 684.380 ↓ 0.0 0 18,010

Hash Join (cost=8.32..13.85 rows=1 width=9) (actual time=0.038..0.038 rows=0 loops=18,010)

  • Hash Cond: (u2_39.transaction_id = u1_68.id)
482. 370.419 370.419 ↑ 1.0 144 17,639

Seq Scan on transactions_returntransaction u2_39 (cost=0.00..4.99 rows=144 width=9) (actual time=0.002..0.021 rows=144 loops=17,639)

  • Filter: (status = ANY ('{16,15}'::integer[]))
  • Rows Removed by Filter: 15
483. 18.010 54.030 ↑ 1.0 1 18,010

Hash (cost=8.30..8.30 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=18,010)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
484. 36.020 36.020 ↑ 1.0 1 18,010

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

  • Index Cond: (order_id = transactions_order.id)
485. 0.002 0.002 ↑ 1.0 1 2

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
486. 0.000 720.400 ↓ 0.0 0 18,010

GroupAggregate (cost=8.60..18.19 rows=1 width=9) (actual time=0.040..0.040 rows=0 loops=18,010)

  • Group Key: u0_69.id
487. 36.016 720.400 ↓ 0.0 0 18,010

Nested Loop (cost=8.60..18.17 rows=1 width=9) (actual time=0.040..0.040 rows=0 loops=18,010)

488. 277.941 684.380 ↓ 0.0 0 18,010

Hash Join (cost=8.32..13.85 rows=1 width=9) (actual time=0.038..0.038 rows=0 loops=18,010)

  • Hash Cond: (u2_40.transaction_id = u1_69.id)
489. 370.419 370.419 ↑ 1.0 144 17,639

Seq Scan on transactions_returntransaction u2_40 (cost=0.00..4.99 rows=144 width=9) (actual time=0.002..0.021 rows=144 loops=17,639)

  • Filter: (status = ANY ('{16,15}'::integer[]))
  • Rows Removed by Filter: 15
490. 0.000 36.020 ↑ 1.0 1 18,010

Hash (cost=8.30..8.30 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=18,010)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
491. 36.020 36.020 ↑ 1.0 1 18,010

Index Scan using transactions_transaction_order_id_e7f281ee on transactions_transaction u1_69 (cost=0.29..8.30 rows=1 width=8) (actual time=0.001..0.002 rows=1 loops=18,010)

  • Index Cond: (order_id = transactions_order.id)
492. 0.004 0.004 ↑ 1.0 1 2

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
493. 18.010 72.040 ↓ 0.0 0 18,010

GroupAggregate (cost=4.74..23.92 rows=1 width=20) (actual time=0.004..0.004 rows=0 loops=18,010)

  • Group Key: u0_70.id
494. 0.000 54.030 ↓ 0.0 0 18,010

Nested Loop (cost=4.74..23.91 rows=1 width=20) (actual time=0.003..0.003 rows=0 loops=18,010)

495. 18.010 54.030 ↓ 0.0 0 18,010

Nested Loop (cost=0.56..12.61 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=18,010)

496. 18.010 18.010 ↑ 1.0 1 18,010

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
497. 18.010 18.010 ↓ 0.0 0 18,010

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 time=0.001..0.001 rows=0 loops=18,010)

  • Index Cond: (order_id = transactions_order.id)
498. 0.200 0.200 ↓ 0.0 0 200

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

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

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

  • Index Cond: (transaction_id = u1_70.id)
500. 0.000 144.080 ↓ 0.0 0 18,010

GroupAggregate (cost=0.29..10.16 rows=1 width=9) (actual time=0.008..0.008 rows=0 loops=18,010)

  • Group Key: u0_71.id
501. 36.020 144.080 ↓ 0.0 0 18,010

Nested Loop (cost=0.29..10.14 rows=1 width=9) (actual time=0.008..0.008 rows=0 loops=18,010)

502. 36.020 36.020 ↑ 1.0 1 18,010

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

  • Index Cond: (id = transactions_order.id)
  • Filter: (flow_type = 1)
503. 72.040 72.040 ↓ 0.0 0 18,010

Seq Scan on sv_cards_svloadtransaction u1_71 (cost=0.00..1.82 rows=1 width=9) (actual time=0.004..0.004 rows=0 loops=18,010)

  • Filter: ((order_id = transactions_order.id) AND (status = 2))
  • Rows Removed by Filter: 55
504. 0.000 72.040 ↓ 0.0 0 18,010

GroupAggregate (cost=4.47..16.98 rows=1 width=20) (actual time=0.004..0.004 rows=0 loops=18,010)

  • Group Key: u0_72.id
505. 36.020 72.040 ↓ 0.0 0 18,010

Nested Loop (cost=4.47..16.97 rows=1 width=20) (actual time=0.004..0.004 rows=0 loops=18,010)

506. 18.010 18.010 ↑ 1.0 1 18,010

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
507. 18.010 18.010 ↓ 0.0 0 18,010

Bitmap Heap Scan on transactions_externalreturntransaction u1_72 (cost=4.18..12.65 rows=1 width=20) (actual time=0.001..0.001 rows=0 loops=18,010)

  • Recheck Cond: (order_id = transactions_order.id)
  • Filter: (status = 3)
508. 0.000 0.000 ↓ 0.0 0 18,010

Bitmap Index Scan on transactions_externalreturntransaction_order_id_43ad2bf9 (cost=0.00..4.18 rows=4 width=0) (actual time=0.000..0.000 rows=0 loops=18,010)

  • Index Cond: (order_id = transactions_order.id)
509. 18.010 738.410 ↓ 0.0 0 18,010

GroupAggregate (cost=8.60..18.19 rows=1 width=9) (actual time=0.041..0.041 rows=0 loops=18,010)

  • Group Key: u0_73.id
510. 36.018 720.400 ↓ 0.0 0 18,010

Nested Loop (cost=8.60..18.17 rows=1 width=9) (actual time=0.040..0.040 rows=0 loops=18,010)

511. 259.931 684.380 ↓ 0.0 0 18,010

Hash Join (cost=8.32..13.85 rows=1 width=9) (actual time=0.038..0.038 rows=0 loops=18,010)

  • Hash Cond: (u2_42.transaction_id = u1_73.id)
512. 370.419 370.419 ↑ 1.0 144 17,639

Seq Scan on transactions_returntransaction u2_42 (cost=0.00..4.99 rows=144 width=9) (actual time=0.002..0.021 rows=144 loops=17,639)

  • Filter: (status = ANY ('{16,15}'::integer[]))
  • Rows Removed by Filter: 15
513. 18.010 54.030 ↑ 1.0 1 18,010

Hash (cost=8.30..8.30 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=18,010)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
514. 36.020 36.020 ↑ 1.0 1 18,010

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

  • Index Cond: (order_id = transactions_order.id)
515. 0.002 0.002 ↑ 1.0 1 2

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
516. 18.010 72.040 ↓ 0.0 0 18,010

GroupAggregate (cost=4.74..23.92 rows=1 width=20) (actual time=0.004..0.004 rows=0 loops=18,010)

  • Group Key: u0_74.id
517. 0.000 54.030 ↓ 0.0 0 18,010

Nested Loop (cost=4.74..23.91 rows=1 width=20) (actual time=0.003..0.003 rows=0 loops=18,010)

518. 18.010 54.030 ↓ 0.0 0 18,010

Nested Loop (cost=0.56..12.61 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=18,010)

519. 18.010 18.010 ↑ 1.0 1 18,010

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
520. 18.010 18.010 ↓ 0.0 0 18,010

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 time=0.001..0.001 rows=0 loops=18,010)

  • Index Cond: (order_id = transactions_order.id)
521. 0.200 0.200 ↓ 0.0 0 200

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

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

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

  • Index Cond: (transaction_id = u1_74.id)
523. 0.000 144.080 ↓ 0.0 0 18,010

GroupAggregate (cost=0.29..10.16 rows=1 width=9) (actual time=0.008..0.008 rows=0 loops=18,010)

  • Group Key: u0_75.id
524. 36.020 144.080 ↓ 0.0 0 18,010

Nested Loop (cost=0.29..10.14 rows=1 width=9) (actual time=0.008..0.008 rows=0 loops=18,010)

525. 36.020 36.020 ↑ 1.0 1 18,010

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

  • Index Cond: (id = transactions_order.id)
  • Filter: (flow_type = 1)
526. 72.040 72.040 ↓ 0.0 0 18,010

Seq Scan on sv_cards_svloadtransaction u1_75 (cost=0.00..1.82 rows=1 width=9) (actual time=0.004..0.004 rows=0 loops=18,010)

  • Filter: ((order_id = transactions_order.id) AND (status = 2))
  • Rows Removed by Filter: 55
527. 0.000 72.040 ↓ 0.0 0 18,010

GroupAggregate (cost=4.47..16.98 rows=1 width=20) (actual time=0.004..0.004 rows=0 loops=18,010)

  • Group Key: u0_76.id
528. 36.020 72.040 ↓ 0.0 0 18,010

Nested Loop (cost=4.47..16.97 rows=1 width=20) (actual time=0.004..0.004 rows=0 loops=18,010)

529. 18.010 18.010 ↑ 1.0 1 18,010

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
530. 18.010 18.010 ↓ 0.0 0 18,010

Bitmap Heap Scan on transactions_externalreturntransaction u1_76 (cost=4.18..12.65 rows=1 width=20) (actual time=0.001..0.001 rows=0 loops=18,010)

  • Recheck Cond: (order_id = transactions_order.id)
  • Filter: (status = 3)
531. 0.000 0.000 ↓ 0.0 0 18,010

Bitmap Index Scan on transactions_externalreturntransaction_order_id_43ad2bf9 (cost=0.00..4.18 rows=4 width=0) (actual time=0.000..0.000 rows=0 loops=18,010)

  • Index Cond: (order_id = transactions_order.id)
532. 18.010 72.040 ↓ 0.0 0 18,010

GroupAggregate (cost=4.74..23.92 rows=1 width=20) (actual time=0.004..0.004 rows=0 loops=18,010)

  • Group Key: u0_77.id
533. 0.000 54.030 ↓ 0.0 0 18,010

Nested Loop (cost=4.74..23.91 rows=1 width=20) (actual time=0.003..0.003 rows=0 loops=18,010)

534. 18.010 54.030 ↓ 0.0 0 18,010

Nested Loop (cost=0.56..12.61 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=18,010)

535. 18.010 18.010 ↑ 1.0 1 18,010

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
536. 18.010 18.010 ↓ 0.0 0 18,010

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 time=0.001..0.001 rows=0 loops=18,010)

  • Index Cond: (order_id = transactions_order.id)
537. 0.200 0.200 ↓ 0.0 0 200

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

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

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

  • Index Cond: (transaction_id = u1_77.id)
539. 0.000 144.080 ↓ 0.0 0 18,010

GroupAggregate (cost=0.29..10.16 rows=1 width=9) (actual time=0.008..0.008 rows=0 loops=18,010)

  • Group Key: u0_78.id
540. 36.020 144.080 ↓ 0.0 0 18,010

Nested Loop (cost=0.29..10.14 rows=1 width=9) (actual time=0.008..0.008 rows=0 loops=18,010)

541. 36.020 36.020 ↑ 1.0 1 18,010

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

  • Index Cond: (id = transactions_order.id)
  • Filter: (flow_type = 1)
542. 72.040 72.040 ↓ 0.0 0 18,010

Seq Scan on sv_cards_svloadtransaction u1_78 (cost=0.00..1.82 rows=1 width=9) (actual time=0.004..0.004 rows=0 loops=18,010)

  • Filter: ((order_id = transactions_order.id) AND (status = 2))
  • Rows Removed by Filter: 55
543. 18.010 738.410 ↓ 0.0 0 18,010

GroupAggregate (cost=8.60..18.19 rows=1 width=9) (actual time=0.041..0.041 rows=0 loops=18,010)

  • Group Key: u0_79.id
544. 36.018 720.400 ↓ 0.0 0 18,010

Nested Loop (cost=8.60..18.17 rows=1 width=9) (actual time=0.040..0.040 rows=0 loops=18,010)

545. 259.931 684.380 ↓ 0.0 0 18,010

Hash Join (cost=8.32..13.85 rows=1 width=9) (actual time=0.038..0.038 rows=0 loops=18,010)

  • Hash Cond: (u2_45.transaction_id = u1_79.id)
546. 370.419 370.419 ↑ 1.0 144 17,639

Seq Scan on transactions_returntransaction u2_45 (cost=0.00..4.99 rows=144 width=9) (actual time=0.002..0.021 rows=144 loops=17,639)

  • Filter: (status = ANY ('{16,15}'::integer[]))
  • Rows Removed by Filter: 15
547. 18.010 54.030 ↑ 1.0 1 18,010

Hash (cost=8.30..8.30 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=18,010)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
548. 36.020 36.020 ↑ 1.0 1 18,010

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

  • Index Cond: (order_id = transactions_order.id)
549. 0.002 0.002 ↑ 1.0 1 2

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
550. 18.010 72.040 ↓ 0.0 0 18,010

GroupAggregate (cost=4.74..23.92 rows=1 width=20) (actual time=0.004..0.004 rows=0 loops=18,010)

  • Group Key: u0_80.id
551. 0.000 54.030 ↓ 0.0 0 18,010

Nested Loop (cost=4.74..23.91 rows=1 width=20) (actual time=0.003..0.003 rows=0 loops=18,010)

552. 18.010 54.030 ↓ 0.0 0 18,010

Nested Loop (cost=0.56..12.61 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=18,010)

553. 18.010 18.010 ↑ 1.0 1 18,010

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
554. 18.010 18.010 ↓ 0.0 0 18,010

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 time=0.001..0.001 rows=0 loops=18,010)

  • Index Cond: (order_id = transactions_order.id)
555. 0.200 0.200 ↓ 0.0 0 200

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

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

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

  • Index Cond: (transaction_id = u1_80.id)
557. 0.000 144.080 ↓ 0.0 0 18,010

GroupAggregate (cost=0.29..10.16 rows=1 width=9) (actual time=0.008..0.008 rows=0 loops=18,010)

  • Group Key: u0_81.id
558. 36.020 144.080 ↓ 0.0 0 18,010

Nested Loop (cost=0.29..10.14 rows=1 width=9) (actual time=0.008..0.008 rows=0 loops=18,010)

559. 36.020 36.020 ↑ 1.0 1 18,010

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

  • Index Cond: (id = transactions_order.id)
  • Filter: (flow_type = 1)
560. 72.040 72.040 ↓ 0.0 0 18,010

Seq Scan on sv_cards_svloadtransaction u1_81 (cost=0.00..1.82 rows=1 width=9) (actual time=0.004..0.004 rows=0 loops=18,010)

  • Filter: ((order_id = transactions_order.id) AND (status = 2))
  • Rows Removed by Filter: 55
561. 0.000 72.040 ↓ 0.0 0 18,010

GroupAggregate (cost=4.47..16.98 rows=1 width=20) (actual time=0.004..0.004 rows=0 loops=18,010)

  • Group Key: u0_82.id
562. 36.020 72.040 ↓ 0.0 0 18,010

Nested Loop (cost=4.47..16.97 rows=1 width=20) (actual time=0.004..0.004 rows=0 loops=18,010)

563. 18.010 18.010 ↑ 1.0 1 18,010

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
564. 18.010 18.010 ↓ 0.0 0 18,010

Bitmap Heap Scan on transactions_externalreturntransaction u1_82 (cost=4.18..12.65 rows=1 width=20) (actual time=0.001..0.001 rows=0 loops=18,010)

  • Recheck Cond: (order_id = transactions_order.id)
  • Filter: (status = 3)
565. 0.000 0.000 ↓ 0.0 0 18,010

Bitmap Index Scan on transactions_externalreturntransaction_order_id_43ad2bf9 (cost=0.00..4.18 rows=4 width=0) (actual time=0.000..0.000 rows=0 loops=18,010)

  • Index Cond: (order_id = transactions_order.id)
566. 54.030 180.100 ↑ 1.0 1 18,010

GroupAggregate (cost=8.59..14.05 rows=1 width=17) (actual time=0.010..0.010 rows=1 loops=18,010)

  • Group Key: u0_83.id
567. 36.020 126.070 ↑ 1.0 1 18,010

Nested Loop Left Join (cost=8.59..14.03 rows=1 width=17) (actual time=0.007..0.007 rows=1 loops=18,010)

  • Join Filter: (u0_83.id = u1_83.order_id)
568. 18.010 18.010 ↑ 1.0 1 18,010

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
569. 36.020 72.040 ↓ 0.0 0 18,010

Hash Right Join (cost=8.30..9.71 rows=1 width=17) (actual time=0.004..0.004 rows=0 loops=18,010)

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

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

571. 18.010 36.020 ↓ 0.0 0 18,010

Hash (cost=8.29..8.29 rows=1 width=17) (actual time=0.002..0.002 rows=0 loops=18,010)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
572. 18.010 18.010 ↓ 0.0 0 18,010

Index Scan using offerings_offeringusage_order_id_6f067d93 on offerings_offeringusage u1_83 (cost=0.28..8.29 rows=1 width=17) (actual time=0.001..0.001 rows=0 loops=18,010)

  • Index Cond: (order_id = transactions_order.id)
573. 18.010 270.150 ↑ 1.0 1 18,010

GroupAggregate (cost=4.74..26.97 rows=1 width=32) (actual time=0.015..0.015 rows=1 loops=18,010)

  • Group Key: u0_84.id
574. 72.040 252.140 ↑ 1.0 1 18,010

Nested Loop Left Join (cost=4.74..26.94 rows=1 width=32) (actual time=0.013..0.014 rows=1 loops=18,010)

  • Join Filter: (u1_84.offering_id = u3_3.id)
  • Rows Removed by Join Filter: 32
575. 36.020 108.060 ↑ 1.0 1 18,010

Nested Loop Left Join (cost=4.74..25.29 rows=1 width=32) (actual time=0.006..0.006 rows=1 loops=18,010)

576. 18.010 54.030 ↑ 1.0 1 18,010

Nested Loop Left Join (cost=0.56..12.61 rows=1 width=12) (actual time=0.003..0.003 rows=1 loops=18,010)

  • Join Filter: (u0_84.id = u1_84.order_id)
577. 18.010 18.010 ↑ 1.0 1 18,010

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
578. 18.010 18.010 ↓ 0.0 0 18,010

Index Scan using offerings_offeringusage_order_id_6f067d93 on offerings_offeringusage u1_84 (cost=0.28..8.29 rows=1 width=12) (actual time=0.001..0.001 rows=0 loops=18,010)

  • Index Cond: (order_id = transactions_order.id)
579. 18.010 18.010 ↓ 0.0 0 18,010

Bitmap Heap Scan on offerings_offeringusagereturn u2_48 (cost=4.18..12.64 rows=4 width=28) (actual time=0.001..0.001 rows=0 loops=18,010)

  • Recheck Cond: (u1_84.id = offering_usage_id)
580. 0.000 0.000 ↓ 0.0 0 18,010

Bitmap Index Scan on offerings_offeringusagereturn_offering_usage_id_9101d4da (cost=0.00..4.18 rows=4 width=0) (actual time=0.000..0.000 rows=0 loops=18,010)

  • Index Cond: (u1_84.id = offering_usage_id)
581. 72.040 72.040 ↓ 1.1 32 18,010

Seq Scan on offerings_offering u3_3 (cost=0.00..1.29 rows=29 width=8) (actual time=0.001..0.004 rows=32 loops=18,010)

582. 18.010 90.050 ↓ 0.0 0 18,010

GroupAggregate (cost=4.47..16.98 rows=1 width=20) (actual time=0.005..0.005 rows=0 loops=18,010)

  • Group Key: u0_85.id
583. 36.020 72.040 ↓ 0.0 0 18,010

Nested Loop (cost=4.47..16.97 rows=1 width=20) (actual time=0.004..0.004 rows=0 loops=18,010)

584. 18.010 18.010 ↑ 1.0 1 18,010

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
585. 18.010 18.010 ↓ 0.0 0 18,010

Bitmap Heap Scan on transactions_externalreturntransaction u1_85 (cost=4.18..12.65 rows=1 width=20) (actual time=0.001..0.001 rows=0 loops=18,010)

  • Recheck Cond: (order_id = transactions_order.id)
  • Filter: (status = 3)
586. 0.000 0.000 ↓ 0.0 0 18,010

Bitmap Index Scan on transactions_externalreturntransaction_order_id_43ad2bf9 (cost=0.00..4.18 rows=4 width=0) (actual time=0.000..0.000 rows=0 loops=18,010)

  • Index Cond: (order_id = transactions_order.id)
587. 18.010 738.410 ↓ 0.0 0 18,010

GroupAggregate (cost=8.60..18.19 rows=1 width=9) (actual time=0.041..0.041 rows=0 loops=18,010)

  • Group Key: u0_86.id
588. 36.016 720.400 ↓ 0.0 0 18,010

Nested Loop (cost=8.60..18.17 rows=1 width=9) (actual time=0.040..0.040 rows=0 loops=18,010)

589. 259.931 684.380 ↓ 0.0 0 18,010

Hash Join (cost=8.32..13.85 rows=1 width=9) (actual time=0.038..0.038 rows=0 loops=18,010)

  • Hash Cond: (u2_49.transaction_id = u1_86.id)
590. 370.419 370.419 ↑ 1.0 144 17,639

Seq Scan on transactions_returntransaction u2_49 (cost=0.00..4.99 rows=144 width=9) (actual time=0.002..0.021 rows=144 loops=17,639)

  • Filter: (status = ANY ('{16,15}'::integer[]))
  • Rows Removed by Filter: 15
591. 18.010 54.030 ↑ 1.0 1 18,010

Hash (cost=8.30..8.30 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=18,010)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
592. 36.020 36.020 ↑ 1.0 1 18,010

Index Scan using transactions_transaction_order_id_e7f281ee on transactions_transaction u1_86 (cost=0.29..8.30 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=18,010)

  • Index Cond: (order_id = transactions_order.id)
593. 0.004 0.004 ↑ 1.0 1 2

Index Only Scan using transactions_order_pkey on transactions_order u0_86 (cost=0.29..4.30 rows=1 width=4) (actual time=0.001..0.002 rows=1 loops=2)

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
594. 0.000 720.400 ↓ 0.0 0 18,010

GroupAggregate (cost=8.60..18.19 rows=1 width=9) (actual time=0.040..0.040 rows=0 loops=18,010)

  • Group Key: u0_87.id
595. 36.018 720.400 ↓ 0.0 0 18,010

Nested Loop (cost=8.60..18.17 rows=1 width=9) (actual time=0.040..0.040 rows=0 loops=18,010)

596. 259.931 684.380 ↓ 0.0 0 18,010

Hash Join (cost=8.32..13.85 rows=1 width=9) (actual time=0.038..0.038 rows=0 loops=18,010)

  • Hash Cond: (u2_50.transaction_id = u1_87.id)
597. 370.419 370.419 ↑ 1.0 144 17,639

Seq Scan on transactions_returntransaction u2_50 (cost=0.00..4.99 rows=144 width=9) (actual time=0.002..0.021 rows=144 loops=17,639)

  • Filter: (status = ANY ('{16,15}'::integer[]))
  • Rows Removed by Filter: 15
598. 18.010 54.030 ↑ 1.0 1 18,010

Hash (cost=8.30..8.30 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=18,010)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
599. 36.020 36.020 ↑ 1.0 1 18,010

Index Scan using transactions_transaction_order_id_e7f281ee on transactions_transaction u1_87 (cost=0.29..8.30 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=18,010)

  • Index Cond: (order_id = transactions_order.id)
600. 0.002 0.002 ↑ 1.0 1 2

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
601. 18.010 72.040 ↓ 0.0 0 18,010

GroupAggregate (cost=4.74..23.92 rows=1 width=20) (actual time=0.004..0.004 rows=0 loops=18,010)

  • Group Key: u0_88.id
602. 0.000 54.030 ↓ 0.0 0 18,010

Nested Loop (cost=4.74..23.91 rows=1 width=20) (actual time=0.003..0.003 rows=0 loops=18,010)

603. 18.010 54.030 ↓ 0.0 0 18,010

Nested Loop (cost=0.56..12.61 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=18,010)

604. 18.010 18.010 ↑ 1.0 1 18,010

Index Only Scan using transactions_order_pkey on transactions_order u0_88 (cost=0.29..4.30 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=18,010)

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
605. 18.010 18.010 ↓ 0.0 0 18,010

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 time=0.001..0.001 rows=0 loops=18,010)

  • Index Cond: (order_id = transactions_order.id)
606. 0.200 0.200 ↓ 0.0 0 200

Bitmap Heap Scan on sv_cards_svreturntransaction u2_51 (cost=4.17..11.29 rows=1 width=20) (actual time=0.001..0.001 rows=0 loops=200)

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

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

  • Index Cond: (transaction_id = u1_88.id)
608. 0.000 144.080 ↓ 0.0 0 18,010

GroupAggregate (cost=0.29..10.16 rows=1 width=9) (actual time=0.008..0.008 rows=0 loops=18,010)

  • Group Key: u0_89.id
609. 36.020 144.080 ↓ 0.0 0 18,010

Nested Loop (cost=0.29..10.14 rows=1 width=9) (actual time=0.008..0.008 rows=0 loops=18,010)

610. 36.020 36.020 ↑ 1.0 1 18,010

Index Scan using transactions_order_pkey on transactions_order u0_89 (cost=0.29..8.31 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=18,010)

  • Index Cond: (id = transactions_order.id)
  • Filter: (flow_type = 1)
611. 72.040 72.040 ↓ 0.0 0 18,010

Seq Scan on sv_cards_svloadtransaction u1_89 (cost=0.00..1.82 rows=1 width=9) (actual time=0.004..0.004 rows=0 loops=18,010)

  • Filter: ((order_id = transactions_order.id) AND (status = 2))
  • Rows Removed by Filter: 55
612. 18.010 90.050 ↓ 0.0 0 18,010

GroupAggregate (cost=4.47..16.98 rows=1 width=20) (actual time=0.005..0.005 rows=0 loops=18,010)

  • Group Key: u0_90.id
613. 36.020 72.040 ↓ 0.0 0 18,010

Nested Loop (cost=4.47..16.97 rows=1 width=20) (actual time=0.004..0.004 rows=0 loops=18,010)

614. 18.010 18.010 ↑ 1.0 1 18,010

Index Only Scan using transactions_order_pkey on transactions_order u0_90 (cost=0.29..4.30 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=18,010)

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
615. 0.000 18.010 ↓ 0.0 0 18,010

Bitmap Heap Scan on transactions_externalreturntransaction u1_90 (cost=4.18..12.65 rows=1 width=20) (actual time=0.001..0.001 rows=0 loops=18,010)

  • Recheck Cond: (order_id = transactions_order.id)
  • Filter: (status = 3)
616. 18.010 18.010 ↓ 0.0 0 18,010

Bitmap Index Scan on transactions_externalreturntransaction_order_id_43ad2bf9 (cost=0.00..4.18 rows=4 width=0) (actual time=0.001..0.001 rows=0 loops=18,010)

  • Index Cond: (order_id = transactions_order.id)
617. 0.000 738.410 ↓ 0.0 0 18,010

GroupAggregate (cost=8.60..18.19 rows=1 width=9) (actual time=0.041..0.041 rows=0 loops=18,010)

  • Group Key: u0_91.id
618. 36.016 738.410 ↓ 0.0 0 18,010

Nested Loop (cost=8.60..18.17 rows=1 width=9) (actual time=0.041..0.041 rows=0 loops=18,010)

619. 277.941 702.390 ↓ 0.0 0 18,010

Hash Join (cost=8.32..13.85 rows=1 width=9) (actual time=0.039..0.039 rows=0 loops=18,010)

  • Hash Cond: (u2_52.transaction_id = u1_91.id)
620. 370.419 370.419 ↑ 1.0 144 17,639

Seq Scan on transactions_returntransaction u2_52 (cost=0.00..4.99 rows=144 width=9) (actual time=0.002..0.021 rows=144 loops=17,639)

  • Filter: (status = ANY ('{16,15}'::integer[]))
  • Rows Removed by Filter: 15
621. 18.010 54.030 ↑ 1.0 1 18,010

Hash (cost=8.30..8.30 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=18,010)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
622. 36.020 36.020 ↑ 1.0 1 18,010

Index Scan using transactions_transaction_order_id_e7f281ee on transactions_transaction u1_91 (cost=0.29..8.30 rows=1 width=8) (actual time=0.001..0.002 rows=1 loops=18,010)

  • Index Cond: (order_id = transactions_order.id)
623. 0.004 0.004 ↑ 1.0 1 2

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
624. 18.010 72.040 ↓ 0.0 0 18,010

GroupAggregate (cost=4.74..23.92 rows=1 width=20) (actual time=0.004..0.004 rows=0 loops=18,010)

  • Group Key: u0_92.id
625. 0.000 54.030 ↓ 0.0 0 18,010

Nested Loop (cost=4.74..23.91 rows=1 width=20) (actual time=0.003..0.003 rows=0 loops=18,010)

626. 18.010 54.030 ↓ 0.0 0 18,010

Nested Loop (cost=0.56..12.61 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=18,010)

627. 18.010 18.010 ↑ 1.0 1 18,010

Index Only Scan using transactions_order_pkey on transactions_order u0_92 (cost=0.29..4.30 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=18,010)

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
628. 18.010 18.010 ↓ 0.0 0 18,010

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 time=0.001..0.001 rows=0 loops=18,010)

  • Index Cond: (order_id = transactions_order.id)
629. 0.200 0.200 ↓ 0.0 0 200

Bitmap Heap Scan on sv_cards_svreturntransaction u2_53 (cost=4.17..11.29 rows=1 width=20) (actual time=0.001..0.001 rows=0 loops=200)

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

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

  • Index Cond: (transaction_id = u1_92.id)
631. 0.000 144.080 ↓ 0.0 0 18,010

GroupAggregate (cost=0.29..10.16 rows=1 width=9) (actual time=0.008..0.008 rows=0 loops=18,010)

  • Group Key: u0_93.id
632. 36.020 144.080 ↓ 0.0 0 18,010

Nested Loop (cost=0.29..10.14 rows=1 width=9) (actual time=0.008..0.008 rows=0 loops=18,010)

633. 36.020 36.020 ↑ 1.0 1 18,010

Index Scan using transactions_order_pkey on transactions_order u0_93 (cost=0.29..8.31 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=18,010)

  • Index Cond: (id = transactions_order.id)
  • Filter: (flow_type = 1)
634. 72.040 72.040 ↓ 0.0 0 18,010

Seq Scan on sv_cards_svloadtransaction u1_93 (cost=0.00..1.82 rows=1 width=9) (actual time=0.004..0.004 rows=0 loops=18,010)

  • Filter: ((order_id = transactions_order.id) AND (status = 2))
  • Rows Removed by Filter: 55
635. 0.000 72.040 ↓ 0.0 0 18,010

GroupAggregate (cost=4.47..16.98 rows=1 width=20) (actual time=0.004..0.004 rows=0 loops=18,010)

  • Group Key: u0_94.id
636. 36.020 72.040 ↓ 0.0 0 18,010

Nested Loop (cost=4.47..16.97 rows=1 width=20) (actual time=0.004..0.004 rows=0 loops=18,010)

637. 18.010 18.010 ↑ 1.0 1 18,010

Index Only Scan using transactions_order_pkey on transactions_order u0_94 (cost=0.29..4.30 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=18,010)

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
638. 0.000 18.010 ↓ 0.0 0 18,010

Bitmap Heap Scan on transactions_externalreturntransaction u1_94 (cost=4.18..12.65 rows=1 width=20) (actual time=0.001..0.001 rows=0 loops=18,010)

  • Recheck Cond: (order_id = transactions_order.id)
  • Filter: (status = 3)
639. 18.010 18.010 ↓ 0.0 0 18,010

Bitmap Index Scan on transactions_externalreturntransaction_order_id_43ad2bf9 (cost=0.00..4.18 rows=4 width=0) (actual time=0.001..0.001 rows=0 loops=18,010)

  • Index Cond: (order_id = transactions_order.id)
640. 36.020 180.100 ↑ 1.0 1 18,010

GroupAggregate (cost=8.59..14.05 rows=1 width=17) (actual time=0.010..0.010 rows=1 loops=18,010)

  • Group Key: u0_95.id
641. 54.030 144.080 ↑ 1.0 1 18,010

Nested Loop Left Join (cost=8.59..14.03 rows=1 width=17) (actual time=0.007..0.008 rows=1 loops=18,010)

  • Join Filter: (u0_95.id = u1_95.order_id)
642. 18.010 18.010 ↑ 1.0 1 18,010

Index Only Scan using transactions_order_pkey on transactions_order u0_95 (cost=0.29..4.30 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=18,010)

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
643. 36.020 72.040 ↓ 0.0 0 18,010

Hash Right Join (cost=8.30..9.71 rows=1 width=17) (actual time=0.004..0.004 rows=0 loops=18,010)

  • Hash Cond: (u2_54.id = u1_95.offering_id)
644. 0.000 0.000 ↓ 0.0 0

Seq Scan on offerings_offering u2_54 (cost=0.00..1.29 rows=29 width=8) (never executed)

645. 18.010 36.020 ↓ 0.0 0 18,010

Hash (cost=8.29..8.29 rows=1 width=17) (actual time=0.002..0.002 rows=0 loops=18,010)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
646. 18.010 18.010 ↓ 0.0 0 18,010

Index Scan using offerings_offeringusage_order_id_6f067d93 on offerings_offeringusage u1_95 (cost=0.28..8.29 rows=1 width=17) (actual time=0.001..0.001 rows=0 loops=18,010)

  • Index Cond: (order_id = transactions_order.id)
647. 18.010 270.150 ↑ 1.0 1 18,010

GroupAggregate (cost=4.74..26.97 rows=1 width=32) (actual time=0.015..0.015 rows=1 loops=18,010)

  • Group Key: u0_96.id
648. 72.040 252.140 ↑ 1.0 1 18,010

Nested Loop Left Join (cost=4.74..26.94 rows=1 width=32) (actual time=0.013..0.014 rows=1 loops=18,010)

  • Join Filter: (u1_96.offering_id = u3_4.id)
  • Rows Removed by Join Filter: 32
649. 36.020 108.060 ↑ 1.0 1 18,010

Nested Loop Left Join (cost=4.74..25.29 rows=1 width=32) (actual time=0.006..0.006 rows=1 loops=18,010)

650. 18.010 54.030 ↑ 1.0 1 18,010

Nested Loop Left Join (cost=0.56..12.61 rows=1 width=12) (actual time=0.003..0.003 rows=1 loops=18,010)

  • Join Filter: (u0_96.id = u1_96.order_id)
651. 18.010 18.010 ↑ 1.0 1 18,010

Index Only Scan using transactions_order_pkey on transactions_order u0_96 (cost=0.29..4.30 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=18,010)

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
652. 18.010 18.010 ↓ 0.0 0 18,010

Index Scan using offerings_offeringusage_order_id_6f067d93 on offerings_offeringusage u1_96 (cost=0.28..8.29 rows=1 width=12) (actual time=0.001..0.001 rows=0 loops=18,010)

  • Index Cond: (order_id = transactions_order.id)
653. 18.010 18.010 ↓ 0.0 0 18,010

Bitmap Heap Scan on offerings_offeringusagereturn u2_55 (cost=4.18..12.64 rows=4 width=28) (actual time=0.001..0.001 rows=0 loops=18,010)

  • Recheck Cond: (u1_96.id = offering_usage_id)
654. 0.000 0.000 ↓ 0.0 0 18,010

Bitmap Index Scan on offerings_offeringusagereturn_offering_usage_id_9101d4da (cost=0.00..4.18 rows=4 width=0) (actual time=0.000..0.000 rows=0 loops=18,010)

  • Index Cond: (u1_96.id = offering_usage_id)
655. 72.040 72.040 ↓ 1.1 32 18,010

Seq Scan on offerings_offering u3_4 (cost=0.00..1.29 rows=29 width=8) (actual time=0.001..0.004 rows=32 loops=18,010)

656. 18.010 72.040 ↓ 0.0 0 18,010

GroupAggregate (cost=4.74..23.92 rows=1 width=20) (actual time=0.004..0.004 rows=0 loops=18,010)

  • Group Key: u0_97.id
657. 0.000 54.030 ↓ 0.0 0 18,010

Nested Loop (cost=4.74..23.91 rows=1 width=20) (actual time=0.003..0.003 rows=0 loops=18,010)

658. 18.010 54.030 ↓ 0.0 0 18,010

Nested Loop (cost=0.56..12.61 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=18,010)

659. 18.010 18.010 ↑ 1.0 1 18,010

Index Only Scan using transactions_order_pkey on transactions_order u0_97 (cost=0.29..4.30 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=18,010)

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
660. 18.010 18.010 ↓ 0.0 0 18,010

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 time=0.001..0.001 rows=0 loops=18,010)

  • Index Cond: (order_id = transactions_order.id)
661. 0.200 0.200 ↓ 0.0 0 200

Bitmap Heap Scan on sv_cards_svreturntransaction u2_56 (cost=4.17..11.29 rows=1 width=20) (actual time=0.001..0.001 rows=0 loops=200)

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

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

  • Index Cond: (transaction_id = u1_97.id)
663. 0.000 144.080 ↓ 0.0 0 18,010

GroupAggregate (cost=0.29..10.16 rows=1 width=9) (actual time=0.008..0.008 rows=0 loops=18,010)

  • Group Key: u0_98.id
664. 36.020 144.080 ↓ 0.0 0 18,010

Nested Loop (cost=0.29..10.14 rows=1 width=9) (actual time=0.008..0.008 rows=0 loops=18,010)

665. 36.020 36.020 ↑ 1.0 1 18,010

Index Scan using transactions_order_pkey on transactions_order u0_98 (cost=0.29..8.31 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=18,010)

  • Index Cond: (id = transactions_order.id)
  • Filter: (flow_type = 1)
666. 72.040 72.040 ↓ 0.0 0 18,010

Seq Scan on sv_cards_svloadtransaction u1_98 (cost=0.00..1.82 rows=1 width=9) (actual time=0.004..0.004 rows=0 loops=18,010)

  • Filter: ((order_id = transactions_order.id) AND (status = 2))
  • Rows Removed by Filter: 55
667. 18.010 738.410 ↓ 0.0 0 18,010

GroupAggregate (cost=8.60..18.19 rows=1 width=9) (actual time=0.041..0.041 rows=0 loops=18,010)

  • Group Key: u0_99.id
668. 36.016 720.400 ↓ 0.0 0 18,010

Nested Loop (cost=8.60..18.17 rows=1 width=9) (actual time=0.040..0.040 rows=0 loops=18,010)

669. 259.931 684.380 ↓ 0.0 0 18,010

Hash Join (cost=8.32..13.85 rows=1 width=9) (actual time=0.038..0.038 rows=0 loops=18,010)

  • Hash Cond: (u2_57.transaction_id = u1_99.id)
670. 370.419 370.419 ↑ 1.0 144 17,639

Seq Scan on transactions_returntransaction u2_57 (cost=0.00..4.99 rows=144 width=9) (actual time=0.002..0.021 rows=144 loops=17,639)

  • Filter: (status = ANY ('{16,15}'::integer[]))
  • Rows Removed by Filter: 15
671. 18.010 54.030 ↑ 1.0 1 18,010

Hash (cost=8.30..8.30 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=18,010)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
672. 36.020 36.020 ↑ 1.0 1 18,010

Index Scan using transactions_transaction_order_id_e7f281ee on transactions_transaction u1_99 (cost=0.29..8.30 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=18,010)

  • Index Cond: (order_id = transactions_order.id)
673. 0.004 0.004 ↑ 1.0 1 2

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
674. 18.010 72.040 ↓ 0.0 0 18,010

GroupAggregate (cost=4.74..23.92 rows=1 width=20) (actual time=0.004..0.004 rows=0 loops=18,010)

  • Group Key: u0_100.id
675. 0.000 54.030 ↓ 0.0 0 18,010

Nested Loop (cost=4.74..23.91 rows=1 width=20) (actual time=0.003..0.003 rows=0 loops=18,010)

676. 18.010 54.030 ↓ 0.0 0 18,010

Nested Loop (cost=0.56..12.61 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=18,010)

677. 18.010 18.010 ↑ 1.0 1 18,010

Index Only Scan using transactions_order_pkey on transactions_order u0_100 (cost=0.29..4.30 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=18,010)

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
678. 18.010 18.010 ↓ 0.0 0 18,010

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 time=0.001..0.001 rows=0 loops=18,010)

  • Index Cond: (order_id = transactions_order.id)
679. 0.200 0.200 ↓ 0.0 0 200

Bitmap Heap Scan on sv_cards_svreturntransaction u2_58 (cost=4.17..11.29 rows=1 width=20) (actual time=0.001..0.001 rows=0 loops=200)

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

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

  • Index Cond: (transaction_id = u1_100.id)
681. 18.010 144.080 ↓ 0.0 0 18,010

GroupAggregate (cost=0.29..10.16 rows=1 width=9) (actual time=0.008..0.008 rows=0 loops=18,010)

  • Group Key: u0_101.id
682. 18.010 126.070 ↓ 0.0 0 18,010

Nested Loop (cost=0.29..10.14 rows=1 width=9) (actual time=0.007..0.007 rows=0 loops=18,010)

683. 36.020 36.020 ↑ 1.0 1 18,010

Index Scan using transactions_order_pkey on transactions_order u0_101 (cost=0.29..8.31 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=18,010)

  • Index Cond: (id = transactions_order.id)
  • Filter: (flow_type = 1)
684. 72.040 72.040 ↓ 0.0 0 18,010

Seq Scan on sv_cards_svloadtransaction u1_101 (cost=0.00..1.82 rows=1 width=9) (actual time=0.004..0.004 rows=0 loops=18,010)

  • Filter: ((order_id = transactions_order.id) AND (status = 2))
  • Rows Removed by Filter: 55
685. 18.010 90.050 ↓ 0.0 0 18,010

GroupAggregate (cost=4.47..16.98 rows=1 width=20) (actual time=0.005..0.005 rows=0 loops=18,010)

  • Group Key: u0_102.id
686. 36.020 72.040 ↓ 0.0 0 18,010

Nested Loop (cost=4.47..16.97 rows=1 width=20) (actual time=0.004..0.004 rows=0 loops=18,010)

687. 18.010 18.010 ↑ 1.0 1 18,010

Index Only Scan using transactions_order_pkey on transactions_order u0_102 (cost=0.29..4.30 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=18,010)

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
688. 0.000 18.010 ↓ 0.0 0 18,010

Bitmap Heap Scan on transactions_externalreturntransaction u1_102 (cost=4.18..12.65 rows=1 width=20) (actual time=0.001..0.001 rows=0 loops=18,010)

  • Recheck Cond: (order_id = transactions_order.id)
  • Filter: (status = 3)
689. 18.010 18.010 ↓ 0.0 0 18,010

Bitmap Index Scan on transactions_externalreturntransaction_order_id_43ad2bf9 (cost=0.00..4.18 rows=4 width=0) (actual time=0.001..0.001 rows=0 loops=18,010)

  • Index Cond: (order_id = transactions_order.id)
690. 18.010 144.080 ↓ 0.0 0 18,010

GroupAggregate (cost=4.48..22.71 rows=1 width=8) (actual time=0.008..0.008 rows=0 loops=18,010)

  • Group Key: u0_103.id
691. 36.020 126.070 ↓ 0.0 0 18,010

Nested Loop (cost=4.48..22.69 rows=1 width=8) (actual time=0.007..0.007 rows=0 loops=18,010)

692. 54.030 54.030 ↑ 1.0 1 18,010

Index Only Scan using merchants_applicationuserprofile_pkey on merchants_applicationuserprofile u0_103 (cost=0.28..8.29 rows=1 width=4) (actual time=0.002..0.003 rows=1 loops=18,010)

  • Index Cond: (id = transactions_order.app_user_id)
  • Heap Fetches: 18010
693. 18.010 36.020 ↓ 0.0 0 18,010

Bitmap Heap Scan on badges_usertag u1_103 (cost=4.21..14.39 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=18,010)

  • 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))
694. 18.010 18.010 ↓ 0.0 0 18,010

Bitmap Index Scan on badges_usertag_app_user_id_tag_id_archi_0e88207c_uniq (cost=0.00..4.21 rows=7 width=0) (actual time=0.001..0.001 rows=0 loops=18,010)

  • Index Cond: (app_user_id = transactions_order.app_user_id)
695. 0.000 108.060 ↓ 0.0 0 18,010

GroupAggregate (cost=4.44..15.62 rows=1 width=8) (actual time=0.006..0.006 rows=0 loops=18,010)

  • Group Key: u0_104.id
696. 54.030 108.060 ↓ 0.0 0 18,010

Nested Loop (cost=4.44..15.60 rows=1 width=8) (actual time=0.006..0.006 rows=0 loops=18,010)

697. 18.010 18.010 ↑ 1.0 1 18,010

Index Only Scan using merchants_applicationuserprofile_pkey on merchants_applicationuserprofile u0_104 (cost=0.28..8.29 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=18,010)

  • Index Cond: (id = transactions_order.app_user_id)
  • Heap Fetches: 18010
698. 0.000 36.020 ↓ 0.0 0 18,010

Bitmap Heap Scan on badges_userbadge u1_104 (cost=4.16..7.30 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=18,010)

  • 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))
  • Heap Blocks: exact=52
699. 36.020 36.020 ↓ 0.0 0 18,010

Bitmap Index Scan on badges_userbadge_user_id_77032e2b (cost=0.00..4.16 rows=2 width=0) (actual time=0.002..0.002 rows=0 loops=18,010)

  • Index Cond: (app_user_id = transactions_order.app_user_id)
700. 54.030 108.060 ↑ 1.0 1 18,010

GroupAggregate (cost=0.56..12.63 rows=1 width=13) (actual time=0.005..0.006 rows=1 loops=18,010)

  • Group Key: u0_105.id
701. 18.010 54.030 ↑ 1.0 1 18,010

Nested Loop Left Join (cost=0.56..12.61 rows=1 width=13) (actual time=0.003..0.003 rows=1 loops=18,010)

  • Join Filter: (u0_105.id = u1_105.order_id)
702. 18.010 18.010 ↑ 1.0 1 18,010

Index Only Scan using transactions_order_pkey on transactions_order u0_105 (cost=0.29..4.30 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=18,010)

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
703. 18.010 18.010 ↓ 0.0 0 18,010

Index Scan using offerings_offeringusage_order_id_6f067d93 on offerings_offeringusage u1_105 (cost=0.28..8.29 rows=1 width=13) (actual time=0.001..0.001 rows=0 loops=18,010)

  • Index Cond: (order_id = transactions_order.id)
Planning time : 73.099 ms
Execution time : 31,872.363 ms