explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ftnX : v4

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 37,140.866 ↑ 1.0 20 1

Limit (cost=129,234.46..129,234.51 rows=20 width=2,863) (actual time=37,140.857..37,140.866 rows=20 loops=1)

2. 96.874 37,140.861 ↑ 3.5 20 1

Sort (cost=129,234.46..129,234.64 rows=69 width=2,863) (actual time=37,140.855..37,140.861 rows=20 loops=1)

  • Sort Key: transactions_order.submit_timestamp DESC
  • Sort Method: top-N heapsort Memory: 65kB
3. 3,644.910 37,043.987 ↓ 261.0 18,010 1

Hash Left Join (cost=56.70..129,232.63 rows=69 width=2,863) (actual time=2.745..37,043.987 rows=18,010 loops=1)

  • Hash Cond: (venues_pointofsale.revenue_center_id = venues_revenuecenter.id)
4. 43.289 909.028 ↓ 261.0 18,010 1

Nested Loop Left Join (cost=42.88..519.99 rows=69 width=2,419) (actual time=1.468..909.028 rows=18,010 loops=1)

5. 40.580 865.739 ↓ 261.0 18,010 1

Nested Loop (cost=42.73..507.78 rows=69 width=2,180) (actual time=1.467..865.739 rows=18,010 loops=1)

6. 41.086 771.129 ↓ 261.0 18,010 1

Nested Loop Left Join (cost=42.57..492.26 rows=69 width=2,170) (actual time=1.463..771.129 rows=18,010 loops=1)

7. 35.772 730.043 ↓ 261.0 18,010 1

Nested Loop Left Join (cost=42.43..480.04 rows=69 width=1,924) (actual time=1.460..730.043 rows=18,010 loops=1)

8. 32.186 604.221 ↓ 261.0 18,010 1

Hash Left Join (cost=42.15..452.63 rows=69 width=1,831) (actual time=1.459..604.221 rows=18,010 loops=1)

  • Hash Cond: (venues_pointofsale.venue_id = venues_venue.id)
9. 23.914 572.030 ↓ 261.0 18,010 1

Hash Left Join (cost=26.08..435.91 rows=69 width=1,565) (actual time=1.449..572.030 rows=18,010 loops=1)

  • Hash Cond: (transactions_order.spot_id = venues_spot.id)
10. 23.958 548.101 ↓ 261.0 18,010 1

Hash Left Join (cost=23.52..433.08 rows=69 width=1,553) (actual time=1.433..548.101 rows=18,010 loops=1)

  • Hash Cond: (transactions_order.section_id = venues_section.id)
11. 35.185 524.121 ↓ 261.0 18,010 1

Hash Left Join (cost=21.11..430.37 rows=69 width=1,508) (actual time=1.409..524.121 rows=18,010 loops=1)

  • Hash Cond: (t10.user_id = userprofiles_userprofile.id)
12. 36.245 488.789 ↓ 261.0 18,010 1

Nested Loop Left Join (cost=5.75..414.44 rows=69 width=1,498) (actual time=1.255..488.789 rows=18,010 loops=1)

13. 30.806 416.524 ↓ 261.0 18,010 1

Nested Loop Left Join (cost=5.48..391.84 rows=69 width=1,470) (actual time=1.254..416.524 rows=18,010 loops=1)

14. 40.638 295.668 ↓ 261.0 18,010 1

Nested Loop Left Join (cost=5.20..365.00 rows=69 width=1,382) (actual time=1.252..295.668 rows=18,010 loops=1)

15. 40.467 182.990 ↓ 261.0 18,010 1

Nested Loop (cost=4.92..343.65 rows=69 width=1,063) (actual time=1.249..182.990 rows=18,010 loops=1)

16. 40.909 40.988 ↓ 233.4 20,307 1

