explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 84sk : wtf

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 31,895.581 ↑ 1.0 20 1

Limit (cost=233,189.33..233,198.08 rows=20 width=2,871) (actual time=31,895.493..31,895.581 rows=20 loops=1)

2. 0.083 31,895.578 ↑ 3.5 20 1

Unique (cost=233,189.33..233,219.52 rows=69 width=2,871) (actual time=31,895.492..31,895.578 rows=20 loops=1)

3. 91.272 31,895.495 ↑ 3.5 20 1

Sort (cost=233,189.33..233,189.51 rows=69 width=2,871) (actual time=31,895.488..31,895.495 rows=20 loops=1)

  • Sort Key: transactions_order.submit_timestamp DESC, transactions_order.id, transactions_order.identifier, transactions_order.external_id, transactions_order.app_user_id, transactions_order.is_chargeback, transactions_order.credit_card_config_ (...)
  • Sort Method: external merge Disk: 15840kB
4. 562.661 31,804.223 ↓ 261.0 18,010 1

HashAggregate (cost=104,488.09..233,187.23 rows=69 width=2,871) (actual time=26,146.510..31,804.223 rows=18,010 loops=1)

  • Group Key: transactions_order.id, (SubPlan 1), (SubPlan 2), (SubPlan 3), (SubPlan 4), COALESCE((SubPlan 5), 0.00), COALESCE((SubPlan 6), 0.00), COALESCE((SubPlan 7), 0.00), COALESCE((SubPlan 8), 0.00), COALESCE((SubPlan 9), 0.00), (((CO (...)
5. 1,882.174 25,928.612 ↓ 262.0 18,077 1

Nested Loop Left Join (cost=563.24..104,477.40 rows=69 width=2,871) (actual time=329.667..25,928.612 rows=18,077 loops=1)

6. 21.608 564.415 ↓ 262.0 18,077 1

Hash Left Join (cost=563.10..610.20 rows=69 width=2,632) (actual time=327.804..564.415 rows=18,077 loops=1)

  • Hash Cond: (venues_pointofsale.revenue_center_id = venues_revenuecenter.id)
7. 33.650 542.798 ↓ 262.0 18,077 1

Nested Loop (cost=549.27..595.84 rows=69 width=2,188) (actual time=327.789..542.798 rows=18,077 loops=1)

8. 23.113 472.994 ↓ 262.0 18,077 1

Hash Left Join (cost=549.12..580.32 rows=69 width=2,178) (actual time=327.777..472.994 rows=18,077 loops=1)

  • Hash Cond: (venues_pointofsale.venue_id = venues_venue.id)
9. 15.023 449.876 ↓ 262.0 18,077 1

Hash Left Join (cost=533.04..563.60 rows=69 width=1,912) (actual time=327.767..449.876 rows=18,077 loops=1)

  • Hash Cond: (transactions_order.section_id = venues_section.id)
10. 27.698 434.830 ↓ 262.0 18,077 1

Nested Loop Left Join (cost=530.62..560.89 rows=69 width=1,867) (actual time=327.738..434.830 rows=18,077 loops=1)

11. 17.704 407.132 ↓ 262.0 18,077 1

Hash Left Join (cost=530.48..548.66 rows=69 width=1,621) (actual time=327.733..407.132 rows=18,077 loops=1)

  • Hash Cond: (transactions_order_sv_cards.svcard_id = sv_cards_svcard.id)
12. 61.797 389.401 ↓ 262.0 18,077 1

Hash Right Join (cost=527.54..544.78 rows=69 width=1,617) (actual time=327.687..389.401 rows=18,077 loops=1)

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

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

14. 23.449 327.555 ↓ 262.0 18,077 1

Hash (cost=526.68..526.68 rows=69 width=1,524) (actual time=327.555..327.555 rows=18,077 loops=1)

  • Buckets: 8192 (originally 1024) Batches: 4 (originally 1) Memory Usage: 9848kB
15. 8.159 304.106 ↓ 262.0 18,077 1

Hash Left Join (cost=345.60..526.68 rows=69 width=1,524) (actual time=74.957..304.106 rows=18,077 loops=1)

  • Hash Cond: (t15.user_id = userprofiles_userprofile.id)
16. 27.610 295.794 ↓ 262.0 18,077 1

Nested Loop Left Join (cost=330.25..510.76 rows=69 width=1,514) (actual time=74.790..295.794 rows=18,077 loops=1)

  • -> Index Scan using merchants_applicationuserprofile_pkey on merchants_applicationuserprofile t15 (cost=0.28..0.32 rows=1 width=28) (actual time=0.001..0.001 rows=1 loo (...)
17. 11.157 268.184 ↓ 262.0 18,077 1

Nested Loop Left Join (cost=329.97..488.15 rows=69 width=1,486) (actual time=74.783..268.184 rows=18,077 loops=1)

  • Index Cond: (payments_creditcard.app_user_id = id)
18. 27.189 238.950 ↓ 262.0 18,077 1

Nested Loop Left Join (cost=329.70..461.31 rows=69 width=1,398) (actual time=74.777..238.950 rows=18,077 loops=1)

  • -> Index Scan using payments_creditcardconfig_pkey on payments_creditcardconfig (cost=0.28..0.30 rows=1 width=319) (actual time=0.001..0.001 rows=1 loops=18 (...)
19. 3.066 211.761 ↓ 262.0 18,077 1

Nested Loop (cost=329.42..439.96 rows=69 width=1,079) (actual time=74.770..211.761 rows=18,077 loops=1)

  • Index Cond: (transactions_order.credit_card_config_id = id)
20. 24.011 167.609 ↓ 236.1 20,543 1

Nested Loop Left Join (cost=329.13..409.44 rows=87 width=1,079) (actual time=74.757..167.609 rows=20,543 loops=1)

  • -> Index Scan using sv_cards_svtransaction_order_id_c2882061 on sv_cards_svtransaction (cost=0.28..0.30 rows=1 width=8) (actual time=0.001..0.00 (...)
21. 53.232 143.598 ↓ 233.5 20,315 1

Nested Loop Left Join (cost=328.86..382.87 rows=87 width=1,075) (actual time=74.751..143.598 rows=20,315 loops=1)

  • -> Index Scan using transactions_transaction_order_id_e7f281ee on transactions_transaction (cost=0.29..0.43 rows=1 width=8) (actual time=0 (...)
  • Index Cond: (transactions_order.id = order_id)
22. 15.810 90.366 ↓ 233.4 20,307 1

Hash Right Join (cost=328.57..344.87 rows=87 width=1,071) (actual time=74.735..90.366 rows=20,307 loops=1)

  • Hash Cond: (offerings_offeringusage.order_id = transactions_order.id)
  • Index Cond: (transactions_order.id = order_id)
23. 0.112 0.112 ↓ 1.0 683 1

Seq Scan on offerings_offeringusage (cost=0.00..13.74 rows=674 width=8) (actual time=0.011..0.112 rows=683 loops=1)

24. 13.688 74.444 ↓ 233.4 20,307 1

Hash (cost=327.48..327.48 rows=87 width=1,067) (actual time=74.444..74.444 rows=20,307 loops=1)

  • Buckets: 16384 (originally 1024) Batches: 2 (originally 1) Memory Usage: 4831kB
25. 24.971 60.756 ↓ 233.4 20,307 1

Hash Right Join (cost=314.21..327.48 rows=87 width=1,067) (actual time=35.854..60.756 rows=20,307 loops=1)

  • Hash Cond: (transactions_order_sv_cards.order_id = transactions_order.id)
  • -> Seq Scan on transactions_order_sv_cards (cost=0.00..10.72 rows=672 width=8) (actual time=0.006..0.070 rows=672 loops= (...)
26. 21.853 35.785 ↓ 233.4 20,307 1

Hash (cost=313.12..313.12 rows=87 width=1,063) (actual time=35.785..35.785 rows=20,307 loops=1)

  • Buckets: 8192 (originally 1024) Batches: 4 (originally 1) Memory Usage: 4033kB
27. 13.870 13.932 ↓ 233.4 20,307 1

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

  • -> Index Scan using transactions_order_point_of_sale_id_1cbcf3f0 on transactions_order (cost=0.29..278.93 ro (...)
28. 0.034 0.062 ↓ 11.0 11 1

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

  • Join Filter: (payments_merchantpaymentgatewaysettings.id = venues_pointofsale.payment_gateway_settings_i (...)
  • Rows Removed by Join Filter: 17
  • -> Seq Scan on venues_pointofsale (cost=0.00..1.27 rows=27 width=85) (actual time=0.004..0.012 rows=28 (...)
  • Index Cond: (point_of_sale_id = venues_pointofsale.id)
29. 0.007 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)

30. 0.021 0.021 ↑ 4.0 1 1

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

  • -> Index Scan using merchants_merchantaccount_application_id_e364f0de on merchants_merchant (...)
  • Index Cond: (application_id = 8)
  • -> Bitmap Heap Scan on payments_merchantpaymentgatewaysettings (cost=4.20..13.67 rows=6 wi (...)
  • Recheck Cond: (merchant_id = merchants_merchantaccount.id)
  • Heap Blocks: exact=1
  • -> Bitmap Index Scan on payments_merchantpayment_merchant_id_payment_gate_293b6c56_un (...)
  • Index Cond: (merchant_id = merchants_merchantaccount.id)
31. 41.086 41.086 ↑ 1.0 1 20,543

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

  • Index Cond: (order_id = transactions_order.id)
  • Filter: (id IS NOT NULL)
32. 18.077 18.077 ↑ 1.0 1 18,077

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

  • Index Cond: (payments_creditcardconfig.credit_card_id = id)
33. 0.067 0.153 ↓ 1.0 551 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 31kB
34. 0.086 0.086 ↓ 1.0 551 1

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

35. 0.012 0.027 ↑ 1.0 86 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
36. 0.015 0.015 ↑ 1.0 86 1

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

37. 0.000 0.000 ↓ 0.0 0 18,077

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

  • Index Cond: (transactions_order.seat_id = id)
38. 0.009 0.023 ↑ 1.0 63 1

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

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

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

40. 0.002 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
41. 0.003 0.003 ↑ 38.6 7 1

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

42. 36.154 36.154 ↑ 1.0 1 18,077

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

  • Index Cond: (id = payments_merchantpaymentgatewaysettings.payment_gateway_id)
43. 0.005 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
44. 0.004 0.004 ↑ 8.1 21 1

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

45. 0.000 0.000 ↓ 0.0 0 18,077

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

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

SubPlan (forNested Loop Left Join)

47. 36.154 777.311 ↑ 1.0 1 18,077

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

  • Group Key: u0.id
48. 54.231 741.157 ↑ 1.0 1 18,077

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

  • Join Filter: (u0.id = u1.order_id)
49. 54.231 54.231 ↑ 1.0 1 18,077

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
50. 365.910 632.695 ↑ 1.0 1 18,077

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

  • Hash Cond: (u2.transaction_id = u1.id)
51. 176.400 176.400 ↑ 1.0 159 17,640

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

52. 18.077 90.385 ↑ 1.0 1 18,077

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
53. 72.308 72.308 ↑ 1.0 1 18,077

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

  • Index Cond: (order_id = transactions_order.id)
54. 36.154 686.926 ↑ 1.0 1 18,077

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

  • Group Key: u0_1.id
55. 54.231 650.772 ↑ 1.0 1 18,077

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

  • Join Filter: (u0_1.id = u1_1.order_id)
56. 18.077 18.077 ↑ 1.0 1 18,077

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
57. 347.833 578.464 ↑ 1.0 1 18,077

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

  • Hash Cond: (u2_1.transaction_id = u1_1.id)
58. 176.400 176.400 ↑ 1.0 159 17,640

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

59. 18.077 54.231 ↑ 1.0 1 18,077

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
60. 36.154 36.154 ↑ 1.0 1 18,077

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

  • Index Cond: (order_id = transactions_order.id)
61. 18.077 668.849 ↑ 1.0 1 18,077

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

  • Group Key: u0_2.id
62. 54.231 650.772 ↑ 1.0 1 18,077

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

  • Join Filter: (u0_2.id = u1_2.order_id)
63. 18.077 18.077 ↑ 1.0 1 18,077

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
64. 365.910 578.464 ↑ 1.0 1 18,077

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

  • Hash Cond: (u2_2.transaction_id = u1_2.id)
65. 176.400 176.400 ↑ 1.0 159 17,640

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

66. 0.000 36.154 ↑ 1.0 1 18,077

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
67. 36.154 36.154 ↑ 1.0 1 18,077

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

  • Index Cond: (order_id = transactions_order.id)
68. 36.154 686.926 ↑ 1.0 1 18,077

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

  • Group Key: u0_3.id
69. 54.231 650.772 ↑ 1.0 1 18,077

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

  • Join Filter: (u0_3.id = u1_3.order_id)
70. 18.077 18.077 ↑ 1.0 1 18,077

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
71. 365.910 578.464 ↑ 1.0 1 18,077

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

  • Hash Cond: (u2_3.transaction_id = u1_3.id)
72. 176.400 176.400 ↑ 1.0 159 17,640

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

73. 0.000 36.154 ↑ 1.0 1 18,077

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
74. 36.154 36.154 ↑ 1.0 1 18,077

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

  • Index Cond: (order_id = transactions_order.id)
75. 0.000 723.080 ↓ 0.0 0 18,077

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

  • Group Key: u0_4.id
76. 36.152 723.080 ↓ 0.0 0 18,077

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

77. 262.255 686.926 ↓ 0.0 0 18,077

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

  • Hash Cond: (u2_4.transaction_id = u1_4.id)
78. 370.440 370.440 ↑ 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.021 rows=144 loops=17,640)

  • Filter: (status = ANY ('{16,15}'::integer[]))
  • Rows Removed by Filter: 15
79. 18.077 54.231 ↑ 1.0 1 18,077

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
80. 36.154 36.154 ↑ 1.0 1 18,077

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

  • Index Cond: (order_id = transactions_order.id)
81. 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
82. 0.000 126.539 ↓ 0.0 0 18,077

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

  • Group Key: u0_5.id
83. 36.154 126.539 ↓ 0.0 0 18,077

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

84. 18.077 18.077 ↑ 1.0 1 18,077

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
85. 72.308 72.308 ↓ 0.0 0 18,077

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

  • Filter: ((order_id = transactions_order.id) AND (status = 2))
  • Rows Removed by Filter: 55
86. 18.077 162.693 ↓ 0.0 0 18,077

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

  • Group Key: u0_6.id
87. 18.077 144.616 ↓ 0.0 0 18,077

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

88. 54.231 54.231 ↑ 1.0 1 18,077

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

  • Index Cond: (id = transactions_order.id)
  • Filter: (flow_type = 1)
89. 72.308 72.308 ↓ 0.0 0 18,077

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

  • Filter: ((order_id = transactions_order.id) AND (status = 2))
  • Rows Removed by Filter: 55
90. 0.000 72.308 ↓ 0.0 0 18,077

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

  • Group Key: u0_7.id
91. 17.745 72.308 ↓ 0.0 0 18,077

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

92. 18.077 54.231 ↓ 0.0 0 18,077

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

93. 18.077 18.077 ↑ 1.0 1 18,077

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
94. 18.077 18.077 ↓ 0.0 0 18,077

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

  • Index Cond: (order_id = transactions_order.id)
95. 0.332 0.332 ↓ 0.0 0 332

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=332)

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

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=332)

  • Index Cond: (transaction_id = u1_7.id)
97. 0.000 72.308 ↓ 0.0 0 18,077

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

  • Group Key: u0_8.id
98. 36.154 72.308 ↓ 0.0 0 18,077

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

99. 18.077 18.077 ↑ 1.0 1 18,077

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
100. 0.000 18.077 ↓ 0.0 0 18,077

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

  • Recheck Cond: (order_id = transactions_order.id)
  • Filter: (status = 3)
101. 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)
102. 0.000 723.080 ↓ 0.0 0 18,077

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

  • Group Key: u0_9.id
103. 36.152 723.080 ↓ 0.0 0 18,077

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

104. 262.255 686.926 ↓ 0.0 0 18,077

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

  • Hash Cond: (u2_6.transaction_id = u1_9.id)
105. 370.440 370.440 ↑ 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.021 rows=144 loops=17,640)

  • Filter: (status = ANY ('{16,15}'::integer[]))
  • Rows Removed by Filter: 15
106. 18.077 54.231 ↑ 1.0 1 18,077

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
107. 36.154 36.154 ↑ 1.0 1 18,077

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

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

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
109. 18.077 72.308 ↓ 0.0 0 18,077

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

  • Group Key: u0_10.id
110. 0.000 54.231 ↓ 0.0 0 18,077

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

111. 18.077 54.231 ↓ 0.0 0 18,077

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

112. 18.077 18.077 ↑ 1.0 1 18,077

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
113. 18.077 18.077 ↓ 0.0 0 18,077

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

  • Index Cond: (order_id = transactions_order.id)
114. 0.332 0.332 ↓ 0.0 0 332

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=332)

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

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=332)

  • Index Cond: (transaction_id = u1_10.id)
116. 0.000 144.616 ↓ 0.0 0 18,077

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

  • Group Key: u0_11.id
117. 36.154 144.616 ↓ 0.0 0 18,077

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

118. 36.154 36.154 ↑ 1.0 1 18,077

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

  • Index Cond: (id = transactions_order.id)
  • Filter: (flow_type = 1)
119. 72.308 72.308 ↓ 0.0 0 18,077

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

  • Filter: ((order_id = transactions_order.id) AND (status = 2))
  • Rows Removed by Filter: 55
120. 18.077 72.308 ↓ 0.0 0 18,077

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

  • Group Key: u0_12.id
121. 18.077 54.231 ↓ 0.0 0 18,077

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

122. 18.077 18.077 ↑ 1.0 1 18,077

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
123. 18.077 18.077 ↓ 0.0 0 18,077

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

  • Recheck Cond: (order_id = transactions_order.id)
  • Filter: (status = 3)
124. 0.000 0.000 ↓ 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.000..0.000 rows=0 loops=18,077)

  • Index Cond: (order_id = transactions_order.id)
125. 36.020 921.927 ↓ 0.0 0 18,077

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

  • 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
126. 36.020 867.696 ↑ 1.0 1 18,077

Nested Loop Left Join (cost=13.05..43.15 rows=1 width=16) (actual time=0.046..0.048 rows=1 loops=18,077)

127. 18.075 813.465 ↑ 1.0 1 18,077

Nested Loop Left Join (cost=8.88..31.84 rows=1 width=16) (actual time=0.044..0.045 rows=1 loops=18,077)

  • Join Filter: (u0_13.id = u4.order_id)
128. 36.146 777.311 ↑ 1.0 1 18,077

Nested Loop Left Join (cost=8.60..23.53 rows=1 width=12) (actual time=0.042..0.043 rows=1 loops=18,077)

  • Join Filter: (u0_13.id = u3.order_id)
129. 36.154 668.849 ↑ 1.0 1 18,077

Nested Loop Left Join (cost=8.60..21.83 rows=1 width=8) (actual time=0.036..0.037 rows=1 loops=18,077)

  • Join Filter: (u0_13.id = u1_13.order_id)
130. 36.154 36.154 ↑ 1.0 1 18,077

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

  • Index Cond: (id = transactions_order.id)
  • Filter: (flow_type = 1)
131. 365.910 596.541 ↑ 1.0 1 18,077

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

  • Hash Cond: (u2_8.transaction_id = u1_13.id)
132. 176.400 176.400 ↑ 1.0 159 17,640

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

133. 18.077 54.231 ↑ 1.0 1 18,077

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
134. 36.154 36.154 ↑ 1.0 1 18,077

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

  • Index Cond: (order_id = transactions_order.id)
135. 72.316 72.316 ↓ 0.0 0 18,079

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

  • Filter: (order_id = transactions_order.id)
  • Rows Removed by Filter: 55
136. 18.079 18.079 ↓ 0.0 0 18,079

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

  • Index Cond: (order_id = transactions_order.id)
137. 18.211 18.211 ↓ 0.0 0 18,211

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

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

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

  • Index Cond: (u4.id = transaction_id)
139. 18.211 18.211 ↓ 0.0 0 18,211

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

  • Recheck Cond: (order_id = transactions_order.id)
140. 0.000 0.000 ↓ 0.0 0 18,211

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

  • Index Cond: (order_id = transactions_order.id)
141. 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))
142. 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)
143. 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)
144. 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)

