explain.depesz.com

PostgreSQL's explain analyze made readable

Result: R0uU

Settings
# exclusive inclusive rows x rows loops node
1. 10.017 102,510.048 ↑ 1.0 1 1

Subquery Scan on q (cost=9,782.64..9,783.29 rows=1 width=348) (actual time=102,341.494..102,510.048 rows=1 loops=1)

  • Filter: ((q.rank = 1) AND ((q.imsi)::text = '204080816106186'::text))
  • Rows Removed by Filter: 96,660
2. 156.522 102,499.560 ↓ 10,740.1 96,661 1

WindowAgg (cost=9,782.64..9,783.16 rows=9 width=496) (actual time=102,324.713..102,499.560 rows=96,661 loops=1)

3. 120.558 102,343.038 ↓ 10,740.1 96,661 1

Sort (cost=9,782.64..9,782.66 rows=9 width=220) (actual time=102,324.656..102,343.038 rows=96,661 loops=1)

  • Sort Key: sim.sim_id, (COALESCE(ptm.prepaid_notify, 0)), (COALESCE(ptm.id, ptmn.id)) DESC
  • Sort Method: external merge Disk: 21,416kB
4. 49.437 102,222.480 ↓ 10,740.1 96,661 1

Hash Left Join (cost=8,399.40..9,782.50 rows=9 width=220) (actual time=3.485..102,222.480 rows=96,661 loops=1)

  • Hash Cond: (bsi.subscription_item_id = bsil.subscription_item_id)
5. 109.170 102,173.043 ↓ 10,740.1 96,661 1

Nested Loop Left Join (cost=4,242.64..5,625.68 rows=9 width=236) (actual time=2.515..102,173.043 rows=96,661 loops=1)

6. 123.093 102,063.873 ↓ 10,740.1 96,661 1

Nested Loop (cost=4,242.49..5,623.85 rows=9 width=236) (actual time=2.507..102,063.873 rows=96,661 loops=1)

7. 44.072 101,940.780 ↓ 8,055.1 96,661 1

Hash Join (cost=4,242.35..5,621.42 rows=12 width=252) (actual time=2.494..101,940.780 rows=96,661 loops=1)

  • Hash Cond: (bpsi.subscription_item_id = sil.subscription_item_id)
8. 38.253 101,896.708 ↓ 4,027.5 96,661 1

Hash Left Join (cost=85.59..1,464.45 rows=24 width=244) (actual time=1.439..101,896.708 rows=96,661 loops=1)

  • Hash Cond: (sim_card.id = sim_att.sim_id)
9. 33.284 101,858.455 ↓ 4,027.5 96,661 1

Merge Join (cost=52.39..1,431.19 rows=24 width=212) (actual time=0.510..101,858.455 rows=96,661 loops=1)

  • Merge Cond: (asi.billing_profile_subscription_item_id = bpsi.billing_profile_subscription_item_id)
10. 139.714 101,825.171 ↓ 4,027.5 96,661 1

Nested Loop Left Join (cost=52.25..3,711.91 rows=24 width=212) (actual time=0.503..101,825.171 rows=96,661 loops=1)

11. 40.648 101,685.457 ↓ 4,027.5 96,661 1

Nested Loop Left Join (cost=52.11..3,692.98 rows=24 width=212) (actual time=0.493..101,685.457 rows=96,661 loops=1)

  • Join Filter: (sim_sub.sim_subscription_id = ptmn.bm_sim_subscription_item_id)
12. 101,416.068 101,644.809 ↓ 4,027.5 96,661 1

Nested Loop Left Join (cost=27.11..2,305.48 rows=24 width=204) (actual time=0.447..101,644.809 rows=96,661 loops=1)

  • Join Filter: (sim_sub.sim_subscription_id = ptm.bm_sim_subscription_item_id)
  • Rows Removed by Join Filter: 524,750,675
13. 4.504 228.741 ↓ 224.8 5,396 1

Nested Loop (cost=2.11..917.98 rows=24 width=192) (actual time=0.269..228.741 rows=5,396 loops=1)

  • Join Filter: (bp.billing_cycle_id = bc.billing_cycle_id)
14. 48.581 224.237 ↓ 224.8 5,396 1

Nested Loop (cost=2.11..916.60 rows=24 width=196) (actual time=0.243..224.237 rows=5,396 loops=1)