Nested Loop (cost=4.63..313.12 rows=87 width=1,063) (actual time=0.047..40.988 rows=20,307 loops=1)

  • -> Index Scan using transactions_order_point_of_sale_id_1cbcf3f0 on transactions_order (cost=0.29..278.93 rows=940 width=650) (actual time=0.006..2.309 rows=1846 (...)
17. 0.028 0.079 ↓ 11.0 11 1

Nested Loop (cost=4.35..24.79 rows=1 width=413) (actual time=0.034..0.079 rows=11 loops=1)

  • Join Filter: (payments_merchantpaymentgatewaysettings.id = venues_pointofsale.payment_gateway_settings_id)
  • Rows Removed by Join Filter: 17
  • Index Cond: (point_of_sale_id = venues_pointofsale.id)
18. 0.023 0.023 ↓ 1.0 28 1

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

19. 0.011 0.028 ↑ 4.0 1 28

Materialize (cost=4.35..21.91 rows=4 width=328) (actual time=0.001..0.001 rows=1 loops=28)

20. 0.012 0.017 ↑ 4.0 1 1

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

  • -> Index Scan using merchants_merchantaccount_application_id_e364f0de on merchants_merchantaccount (cost=0.15..8.17 rows=1 width=284) (actual ti (...)
  • Index Cond: (application_id = 8)
21. 0.005 0.005 ↑ 6.0 1 1

Bitmap Heap Scan on payments_merchantpaymentgatewaysettings (cost=4.20..13.67 rows=6 width=44) (actual time=0.005..0.005 rows=1 loops=1)

  • Recheck Cond: (merchant_id = merchants_merchantaccount.id)
  • Heap Blocks: exact=1
  • -> Bitmap Index Scan on payments_merchantpayment_merchant_id_payment_gate_293b6c56_uniq (cost=0.00..4.20 rows=6 width=0) (actual time=0.00 (...)
  • Index Cond: (merchant_id = merchants_merchantaccount.id)
22. 101.535 101.535 ↑ 1.0 1 20,307

Index Scan using mlc_mlcorder_order_id_key on mlc_mlcorder (cost=0.29..0.34 rows=1 width=4) (actual time=0.005..0.005 rows=1 loops=20,307)

  • Index Cond: (order_id = transactions_order.id)
  • Filter: (id IS NOT NULL)
23. 72.040 72.040 ↑ 1.0 1 18,010

Index Scan using payments_creditcardconfig_pkey on payments_creditcardconfig (cost=0.28..0.30 rows=1 width=319) (actual time=0.004..0.004 rows=1 loops=18,010)

  • Index Cond: (transactions_order.credit_card_config_id = id)
24. 90.050 90.050 ↑ 1.0 1 18,010

Index Scan using payments_creditcard_pkey on payments_creditcard (cost=0.28..0.38 rows=1 width=88) (actual time=0.004..0.005 rows=1 loops=18,010)

  • Index Cond: (payments_creditcardconfig.credit_card_id = id)
25. 36.020 36.020 ↑ 1.0 1 18,010

Index Scan using merchants_applicationuserprofile_pkey on merchants_applicationuserprofile t10 (cost=0.28..0.32 rows=1 width=28) (actual time=0.001..0.002 rows=1 loops=18,010)

  • Index Cond: (payments_creditcard.app_user_id = id)
26. 0.077 0.147 ↓ 1.0 551 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 31kB
27. 0.070 0.070 ↓ 1.0 551 1

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

28. 0.010 0.022 ↑ 1.0 63 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 13kB
29. 0.012 0.012 ↑ 1.0 63 1

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

30. 0.008 0.015 ↑ 1.0 69 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
31. 0.007 0.007 ↑ 1.0 69 1

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

32. 0.003 0.005 ↑ 38.6 7 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
33. 0.002 0.002 ↑ 38.6 7 1

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

34. 90.050 90.050 ↑ 1.0 1 18,010

Index Scan using auth_user_pkey on auth_user (cost=0.28..0.39 rows=1 width=93) (actual time=0.004..0.005 rows=1 loops=18,010)

  • Index Cond: (userprofiles_userprofile.user_id = id)
35. 0.000 0.000 ↓ 0.0 0 18,010

Index Scan using venues_seat_pkey on venues_seat (cost=0.15..0.17 rows=1 width=246) (actual time=0.000..0.000 rows=0 loops=18,010)

  • Index Cond: (transactions_order.seat_id = id)
36. 54.030 54.030 ↑ 1.0 1 18,010

Index Scan using payments_paymentgateway_pkey on payments_paymentgateway (cost=0.15..0.21 rows=1 width=10) (actual time=0.002..0.003 rows=1 loops=18,010)

  • Index Cond: (id = payments_merchantpaymentgatewaysettings.payment_gateway_id)
37. 0.000 0.000 ↓ 0.0 0 18,010

Index Scan using venues_event_pkey on venues_event (cost=0.15..0.17 rows=1 width=239) (actual time=0.000..0.000 rows=0 loops=18,010)

  • Index Cond: (transactions_order.event_id = id)
38. 0.004 0.009 ↑ 8.1 21 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
39. 0.005 0.005 ↑ 8.1 21 1

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

40.          

SubPlan (forHash Left Join)

41. 54.030 810.450 ↑ 1.0 1 18,010

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

  • Group Key: u0.id
42. 54.030 756.420 ↑ 1.0 1 18,010

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

  • Join Filter: (u0.id = u1.order_id)
43. 36.020 36.020 ↑ 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.002 rows=1 loops=18,010)

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
44. 417.940 666.370 ↑ 1.0 1 18,010

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

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

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

46. 36.020 72.040 ↑ 1.0 1 18,010

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

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
47. 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)
48. 36.020 738.410 ↑ 1.0 1 18,010

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

  • Group Key: u0_1.id
49. 72.040 702.390 ↑ 1.0 1 18,010

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

  • Join Filter: (u0_1.id = u1_1.order_id)
50. 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
51. 381.920 612.340 ↑ 1.0 1 18,010

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

  • Hash Cond: (u2_1.transaction_id = u1_1.id)
52. 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)

53. 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
54. 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.002..0.002 rows=1 loops=18,010)

  • Index Cond: (order_id = transactions_order.id)
55. 54.030 738.410 ↑ 1.0 1 18,010

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

  • Group Key: u0_2.id
56. 54.030 684.380 ↑ 1.0 1 18,010

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

  • Join Filter: (u0_2.id = u1_2.order_id)
57. 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
58. 381.920 612.340 ↑ 1.0 1 18,010

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

  • Hash Cond: (u2_2.transaction_id = u1_2.id)
59. 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)

60. 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
61. 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.002..0.002 rows=1 loops=18,010)

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

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

  • Group Key: u0_3.id
63. 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.037..0.039 rows=1 loops=18,010)

  • Join Filter: (u0_3.id = u1_3.order_id)
64. 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
65. 381.920 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_3.transaction_id = u1_3.id)
66. 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)

67. 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
68. 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.002..0.002 rows=1 loops=18,010)

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

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

  • Group Key: u0_4.id
70. 54.028 756.420 ↓ 0.0 0 18,010

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

71. 260.280 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_4.transaction_id = u1_4.id)
72. 388.080 388.080 ↑ 1.0 144 17,640

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

  • Filter: (status = ANY ('{16,15}'::integer[]))
  • Rows Removed by Filter: 15
73. 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
74. 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)
75. 0.002 0.002 ↑ 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.001..0.001 rows=1 loops=2)

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
76. 0.000 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
77. 36.020 144.080 ↓ 0.0 0 18,010

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

78. 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
79. 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
80. 0.000 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_6.id
81. 54.030 162.090 ↓ 0.0 0 18,010

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