145. 0.000 0.000 ↓ 0.0 0

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

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

147. 0.000 0.000 ↓ 0.0 0

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

148. 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)
149. 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)

150. 0.000 0.000 ↓ 0.0 0

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

151. 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)
152. 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)

153. 0.000 0.000 ↓ 0.0 0

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

154. 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)
155. 0.000 0.000 ↓ 0.0 0

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

156. 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)
157. 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)

158. 0.000 0.000 ↓ 0.0 0

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

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

160. 36.154 90.385 ↑ 1.0 1 18,077

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

  • Group Key: u0_15.id
161. 18.077 54.231 ↑ 1.0 1 18,077

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

  • Join Filter: (u0_15.id = u1_15.order_id)
162. 18.077 18.077 ↑ 1.0 1 18,077

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
163. 18.077 18.077 ↓ 0.0 0 18,077

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

  • Index Cond: (order_id = transactions_order.id)
164. 36.154 162.693 ↑ 1.0 1 18,077

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

  • Group Key: u0_16.id
165. 54.231 126.539 ↑ 1.0 1 18,077

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

  • Join Filter: (u0_16.id = u1_16.order_id)
166. 18.077 18.077 ↑ 1.0 1 18,077

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
167. 36.154 54.231 ↓ 0.0 0 18,077

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

  • Hash Cond: (u2_10.id = u1_16.offering_id)
