explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Eu1b : SOT_Second_Query

Settings
# exclusive inclusive rows x rows loops node
1. 13,803.695 16,302.294 ↓ 1.0 108,265 1

Gather (cost=46,230.99..7,512,611.29 rows=108,263 width=2,286) (actual time=1,006.869..16,302.294 rows=108,265 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 58.993 2,498.524 ↑ 1.2 36,088 3

Hash Left Join (cost=45,230.99..82,333.57 rows=45,110 width=1,325) (actual time=970.443..2,498.524 rows=36,088 loops=3)

  • Hash Cond: (ccmp.currency_id = rc.id)
3. 51.025 2,439.425 ↑ 1.2 36,088 3

Hash Left Join (cost=45,225.21..82,206.38 rows=45,110 width=1,326) (actual time=970.315..2,439.425 rows=36,088 loops=3)

  • Hash Cond: (crm_opportunity.crm_company_id = ccmp.id)
4. 45.387 2,388.365 ↑ 1.2 36,088 3

Hash Left Join (cost=45,224.08..82,003.19 rows=45,110 width=1,317) (actual time=970.258..2,388.365 rows=36,088 loops=3)

  • Hash Cond: (crm_opportunity.delivery_method_id = dm.id)
5. 47.420 2,342.941 ↑ 1.2 36,088 3

Hash Left Join (cost=45,222.49..81,867.84 rows=45,110 width=1,308) (actual time=970.199..2,342.941 rows=36,088 loops=3)

  • Hash Cond: (crm_opportunity.vertical_id = cv.id)
6. 44.529 2,295.386 ↑ 1.2 36,088 3

Hash Left Join (cost=45,214.94..81,738.86 rows=45,110 width=1,282) (actual time=970.039..2,295.386 rows=36,088 loops=3)

  • Hash Cond: (crm_opportunity.booking_type_id = bt.id)
7. 42.746 2,250.804 ↑ 1.2 36,088 3

Hash Left Join (cost=45,213.08..81,606.06 rows=45,110 width=1,264) (actual time=969.963..2,250.804 rows=36,088 loops=3)

  • Hash Cond: (crm_opportunity.solution_set_id = cs.id)
8. 44.653 2,207.334 ↑ 1.2 36,088 3

Hash Left Join (cost=45,169.27..81,443.62 rows=45,110 width=1,242) (actual time=969.216..2,207.334 rows=36,088 loops=3)

  • Hash Cond: (crm_opportunity.domain_id = cd.id)
9. 42.476 2,162.410 ↑ 1.2 36,088 3

Hash Left Join (cost=45,152.67..81,307.74 rows=45,110 width=1,219) (actual time=968.922..2,162.410 rows=36,088 loops=3)

  • Hash Cond: (crm_opportunity.region_id = cr.id)
10. 43.490 2,119.894 ↑ 1.2 36,088 3

Hash Left Join (cost=45,150.82..81,175.43 rows=45,110 width=1,209) (actual time=968.852..2,119.894 rows=36,088 loops=3)

  • Hash Cond: (crm_opportunity.practice_id = pr.id)
11. 45.230 2,076.323 ↑ 1.2 36,088 3

Hash Left Join (cost=45,146.59..81,048.51 rows=45,110 width=1,195) (actual time=968.746..2,076.323 rows=36,088 loops=3)

  • Hash Cond: (crm_opportunity.market_id = cm.id)
12. 46.864 2,030.875 ↑ 1.2 36,088 3

Hash Left Join (cost=45,134.34..80,916.36 rows=45,110 width=1,189) (actual time=968.504..2,030.875 rows=36,088 loops=3)

  • Hash Cond: (crm_opportunity.forecast_status_id = fs.id)
13. 39.619 1,983.971 ↑ 1.2 36,088 3

Hash Left Join (cost=45,132.87..80,772.71 rows=45,110 width=1,187) (actual time=968.441..1,983.971 rows=36,088 loops=3)

  • Hash Cond: (crm_opportunity.won_lost_reason = wlr.id)
14. 39.123 1,944.227 ↑ 1.2 36,088 3

Hash Left Join (cost=45,125.50..80,645.53 rows=45,110 width=1,165) (actual time=968.294..1,944.227 rows=36,088 loops=3)

  • Hash Cond: (crm_opportunity.recruiter_id = ru8.id)
15. 39.036 1,904.696 ↑ 1.2 36,088 3

Hash Left Join (cost=45,094.11..80,495.73 rows=45,110 width=1,155) (actual time=967.861..1,904.696 rows=36,088 loops=3)

  • Hash Cond: (crm_opportunity.executive_sponsor = ru7.id)
16. 43.116 1,865.254 ↑ 1.2 36,088 3

Hash Left Join (cost=45,062.72..80,345.89 rows=45,110 width=1,145) (actual time=967.429..1,865.254 rows=36,088 loops=3)

  • Hash Cond: (crm_opportunity.bid_center_team_member = ru6.id)
17. 39.903 1,821.736 ↑ 1.2 36,088 3

Hash Left Join (cost=45,031.33..80,196.07 rows=45,110 width=1,135) (actual time=967.004..1,821.736 rows=36,088 loops=3)

  • Hash Cond: (crm_opportunity.inside_sales_executive = ru5.id)
18. 40.953 1,781.420 ↑ 1.2 36,088 3

Hash Left Join (cost=44,999.95..80,046.27 rows=45,110 width=1,125) (actual time=966.569..1,781.420 rows=36,088 loops=3)

  • Hash Cond: (crm_opportunity.proposal_manager = ru4.id)
19. 36.847 1,740.070 ↑ 1.2 36,088 3

Hash Left Join (cost=44,968.56..79,896.47 rows=45,110 width=1,115) (actual time=966.145..1,740.070 rows=36,088 loops=3)

  • Hash Cond: (crm_opportunity.pursuit_leader = ru3.id)
20. 40.042 1,702.815 ↑ 1.2 36,088 3

Hash Left Join (cost=44,937.17..79,746.67 rows=45,110 width=1,105) (actual time=965.710..1,702.815 rows=36,088 loops=3)

  • Hash Cond: (crm_opportunity.secondary_sales_rep_int = ru2.id)
21. 39.944 1,662.345 ↑ 1.2 36,088 3

Hash Left Join (cost=44,905.78..79,596.86 rows=45,110 width=1,095) (actual time=965.258..1,662.345 rows=36,088 loops=3)

  • Hash Cond: (crm_opportunity.id = cli.opportunity_id)
22. 41.139 1,622.350 ↑ 1.2 36,088 3

Hash Left Join (cost=44,904.63..79,370.13 rows=45,110 width=1,067) (actual time=965.170..1,622.350 rows=36,088 loops=3)

  • Hash Cond: (acc.parent_account_id = e2.id)
23. 43.737 1,561.299 ↑ 1.2 36,088 3

Hash Left Join (cost=42,488.46..76,835.55 rows=45,110 width=1,049) (actual time=944.875..1,561.299 rows=36,088 loops=3)

  • Hash Cond: (acc.account_owner_id = ru1.id)
24. 69.196 1,517.129 ↑ 1.2 36,088 3

Hash Left Join (cost=42,457.07..76,684.90 rows=45,110 width=1,039) (actual time=944.409..1,517.129 rows=36,088 loops=3)

  • Hash Cond: (crm_opportunity.lead_id = cl.id)
25. 43.587 1,124.556 ↑ 1.2 36,088 3

Hash Left Join (cost=21,292.15..41,680.56 rows=45,110 width=1,029) (actual time=619.944..1,124.556 rows=36,088 loops=3)

  • Hash Cond: (acc.type = acc_type.id)
26. 56.014 1,080.815 ↑ 1.2 36,088 3

Hash Left Join (cost=21,288.51..41,553.09 rows=45,110 width=1,023) (actual time=619.739..1,080.815 rows=36,088 loops=3)

  • Hash Cond: (crm_opportunity.account_id = acc.id)
27. 43.393 937.402 ↑ 1.2 36,088 3

Hash Left Join (cost=18,872.35..39,018.50 rows=45,110 width=989) (actual time=531.632..937.402 rows=36,088 loops=3)

  • Hash Cond: (ru.crm_manager_id = rue.id)
28. 35.893 893.211 ↑ 1.2 36,088 3

Hash Left Join (cost=18,840.96..38,868.43 rows=45,110 width=979) (actual time=530.793..893.211 rows=36,088 loops=3)

  • Hash Cond: (ru.crm_owner_role_id = own_con.id)
29. 98.296 857.190 ↑ 1.2 36,088 3

Hash Left Join (cost=18,837.56..38,743.44 rows=45,110 width=954) (actual time=530.625..857.190 rows=36,088 loops=3)

  • Hash Cond: (crm_opportunity.opportunity_owner = ru.id)
  • -> Hash Left Join (cost=18806.18..38592.80 rows=45110 width=936)(actual time=529.434..811.180 rows=36088 loops=3)
  • Hash Cond: (crm_opportunity.opportunity_stage_id = os.id)
  • Buckets: 1024 Batches: 1 Memory Usage: 40kB
30. 98.516 757.616 ↑ 1.2 36,088 3

Hash Left Join (cost=18,804.12..38,461.64 rows=45,110 width=920) (actual time=529.236..757.616 rows=36,088 loops=3)

  • Hash Cond: (crm_opportunity.contact_id = cc.id)
31. 131.451 131.451 ↑ 1.2 36,088 3

Parallel Seq Scan on crm_opportunity (cost=0.00..7,709.11 rows=45,110 width=909) (actual time=0.036..131.451 rows=36,088 loops=3)

  • Filter: is_reviewed
  • Rows Removed by Filter: 1
32. 187.888 527.649 ↑ 1.0 259,383 3

Hash (cost=14,041.83..14,041.83 rows=259,383 width=19) (actual time=527.649..527.649 rows=259,383 loops=3)

  • Buckets: 65536 Batches: 8 Memory Usage: 2192kB
33. 339.761 339.761 ↑ 1.0 259,383 3

Seq Scan on crm_contacts cc (cost=0.00..14,041.83 rows=259,383 width=19) (actual time=0.118..339.761 rows=259,383 loops=3)

34. 0.048 0.137 ↑ 1.0 47 3

Hash (cost=1.47..1.47 rows=47 width=24) (actual time=0.137..0.137 rows=47 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
35. 0.089 0.089 ↑ 1.0 47 3

Seq Scan on crm_opportunity_stages os (cost=0.00..1.47 rows=47 width=24) (actual time=0.064..0.089 rows=47 loops=3)

36. 0.410 1.141 ↑ 1.0 595 3

Hash (cost=23.95..23.95 rows=595 width=26) (actual time=1.141..1.141 rows=595 loops=3)

37. 0.731 0.731 ↑ 1.0 595 3

Seq Scan on res_users ru (cost=0.00..23.95 rows=595 width=26) (actual time=0.040..0.731 rows=595 loops=3)

38. 0.050 0.128 ↑ 1.0 62 3

Hash (cost=2.62..2.62 rows=62 width=33) (actual time=0.127..0.128 rows=62 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 13kB
39. 0.078 0.078 ↑ 1.0 62 3

Seq Scan on crm_owner_role_configuration own_con (cost=0.00..2.62 rows=62 width=33) (actual time=0.040..0.078 rows=62 loops=3)

40. 0.340 0.798 ↑ 1.0 595 3

Hash (cost=23.95..23.95 rows=595 width=18) (actual time=0.798..0.798 rows=595 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 39kB
41. 0.458 0.458 ↑ 1.0 595 3

Seq Scan on res_users rue (cost=0.00..23.95 rows=595 width=18) (actual time=0.013..0.458 rows=595 loops=3)

42. 26.838 87.399 ↑ 1.0 33,074 3

Hash (cost=2,002.74..2,002.74 rows=33,074 width=42) (actual time=87.399..87.399 rows=33,074 loops=3)

  • Buckets: 65536 Batches: 1 Memory Usage: 2762kB
43. 60.561 60.561 ↑ 1.0 33,074 3

Seq Scan on crm_account acc (cost=0.00..2,002.74 rows=33,074 width=42) (actual time=0.042..60.561 rows=33,074 loops=3)

44. 0.058 0.154 ↑ 1.0 73 3

Hash (cost=2.73..2.73 rows=73 width=14) (actual time=0.154..0.154 rows=73 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
45. 0.096 0.096 ↑ 1.0 73 3

Seq Scan on crm_account_type acc_type (cost=0.00..2.73 rows=73 width=14) (actual time=0.052..0.096 rows=73 loops=3)

46. 143.780 323.377 ↑ 1.0 356,841 3

Hash (cost=14,613.41..14,613.41 rows=356,841 width=18) (actual time=323.377..323.377 rows=356,841 loops=3)

  • Buckets: 65536 Batches: 8 Memory Usage: 2772kB
47. 179.597 179.597 ↑ 1.0 356,841 3

Seq Scan on crm_leads cl (cost=0.00..14,613.41 rows=356,841 width=18) (actual time=0.057..179.597 rows=356,841 loops=3)

48. 0.168 0.433 ↑ 1.0 595 3

Hash (cost=23.95..23.95 rows=595 width=18) (actual time=0.433..0.433 rows=595 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 39kB
49. 0.265 0.265 ↑ 1.0 595 3

Seq Scan on res_users ru1 (cost=0.00..23.95 rows=595 width=18) (actual time=0.010..0.265 rows=595 loops=3)

50. 10.308 19.912 ↑ 1.0 33,074 3

Hash (cost=2,002.74..2,002.74 rows=33,074 width=26) (actual time=19.911..19.912 rows=33,074 loops=3)

  • Buckets: 65536 Batches: 1 Memory Usage: 2454kB
51. 9.604 9.604 ↑ 1.0 33,074 3

Seq Scan on crm_account e2 (cost=0.00..2,002.74 rows=33,074 width=26) (actual time=0.010..9.604 rows=33,074 loops=3)

52. 0.014 0.051 ↑ 1.0 7 3

Hash (cost=1.07..1.07 rows=7 width=40) (actual time=0.051..0.051 rows=7 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
53. 0.037 0.037 ↑ 1.0 7 3

Seq Scan on crm_opportunity_line_item cli (cost=0.00..1.07 rows=7 width=40) (actual time=0.031..0.037 rows=7 loops=3)

54. 0.161 0.428 ↑ 1.0 595 3

Hash (cost=23.95..23.95 rows=595 width=18) (actual time=0.428..0.428 rows=595 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 39kB
55. 0.267 0.267 ↑ 1.0 595 3

Seq Scan on res_users ru2 (cost=0.00..23.95 rows=595 width=18) (actual time=0.009..0.267 rows=595 loops=3)

56. 0.163 0.408 ↑ 1.0 595 3

Hash (cost=23.95..23.95 rows=595 width=18) (actual time=0.408..0.408 rows=595 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 39kB
57. 0.245 0.245 ↑ 1.0 595 3

Seq Scan on res_users ru3 (cost=0.00..23.95 rows=595 width=18) (actual time=0.007..0.245 rows=595 loops=3)

58. 0.165 0.397 ↑ 1.0 595 3

Hash (cost=23.95..23.95 rows=595 width=18) (actual time=0.397..0.397 rows=595 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 39kB
59. 0.232 0.232 ↑ 1.0 595 3

Seq Scan on res_users ru4 (cost=0.00..23.95 rows=595 width=18) (actual time=0.008..0.232 rows=595 loops=3)

60. 0.179 0.413 ↑ 1.0 595 3

Hash (cost=23.95..23.95 rows=595 width=18) (actual time=0.413..0.413 rows=595 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 39kB
61. 0.234 0.234 ↑ 1.0 595 3

Seq Scan on res_users ru5 (cost=0.00..23.95 rows=595 width=18) (actual time=0.008..0.234 rows=595 loops=3)

62. 0.164 0.402 ↑ 1.0 595 3

Hash (cost=23.95..23.95 rows=595 width=18) (actual time=0.402..0.402 rows=595 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 39kB
63. 0.238 0.238 ↑ 1.0 595 3

Seq Scan on res_users ru6 (cost=0.00..23.95 rows=595 width=18) (actual time=0.008..0.238 rows=595 loops=3)

64. 0.164 0.406 ↑ 1.0 595 3

Hash (cost=23.95..23.95 rows=595 width=18) (actual time=0.406..0.406 rows=595 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 39kB
65. 0.242 0.242 ↑ 1.0 595 3

Seq Scan on res_users ru7 (cost=0.00..23.95 rows=595 width=18) (actual time=0.009..0.242 rows=595 loops=3)

66. 0.170 0.408 ↑ 1.0 595 3

Hash (cost=23.95..23.95 rows=595 width=18) (actual time=0.408..0.408 rows=595 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 39kB
67. 0.238 0.238 ↑ 1.0 595 3

Seq Scan on res_users ru8 (cost=0.00..23.95 rows=595 width=18) (actual time=0.007..0.238 rows=595 loops=3)

68. 0.052 0.125 ↑ 1.0 150 3

Hash (cost=5.50..5.50 rows=150 width=30) (actual time=0.125..0.125 rows=150 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 18kB
69. 0.073 0.073 ↑ 1.0 150 3

Seq Scan on crm_won_lost_reasons wlr (cost=0.00..5.50 rows=150 width=30) (actual time=0.023..0.073 rows=150 loops=3)

70. 0.014 0.040 ↑ 1.0 21 3

Hash (cost=1.21..1.21 rows=21 width=10) (actual time=0.040..0.040 rows=21 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
71. 0.026 0.026 ↑ 1.0 21 3

Seq Scan on crm_forecast_status fs (cost=0.00..1.21 rows=21 width=10) (actual time=0.019..0.026 rows=21 loops=3)

72. 0.106 0.218 ↑ 1.0 322 3

Hash (cost=8.22..8.22 rows=322 width=14) (actual time=0.218..0.218 rows=322 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 24kB
73. 0.112 0.112 ↑ 1.0 322 3

Seq Scan on crm_markets cm (cost=0.00..8.22 rows=322 width=14) (actual time=0.017..0.112 rows=322 loops=3)

74. 0.034 0.081 ↑ 1.0 99 3

Hash (cost=2.99..2.99 rows=99 width=22) (actual time=0.081..0.081 rows=99 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
75. 0.047 0.047 ↑ 1.0 99 3

Seq Scan on hr_practice pr (cost=0.00..2.99 rows=99 width=22) (actual time=0.019..0.047 rows=99 loops=3)

76. 0.015 0.040 ↑ 1.0 38 3

Hash (cost=1.38..1.38 rows=38 width=18) (actual time=0.040..0.040 rows=38 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
77. 0.025 0.025 ↑ 1.0 38 3

Seq Scan on crm_regions cr (cost=0.00..1.38 rows=38 width=18) (actual time=0.017..0.025 rows=38 loops=3)

78. 0.125 0.271 ↑ 1.0 382 3

Hash (cost=11.82..11.82 rows=382 width=31) (actual time=0.271..0.271 rows=382 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 33kB
79. 0.146 0.146 ↑ 1.0 382 3

Seq Scan on crm_domains cd (cost=0.00..11.82 rows=382 width=31) (actual time=0.016..0.146 rows=382 loops=3)

80. 0.354 0.724 ↑ 1.0 1,014 3

Hash (cost=31.14..31.14 rows=1,014 width=30) (actual time=0.724..0.724 rows=1,014 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 72kB
81. 0.370 0.370 ↑ 1.0 1,014 3

Seq Scan on crm_solution_set cs (cost=0.00..31.14 rows=1,014 width=30) (actual time=0.019..0.370 rows=1,014 loops=3)

82. 0.019 0.053 ↑ 1.0 38 3

Hash (cost=1.38..1.38 rows=38 width=26) (actual time=0.053..0.053 rows=38 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
83. 0.034 0.034 ↑ 1.0 38 3

Seq Scan on crm_booking_types bt (cost=0.00..1.38 rows=38 width=26) (actual time=0.023..0.034 rows=38 loops=3)

84. 0.060 0.135 ↑ 1.0 158 3

Hash (cost=5.58..5.58 rows=158 width=34) (actual time=0.135..0.135 rows=158 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 19kB
85. 0.075 0.075 ↑ 1.0 158 3

Seq Scan on crm_verticals cv (cost=0.00..5.58 rows=158 width=34) (actual time=0.018..0.075 rows=158 loops=3)

86. 0.014 0.037 ↑ 1.0 26 3

Hash (cost=1.26..1.26 rows=26 width=17) (actual time=0.036..0.037 rows=26 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
87. 0.023 0.023 ↑ 1.0 26 3

Seq Scan on crm_delivery_methods dm (cost=0.00..1.26 rows=26 width=17) (actual time=0.016..0.023 rows=26 loops=3)

88. 0.011 0.035 ↑ 1.0 6 3

Hash (cost=1.06..1.06 rows=6 width=17) (actual time=0.035..0.035 rows=6 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
89. 0.024 0.024 ↑ 1.0 6 3

Seq Scan on crm_companies ccmp (cost=0.00..1.06 rows=6 width=17) (actual time=0.019..0.024 rows=6 loops=3)

90. 0.049 0.106 ↑ 1.0 168 3

Hash (cost=3.68..3.68 rows=168 width=7) (actual time=0.106..0.106 rows=168 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 15kB
91. 0.057 0.057 ↑ 1.0 168 3

Seq Scan on res_currency rc (cost=0.00..3.68 rows=168 width=7) (actual time=0.017..0.057 rows=168 loops=3)

92.          

SubPlan (forGather)

93. 0.001 0.001 ↓ 0.0 0 108,265

Index Scan using product_template_pkey on product_template a (cost=0.28..8.29 rows=1 width=14) (actual time=0.001..0.001 rows=0 loops=108,265)

  • Index Cond: (crm_opportunity.product_id = id)
94. 0.000 0.000 ↓ 0.0 0 108,265

Index Scan using crm_account_pkey on crm_account a_1 (cost=0.29..8.31 rows=1 width=22) (actual time=0.000..0.000 rows=0 loops=108,265)

  • Index Cond: (crm_opportunity.bill_to_customer = id)
95. 0.011 0.011 ↑ 1.0 1 108,265

Seq Scan on crm_billing_types a_2 (cost=0.00..3.06 rows=1 width=23) (actual time=0.010..0.011 rows=1 loops=108,265)

  • Filter: (crm_opportunity.billing_type_id = id)
  • Rows Removed by Filter: 84
96. 0.017 0.017 ↑ 1.0 1 108,265

Seq Scan on res_currency a_3 (cost=0.00..4.10 rows=1 width=4) (actual time=0.005..0.017 rows=1 loops=108,265)

  • Filter: (crm_opportunity.foreign_currency_code = id)
  • Rows Removed by Filter: 167
97. 0.001 0.001 ↓ 0.0 0 108,265

Index Scan using res_users_pkey on res_users a_4 (cost=0.28..8.29 rows=1 width=14) (actual time=0.001..0.001 rows=0 loops=108,265)

  • Index Cond: (crm_opportunity.delivery_leader = id)
98. 0.025 0.025 ↓ 0.0 0 108,265

Seq Scan on crm_lead_sources a_5 (cost=0.00..8.11 rows=1 width=18) (actual time=0.023..0.025 rows=0 loops=108,265)

  • Filter: (crm_opportunity.lead_source = id)
  • Rows Removed by Filter: 249
99. 0.001 0.001 ↓ 0.0 0 108,265

Index Scan using crm_campaign_sources_pkey on crm_campaign_sources a_6 (cost=0.15..8.17 rows=1 width=32) (actual time=0.001..0.001 rows=0 loops=108,265)

  • Index Cond: (crm_opportunity.primary_campaign_source = id)
100. 0.003 0.003 ↑ 1.0 1 108,265

Index Scan using crm_industry_types_pkey on crm_industry_types a_7 (cost=0.15..8.17 rows=1 width=19) (actual time=0.003..0.003 rows=1 loops=108,265)

  • Index Cond: (crm_opportunity.industry_id = id)
101. 0.015 0.015 ↑ 1.0 1 108,265

Seq Scan on res_country_state a_8 (cost=0.00..3.60 rows=1 width=11) (actual time=0.012..0.015 rows=1 loops=108,265)

  • Filter: (acc.billing_state_id = id)
  • Rows Removed by Filter: 127
102. 0.001 0.001 ↓ 0.0 0 108,265

Index Scan using hr_department_pkey on hr_department a_9 (cost=0.14..8.16 rows=1 width=32) (actual time=0.001..0.001 rows=0 loops=108,265)

  • Index Cond: (crm_opportunity.department_id = id)
Planning time : 77.248 ms
Execution time : 16,814.846 ms