82. 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)
83. 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
84. 18.010 90.050 ↓ 0.0 0 18,010

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

  • Group Key: u0_7.id
85. 0.000 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)

86. 36.020 72.040 ↓ 0.0 0 18,010

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

87. 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
88. 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)
89. 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[]))
90. 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)
91. 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_8.id
92. 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)

93. 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
94. 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)
95. 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)
96. 18.010 792.440 ↓ 0.0 0 18,010

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

  • Group Key: u0_9.id
97. 54.026 774.430 ↓ 0.0 0 18,010

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

98. 278.290 720.400 ↓ 0.0 0 18,010

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

  • Hash Cond: (u2_6.transaction_id = u1_9.id)
99. 388.080 388.080 ↑ 1.0 144 17,640

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

  • Filter: (status = ANY ('{16,15}'::integer[]))
  • Rows Removed by Filter: 15
100. 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
101. 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.002..0.002 rows=1 loops=18,010)

  • Index Cond: (order_id = transactions_order.id)
102. 0.004 0.004 ↑ 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.002..0.002 rows=1 loops=2)

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

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

  • Group Key: u0_10.id
104. 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)

105. 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)

106. 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
107. 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)
108. 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[]))
109. 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)
110. 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_11.id
111. 18.010 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)

112. 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)
113. 90.050 90.050 ↓ 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.005..0.005 rows=0 loops=18,010)

  • Filter: ((order_id = transactions_order.id) AND (status = 2))
  • Rows Removed by Filter: 55
114. 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_12.id
115. 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)

116. 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
117. 0.000 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)
118. 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)
119. 53.963 1,044.580 ↓ 0.0 0 18,010

Nested Loop Left Join (cost=17.23..55.88 rows=1 width=0) (actual time=0.058..0.058 rows=0 loops=18,010)

  • 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))
  • Rows Removed by Filter: 1
120. 53.963 972.540 ↑ 1.0 1 18,010

Nested Loop Left Join (cost=13.05..43.15 rows=1 width=16) (actual time=0.052..0.054 rows=1 loops=18,010)

121. 36.019 900.500 ↑ 1.0 1 18,010

Nested Loop Left Join (cost=8.88..31.84 rows=1 width=16) (actual time=0.048..0.050 rows=1 loops=18,010)

  • Join Filter: (u0_13.id = u4.order_id)
122. 36.016 846.470 ↑ 1.0 1 18,010

Nested Loop Left Join (cost=8.60..23.53 rows=1 width=12) (actual time=0.045..0.047 rows=1 loops=18,010)

  • Join Filter: (u0_13.id = u3.order_id)
123. 72.040 738.410 ↑ 1.0 1 18,010

Nested Loop Left Join (cost=8.60..21.83 rows=1 width=8) (actual time=0.039..0.041 rows=1 loops=18,010)

  • Join Filter: (u0_13.id = u1_13.order_id)
124. 36.020 36.020 ↑ 1.0 1 18,010

Index Scan using transactions_order_pkey on transactions_order u0_13 (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)
125. 399.930 630.350 ↑ 1.0 1 18,010

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

  • Hash Cond: (u2_8.transaction_id = u1_13.id)
126. 176.390 176.390 ↑ 1.0 159 17,639

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

127. 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
128. 36.020 36.020 ↑ 1.0 1 18,010

Index Scan using transactions_transaction_order_id_e7f281ee on transactions_transaction u1_13 (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)
129. 72.044 72.044 ↓ 0.0 0 18,011

Seq Scan on sv_cards_svloadtransaction u3 (cost=0.00..1.69 rows=1 width=8) (actual time=0.004..0.004 rows=0 loops=18,011)

  • Filter: (order_id = transactions_order.id)
  • Rows Removed by Filter: 55
130. 18.011 18.011 ↓ 0.0 0 18,011

Index Scan using sv_cards_svtransaction_order_id_c2882061 on sv_cards_svtransaction u4 (cost=0.28..8.29 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=18,011)

  • Index Cond: (order_id = transactions_order.id)
131. 18.077 18.077 ↓ 0.0 0 18,077

Bitmap Heap Scan on sv_cards_svreturntransaction u5 (cost=4.17..11.28 rows=3 width=8) (actual time=0.001..0.001 rows=0 loops=18,077)

  • Recheck Cond: (u4.id = transaction_id)
132. 0.000 0.000 ↓ 0.0 0 18,077

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=18,077)

  • Index Cond: (u4.id = transaction_id)
133. 0.000 18.077 ↓ 0.0 0 18,077

Bitmap Heap Scan on transactions_externalreturntransaction u6 (cost=4.18..12.64 rows=4 width=8) (actual time=0.001..0.001 rows=0 loops=18,077)

  • Recheck Cond: (order_id = transactions_order.id)
134. 18.077 18.077 ↓ 0.0 0 18,077

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,077)

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

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

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

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

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

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

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

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

139. 0.000 0.000 ↓ 0.0 0

Hash (cost=4.59..4.59 rows=159 width=8) (never executed)

140. 0.000 0.000 ↓ 0.0 0

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

141. 0.000 0.000 ↓ 0.0 0

Hash (cost=3,005.64..3,005.64 rows=22,553 width=12) (never executed)

142. 0.000 0.000 ↓ 0.0 0

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

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

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

144. 0.000 0.000 ↓ 0.0 0

Hash (cost=2,696.63..2,696.63 rows=22,553 width=8) (never executed)

145. 0.000 0.000 ↓ 0.0 0

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

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

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

147. 0.000 0.000 ↓ 0.0 0

Hash (cost=2,412.91..2,412.91 rows=22,553 width=4) (never executed)

148. 0.000 0.000 ↓ 0.0 0

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

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

Hash (cost=54.60..54.60 rows=881 width=8) (never executed)