168. 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)

169. 0.000 18.077 ↓ 0.0 0 18,077

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

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
170. 18.077 18.077 ↓ 0.0 0 18,077

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

  • Index Cond: (order_id = transactions_order.id)
171. 36.154 144.616 ↑ 1.0 1 18,077

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

  • Group Key: u0_17.id
172. 36.154 108.462 ↑ 1.0 1 18,077

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

  • Join Filter: (u0_17.id = u1_17.order_id)
173. 18.077 18.077 ↑ 1.0 1 18,077

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
174. 36.154 54.231 ↓ 0.0 0 18,077

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

  • Hash Cond: (u2_11.id = u1_17.offering_id)
175. 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)

176. 0.000 18.077 ↓ 0.0 0 18,077

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

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
177. 18.077 18.077 ↓ 0.0 0 18,077

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

  • Index Cond: (order_id = transactions_order.id)
178. 36.154 144.616 ↑ 1.0 1 18,077

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

  • Group Key: u0_18.id
179. 36.154 108.462 ↑ 1.0 1 18,077

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

  • Join Filter: (u0_18.id = u1_18.order_id)
180. 18.077 18.077 ↑ 1.0 1 18,077

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
181. 36.154 54.231 ↓ 0.0 0 18,077

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

  • Hash Cond: (u2_12.id = u1_18.offering_id)
182. 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)

183. 0.000 18.077 ↓ 0.0 0 18,077

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

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
184. 18.077 18.077 ↓ 0.0 0 18,077

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

  • Index Cond: (order_id = transactions_order.id)
185. 36.154 144.616 ↑ 1.0 1 18,077

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

  • Group Key: u0_19.id
186. 36.154 108.462 ↑ 1.0 1 18,077

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

187. 18.077 54.231 ↑ 1.0 1 18,077

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

  • Join Filter: (u0_19.id = u1_19.order_id)
188. 18.077 18.077 ↑ 1.0 1 18,077

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
189. 18.077 18.077 ↓ 0.0 0 18,077

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

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

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

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

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

  • Index Cond: (u1_19.id = offering_usage_id)
192. 18.077 253.078 ↑ 1.0 1 18,077

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

  • Group Key: u0_20.id
193. 72.308 235.001 ↑ 1.0 1 18,077

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

  • Join Filter: (u1_20.offering_id = u3_2.id)
  • Rows Removed by Join Filter: 32
194. 18.077 90.385 ↑ 1.0 1 18,077

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

195. 18.077 54.231 ↑ 1.0 1 18,077

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

  • Join Filter: (u0_20.id = u1_20.order_id)
196. 18.077 18.077 ↑ 1.0 1 18,077

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
197. 18.077 18.077 ↓ 0.0 0 18,077

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

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

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

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

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

  • Index Cond: (u1_20.id = offering_usage_id)
200. 72.308 72.308 ↓ 1.1 32 18,077

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

201. 36.154 686.926 ↑ 1.0 1 18,077

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

  • Group Key: u0_21.id
202. 36.154 650.772 ↑ 1.0 1 18,077

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

  • Join Filter: (u0_21.id = u1_21.order_id)