15. 11.999 175.656 ↓ 18.4 5,396 1

Nested Loop (cost=1.83..823.62 rows=293 width=138) (actual time=0.207..175.656 rows=5,396 loops=1)

16. 12.074 163.657 ↓ 18.4 5,396 1

Nested Loop (cost=1.68..752.71 rows=293 width=138) (actual time=0.194..163.657 rows=5,396 loops=1)

17. 25.372 151.583 ↓ 18.4 5,396 1

Nested Loop (cost=1.54..706.53 rows=293 width=130) (actual time=0.184..151.583 rows=5,396 loops=1)

  • Join Filter: (sim_sub.sim_id = imsi.active_on_sim_id)
18. 24.495 126.211 ↓ 17.0 5,401 1

Nested Loop (cost=1.13..552.28 rows=317 width=100) (actual time=0.166..126.211 rows=5,401 loops=1)

19. 25.375 101.716 ↓ 17.0 5,401 1

Nested Loop (cost=0.71..294.60 rows=317 width=64) (actual time=0.129..101.716 rows=5,401 loops=1)

20. 68.190 76.341 ↓ 22.7 5,527 1

Nested Loop Left Join (cost=0.43..212.62 rows=244 width=48) (actual time=0.110..76.341 rows=5,527 loops=1)

  • Join Filter: (sub.base_account_subscription_item_id = basi.account_subscription_item_id)
  • Rows Removed by Join Filter: 485,520
21. 8.151 8.151 ↓ 22.7 5,527 1

Nested Loop (cost=0.43..169.36 rows=244 width=36) (actual time=0.048..8.151 rows=5,527 loops=1)

  • -> Index Scan using account_subscription_item_billing_profile_subscription_item_idx on account_subscription_item asi (cost=0.14..21.79 rows=7
22. 0.000 0.471 ↓ 0.0 143 1

width=20) (cost=0..0 rows=0 width=0) (actual time=0.036..0.471 rows=143 loops=1)

  • Filter: ((c_subscription_item_type)::text = ANY ('{PRICEPLAN-NETWORKPRICELIST,PRICEPLAN-POSTPAID-FLEX,PRICEPLAN-POSTPAID-INDIVIDUAL,PRICEPLAN-POSTPAID-STATIC,PRICEPLAN-PREPAID-FLEX,PRICEPLAN-PREPAID-INDIVIDUAL,PRICEPLAN-PREPAID-STATIC}'::text[]))
  • Rows Removed by Filter: 16
23. 5.291 5.291 ↑ 1.1 39 143

Index Scan using ix_fk_account_si__subscription on subscription sub (cost=0.28..20.65 rows=43 width=24) (actual time=0.004..0.037 rows=39 loops=143)

  • Index Cond: (account_subscription_item_id = asi.account_subscription_item_id)
24. 27.496 27.635 ↓ 12.7 89 5,527

Materialize (cost=0.00..17.81 rows=7 width=20) (actual time=0.000..0.005 rows=89 loops=5,527)

25. 0.139 0.139 ↓ 20.4 143 1

Seq Scan on account_subscription_item basi (cost=0.00..17.78 rows=7 width=20) (actual time=0.008..0.139 rows=143 loops=1)

  • Filter: ((c_subscription_item_type)::text = ANY ('{PRICEPLAN-NETWORKPRICELIST,PRICEPLAN-POSTPAID-FLEX,PRICEPLAN-POSTPAID-INDIVIDUAL,PRICEPLAN-POSTPAID-STATIC,PRICEPLAN-PREPAID-FLEX,PRICEPLAN-PREPAID-INDIVIDUAL,PRICEPLAN-PREPAID-STATIC}'::text[]))
  • Rows Removed by Filter: 16
26. 22.108 22.108 ↑ 1.0 1 5,527

Index Scan using ix_fk_subscription__sim_subscription on sim_subscription sim_sub (cost=0.28..0.33 rows=1 width=24) (actual time=0.003..0.004 rows=1 loops=5,527)

  • Index Cond: (subscription_id = sub.subscription_id)
27. 16.203 16.203 ↑ 1.0 1 5,401

Index Scan using pk_sim on sim (cost=0.42..0.81 rows=1 width=36) (actual time=0.003..0.003 rows=1 loops=5,401)

  • Index Cond: (sim_id = sim_sub.sim_id)
28. 21.604 21.604 ↑ 1.0 1 5,401