150. 0.000 0.000 ↓ 0.0 0

Hash Right Join (cost=30.82..54.60 rows=881 width=8) (never executed)

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

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

152. 0.000 0.000 ↓ 0.0 0

Hash (cost=19.81..19.81 rows=881 width=8) (never executed)

153. 0.000 0.000 ↓ 0.0 0

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

154. 54.030 126.070 ↑ 1.0 1 18,010

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

  • Group Key: u0_15.id
155. 36.020 72.040 ↑ 1.0 1 18,010

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

  • Join Filter: (u0_15.id = u1_15.order_id)
156. 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
157. 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)
158. 36.020 198.110 ↑ 1.0 1 18,010

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

  • Group Key: u0_16.id
159. 72.040 162.090 ↑ 1.0 1 18,010

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

  • Join Filter: (u0_16.id = u1_16.order_id)
160. 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
161. 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_10.id = u1_16.offering_id)
162. 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)

163. 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
164. 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)
165. 54.030 198.110 ↑ 1.0 1 18,010

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

  • Group Key: u0_17.id
166. 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.008..0.008 rows=1 loops=18,010)

  • Join Filter: (u0_17.id = u1_17.order_id)
167. 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
168. 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_11.id = u1_17.offering_id)
169. 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)

170. 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
171. 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)
172. 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_18.id
173. 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.008..0.008 rows=1 loops=18,010)

  • Join Filter: (u0_18.id = u1_18.order_id)
174. 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
175. 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_12.id = u1_18.offering_id)
176. 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)

177. 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
178. 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)
179. 54.030 180.100 ↑ 1.0 1 18,010

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

  • Group Key: u0_19.id
180. 36.020 126.070 ↑ 1.0 1 18,010

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

181. 36.020 72.040 ↑ 1.0 1 18,010

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

  • Join Filter: (u0_19.id = u1_19.order_id)
182. 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
183. 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)
184. 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)
185. 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)
186. 36.020 324.180 ↑ 1.0 1 18,010

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

  • Group Key: u0_20.id
187. 90.050 288.160 ↑ 1.0 1 18,010

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

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

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

189. 36.020 72.040 ↑ 1.0 1 18,010

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

  • Join Filter: (u0_20.id = u1_20.order_id)
190. 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
191. 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)
192. 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)
193. 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)
194. 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.002..0.004 rows=32 loops=18,010)

195. 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_21.id
196. 54.030 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_21.id = u1_21.order_id)
197. 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
198. 399.930 630.350 ↑ 1.0 1 18,010

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

  • Hash Cond: (u2_15.transaction_id = u1_21.id)
199. 176.390 176.390 ↑ 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.010 rows=159 loops=17,639)

200. 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
201. 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)
202. 0.000 756.420 ↓ 0.0 0 18,010

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

  • Group Key: u0_22.id
203. 54.026 756.420 ↓ 0.0 0 18,010

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

204. 260.280 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_16.transaction_id = u1_22.id)
205. 388.080 388.080 ↑ 1.0 144 17,640

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

  • Filter: (status = ANY ('{16,15}'::integer[]))
  • Rows Removed by Filter: 15
206. 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
207. 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.002..0.002 rows=1 loops=18,010)

  • Index Cond: (order_id = transactions_order.id)
208. 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
209. 18.010 90.050 ↓ 0.0 0 18,010

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

  • Group Key: u0_23.id
210. 0.000 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)

211. 36.020 72.040 ↓ 0.0 0 18,010

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

212. 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
213. 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)
214. 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[]))
215. 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)
216. 0.000 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_24.id
217. 36.020 162.090 ↓ 0.0 0 18,010

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

218. 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)
219. 90.050 90.050 ↓ 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.005..0.005 rows=0 loops=18,010)

  • Filter: ((order_id = transactions_order.id) AND (status = 2))
  • Rows Removed by Filter: 55
220. 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
221. 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)

222. 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
223. 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)
224. 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)
225. 18.010 774.430 ↓ 0.0 0 18,010

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

  • Group Key: u0_26.id
226. 36.018 756.420 ↓ 0.0 0 18,010

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

227. 278.290 720.400 ↓ 0.0 0 18,010

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

  • Hash Cond: (u2_18.transaction_id = u1_26.id)
228. 388.080 388.080 ↑ 1.0 144 17,640

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

  • Filter: (status = ANY ('{16,15}'::integer[]))
  • Rows Removed by Filter: 15
229. 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
230. 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)
231. 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
232. 18.010 756.420 ↓ 0.0 0 18,010

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

  • Group Key: u0_27.id
233. 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)

234. 277.920 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_19.transaction_id = u1_27.id)
235. 370.440 370.440 ↑ 1.0 144 17,640

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,640)

  • Filter: (status = ANY ('{16,15}'::integer[]))
  • Rows Removed by Filter: 15
236. 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
237. 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.002..0.002 rows=1 loops=18,010)

  • Index Cond: (order_id = transactions_order.id)
238. 0.002 0.002 ↑ 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.001..0.001 rows=1 loops=2)

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

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

  • Group Key: u0_28.id
240. 0.000 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)

241. 36.020 72.040 ↓ 0.0 0 18,010

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

242. 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
243. 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)
244. 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[]))
245. 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)
246. 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_29.id
247. 18.010 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)

248. 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)
249. 90.050 90.050 ↓ 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.005..0.005 rows=0 loops=18,010)

  • Filter: ((order_id = transactions_order.id) AND (status = 2))
  • Rows Removed by Filter: 55
250. 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_30.id
251. 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)

252. 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
253. 0.000 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)
254. 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)
255. 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_31.id
256. 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)

257. 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
258. 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)
259. 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)
260. 18.010 774.430 ↓ 0.0 0 18,010

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

  • Group Key: u0_32.id