203. 18.077 18.077 ↑ 1.0 1 18,077

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
204. 365.910 596.541 ↑ 1.0 1 18,077

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

  • Hash Cond: (u2_15.transaction_id = u1_21.id)
205. 176.400 176.400 ↑ 1.0 159 17,640

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

206. 18.077 54.231 ↑ 1.0 1 18,077

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
207. 36.154 36.154 ↑ 1.0 1 18,077

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

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

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

  • Group Key: u0_22.id
209. 18.075 705.003 ↓ 0.0 0 18,077

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

210. 262.255 686.926 ↓ 0.0 0 18,077

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

  • Hash Cond: (u2_16.transaction_id = u1_22.id)
211. 370.440 370.440 ↑ 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.021 rows=144 loops=17,640)

  • Filter: (status = ANY ('{16,15}'::integer[]))
  • Rows Removed by Filter: 15
212. 18.077 54.231 ↑ 1.0 1 18,077

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
213. 36.154 36.154 ↑ 1.0 1 18,077

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

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
215. 0.000 72.308 ↓ 0.0 0 18,077

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

  • Group Key: u0_23.id
216. 17.745 72.308 ↓ 0.0 0 18,077

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

217. 18.077 54.231 ↓ 0.0 0 18,077

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

218. 18.077 18.077 ↑ 1.0 1 18,077

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
219. 18.077 18.077 ↓ 0.0 0 18,077

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

  • Index Cond: (order_id = transactions_order.id)
220. 0.332 0.332 ↓ 0.0 0 332

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=332)

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

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=332)

  • Index Cond: (transaction_id = u1_23.id)
222. 0.000 144.616 ↓ 0.0 0 18,077

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

  • Group Key: u0_24.id
223. 36.154 144.616 ↓ 0.0 0 18,077

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

224. 36.154 36.154 ↑ 1.0 1 18,077

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

  • Index Cond: (id = transactions_order.id)
  • Filter: (flow_type = 1)
225. 72.308 72.308 ↓ 0.0 0 18,077

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

  • Filter: ((order_id = transactions_order.id) AND (status = 2))
  • Rows Removed by Filter: 55
226. 18.077 72.308 ↓ 0.0 0 18,077

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

  • Group Key: u0_25.id
227. 18.077 54.231 ↓ 0.0 0 18,077

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

228. 18.077 18.077 ↑ 1.0 1 18,077

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
229. 0.000 18.077 ↓ 0.0 0 18,077

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

  • Recheck Cond: (order_id = transactions_order.id)
  • Filter: (status = 3)
230. 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)
231. 0.000 723.080 ↓ 0.0 0 18,077

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

  • Group Key: u0_26.id
232. 36.152 723.080 ↓ 0.0 0 18,077

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

233. 262.255 686.926 ↓ 0.0 0 18,077

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

  • Hash Cond: (u2_18.transaction_id = u1_26.id)
234. 370.440 370.440 ↑ 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.021 rows=144 loops=17,640)

  • Filter: (status = ANY ('{16,15}'::integer[]))
  • Rows Removed by Filter: 15
235. 18.077 54.231 ↑ 1.0 1 18,077

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
236. 36.154 36.154 ↑ 1.0 1 18,077

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

  • Index Cond: (order_id = transactions_order.id)
237. 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
238. 0.000 723.080 ↓ 0.0 0 18,077

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

  • Group Key: u0_27.id
239. 36.152 723.080 ↓ 0.0 0 18,077

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

240. 262.255 686.926 ↓ 0.0 0 18,077

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

  • Hash Cond: (u2_19.transaction_id = u1_27.id)
241. 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
242. 18.077 54.231 ↑ 1.0 1 18,077

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
243. 36.154 36.154 ↑ 1.0 1 18,077

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

  • Index Cond: (order_id = transactions_order.id)
244. 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
245. 18.077 72.308 ↓ 0.0 0 18,077

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

  • Group Key: u0_28.id
246. 0.000 54.231 ↓ 0.0 0 18,077

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

247. 18.077 54.231 ↓ 0.0 0 18,077

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

248. 18.077 18.077 ↑ 1.0 1 18,077

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
249. 18.077 18.077 ↓ 0.0 0 18,077

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

  • Index Cond: (order_id = transactions_order.id)
250. 0.332 0.332 ↓ 0.0 0 332

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=332)

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

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=332)

  • Index Cond: (transaction_id = u1_28.id)
252. 18.077 144.616 ↓ 0.0 0 18,077

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

  • Group Key: u0_29.id
253. 18.077 126.539 ↓ 0.0 0 18,077

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

254. 36.154 36.154 ↑ 1.0 1 18,077

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

  • Index Cond: (id = transactions_order.id)
  • Filter: (flow_type = 1)
255. 72.308 72.308 ↓ 0.0 0 18,077

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

  • Filter: ((order_id = transactions_order.id) AND (status = 2))
  • Rows Removed by Filter: 55
256. 0.000 72.308 ↓ 0.0 0 18,077

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

  • Group Key: u0_30.id
257. 36.154 72.308 ↓ 0.0 0 18,077

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

258. 18.077 18.077 ↑ 1.0 1 18,077

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
259. 0.000 18.077 ↓ 0.0 0 18,077

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

  • Recheck Cond: (order_id = transactions_order.id)
  • Filter: (status = 3)
260. 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)
261. 18.077 72.308 ↓ 0.0 0 18,077

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

  • Group Key: u0_31.id
262. 18.077 54.231 ↓ 0.0 0 18,077

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

263. 18.077 18.077 ↑ 1.0 1 18,077

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

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

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

  • Recheck Cond: (order_id = transactions_order.id)
  • Filter: (status = 3)
265. 0.000 0.000 ↓ 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.000..0.000 rows=0 loops=18,077)

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

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

  • Group Key: u0_32.id
267. 36.152 723.080 ↓ 0.0 0 18,077

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

268. 262.255 686.926 ↓ 0.0 0 18,077

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

  • Hash Cond: (u2_21.transaction_id = u1_32.id)
269. 370.440 370.440 ↑ 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.021 rows=144 loops=17,640)

  • Filter: (status = ANY ('{16,15}'::integer[]))
  • Rows Removed by Filter: 15
270. 18.077 54.231 ↑ 1.0 1 18,077

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
271. 36.154 36.154 ↑ 1.0 1 18,077

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

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
273. 0.000 705.003 ↓ 0.0 0 18,077

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

  • Group Key: u0_33.id
274. 36.152 705.003 ↓ 0.0 0 18,077

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

275. 262.255 668.849 ↓ 0.0 0 18,077

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

  • Hash Cond: (u2_22.transaction_id = u1_33.id)
276. 370.440 370.440 ↑ 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.021 rows=144 loops=17,640)

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

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
278. 36.154 36.154 ↑ 1.0 1 18,077

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.001..0.002 rows=1 loops=18,077)

  • Index Cond: (order_id = transactions_order.id)
279. 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
280. 18.077 72.308 ↓ 0.0 0 18,077

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

  • Group Key: u0_34.id
281. 0.000 54.231 ↓ 0.0 0 18,077

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

282. 18.077 54.231 ↓ 0.0 0 18,077

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

283. 18.077 18.077 ↑ 1.0 1 18,077

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
284. 18.077 18.077 ↓ 0.0 0 18,077

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

  • Index Cond: (order_id = transactions_order.id)
285. 0.332 0.332 ↓ 0.0 0 332

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=332)

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

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=332)

  • Index Cond: (transaction_id = u1_34.id)
287. 18.077 144.616 ↓ 0.0 0 18,077

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

  • Group Key: u0_35.id
288. 18.077 126.539 ↓ 0.0 0 18,077

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

289. 36.154 36.154 ↑ 1.0 1 18,077

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

  • Index Cond: (id = transactions_order.id)
  • Filter: (flow_type = 1)
290. 72.308 72.308 ↓ 0.0 0 18,077

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

  • Filter: ((order_id = transactions_order.id) AND (status = 2))
  • Rows Removed by Filter: 55
291. 18.077 72.308 ↓ 0.0 0 18,077

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

  • Group Key: u0_36.id
292. 18.077 54.231 ↓ 0.0 0 18,077

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

293. 18.077 18.077 ↑ 1.0 1 18,077

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
294. 18.077 18.077 ↓ 0.0 0 18,077

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

  • Recheck Cond: (order_id = transactions_order.id)
  • Filter: (status = 3)
295. 0.000 0.000 ↓ 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.000..0.000 rows=0 loops=18,077)

  • Index Cond: (order_id = transactions_order.id)