Index Scan using "IX_fk_sim__active_profile" on imsi (cost=0.41..0.47 rows=1 width=46) (actual time=0.003..0.004 rows=1 loops=5,401)

  • Index Cond: (active_on_sim_id = sim.sim_id)
29. 5.396 5.396 ↑ 1.0 1 5,396

Index Scan using pk_account on account a (cost=0.14..0.16 rows=1 width=16) (actual time=0.001..0.001 rows=1 loops=5,396)

  • Index Cond: (account_id = imsi.account_id)
30. 5.396 5.396 ↑ 1.0 1 5,396

Index Scan using pk_billing_profile on billing_profile bp (cost=0.14..0.24 rows=1 width=16) (actual time=0.001..0.001 rows=1 loops=5,396)

  • Index Cond: (billing_profile_id = a.billing_profile_id)
31. 43.168 43.168 ↑ 1.0 1 5,396

Index Scan using sim_cards_iccid_idx on sim_cards sim_card (cost=0.28..0.31 rows=1 width=78) (actual time=0.007..0.008 rows=1 loops=5,396)

  • Index Cond: ((iccid)::text = (sim.sim_identifier)::text)
32. 0.000 0.000 ↑ 1.0 1 5,396

Materialize (cost=0.00..1.01 rows=1 width=12) (actual time=0.000..0.000 rows=1 loops=5,396)

33. 0.022 0.022 ↑ 1.0 1 1

Seq Scan on billing_cycle bc (cost=0.00..1.01 rows=1 width=12) (actual time=0.022..0.022 rows=1 loops=1)

34. 57,257.401 57,435.024 ↓ 97.3 97,266 5,396

Materialize (cost=25.00..1,030.00 rows=1,000 width=20) (actual time=0.002..10.644 rows=97,266 loops=5,396)

35. 177.623 177.623 ↓ 97.3 97,266 1

Foreign Scan on _products_telephone_mobilephone ptm (cost=25.00..1,025.00 rows=1,000 width=20) (actual time=0.118..177.623 rows=97,266 loops=1)

36. 0.000 0.000 ↓ 0.0 0 96,661

Materialize (cost=25.00..1,030.00 rows=1,000 width=16) (actual time=0.000..0.000 rows=0 loops=96,661)

37. 0.044 0.044 ↓ 0.0 0 1

Foreign Scan on _products_telephone_mobilephone_nwtariff ptmn (cost=25.00..1,025.00 rows=1,000 width=16) (actual time=0.044..0.044 rows=0 loops=1)

38. 96.661 96.661 ↑ 1.0 1 96,661

Index Scan using pk_billing_profile_subscription_item on billing_profile_subscription_item bbpsi (cost=0.14..0.79 rows=1 width=16) (actual time=0.001..0.001 rows=1 loops=96,661)

  • Index Cond: (billing_profile_subscription_item_id = basi.billing_profile_subscription_item_id)
39. 0.046 0.046 ↓ 1.4 150 1

Index Scan using pk_billing_profile_subscription_item on billing_profile_subscription_item bpsi (cost=0.14..6.09 rows=110 width=16) (actual time=0.004..0.046 rows=150 loops=1)

40. 0.072 0.915 ↓ 1.1 357 1