261. 36.016 756.420 ↓ 0.0 0 18,010

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

262. 278.290 720.400 ↓ 0.0 0 18,010

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

  • Hash Cond: (u2_21.transaction_id = u1_32.id)
263. 388.080 388.080 ↑ 1.0 144 17,640

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

  • Filter: (status = ANY ('{16,15}'::integer[]))
  • Rows Removed by Filter: 15
264. 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
265. 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.002..0.002 rows=1 loops=18,010)

  • Index Cond: (order_id = transactions_order.id)
266. 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
267. 0.000 756.420 ↓ 0.0 0 18,010

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

  • Group Key: u0_33.id
268. 54.028 756.420 ↓ 0.0 0 18,010

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

269. 260.280 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_22.transaction_id = u1_33.id)
270. 388.080 388.080 ↑ 1.0 144 17,640

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

  • Filter: (status = ANY ('{16,15}'::integer[]))
  • Rows Removed by Filter: 15
271. 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
272. 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)
273. 0.002 0.002 ↑ 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.001..0.001 rows=1 loops=2)

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

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

  • Group Key: u0_34.id
275. 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)

276. 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)

277. 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
278. 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)
279. 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[]))
280. 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)
281. 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_35.id
282. 18.010 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)

283. 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)
284. 90.050 90.050 ↓ 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.005..0.005 rows=0 loops=18,010)

  • Filter: ((order_id = transactions_order.id) AND (status = 2))
  • Rows Removed by Filter: 55
285. 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_36.id
286. 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)

287. 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
288. 0.000 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)
289. 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)
290. 18.010 774.430 ↓ 0.0 0 18,010

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

  • Group Key: u0_37.id
291. 36.018 756.420 ↓ 0.0 0 18,010

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

292. 278.290 720.400 ↓ 0.0 0 18,010

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

  • Hash Cond: (u2_24.transaction_id = u1_37.id)
293. 388.080 388.080 ↑ 1.0 144 17,640

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

  • Filter: (status = ANY ('{16,15}'::integer[]))
  • Rows Removed by Filter: 15
294. 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
295. 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.002..0.002 rows=1 loops=18,010)

  • Index Cond: (order_id = transactions_order.id)
296. 0.002 0.002 ↑ 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.001..0.001 rows=1 loops=2)

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

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

  • Group Key: u0_38.id
298. 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)

299. 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)

300. 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
301. 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)
302. 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[]))
303. 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)
304. 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_39.id
305. 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)

306. 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)
307. 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
308. 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_40.id
309. 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)

310. 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
311. 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)
312. 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)
313. 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_41.id
314. 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)

315. 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
316. 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)
317. 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)
318. 18.010 774.430 ↓ 0.0 0 18,010

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

  • Group Key: u0_42.id
319. 36.018 756.420 ↓ 0.0 0 18,010

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

320. 278.290 720.400 ↓ 0.0 0 18,010

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

  • Hash Cond: (u2_26.transaction_id = u1_42.id)
321. 388.080 388.080 ↑ 1.0 144 17,640

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

  • Filter: (status = ANY ('{16,15}'::integer[]))
  • Rows Removed by Filter: 15
322. 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
323. 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)
324. 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
325. 18.010 756.420 ↓ 0.0 0 18,010

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

  • Group Key: u0_43.id
326. 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)

327. 277.920 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_27.transaction_id = u1_43.id)
328. 370.440 370.440 ↑ 1.0 144 17,640

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,640)

  • Filter: (status = ANY ('{16,15}'::integer[]))
  • Rows Removed by Filter: 15
329. 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
330. 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.002..0.002 rows=1 loops=18,010)

  • Index Cond: (order_id = transactions_order.id)
331. 0.002 0.002 ↑ 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.001 rows=1 loops=2)

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

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

  • Group Key: u0_44.id
333. 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)

334. 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)

335. 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
336. 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)
337. 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[]))
338. 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)
339. 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
340. 18.010 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)

341. 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)
342. 90.050 90.050 ↓ 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.005..0.005 rows=0 loops=18,010)

  • Filter: ((order_id = transactions_order.id) AND (status = 2))
  • Rows Removed by Filter: 55
343. 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_46.id
344. 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)

345. 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
346. 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)
347. 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)
348. 18.010 792.440 ↓ 0.0 0 18,010

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

  • Group Key: u0_47.id
349. 36.018 774.430 ↓ 0.0 0 18,010

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

350. 296.300 738.410 ↓ 0.0 0 18,010

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

  • Hash Cond: (u2_29.transaction_id = u1_47.id)
351. 388.080 388.080 ↑ 1.0 144 17,640

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

  • Filter: (status = ANY ('{16,15}'::integer[]))
  • Rows Removed by Filter: 15
352. 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
353. 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.002..0.002 rows=1 loops=18,010)

  • Index Cond: (order_id = transactions_order.id)
354. 0.002 0.002 ↑ 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.001 rows=1 loops=2)

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

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

  • Group Key: u0_48.id
356. 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)

357. 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)

358. 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
359. 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)
360. 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[]))
361. 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)
362. 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_49.id
363. 18.010 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)

364. 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)
365. 90.050 90.050 ↓ 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.005..0.005 rows=0 loops=18,010)

  • Filter: ((order_id = transactions_order.id) AND (status = 2))
  • Rows Removed by Filter: 55
366. 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_50.id
367. 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)

368. 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
369. 0.000 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)
370. 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)
371. 18.010 90.050 ↓ 0.0 0 18,010

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

  • Group Key: u0_51.id
372. 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)

373. 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)

374. 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
375. 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)
376. 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[]))
377. 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)
378. 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_52.id
379. 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)

380. 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)
381. 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
382. 18.010 774.430 ↓ 0.0 0 18,010

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

  • Group Key: u0_53.id