296. 0.000 723.080 ↓ 0.0 0 18,077

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

  • Group Key: u0_37.id
297. 36.152 723.080 ↓ 0.0 0 18,077

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

298. 280.332 686.926 ↓ 0.0 0 18,077

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

  • Hash Cond: (u2_24.transaction_id = u1_37.id)
299. 370.440 370.440 ↑ 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.021 rows=144 loops=17,640)

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

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
301. 36.154 36.154 ↑ 1.0 1 18,077

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

  • Index Cond: (order_id = transactions_order.id)
302. 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
303. 0.000 72.308 ↓ 0.0 0 18,077

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

  • Group Key: u0_38.id
304. 17.745 72.308 ↓ 0.0 0 18,077

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

305. 18.077 54.231 ↓ 0.0 0 18,077

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

306. 18.077 18.077 ↑ 1.0 1 18,077

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
307. 18.077 18.077 ↓ 0.0 0 18,077

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

  • Index Cond: (order_id = transactions_order.id)
308. 0.332 0.332 ↓ 0.0 0 332

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=332)

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

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=332)

  • Index Cond: (transaction_id = u1_38.id)
310. 18.077 144.616 ↓ 0.0 0 18,077

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

  • Group Key: u0_39.id
311. 18.077 126.539 ↓ 0.0 0 18,077

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

312. 36.154 36.154 ↑ 1.0 1 18,077

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

  • Index Cond: (id = transactions_order.id)
  • Filter: (flow_type = 1)
313. 72.308 72.308 ↓ 0.0 0 18,077

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

  • Filter: ((order_id = transactions_order.id) AND (status = 2))
  • Rows Removed by Filter: 55
314. 0.000 72.308 ↓ 0.0 0 18,077

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

  • Group Key: u0_40.id
315. 36.154 72.308 ↓ 0.0 0 18,077

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

316. 18.077 18.077 ↑ 1.0 1 18,077

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
317. 18.077 18.077 ↓ 0.0 0 18,077

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

  • Recheck Cond: (order_id = transactions_order.id)
  • Filter: (status = 3)
318. 0.000 0.000 ↓ 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.000..0.000 rows=0 loops=18,077)

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

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

  • Group Key: u0_51.id
320. 0.000 54.231 ↓ 0.0 0 18,077

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

321. 18.077 54.231 ↓ 0.0 0 18,077

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

322. 18.077 18.077 ↑ 1.0 1 18,077

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
323. 18.077 18.077 ↓ 0.0 0 18,077

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

  • Index Cond: (order_id = transactions_order.id)
324. 0.332 0.332 ↓ 0.0 0 332

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=332)

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

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=332)

  • Index Cond: (transaction_id = u1_51.id)
326. 18.077 144.616 ↓ 0.0 0 18,077

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

  • Group Key: u0_52.id
327. 18.077 126.539 ↓ 0.0 0 18,077

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

328. 36.154 36.154 ↑ 1.0 1 18,077

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

  • Index Cond: (id = transactions_order.id)
  • Filter: (flow_type = 1)
329. 72.308 72.308 ↓ 0.0 0 18,077

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

  • Filter: ((order_id = transactions_order.id) AND (status = 2))
  • Rows Removed by Filter: 55
330. 0.000 723.080 ↓ 0.0 0 18,077

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

  • Group Key: u0_53.id
331. 36.152 723.080 ↓ 0.0 0 18,077

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

332. 262.255 686.926 ↓ 0.0 0 18,077

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

  • Hash Cond: (u2_32.transaction_id = u1_53.id)
333. 370.440 370.440 ↑ 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.021 rows=144 loops=17,640)

  • Filter: (status = ANY ('{16,15}'::integer[]))
  • Rows Removed by Filter: 15
334. 18.077 54.231 ↑ 1.0 1 18,077

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
335. 36.154 36.154 ↑ 1.0 1 18,077

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

  • Index Cond: (order_id = transactions_order.id)
336. 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
337. 18.077 72.308 ↓ 0.0 0 18,077

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

  • Group Key: u0_54.id
338. 0.000 54.231 ↓ 0.0 0 18,077

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

339. 18.077 54.231 ↓ 0.0 0 18,077

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

340. 18.077 18.077 ↑ 1.0 1 18,077

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
341. 18.077 18.077 ↓ 0.0 0 18,077

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

  • Index Cond: (order_id = transactions_order.id)
342. 0.332 0.332 ↓ 0.0 0 332

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=332)

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

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=332)

  • Index Cond: (transaction_id = u1_54.id)
344. 18.077 144.616 ↓ 0.0 0 18,077

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

  • Group Key: u0_55.id
345. 18.077 126.539 ↓ 0.0 0 18,077

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

346. 36.154 36.154 ↑ 1.0 1 18,077

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

  • Index Cond: (id = transactions_order.id)
  • Filter: (flow_type = 1)
347. 72.308 72.308 ↓ 0.0 0 18,077

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

  • Filter: ((order_id = transactions_order.id) AND (status = 2))
  • Rows Removed by Filter: 55
348. 18.077 72.308 ↓ 0.0 0 18,077

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

  • Group Key: u0_56.id
349. 18.077 54.231 ↓ 0.0 0 18,077

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

350. 18.077 18.077 ↑ 1.0 1 18,077

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
351. 18.077 18.077 ↓ 0.0 0 18,077

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

  • Recheck Cond: (order_id = transactions_order.id)
  • Filter: (status = 3)
352. 0.000 0.000 ↓ 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.000..0.000 rows=0 loops=18,077)

  • Index Cond: (order_id = transactions_order.id)
353. 0.000 72.308 ↓ 0.0 0 18,077

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

  • Group Key: u0_67.id
354. 36.154 72.308 ↓ 0.0 0 18,077

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

355. 18.077 18.077 ↑ 1.0 1 18,077

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
356. 18.077 18.077 ↓ 0.0 0 18,077

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

  • Recheck Cond: (order_id = transactions_order.id)
  • Filter: (status = 3)
357. 0.000 0.000 ↓ 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.000..0.000 rows=0 loops=18,077)

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

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

  • Group Key: u0_68.id
359. 18.073 705.003 ↓ 0.0 0 18,077

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

360. 280.332 686.926 ↓ 0.0 0 18,077

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

  • Hash Cond: (u2_39.transaction_id = u1_68.id)
361. 370.440 370.440 ↑ 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.021 rows=144 loops=17,640)

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

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
363. 36.154 36.154 ↑ 1.0 1 18,077

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.001..0.002 rows=1 loops=18,077)

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
365. 0.000 705.003 ↓ 0.0 0 18,077

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

  • Group Key: u0_69.id
366. 36.152 705.003 ↓ 0.0 0 18,077

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

367. 262.255 668.849 ↓ 0.0 0 18,077

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

  • Hash Cond: (u2_40.transaction_id = u1_69.id)
368. 370.440 370.440 ↑ 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.021 rows=144 loops=17,640)

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

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
370. 36.154 36.154 ↑ 1.0 1 18,077

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

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

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
372. 18.077 72.308 ↓ 0.0 0 18,077

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

  • Group Key: u0_70.id
373. 0.000 54.231 ↓ 0.0 0 18,077

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

374. 18.077 54.231 ↓ 0.0 0 18,077

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

375. 18.077 18.077 ↑ 1.0 1 18,077

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
376. 18.077 18.077 ↓ 0.0 0 18,077

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

  • Index Cond: (order_id = transactions_order.id)
377. 0.332 0.332 ↓ 0.0 0 332

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=332)

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

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=332)

  • Index Cond: (transaction_id = u1_70.id)
379. 18.077 144.616 ↓ 0.0 0 18,077

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

  • Group Key: u0_71.id
380. 18.077 126.539 ↓ 0.0 0 18,077

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

381. 36.154 36.154 ↑ 1.0 1 18,077

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

  • Index Cond: (id = transactions_order.id)
  • Filter: (flow_type = 1)
382. 72.308 72.308 ↓ 0.0 0 18,077

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

  • Filter: ((order_id = transactions_order.id) AND (status = 2))
  • Rows Removed by Filter: 55
383. 0.000 72.308 ↓ 0.0 0 18,077

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

  • Group Key: u0_72.id
384. 36.154 72.308 ↓ 0.0 0 18,077

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

385. 18.077 18.077 ↑ 1.0 1 18,077

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

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

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

  • Recheck Cond: (order_id = transactions_order.id)
  • Filter: (status = 3)