Hash (cost=28.97..28.97 rows=338 width=36) (actual time=0.914..0.915 rows=357 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 28kB
41. 0.050 0.843 ↓ 1.1 357 1

Subquery Scan on sim_att (cost=21.36..28.97 rows=338 width=36) (actual time=0.719..0.843 rows=357 loops=1)

42. 0.523 0.793 ↓ 1.1 357 1

HashAggregate (cost=21.36..25.59 rows=338 width=36) (actual time=0.719..0.793 rows=357 loops=1)

  • Group Key: sim_att_v.sim_id
43. 0.168 0.270 ↓ 1.1 414 1

Hash Join (cost=1.07..9.57 rows=393 width=164) (actual time=0.055..0.270 rows=414 loops=1)

  • Hash Cond: (sim_att_v.attribute_id = sim_att_1.id)
44. 0.079 0.079 ↓ 1.1 414 1

Seq Scan on sim_cards_attr_value sim_att_v (cost=0.00..6.93 rows=393 width=22) (actual time=0.017..0.079 rows=414 loops=1)

45. 0.012 0.023 ↓ 6.0 18 1

Hash (cost=1.03..1.03 rows=3 width=150) (actual time=0.022..0.023 rows=18 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
46. 0.011 0.011 ↓ 6.0 18 1

Seq Scan on sim_cards_attr sim_att_1 (cost=0.00..1.03 rows=3 width=150) (actual time=0.008..0.011 rows=18 loops=1)

47. 0.020 1.040 ↓ 2.7 149 1

Hash (cost=4,156.07..4,156.07 rows=55 width=8) (actual time=1.039..1.040 rows=149 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 14kB
48. 0.015 1.020 ↓ 2.7 149 1

Subquery Scan on sil (cost=4,154.97..4,156.07 rows=55 width=8) (actual time=0.972..1.020 rows=149 loops=1)

49. 0.124 1.005 ↓ 2.7 149 1

HashAggregate (cost=4,154.97..4,155.52 rows=55 width=144) (actual time=0.971..1.005 rows=149 loops=1)

  • Group Key: si_1.subscription_item_id, hm.name, ((si_1.subscription_item_type)::text), (CASE WHEN ((hm.status)::text = 'DR'::text) THEN 'DRAFT'::text WHEN ((hm.status)::text = 'AP'::text) THEN 'READY-FOR-APPROVAL'::text WHEN ((hm.status)::text = 'OK'::text) THEN 'APPROVED'::text WHEN ((hm.status)::text = 'SP'::text) THEN 'SUSPENDED'::text WHEN ((hm.status)::text = 'TM'::text) THEN 'TERMINATED'::text ELSE 'ERROR'::text END), si_1.detail_id, hm.uuid
50. 0.013 0.881 ↓ 2.7 149 1

Append (cost=30.60..4,154.15 rows=55 width=144) (actual time=0.325..0.881 rows=149 loops=1)

51. 0.119 0.663 ↓ 3.9 137 1

Hash Right Join (cost=30.60..1,035.32 rows=35 width=870) (actual time=0.325..0.663 rows=137 loops=1)

  • Hash Cond: (hm.id = si_1.detail_id)
52. 0.441 0.441 ↑ 6.7 150 1

Foreign Scan on _hardware_mobilephone hm (cost=25.00..1,025.00 rows=1,000 width=806) (actual time=0.206..0.441 rows=150 loops=1)

53. 0.024 0.103 ↓ 19.6 137 1

Hash (cost=5.52..5.52 rows=7 width=20) (actual time=0.102..0.103 rows=137 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 16kB
54. 0.079 0.079 ↓ 19.6 137 1

Seq Scan on subscription_item si_1 (cost=0.00..5.52 rows=7 width=20) (actual time=0.008..0.079 rows=137 loops=1)

  • Filter: ((subscription_item_type)::text = ANY ('{PRICEPLAN-POSTPAID-INDIVIDUAL,PRICEPLAN-PREPAID-INDIVIDUAL,PRICEPLAN-POSTPAID-FLEX,PRICEPLAN-PREPAID-FLEX,PRICEPLAN-POSTPAID-STATIC,PRICEPLAN-PREPAID-STATIC,PRICEPLAN-TOPOFF}'::text[]))
  • Rows Removed by Filter: 12
55. 0.000 0.031 ↓ 0.0 0 1

Nested Loop Left Join (cost=25.00..1,042.18 rows=5 width=870) (actual time=0.031..0.031 rows=0 loops=1)

  • Join Filter: (hm_1.id = si_2.detail_id)
56. 0.031 0.031 ↓ 0.0 0 1

Seq Scan on subscription_item si_2 (cost=0.00..4.59 rows=1 width=20) (actual time=0.031..0.031 rows=0 loops=1)

  • Filter: ((subscription_item_type)::text = 'PRICEPLAN-NETWORKPRICELIST'::text)
  • Rows Removed by Filter: 149
57. 0.000 0.000 ↓ 0.0 0

Foreign Scan on _hardware_mobilephone_nwtariff hm_1 (cost=25.00..1,025.00 rows=1,000 width=806) (never executed)

58. 0.003 0.132 ↓ 1.2 12 1

Subquery Scan on *SELECT* 3 (cost=29.61..1,033.74 rows=10 width=144) (actual time=0.112..0.132 rows=12 loops=1)

59. 0.024 0.129 ↓ 1.2 12 1

Hash Right Join (cost=29.61..1,033.64 rows=10 width=144) (actual time=0.111..0.129 rows=12 loops=1)

  • Hash Cond: (v.id = si_3.detail_id)
60. 0.061 0.061 ↑ 83.3 12 1

Foreign Scan on _hardware_hardwareservice_catalog v (cost=25.00..1,025.00 rows=1,000 width=52) (actual time=0.053..0.061 rows=12 loops=1)

61. 0.004 0.044 ↓ 6.0 12 1

Hash (cost=4.59..4.59 rows=2 width=20) (actual time=0.044..0.044 rows=12 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
62. 0.040 0.040 ↓ 6.0 12 1

Seq Scan on subscription_item si_3 (cost=0.00..4.59 rows=2 width=20) (actual time=0.007..0.040 rows=12 loops=1)

  • Filter: ((subscription_item_id IS NOT NULL) AND ((subscription_item_type)::text = ANY ('{ADDON-ACCOUNT,ADDON-SIM}'::text[])))
  • Rows Removed by Filter: 137
63. 0.000 0.042 ↓ 0.0 0 1

Subquery Scan on *SELECT* 4 (cost=25.00..1,042.24 rows=5 width=144) (actual time=0.042..0.042 rows=0 loops=1)

64. 0.001 0.042 ↓ 0.0 0 1

Nested Loop Left Join (cost=25.00..1,042.19 rows=5 width=144) (actual time=0.042..0.042 rows=0 loops=1)

  • Join Filter: (a_1.id = si_4.detail_id)
65. 0.041 0.041 ↓ 0.0 0 1

Seq Scan on subscription_item si_4 (cost=0.00..4.59 rows=1 width=20) (actual time=0.041..0.041 rows=0 loops=1)

  • Filter: ((subscription_item_type)::text = 'ADDON-TOPOFF'::text)
  • Rows Removed by Filter: 149
66. 0.000 0.000 ↓ 0.0 0

Foreign Scan on _products_hardwareservice_topoff a_1 (cost=25.00..1,025.00 rows=1,000 width=72) (never executed)

67. 96.661 96.661 ↑ 1.0 1 96,661

Index Only Scan using pk_subscription_item on subscription_item si (cost=0.14..0.20 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=96,661)

  • Index Cond: (subscription_item_id = bpsi.subscription_item_id)
  • Heap Fetches: 96,661
68. 96.661 96.661 ↑ 1.0 1 96,661

Index Only Scan using pk_subscription_item on subscription_item bsi (cost=0.14..0.20 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=96,661)

  • Index Cond: (subscription_item_id = bbpsi.subscription_item_id)
  • Heap Fetches: 96,661
69. 0.019 0.954 ↓ 2.7 149 1

Hash (cost=4,156.07..4,156.07 rows=55 width=8) (actual time=0.954..0.954 rows=149 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 14kB
70. 0.015 0.935 ↓ 2.7 149 1

Subquery Scan on bsil (cost=4,154.97..4,156.07 rows=55 width=8) (actual time=0.887..0.935 rows=149 loops=1)

71. 0.116 0.920 ↓ 2.7 149 1

HashAggregate (cost=4,154.97..4,155.52 rows=55 width=144) (actual time=0.886..0.920 rows=149 loops=1)

  • Group Key: si_5.subscription_item_id, hm_2.name, ((si_5.subscription_item_type)::text), (CASE WHEN ((hm_2.status)::text = 'DR'::text) THEN 'DRAFT'::text WHEN ((hm_2.status)::text = 'AP'::text) THEN 'READY-FOR-APPROVAL'::text WHEN ((hm_2.status)::text = 'OK'::text) THEN 'APPROVED'::text WHEN ((hm_2.status)::text = 'SP'::text) THEN 'SUSPENDED'::text WHEN ((hm_2.status)::text = 'TM'::text) THEN 'TERMINATED'::text ELSE 'ERROR'::text END), si_5.detail_id, hm_2.uuid
72. 0.012 0.804 ↓ 2.7 149 1

Append (cost=30.60..4,154.15 rows=55 width=144) (actual time=0.276..0.804 rows=149 loops=1)

73. 0.113 0.602 ↓ 3.9 137 1

Hash Right Join (cost=30.60..1,035.32 rows=35 width=870) (actual time=0.276..0.602 rows=137 loops=1)

  • Hash Cond: (hm_2.id = si_5.detail_id)
74. 0.407 0.407 ↑ 6.7 150 1

Foreign Scan on _hardware_mobilephone hm_2 (cost=25.00..1,025.00 rows=1,000 width=806) (actual time=0.181..0.407 rows=150 loops=1)

75. 0.025 0.082 ↓ 19.6 137 1

Hash (cost=5.52..5.52 rows=7 width=20) (actual time=0.082..0.082 rows=137 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 16kB
76. 0.057 0.057 ↓ 19.6 137 1

Seq Scan on subscription_item si_5 (cost=0.00..5.52 rows=7 width=20) (actual time=0.005..0.057 rows=137 loops=1)

  • Filter: ((subscription_item_type)::text = ANY ('{PRICEPLAN-POSTPAID-INDIVIDUAL,PRICEPLAN-PREPAID-INDIVIDUAL,PRICEPLAN-POSTPAID-FLEX,PRICEPLAN-PREPAID-FLEX,PRICEPLAN-POSTPAID-STATIC,PRICEPLAN-PREPAID-STATIC,PRICEPLAN-TOPOFF}'::text[]))
  • Rows Removed by Filter: 12
77. 0.000 0.031 ↓ 0.0 0 1

Nested Loop Left Join (cost=25.00..1,042.18 rows=5 width=870) (actual time=0.031..0.031 rows=0 loops=1)

  • Join Filter: (hm_3.id = si_6.detail_id)
78. 0.031 0.031 ↓ 0.0 0 1

Seq Scan on subscription_item si_6 (cost=0.00..4.59 rows=1 width=20) (actual time=0.031..0.031 rows=0 loops=1)

  • Filter: ((subscription_item_type)::text = 'PRICEPLAN-NETWORKPRICELIST'::text)
  • Rows Removed by Filter: 149
79. 0.000 0.000 ↓ 0.0 0

Foreign Scan on _hardware_mobilephone_nwtariff hm_3 (cost=25.00..1,025.00 rows=1,000 width=806) (never executed)

80. 0.003 0.129 ↓ 1.2 12 1

Subquery Scan on *SELECT* 3_1 (cost=29.61..1,033.74 rows=10 width=144) (actual time=0.109..0.129 rows=12 loops=1)

81. 0.026 0.126 ↓ 1.2 12 1

Hash Right Join (cost=29.61..1,033.64 rows=10 width=144) (actual time=0.108..0.126 rows=12 loops=1)

  • Hash Cond: (v_1.id = si_7.detail_id)
82. 0.059 0.059 ↑ 83.3 12 1

Foreign Scan on _hardware_hardwareservice_catalog v_1 (cost=25.00..1,025.00 rows=1,000 width=52) (actual time=0.050..0.059 rows=12 loops=1)

83. 0.004 0.041 ↓ 6.0 12 1

Hash (cost=4.59..4.59 rows=2 width=20) (actual time=0.041..0.041 rows=12 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
84. 0.037 0.037 ↓ 6.0 12 1

Seq Scan on subscription_item si_7 (cost=0.00..4.59 rows=2 width=20) (actual time=0.005..0.037 rows=12 loops=1)

  • Filter: ((subscription_item_id IS NOT NULL) AND ((subscription_item_type)::text = ANY ('{ADDON-ACCOUNT,ADDON-SIM}'::text[])))
  • Rows Removed by Filter: 137
85. 0.000 0.030 ↓ 0.0 0 1

Subquery Scan on *SELECT* 4_1 (cost=25.00..1,042.24 rows=5 width=144) (actual time=0.030..0.030 rows=0 loops=1)

86. 0.000 0.030 ↓ 0.0 0 1

Nested Loop Left Join (cost=25.00..1,042.19 rows=5 width=144) (actual time=0.030..0.030 rows=0 loops=1)

  • Join Filter: (a_2.id = si_8.detail_id)
87. 0.030 0.030 ↓ 0.0 0 1

Seq Scan on subscription_item si_8 (cost=0.00..4.59 rows=1 width=20) (actual time=0.030..0.030 rows=0 loops=1)

  • Filter: ((subscription_item_type)::text = 'ADDON-TOPOFF'::text)
  • Rows Removed by Filter: 149
88. 0.000 0.000 ↓ 0.0 0

Foreign Scan on _products_hardwareservice_topoff a_2 (cost=25.00..1,025.00 rows=1,000 width=72) (never executed)

Planning time : 32.112 ms
Execution time : 102,675.749 ms