383. 36.018 756.420 ↓ 0.0 0 18,010

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

384. 278.290 720.400 ↓ 0.0 0 18,010

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

  • Hash Cond: (u2_32.transaction_id = u1_53.id)
385. 388.080 388.080 ↑ 1.0 144 17,640

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

  • Filter: (status = ANY ('{16,15}'::integer[]))
  • Rows Removed by Filter: 15
386. 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
387. 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)
388. 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
389. 18.010 90.050 ↓ 0.0 0 18,010

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

  • Group Key: u0_54.id
390. 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)

391. 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)

392. 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
393. 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)
394. 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[]))
395. 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)
396. 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_55.id
397. 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)

398. 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)
399. 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
400. 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_56.id
401. 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)

402. 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
403. 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)
404. 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)
405. 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_57.id
406. 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)

407. 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
408. 0.000 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)
409. 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)
410. 18.010 774.430 ↓ 0.0 0 18,010

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

  • Group Key: u0_58.id
411. 36.018 756.420 ↓ 0.0 0 18,010

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

412. 278.290 720.400 ↓ 0.0 0 18,010

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

  • Hash Cond: (u2_34.transaction_id = u1_58.id)
413. 388.080 388.080 ↑ 1.0 144 17,640

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

  • Filter: (status = ANY ('{16,15}'::integer[]))
  • Rows Removed by Filter: 15
414. 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
415. 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)
416. 0.002 0.002 ↑ 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.001..0.001 rows=1 loops=2)

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

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

  • Group Key: u0_59.id
418. 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)

419. 277.920 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_35.transaction_id = u1_59.id)
420. 370.440 370.440 ↑ 1.0 144 17,640

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,640)

  • Filter: (status = ANY ('{16,15}'::integer[]))
  • Rows Removed by Filter: 15
421. 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
422. 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.002..0.002 rows=1 loops=18,010)

  • Index Cond: (order_id = transactions_order.id)
423. 0.002 0.002 ↑ 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.001..0.001 rows=1 loops=2)

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

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

  • Group Key: u0_60.id
425. 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)

426. 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)

427. 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
428. 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)
429. 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[]))
430. 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)
431. 0.000 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_61.id
432. 36.020 162.090 ↓ 0.0 0 18,010

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

433. 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)
434. 90.050 90.050 ↓ 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.005..0.005 rows=0 loops=18,010)

  • Filter: ((order_id = transactions_order.id) AND (status = 2))
  • Rows Removed by Filter: 55
435. 0.000 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_62.id
436. 54.030 90.050 ↓ 0.0 0 18,010

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

437. 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
438. 0.000 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)
439. 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)
440. 18.010 774.430 ↓ 0.0 0 18,010

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

  • Group Key: u0_63.id
441. 36.018 756.420 ↓ 0.0 0 18,010

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

442. 278.290 720.400 ↓ 0.0 0 18,010

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

  • Hash Cond: (u2_37.transaction_id = u1_63.id)
443. 388.080 388.080 ↑ 1.0 144 17,640

Seq Scan on transactions_returntransaction u2_37 (cost=0.00..4.99 rows=144 width=9) (actual time=0.002..0.022 rows=144 loops=17,640)

  • Filter: (status = ANY ('{16,15}'::integer[]))
  • Rows Removed by Filter: 15
444. 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
445. 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)
446. 0.002 0.002 ↑ 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.001..0.001 rows=1 loops=2)

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

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

  • Group Key: u0_64.id
448. 0.000 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)

449. 36.020 72.040 ↓ 0.0 0 18,010

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

450. 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
451. 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)
452. 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[]))
453. 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)
454. 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_65.id
455. 18.010 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)

456. 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)
457. 90.050 90.050 ↓ 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.005..0.005 rows=0 loops=18,010)

  • Filter: ((order_id = transactions_order.id) AND (status = 2))
  • Rows Removed by Filter: 55
458. 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_66.id
459. 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)

460. 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
461. 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)
462. 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)
463. 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_67.id
464. 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)

465. 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
466. 0.000 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)
467. 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)
468. 18.010 774.430 ↓ 0.0 0 18,010

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

  • Group Key: u0_68.id
469. 36.016 756.420 ↓ 0.0 0 18,010

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

470. 278.290 720.400 ↓ 0.0 0 18,010

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

  • Hash Cond: (u2_39.transaction_id = u1_68.id)
471. 388.080 388.080 ↑ 1.0 144 17,640

Seq Scan on transactions_returntransaction u2_39 (cost=0.00..4.99 rows=144 width=9) (actual time=0.002..0.022 rows=144 loops=17,640)

  • Filter: (status = ANY ('{16,15}'::integer[]))
  • Rows Removed by Filter: 15
472. 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
473. 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)
474. 0.004 0.004 ↑ 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.002..0.002 rows=1 loops=2)

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

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

  • Group Key: u0_69.id
476. 36.016 756.420 ↓ 0.0 0 18,010

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

477. 278.290 720.400 ↓ 0.0 0 18,010

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

  • Hash Cond: (u2_40.transaction_id = u1_69.id)
478. 388.080 388.080 ↑ 1.0 144 17,640

Seq Scan on transactions_returntransaction u2_40 (cost=0.00..4.99 rows=144 width=9) (actual time=0.002..0.022 rows=144 loops=17,640)

  • Filter: (status = ANY ('{16,15}'::integer[]))
  • Rows Removed by Filter: 15
479. 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
480. 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.002..0.002 rows=1 loops=18,010)

  • Index Cond: (order_id = transactions_order.id)
481. 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.002..0.002 rows=1 loops=2)

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

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

  • Group Key: u0_70.id
483. 0.000 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)

484. 36.020 72.040 ↓ 0.0 0 18,010

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