387. 0.000 0.000 ↓ 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.000..0.000 rows=0 loops=18,077)

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

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

  • Group Key: u0_73.id
389. 18.075 705.003 ↓ 0.0 0 18,077

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

390. 280.332 686.926 ↓ 0.0 0 18,077

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

  • Hash Cond: (u2_42.transaction_id = u1_73.id)
391. 370.440 370.440 ↑ 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.021 rows=144 loops=17,640)

  • Filter: (status = ANY ('{16,15}'::integer[]))
  • Rows Removed by Filter: 15
392. 18.077 36.154 ↑ 1.0 1 18,077

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
393. 18.077 18.077 ↑ 1.0 1 18,077

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.001..0.001 rows=1 loops=18,077)

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

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
395. 18.077 72.308 ↓ 0.0 0 18,077

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

  • Group Key: u0_74.id
396. 0.000 54.231 ↓ 0.0 0 18,077

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

397. 18.077 54.231 ↓ 0.0 0 18,077

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

398. 18.077 18.077 ↑ 1.0 1 18,077

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
399. 18.077 18.077 ↓ 0.0 0 18,077

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

  • Index Cond: (order_id = transactions_order.id)
400. 0.332 0.332 ↓ 0.0 0 332

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=332)

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

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=332)

  • Index Cond: (transaction_id = u1_74.id)
402. 18.077 144.616 ↓ 0.0 0 18,077

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

  • Group Key: u0_75.id
403. 18.077 126.539 ↓ 0.0 0 18,077

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

404. 36.154 36.154 ↑ 1.0 1 18,077

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

  • Index Cond: (id = transactions_order.id)
  • Filter: (flow_type = 1)
405. 72.308 72.308 ↓ 0.0 0 18,077

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

  • Filter: ((order_id = transactions_order.id) AND (status = 2))
  • Rows Removed by Filter: 55
406. 18.077 72.308 ↓ 0.0 0 18,077

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

  • Group Key: u0_76.id
407. 18.077 54.231 ↓ 0.0 0 18,077

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

408. 18.077 18.077 ↑ 1.0 1 18,077

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
409. 18.077 18.077 ↓ 0.0 0 18,077

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

  • Recheck Cond: (order_id = transactions_order.id)
  • Filter: (status = 3)
410. 0.000 0.000 ↓ 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.000..0.000 rows=0 loops=18,077)

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

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

  • Group Key: u0_77.id
412. 0.000 54.231 ↓ 0.0 0 18,077

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

413. 18.077 54.231 ↓ 0.0 0 18,077

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

414. 18.077 18.077 ↑ 1.0 1 18,077

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
415. 18.077 18.077 ↓ 0.0 0 18,077

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

  • Index Cond: (order_id = transactions_order.id)
416. 0.332 0.332 ↓ 0.0 0 332

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=332)

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

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=332)

  • Index Cond: (transaction_id = u1_77.id)
418. 18.077 144.616 ↓ 0.0 0 18,077

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

  • Group Key: u0_78.id
419. 18.077 126.539 ↓ 0.0 0 18,077

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

420. 36.154 36.154 ↑ 1.0 1 18,077

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

  • Index Cond: (id = transactions_order.id)
  • Filter: (flow_type = 1)
421. 72.308 72.308 ↓ 0.0 0 18,077

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

  • Filter: ((order_id = transactions_order.id) AND (status = 2))
  • Rows Removed by Filter: 55
422. 18.077 723.080 ↓ 0.0 0 18,077

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

  • Group Key: u0_79.id
423. 36.150 705.003 ↓ 0.0 0 18,077

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

424. 262.255 668.849 ↓ 0.0 0 18,077

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

  • Hash Cond: (u2_45.transaction_id = u1_79.id)
425. 370.440 370.440 ↑ 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.021 rows=144 loops=17,640)

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

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
427. 36.154 36.154 ↑ 1.0 1 18,077

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.001..0.002 rows=1 loops=18,077)

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
429. 18.077 72.308 ↓ 0.0 0 18,077

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

  • Group Key: u0_80.id
430. 0.000 54.231 ↓ 0.0 0 18,077

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

431. 18.077 54.231 ↓ 0.0 0 18,077

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

432. 18.077 18.077 ↑ 1.0 1 18,077

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
433. 18.077 18.077 ↓ 0.0 0 18,077

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

  • Index Cond: (order_id = transactions_order.id)
434. 0.332 0.332 ↓ 0.0 0 332

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=332)

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

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=332)

  • Index Cond: (transaction_id = u1_80.id)
436. 18.077 144.616 ↓ 0.0 0 18,077

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

  • Group Key: u0_81.id
437. 18.077 126.539 ↓ 0.0 0 18,077

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

438. 36.154 36.154 ↑ 1.0 1 18,077

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

  • Index Cond: (id = transactions_order.id)
  • Filter: (flow_type = 1)
439. 72.308 72.308 ↓ 0.0 0 18,077

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

  • Filter: ((order_id = transactions_order.id) AND (status = 2))
  • Rows Removed by Filter: 55
440. 0.000 72.308 ↓ 0.0 0 18,077

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

  • Group Key: u0_82.id
441. 36.154 72.308 ↓ 0.0 0 18,077

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

442. 18.077 18.077 ↑ 1.0 1 18,077

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
443. 18.077 18.077 ↓ 0.0 0 18,077

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

  • Recheck Cond: (order_id = transactions_order.id)
  • Filter: (status = 3)
444. 0.000 0.000 ↓ 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.000..0.000 rows=0 loops=18,077)

  • Index Cond: (order_id = transactions_order.id)
445. 36.154 162.693 ↑ 1.0 1 18,077

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

  • Group Key: u0_83.id
446. 36.154 126.539 ↑ 1.0 1 18,077

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

  • Join Filter: (u0_83.id = u1_83.order_id)
447. 18.077 18.077 ↑ 1.0 1 18,077

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
448. 36.154 72.308 ↓ 0.0 0 18,077

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

  • Hash Cond: (u2_47.id = u1_83.offering_id)
449. 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)

450. 18.077 36.154 ↓ 0.0 0 18,077

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

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
451. 18.077 18.077 ↓ 0.0 0 18,077

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

  • Index Cond: (order_id = transactions_order.id)
452. 18.077 271.155 ↑ 1.0 1 18,077

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

  • Group Key: u0_84.id
453. 72.308 253.078 ↑ 1.0 1 18,077

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

  • Join Filter: (u1_84.offering_id = u3_3.id)
  • Rows Removed by Join Filter: 32
454. 36.154 108.462 ↑ 1.0 1 18,077

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

455. 18.077 54.231 ↑ 1.0 1 18,077

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

  • Join Filter: (u0_84.id = u1_84.order_id)
456. 18.077 18.077 ↑ 1.0 1 18,077

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
457. 18.077 18.077 ↓ 0.0 0 18,077

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

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

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

  • Recheck Cond: (u1_84.id = offering_usage_id)
459. 0.000 0.000 ↓ 0.0 0 18,077

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

  • Index Cond: (u1_84.id = offering_usage_id)
460. 72.308 72.308 ↓ 1.1 32 18,077

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

461. 0.000 72.308 ↓ 0.0 0 18,077

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

  • Group Key: u0_85.id
462. 36.154 72.308 ↓ 0.0 0 18,077

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

463. 18.077 18.077 ↑ 1.0 1 18,077

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
464. 18.077 18.077 ↓ 0.0 0 18,077

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

  • Recheck Cond: (order_id = transactions_order.id)
  • Filter: (status = 3)
465. 0.000 0.000 ↓ 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.000..0.000 rows=0 loops=18,077)

  • Index Cond: (order_id = transactions_order.id)
466. 0.000 723.080 ↓ 0.0 0 18,077

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

  • Group Key: u0_86.id
467. 36.148 723.080 ↓ 0.0 0 18,077

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

468. 262.255 686.926 ↓ 0.0 0 18,077

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

  • Hash Cond: (u2_49.transaction_id = u1_86.id)
469. 370.440 370.440 ↑ 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.021 rows=144 loops=17,640)

  • Filter: (status = ANY ('{16,15}'::integer[]))
  • Rows Removed by Filter: 15
470. 18.077 54.231 ↑ 1.0 1 18,077

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
471. 36.154 36.154 ↑ 1.0 1 18,077

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

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
473. 18.077 723.080 ↓ 0.0 0 18,077

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

  • Group Key: u0_87.id
474. 18.073 705.003 ↓ 0.0 0 18,077

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

475. 280.332 686.926 ↓ 0.0 0 18,077

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

  • Hash Cond: (u2_50.transaction_id = u1_87.id)
476. 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
477. 0.000 36.154 ↑ 1.0 1 18,077

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
478. 36.154 36.154 ↑ 1.0 1 18,077

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.001..0.002 rows=1 loops=18,077)

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
480. 18.077 72.308 ↓ 0.0 0 18,077

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

  • Group Key: u0_88.id
481. 0.000 54.231 ↓ 0.0 0 18,077

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

482. 18.077 54.231 ↓ 0.0 0 18,077

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

483. 18.077 18.077 ↑ 1.0 1 18,077

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
484. 18.077 18.077 ↓ 0.0 0 18,077

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

  • Index Cond: (order_id = transactions_order.id)
485. 0.332 0.332 ↓ 0.0 0 332

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=332)

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

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=332)

  • Index Cond: (transaction_id = u1_88.id)
487. 0.000 144.616 ↓ 0.0 0 18,077

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

  • Group Key: u0_89.id
488. 36.154 144.616 ↓ 0.0 0 18,077

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

489. 36.154 36.154 ↑ 1.0 1 18,077

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

  • Index Cond: (id = transactions_order.id)
  • Filter: (flow_type = 1)
490. 72.308 72.308 ↓ 0.0 0 18,077

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

  • Filter: ((order_id = transactions_order.id) AND (status = 2))
  • Rows Removed by Filter: 55
491. 18.077 72.308 ↓ 0.0 0 18,077

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

  • Group Key: u0_90.id
492. 18.077 54.231 ↓ 0.0 0 18,077

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

493. 18.077 18.077 ↑ 1.0 1 18,077

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
494. 18.077 18.077 ↓ 0.0 0 18,077

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

  • Recheck Cond: (order_id = transactions_order.id)
  • Filter: (status = 3)
495. 0.000 0.000 ↓ 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.000..0.000 rows=0 loops=18,077)

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

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

  • Group Key: u0_91.id
497. 18.073 705.003 ↓ 0.0 0 18,077

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

498. 280.332 686.926 ↓ 0.0 0 18,077

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

  • Hash Cond: (u2_52.transaction_id = u1_91.id)
499. 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
500. 0.000 36.154 ↑ 1.0 1 18,077

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
501. 36.154 36.154 ↑ 1.0 1 18,077

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

  • Index Cond: (order_id = transactions_order.id)
502. 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
503. 18.077 72.308 ↓ 0.0 0 18,077

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

  • Group Key: u0_92.id
504. 0.000 54.231 ↓ 0.0 0 18,077

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

505. 18.077 54.231 ↓ 0.0 0 18,077

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

506. 18.077 18.077 ↑ 1.0 1 18,077

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
507. 18.077 18.077 ↓ 0.0 0 18,077

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

  • Index Cond: (order_id = transactions_order.id)
508. 0.332 0.332 ↓ 0.0 0 332

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=332)

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

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=332)

  • Index Cond: (transaction_id = u1_92.id)
510. 0.000 144.616 ↓ 0.0 0 18,077

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

  • Group Key: u0_93.id
511. 36.154 144.616 ↓ 0.0 0 18,077

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

512. 36.154 36.154 ↑ 1.0 1 18,077

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

  • Index Cond: (id = transactions_order.id)
  • Filter: (flow_type = 1)
513. 72.308 72.308 ↓ 0.0 0 18,077

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

  • Filter: ((order_id = transactions_order.id) AND (status = 2))
  • Rows Removed by Filter: 55
514. 0.000 72.308 ↓ 0.0 0 18,077

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

  • Group Key: u0_94.id
515. 36.154 72.308 ↓ 0.0 0 18,077

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

516. 18.077 18.077 ↑ 1.0 1 18,077

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
517. 18.077 18.077 ↓ 0.0 0 18,077

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

  • Recheck Cond: (order_id = transactions_order.id)
  • Filter: (status = 3)
518. 0.000 0.000 ↓ 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.000..0.000 rows=0 loops=18,077)

  • Index Cond: (order_id = transactions_order.id)
519. 36.154 162.693 ↑ 1.0 1 18,077

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

  • Group Key: u0_95.id
520. 36.154 126.539 ↑ 1.0 1 18,077

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

  • Join Filter: (u0_95.id = u1_95.order_id)
521. 18.077 18.077 ↑ 1.0 1 18,077

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
522. 36.154 72.308 ↓ 0.0 0 18,077

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

  • Hash Cond: (u2_54.id = u1_95.offering_id)
523. 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)

524. 18.077 36.154 ↓ 0.0 0 18,077

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

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
525. 18.077 18.077 ↓ 0.0 0 18,077

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

  • Index Cond: (order_id = transactions_order.id)
526. 18.077 253.078 ↑ 1.0 1 18,077

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

  • Group Key: u0_96.id
527. 72.308 235.001 ↑ 1.0 1 18,077

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

  • Join Filter: (u1_96.offering_id = u3_4.id)
  • Rows Removed by Join Filter: 32
528. 18.077 90.385 ↑ 1.0 1 18,077

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

529. 18.077 54.231 ↑ 1.0 1 18,077

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

  • Join Filter: (u0_96.id = u1_96.order_id)
530. 18.077 18.077 ↑ 1.0 1 18,077

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
531. 18.077 18.077 ↓ 0.0 0 18,077

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

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

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

  • Recheck Cond: (u1_96.id = offering_usage_id)
533. 0.000 0.000 ↓ 0.0 0 18,077

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

  • Index Cond: (u1_96.id = offering_usage_id)
534. 72.308 72.308 ↓ 1.1 32 18,077

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

535. 18.077 72.308 ↓ 0.0 0 18,077

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

  • Group Key: u0_97.id
536. 0.000 54.231 ↓ 0.0 0 18,077

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

537. 18.077 54.231 ↓ 0.0 0 18,077

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

538. 18.077 18.077 ↑ 1.0 1 18,077

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
539. 18.077 18.077 ↓ 0.0 0 18,077

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

  • Index Cond: (order_id = transactions_order.id)
540. 0.332 0.332 ↓ 0.0 0 332

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=332)

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

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=332)

  • Index Cond: (transaction_id = u1_97.id)
542. 18.077 144.616 ↓ 0.0 0 18,077

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

  • Group Key: u0_98.id
543. 18.077 126.539 ↓ 0.0 0 18,077

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

544. 36.154 36.154 ↑ 1.0 1 18,077

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

  • Index Cond: (id = transactions_order.id)
  • Filter: (flow_type = 1)
545. 72.308 72.308 ↓ 0.0 0 18,077

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

  • Filter: ((order_id = transactions_order.id) AND (status = 2))
  • Rows Removed by Filter: 55
546. 0.000 723.080 ↓ 0.0 0 18,077

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

  • Group Key: u0_99.id
547. 36.150 723.080 ↓ 0.0 0 18,077

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

548. 262.255 686.926 ↓ 0.0 0 18,077

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

  • Hash Cond: (u2_57.transaction_id = u1_99.id)
549. 370.440 370.440 ↑ 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.021 rows=144 loops=17,640)

  • Filter: (status = ANY ('{16,15}'::integer[]))
  • Rows Removed by Filter: 15
550. 18.077 54.231 ↑ 1.0 1 18,077

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
551. 36.154 36.154 ↑ 1.0 1 18,077

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

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

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
553. 18.077 72.308 ↓ 0.0 0 18,077

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

  • Group Key: u0_100.id
554. 0.000 54.231 ↓ 0.0 0 18,077

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

555. 18.077 54.231 ↓ 0.0 0 18,077

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

556. 18.077 18.077 ↑ 1.0 1 18,077

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
557. 18.077 18.077 ↓ 0.0 0 18,077

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

  • Index Cond: (order_id = transactions_order.id)
558. 0.332 0.332 ↓ 0.0 0 332

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=332)

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

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=332)

  • Index Cond: (transaction_id = u1_100.id)
560. 18.077 144.616 ↓ 0.0 0 18,077

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

  • Group Key: u0_101.id
561. 18.077 126.539 ↓ 0.0 0 18,077

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

562. 36.154 36.154 ↑ 1.0 1 18,077

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

  • Index Cond: (id = transactions_order.id)
  • Filter: (flow_type = 1)