485. 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
486. 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)
487. 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[]))
488. 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)
489. 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_71.id
490. 18.010 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)

491. 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)
492. 90.050 90.050 ↓ 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.005..0.005 rows=0 loops=18,010)

  • Filter: ((order_id = transactions_order.id) AND (status = 2))
  • Rows Removed by Filter: 55
493. 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_72.id
494. 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)

495. 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
496. 0.000 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)
497. 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)
498. 18.010 774.430 ↓ 0.0 0 18,010

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

  • Group Key: u0_73.id
499. 54.026 756.420 ↓ 0.0 0 18,010

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

500. 260.280 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_42.transaction_id = u1_73.id)
501. 388.080 388.080 ↑ 1.0 144 17,640

Seq Scan on transactions_returntransaction u2_42 (cost=0.00..4.99 rows=144 width=9) (actual time=0.002..0.022 rows=144 loops=17,640)

  • Filter: (status = ANY ('{16,15}'::integer[]))
  • Rows Removed by Filter: 15
502. 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
503. 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)
504. 0.004 0.004 ↑ 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.002..0.002 rows=1 loops=2)

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

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

  • Group Key: u0_74.id
506. 0.000 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)

507. 36.020 72.040 ↓ 0.0 0 18,010

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

508. 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
509. 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)
510. 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[]))
511. 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)
512. 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_75.id
513. 18.010 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)

514. 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)
515. 90.050 90.050 ↓ 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.005..0.005 rows=0 loops=18,010)

  • Filter: ((order_id = transactions_order.id) AND (status = 2))
  • Rows Removed by Filter: 55
516. 0.000 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_76.id
517. 54.030 90.050 ↓ 0.0 0 18,010

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

518. 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
519. 0.000 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)
520. 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)
521. 18.010 90.050 ↓ 0.0 0 18,010

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

  • Group Key: u0_77.id
522. 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)

523. 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)

524. 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
525. 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)
526. 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[]))
527. 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)
528. 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_78.id
529. 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)

530. 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)
531. 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
532. 18.010 792.440 ↓ 0.0 0 18,010

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

  • Group Key: u0_79.id
533. 54.028 774.430 ↓ 0.0 0 18,010

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

534. 278.290 720.400 ↓ 0.0 0 18,010

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

  • Hash Cond: (u2_45.transaction_id = u1_79.id)
535. 388.080 388.080 ↑ 1.0 144 17,640

Seq Scan on transactions_returntransaction u2_45 (cost=0.00..4.99 rows=144 width=9) (actual time=0.002..0.022 rows=144 loops=17,640)

  • Filter: (status = ANY ('{16,15}'::integer[]))
  • Rows Removed by Filter: 15
536. 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
537. 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)
538. 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
539. 18.010 90.050 ↓ 0.0 0 18,010

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

  • Group Key: u0_80.id
540. 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)

541. 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)

542. 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
543. 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)
544. 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[]))
545. 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)
546. 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_81.id
547. 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)

548. 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)
549. 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
550. 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_82.id
551. 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)

552. 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
553. 0.000 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)
554. 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)
555. 54.030 216.120 ↑ 1.0 1 18,010

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

  • Group Key: u0_83.id
556. 72.040 162.090 ↑ 1.0 1 18,010

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

  • Join Filter: (u0_83.id = u1_83.order_id)
557. 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
558. 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)
559. 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)

560. 0.000 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
561. 36.020 36.020 ↓ 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.002..0.002 rows=0 loops=18,010)

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

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

  • Group Key: u0_84.id
563. 72.040 306.170 ↑ 1.0 1 18,010

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

  • Join Filter: (u1_84.offering_id = u3_3.id)
  • Rows Removed by Join Filter: 32
564. 54.030 144.080 ↑ 1.0 1 18,010

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

565. 36.020 72.040 ↑ 1.0 1 18,010

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

  • Join Filter: (u0_84.id = u1_84.order_id)
566. 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
567. 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)
568. 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)
569. 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)
570. 90.050 90.050 ↓ 1.1 32 18,010

Seq Scan on offerings_offering u3_3 (cost=0.00..1.29 rows=29 width=8) (actual time=0.002..0.005 rows=32 loops=18,010)

571. 18.010 108.060 ↓ 0.0 0 18,010

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

  • Group Key: u0_85.id
572. 54.030 90.050 ↓ 0.0 0 18,010

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

573. 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
574. 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)
575. 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)
576. 18.010 774.430 ↓ 0.0 0 18,010

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

  • Group Key: u0_86.id
577. 36.018 756.420 ↓ 0.0 0 18,010

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

578. 278.290 720.400 ↓ 0.0 0 18,010

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

  • Hash Cond: (u2_49.transaction_id = u1_86.id)
579. 388.080 388.080 ↑ 1.0 144 17,640

Seq Scan on transactions_returntransaction u2_49 (cost=0.00..4.99 rows=144 width=9) (actual time=0.002..0.022 rows=144 loops=17,640)

  • Filter: (status = ANY ('{16,15}'::integer[]))
  • Rows Removed by Filter: 15
580. 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
581. 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)
582. 0.002 0.002 ↑ 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.001 rows=1 loops=2)

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

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

  • Group Key: u0_87.id
584. 36.016 756.420 ↓ 0.0 0 18,010

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

585. 295.930 720.400 ↓ 0.0 0 18,010

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

  • Hash Cond: (u2_50.transaction_id = u1_87.id)
586. 370.440 370.440 ↑ 1.0 144 17,640

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,640)

  • Filter: (status = ANY ('{16,15}'::integer[]))
  • Rows Removed by Filter: 15
587. 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
588. 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)
589. 0.004 0.004 ↑ 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.002 rows=1 loops=2)

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

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

  • Group Key: u0_88.id
591. 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)

592. 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)

593. 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
594. 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)
595. 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[]))
596. 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)
597. 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_89.id
598. 18.010 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)

599. 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)
600. 90.050 90.050 ↓ 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.005..0.005 rows=0 loops=18,010)

  • Filter: ((order_id = transactions_order.id) AND (status = 2))
  • Rows Removed by Filter: 55
601. 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
602. 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)

603. 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
604. 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)
605. 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)
606. 18.010 774.430 ↓ 0.0 0 18,010

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

  • Group Key: u0_91.id
607. 36.016 756.420 ↓ 0.0 0 18,010

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

608. 295.930 720.400 ↓ 0.0 0 18,010

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

  • Hash Cond: (u2_52.transaction_id = u1_91.id)
609. 370.440 370.440 ↑ 1.0 144 17,640

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,640)

  • Filter: (status = ANY ('{16,15}'::integer[]))
  • Rows Removed by Filter: 15
610. 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
611. 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.002..0.002 rows=1 loops=18,010)

  • Index Cond: (order_id = transactions_order.id)
612. 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
613. 18.010 90.050 ↓ 0.0 0 18,010

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

  • Group Key: u0_92.id
614. 0.000 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)

615. 36.020 72.040 ↓ 0.0 0 18,010

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

616. 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
617. 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)
618. 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[]))
619. 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)
620. 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_93.id
621. 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)

622. 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)
623. 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
624. 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_94.id
625. 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)

626. 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
627. 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)
628. 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)
629. 36.020 198.110 ↑ 1.0 1 18,010

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

  • Group Key: u0_95.id
630. 72.040 162.090 ↑ 1.0 1 18,010

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

  • Join Filter: (u0_95.id = u1_95.order_id)
631. 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
632. 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)
633. 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)

634. 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
635. 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)
636. 36.020 324.180 ↑ 1.0 1 18,010

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

  • Group Key: u0_96.id
637. 90.050 288.160 ↑ 1.0 1 18,010

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

  • Join Filter: (u1_96.offering_id = u3_4.id)
  • Rows Removed by Join Filter: 32
638. 36.020 126.070 ↑ 1.0 1 18,010

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

639. 36.020 72.040 ↑ 1.0 1 18,010

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

  • Join Filter: (u0_96.id = u1_96.order_id)
640. 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
641. 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)
642. 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)
643. 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)
644. 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)

645. 18.010 90.050 ↓ 0.0 0 18,010

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

  • Group Key: u0_97.id
646. 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)

647. 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)

648. 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
649. 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)
650. 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[]))
651. 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)
652. 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_98.id
653. 18.010 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)

654. 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)
655. 90.050 90.050 ↓ 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.005..0.005 rows=0 loops=18,010)

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

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

  • Group Key: u0_99.id
657. 36.016 756.420 ↓ 0.0 0 18,010

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

658. 278.290 720.400 ↓ 0.0 0 18,010

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

  • Hash Cond: (u2_57.transaction_id = u1_99.id)
659. 388.080 388.080 ↑ 1.0 144 17,640

Seq Scan on transactions_returntransaction u2_57 (cost=0.00..4.99 rows=144 width=9) (actual time=0.002..0.022 rows=144 loops=17,640)

  • Filter: (status = ANY ('{16,15}'::integer[]))
  • Rows Removed by Filter: 15
660. 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
661. 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)
662. 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.001..0.002 rows=1 loops=2)

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

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

  • Group Key: u0_100.id
664. 0.000 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)

665. 36.020 72.040 ↓ 0.0 0 18,010

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

666. 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
667. 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)
668. 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[]))
669. 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)
670. 18.010 180.100 ↓ 0.0 0 18,010

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

  • Group Key: u0_101.id
671. 36.020 162.090 ↓ 0.0 0 18,010

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

672. 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)
673. 90.050 90.050 ↓ 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.005..0.005 rows=0 loops=18,010)

  • Filter: ((order_id = transactions_order.id) AND (status = 2))
  • Rows Removed by Filter: 55
674. 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
675. 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)

676. 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
677. 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)
678. 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)
679. 18.010 162.090 ↓ 0.0 0 18,010

GroupAggregate (cost=4.48..22.71 rows=1 width=8) (actual time=0.009..0.009 rows=0 loops=18,010)

  • Group Key: u0_103.id
680. 36.020 144.080 ↓ 0.0 0 18,010

Nested Loop (cost=4.48..22.69 rows=1 width=8) (actual time=0.008..0.008 rows=0 loops=18,010)

681. 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.003..0.003 rows=1 loops=18,010)

  • Index Cond: (id = transactions_order.app_user_id)
  • Heap Fetches: 18010
682. 18.010 54.030 ↓ 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.003..0.003 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))
683. 36.020 36.020 ↓ 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.002..0.002 rows=0 loops=18,010)

  • Index Cond: (app_user_id = transactions_order.app_user_id)
684. 18.010 144.080 ↓ 0.0 0 18,010

GroupAggregate (cost=4.44..15.62 rows=1 width=8) (actual time=0.008..0.008 rows=0 loops=18,010)

  • Group Key: u0_104.id
685. 54.030 126.070 ↓ 0.0 0 18,010

Nested Loop (cost=4.44..15.60 rows=1 width=8) (actual time=0.007..0.007 rows=0 loops=18,010)

686. 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
687. 18.010 54.030 ↓ 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.003..0.003 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
688. 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)
689. 36.020 108.060 ↑ 1.0 1 18,010

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

  • Group Key: u0_105.id
690. 36.020 72.040 ↑ 1.0 1 18,010

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

  • Join Filter: (u0_105.id = u1_105.order_id)
691. 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
692. 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 : 107.339 ms
Execution time : 37,144.231 ms