563. 72.308 72.308 ↓ 0.0 0 18,077

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

  • Filter: ((order_id = transactions_order.id) AND (status = 2))
  • Rows Removed by Filter: 55
564. 0.000 72.308 ↓ 0.0 0 18,077

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

  • Group Key: u0_102.id
565. 36.154 72.308 ↓ 0.0 0 18,077

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

566. 18.077 18.077 ↑ 1.0 1 18,077

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

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
567. 0.000 18.077 ↓ 0.0 0 18,077

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

  • Recheck Cond: (order_id = transactions_order.id)
  • Filter: (status = 3)
568. 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)
569. 18.077 126.539 ↓ 0.0 0 18,077

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

  • Group Key: u0_103.id
570. 36.154 108.462 ↓ 0.0 0 18,077

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

571. 36.154 36.154 ↑ 1.0 1 18,077

Index Only Scan using merchants_applicationuserprofile_pkey on merchants_applicationuserprofile u0_103 (cost=0.28..8.29 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=18,077)

  • Index Cond: (id = transactions_order.app_user_id)
  • Heap Fetches: 18077
572. 18.077 36.154 ↓ 0.0 0 18,077

Bitmap Heap Scan on badges_usertag u1_103 (cost=4.21..14.39 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=18,077)

  • 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))
573. 18.077 18.077 ↓ 0.0 0 18,077

Bitmap Index Scan on badges_usertag_app_user_id_tag_id_archi_0e88207c_uniq (cost=0.00..4.21 rows=7 width=0) (actual time=0.001..0.001 rows=0 loops=18,077)

  • Index Cond: (app_user_id = transactions_order.app_user_id)
574. 18.077 108.462 ↓ 0.0 0 18,077

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

  • Group Key: u0_104.id
575. 36.154 90.385 ↓ 0.0 0 18,077

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

576. 18.077 18.077 ↑ 1.0 1 18,077

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

  • Index Cond: (id = transactions_order.app_user_id)
  • Heap Fetches: 18077
577. 18.077 36.154 ↓ 0.0 0 18,077

Bitmap Heap Scan on badges_userbadge u1_104 (cost=4.16..7.30 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=18,077)

  • 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
578. 18.077 18.077 ↓ 0.0 0 18,077

Bitmap Index Scan on badges_userbadge_user_id_77032e2b (cost=0.00..4.16 rows=2 width=0) (actual time=0.001..0.001 rows=0 loops=18,077)

  • Index Cond: (app_user_id = transactions_order.app_user_id)
579.          

SubPlan (forHashAggregate)

580. 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
581. 18.010 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)

582. 36.020 36.020 ↑ 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.002..0.002 rows=1 loops=18,010)

  • Index Cond: (id = transactions_order.id)
  • Heap Fetches: 0
583. 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)
584. 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)
585. 0.000 720.400 ↓ 0.0 0 18,010

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

  • Group Key: u0_42.id
586. 18.006 720.400 ↓ 0.0 0 18,010

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

587. 259.931 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_26.transaction_id = u1_42.id)
588. 370.419 370.419 ↑ 1.0 144 17,639

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

  • Filter: (status = ANY ('{16,15}'::integer[]))
  • Rows Removed by Filter: 15
589. 18.010 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: 9kB
590. 54.030 54.030 ↑ 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.003..0.003 rows=1 loops=18,010)

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

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

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

  • Group Key: u0_43.id
593. 18.006 684.380 ↓ 0.0 0 18,010

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

594. 259.931 666.370 ↓ 0.0 0 18,010

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

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

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

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

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

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

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

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

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

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

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

  • Group Key: u0_44.id
600. 0.000 54.030 ↓ 0.0 0 18,010

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

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

602. 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
603. 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)
604. 0.200 0.400 ↓ 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.002..0.002 rows=0 loops=200)

  • Recheck Cond: (transaction_id = u1_44.id)
  • Filter: (status = ANY ('{16,15}'::integer[]))
605. 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_44.id)
606. 0.000 144.080 ↓ 0.0 0 18,010

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

  • Group Key: u0_45.id
607. 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)

608. 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)
609. 72.040 72.040 ↓ 0.0 0 18,010

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

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

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

  • Group Key: u0_46.id
611. 18.010 54.030 ↓ 0.0 0 18,010

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

612. 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
613. 18.010 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)
614. 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)
615. 0.000 684.380 ↓ 0.0 0 18,010

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

  • Group Key: u0_47.id
616. 18.008 684.380 ↓ 0.0 0 18,010

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

617. 259.931 666.370 ↓ 0.0 0 18,010

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

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

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

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

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

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

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

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

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

  • Group Key: u0_48.id
623. 17.810 54.030 ↓ 0.0 0 18,010

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

624. 0.000 36.020 ↓ 0.0 0 18,010

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

625. 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
626. 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)
627. 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[]))
628. 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)
629. 0.000 126.070 ↓ 0.0 0 18,010

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

  • Group Key: u0_49.id
630. 18.010 126.070 ↓ 0.0 0 18,010

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

631. 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.001..0.002 rows=1 loops=18,010)

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

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

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

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

  • Group Key: u0_50.id
634. 18.010 54.030 ↓ 0.0 0 18,010

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

635. 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
636. 18.010 18.010 ↓ 0.0 0 18,010

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

  • Recheck Cond: (order_id = transactions_order.id)
  • Filter: (status = 3)
637. 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)
638. 0.000 54.030 ↓ 0.0 0 18,010

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

  • Group Key: u0_57.id
639. 18.010 54.030 ↓ 0.0 0 18,010

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

640. 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
641. 18.010 18.010 ↓ 0.0 0 18,010

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

  • Recheck Cond: (order_id = transactions_order.id)
  • Filter: (status = 3)
642. 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)
643. 0.000 684.380 ↓ 0.0 0 18,010

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

  • Group Key: u0_58.id
644. 18.008 684.380 ↓ 0.0 0 18,010

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

645. 259.931 666.370 ↓ 0.0 0 18,010

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

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

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

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

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
648. 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.001..0.002 rows=1 loops=18,010)

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

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

  • Group Key: u0_59.id
651. 18.008 684.380 ↓ 0.0 0 18,010

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

652. 259.931 666.370 ↓ 0.0 0 18,010

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

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

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

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

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

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

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

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

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

  • Group Key: u0_60.id
658. 17.810 54.030 ↓ 0.0 0 18,010

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

659. 0.000 36.020 ↓ 0.0 0 18,010

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

660. 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
661. 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)
662. 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[]))
663. 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)
664. 0.000 126.070 ↓ 0.0 0 18,010

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

  • Group Key: u0_61.id
665. 18.010 126.070 ↓ 0.0 0 18,010

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

666. 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.001..0.002 rows=1 loops=18,010)

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

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

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

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

  • Group Key: u0_62.id
669. 18.010 54.030 ↓ 0.0 0 18,010

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

670. 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
671. 18.010 18.010 ↓ 0.0 0 18,010

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

  • Recheck Cond: (order_id = transactions_order.id)
  • Filter: (status = 3)
672. 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)
673. 0.000 684.380 ↓ 0.0 0 18,010

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

  • Group Key: u0_63.id
674. 18.006 684.380 ↓ 0.0 0 18,010

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

675. 259.931 666.370 ↓ 0.0 0 18,010

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

  • Hash Cond: (u2_37.transaction_id = u1_63.id)
676. 370.419 370.419 ↑ 1.0 144 17,639

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

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

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
678. 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.001..0.002 rows=1 loops=18,010)

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

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

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

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

  • Group Key: u0_64.id
681. 17.810 54.030 ↓ 0.0 0 18,010

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

682. 0.000 36.020 ↓ 0.0 0 18,010

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

683. 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
684. 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)
685. 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[]))
686. 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)
687. 0.000 126.070 ↓ 0.0 0 18,010

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

  • Group Key: u0_65.id
688. 18.010 126.070 ↓ 0.0 0 18,010

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

689. 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.001..0.002 rows=1 loops=18,010)

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

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

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

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

  • Group Key: u0_66.id
692. 18.010 54.030 ↓ 0.0 0 18,010

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

693. 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
694. 18.010 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)
695. 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)
696. 36.020 72.040 ↑ 1.0 1 18,010

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

  • Group Key: u0_105.id
697. 0.000 36.020 ↑ 1.0 1 18,010

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

  • Join Filter: (u0_105.id = u1_105.order_id)
698. 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
699. 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 : 134.208 ms
Execution time : 31,904.732 ms