explain.depesz.com

PostgreSQL's explain analyze made readable

Result: r61

Settings
# exclusive inclusive rows x rows loops node
1. 0.036 401,247.342 ↓ 100.0 100 1

Limit (cost=128,226.41..128,227.03 rows=1 width=15,053) (actual time=401,241.311..401,247.342 rows=100 loops=1)

2. 5.685 401,247.306 ↓ 100.0 100 1

Unique (cost=128,226.41..128,227.03 rows=1 width=15,053) (actual time=401,241.310..401,247.306 rows=100 loops=1)

3. 937.256 401,241.621 ↓ 195.0 195 1

Sort (cost=128,226.41..128,226.42 rows=1 width=15,053) (actual time=401,241.308..401,241.621 rows=195 loops=1)

  • Sort Key: (CASE WHEN ((SubPlan 1) IS NULL) THEN 0 ELSE 1 END) DESC, flights10_.thermal_mean DESC NULLS LAST, field0_.id, flights10_.id, anomalyimp13_.id, weedimpact14_.id, changeimpa15_.id, thermalimp16_.id, (CASE WHEN (deerefield18_.id IS NULL) THEN 0 ELSE 1 END), (CASE WHEN (climatefie19_.id IS NULL) THEN 0 ELSE 1 END), (CASE WHEN (spensafiel20_.id IS NULL) THEN 0 ELSE 1 END), weatherobs17_.id, (string_agg(DISTINCT (ct.name)::text, ','::text ORDER BY (ct.name)::text)), ((SubPlan 3)), farm2_.id, division3_.id, company4_.id, companyali5_.id, companyhie6_.id, integratio24_.id, geodata7_.id, grid9_.id, field0_.version, field0_.precipitation, field0_.last_updated_by, field0_.date_created, field0_.is_covered, field0_.is_favorite, field0_.precipitation72, field0_.thumbnail_path, field0_.order_placed, field0_.planted_seeds, field0_.grid_id, field0_.center_longitude, field0_.is_alert, field0_.growing_degree_days, field0_.name, field0_.area, field0_.precipitation48, field0_.geo_data_id, field0_.last_boundary_sync, field0_.last_updated, field0_.is_monitored, field0_.number, field0_.deleted, field0_.precipitation_total, field0_.token, field0_.center_latitude, field0_.planting_date, field0_.created_by, field0_.tract_name, field0_.description, flights10_.version, flights10_.flightscores, flights10_.spensa_integration_upload_processing, flights10_.last_updated_by, flights10_.date_created, flights10_.thermal_variance, flights10_.climate_integration_upload_processing, flights10_.south_west_latitude, flights10_.processing_start_date, flights10_.thumbnail_path, flights10_.soil_path, flights10_.season_id, flights10_.anomaly_impact_id, flights10_.coverage, flights10_.integration_upload, flights10_.rerun_date, flights10_.notify, flights10_.thermal_impact_id, flights10_.commands, flights10_.weather, flights10_.north_east_latitude, flights10_.upload_start_date, flights10_.center_longitude, flights10_.mosaics_quality, flights10_.last_message_received_time, flights10_.stand_count, flights10_.integration_upload_processing, flights10_.stress_increase, flights10_.climate_integration_upload, flights10_.flight_number, flights10_.review_status, flights10_.file_id, flights10_.weediness_mode, flights10_.date, flights10_.upload_date, flights10_.code, flights10_.review_date, flights10_.imagery_id, flights10_.last_updated, flights10_.health, flights10_.weediness, flights10_.spensa_integration_upload, flights10_.center_latitude, flights10_.released, flights10_.provider, flights10_.thermal_max, flights10_.change_impact_id, flights10_.tester, flights10_.north_east_longitude, flights10_.hybrid_path, flights10_.upload_path, flights10_.release_date, flights10_.weed_impact_id, flights10_.south_west_longitude, flights10_.created_by, flights10_.status, flights10_.row_tracer, flights10_.thermal_min, flights10_.previous_code, flights10_.scouting_report_id, ((round(((((flights10_.flightscores -> 'WEED_WATCH'::text) ->> 'area'::text))::real)::numeric, 2))::double precision), anomalyimp13_.version, anomalyimp13_.last_calc, anomalyimp13_.gain_area_delta, anomalyimp13_.flight_id, anomalyimp13_.loss, anomalyimp13_.gain, anomalyimp13_.loss_area_delta, anomalyimp13_.normal_area, anomalyimp13_.loss_area, anomalyimp13_.gain_area, anomalyimp13_.bushel_acre, anomalyimp13_.normal_area_delta, anomalyimp13_.gain_delta, anomalyimp13_.loss_delta, weedimpact14_.version, weedimpact14_.last_calc, weedimpact14_.gain_area_delta, weedimpact14_.flight_id, weedimpact14_.loss, weedimpact14_.gain, weedimpact14_.loss_area_delta, weedimpact14_.normal_area, weedimpact14_.loss_area, weedimpact14_.gain_area, weedimpact14_.bushel_acre, weedimpact14_.normal_area_delta, weedimpact14_.gain_delta, weedimpact14_.loss_delta, changeimpa15_.version, changeimpa15_.last_calc, changeimpa15_.gain_area_delta, changeimpa15_.flight_id, changeimpa15_.loss, changeimpa15_.gain, changeimpa15_.loss_area_delta, changeimpa15_.normal_area, changeimpa15_.loss_area, changeimpa15_.gain_area, changeimpa15_.bushel_acre, changeimpa15_.normal_area_delta, changeimpa15_.gain_delta, changeimpa15_.loss_delta, thermalimp16_.version, thermalimp16_.last_calc, thermalimp16_.low_area, thermalimp16_.high_area, weatherobs17_.version, weatherobs17_.last_updated_by, weatherobs17_.date, weatherobs17_.date_created, weatherobs17_.last_updated, weatherobs17_.precipitation_intensity, weatherobs17_.wind_speed, weatherobs17_.season_id, weatherobs17_.dew_point, weatherobs17_.hourly_data, weatherobs17_.created_by, weatherobs17_.wind_gust, weatherobs17_.status, weatherobs17_.temperature_low, weatherobs17_.humidity, weatherobs17_.temperature_high, weatherobs17_.description, weatherobs17_.field_id, farm2_.version, farm2_.last_updated_by, farm2_.date_created, farm2_.last_updated, farm2_.deleted, farm2_.name, farm2_.created_by, division3_.version, division3_.last_updated_by, division3_.date_created, division3_.last_updated, division3_.deleted, division3_.name, division3_.created_by, company4_.version, company4_.address1, company4_.last_updated_by, company4_.date_created, company4_.logo, company4_.address2, company4_.zip, company4_.climate_enabled, company4_.heard_from, company4_.state_id, company4_.name, company4_.city, company4_.parent_id, company4_.last_updated, company4_.deleted, company4_.phone_number, company4_.created_by, company4_.enabled, companyali5_.version, companyali5_.name, companyali5_.parent_alias_id, companyali5_.is_default, companyhie6_.version, companyhie6_.logo, companyhie6_.name, integratio24_.version, integratio24_.company_id, integratio24_.last_spensa_sync, integratio24_.last_climate_sync, integratio24_.deere_token_expired, integratio24_.user_id, integratio24_.deere_access_token, integratio24_.spensa_token, integratio24_.deere_request_token, integratio24_.last_deere_sync, integratio24_.climate_access_token, geodata7_.version, geodata7_.geometry, grid9_.version, grid9_.last_updated_by, grid9_.date_created, grid9_.last_updated, grid9_.south_west_latitude, grid9_.season_id, grid9_.state, grid9_.provider, grid9_.north_east_latitude, grid9_.north_east_longitude, grid9_.geometry, grid9_.south_west_longitude, grid9_.created_by, grid9_.schedule_id, grid9_.enabled, grid9_.grid_name
  • Sort Method: external merge Disk: 47288kB
4. 896.235 400,304.365 ↓ 6,499.0 6,499 1

Nested Loop Left Join (cost=36,700.13..128,226.40 rows=1 width=15,053) (actual time=180.974..400,304.365 rows=6,499 loops=1)

  • Join Filter: (spensafiel20_.field_id = field0_.id)
  • Rows Removed by Join Filter: 6315971
5. 6,302.908 398,381.288 ↓ 6,499.0 6,499 1

Nested Loop Left Join (cost=36,700.13..128,120.30 rows=1 width=14,913) (actual time=180.671..398,381.288 rows=6,499 loops=1)

  • Join Filter: (climatefie19_.field_id = field0_.id)
  • Rows Removed by Join Filter: 51539357
6. 9,125.847 386,112.298 ↓ 6,499.0 6,499 1

Nested Loop Left Join (cost=36,700.13..127,630.69 rows=1 width=14,905) (actual time=180.570..386,112.298 rows=6,499 loops=1)

  • Join Filter: (deerefield18_.field_id = field0_.id)
  • Rows Removed by Join Filter: 63367687
7. 38.476 369,740.066 ↓ 6,499.0 6,499 1

Nested Loop Left Join (cost=36,700.13..127,077.23 rows=1 width=14,897) (actual time=178.126..369,740.066 rows=6,499 loops=1)

8. 14,372.064 369,617.103 ↓ 6,499.0 6,499 1

Nested Loop Left Join (cost=36,699.71..127,073.04 rows=1 width=13,333) (actual time=178.102..369,617.103 rows=6,499 loops=1)

  • Join Filter: (cts.field_crop_types_id = field0_.id)
  • Rows Removed by Join Filter: 217125932
9. 27.384 2,388.333 ↓ 6,499.0 6,499 1

Nested Loop (cost=22,895.75..111,498.62 rows=1 width=13,301) (actual time=135.864..2,388.333 rows=6,499 loops=1)

  • Join Filter: (alertrule22_.badge_id = badge23_.id)
  • Rows Removed by Join Filter: 2895
10. 35.189 2,342.161 ↓ 9,394.0 9,394 1

Nested Loop (cost=22,895.75..111,497.54 rows=1 width=13,309) (actual time=135.858..2,342.161 rows=9,394 loops=1)

  • Join Filter: (problemale21_.alert_rule_id = alertrule22_.id)
  • Rows Removed by Join Filter: 9501
11. 31.073 2,297.578 ↓ 9,394.0 9,394 1

Nested Loop (cost=22,895.75..111,496.45 rows=1 width=13,309) (actual time=135.852..2,297.578 rows=9,394 loops=1)

12. 16.822 2,221.109 ↓ 5,044.0 5,044 1

Nested Loop Left Join (cost=22,895.46..111,495.12 rows=1 width=13,301) (actual time=135.836..2,221.109 rows=5,044 loops=1)

13. 18.127 2,204.287 ↓ 5,044.0 5,044 1

Nested Loop Left Join (cost=22,895.17..111,494.74 rows=1 width=13,269) (actual time=135.828..2,204.287 rows=5,044 loops=1)

14. 17.835 2,186.160 ↓ 5,044.0 5,044 1

Nested Loop Left Join (cost=22,894.75..111,493.94 rows=1 width=13,193) (actual time=135.821..2,186.160 rows=5,044 loops=1)

15. 18.635 2,168.325 ↓ 5,044.0 5,044 1

Nested Loop Left Join (cost=22,894.33..111,493.14 rows=1 width=13,117) (actual time=135.812..2,168.325 rows=5,044 loops=1)

16. 320.057 2,149.690 ↓ 5,044.0 5,044 1

Nested Loop Left Join (cost=22,893.92..111,492.34 rows=1 width=13,041) (actual time=135.802..2,149.690 rows=5,044 loops=1)

  • Join Filter: (field0_.grid_id = grid9_.id)
  • Rows Removed by Join Filter: 3950708
17. 19.435 513.149 ↓ 5,044.0 5,044 1

Nested Loop Left Join (cost=22,893.92..111,204.36 rows=1 width=9,604) (actual time=135.438..513.149 rows=5,044 loops=1)

18. 111.680 468.494 ↓ 5,044.0 5,044 1

Hash Join (cost=22,893.62..111,201.35 rows=1 width=6,781) (actual time=135.424..468.494 rows=5,044 loops=1)

  • Hash Cond: ((field0_.id = flights10_.field_id) AND ((SubPlan 6) = flights10_.id))
19. 4.383 85.654 ↑ 2.1 5,799 1

Hash Left Join (cost=6,848.15..56,161.51 rows=11,940 width=5,245) (actual time=37.119..85.654 rows=5,799 loops=1)

  • Hash Cond: (company4_.id = integratio24_.company_id)
20. 3.746 80.835 ↑ 2.1 5,799 1

Hash Join (cost=6,604.44..55,886.41 rows=11,940 width=2,824) (actual time=36.667..80.835 rows=5,799 loops=1)

  • Hash Cond: (companyali5_.company_hierarchy_id = companyhie6_.id)
21. 3.632 77.079 ↑ 2.1 5,799 1

Hash Join (cost=6,603.31..55,847.30 rows=11,940 width=1,776) (actual time=36.640..77.079 rows=5,799 loops=1)

  • Hash Cond: (company4_.alias_id = companyali5_.id)
22. 4.527 73.437 ↑ 2.1 5,799 1

Hash Join (cost=6,601.86..55,807.86 rows=11,940 width=1,227) (actual time=36.622..73.437 rows=5,799 loops=1)

  • Hash Cond: (division3_.company_id = company4_.id)
23. 3.812 66.986 ↑ 2.2 5,808 1

Hash Join (cost=6,470.75..55,642.44 rows=13,053 width=530) (actual time=34.669..66.986 rows=5,808 loops=1)

  • Hash Cond: (farm2_.division_id = division3_.id)
24. 4.276 61.941 ↑ 2.2 5,808 1

Hash Join (cost=6,367.43..55,504.80 rows=13,053 width=435) (actual time=33.408..61.941 rows=5,808 loops=1)

  • Hash Cond: (field0_.farm_id = farm2_.id)
25. 16.933 50.333 ↑ 2.2 5,808 1

Hash Join (cost=5,789.88..54,892.98 rows=13,053 width=347) (actual time=26.002..50.333 rows=5,808 loops=1)

  • Hash Cond: (accesscont1_.field_id = field0_.id)
26. 7.629 9.174 ↑ 1.0 42,239 1

Bitmap Heap Scan on acl accesscont1_ (cost=803.70..48,555.59 rows=42,745 width=8) (actual time=1.602..9.174 rows=42,239 loops=1)

  • Recheck Cond: (user_id = 413)
  • Heap Blocks: exact=523
27. 1.545 1.545 ↑ 1.0 42,239 1

Bitmap Index Scan on acl_user_id (cost=0.00..793.02 rows=42,745 width=0) (actual time=1.545..1.545 rows=42,239 loops=1)

  • Index Cond: (user_id = 413)
28. 11.282 24.226 ↑ 1.1 18,341 1

Hash (cost=3,829.54..3,829.54 rows=20,131 width=339) (actual time=24.225..24.226 rows=18,341 loops=1)

  • Buckets: 16384 Batches: 2 Memory Usage: 3166kB
29. 12.944 12.944 ↑ 1.1 18,341 1

Seq Scan on field field0_ (cost=0.00..3,829.54 rows=20,131 width=339) (actual time=0.079..12.944 rows=18,341 loops=1)

  • Filter: ((NOT deleted) AND is_monitored)
  • Rows Removed by Filter: 23813
30. 4.527 7.332 ↓ 1.0 15,404 1

Hash (cost=385.02..385.02 rows=15,402 width=88) (actual time=7.332..7.332 rows=15,404 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 2116kB
31. 2.805 2.805 ↓ 1.0 15,404 1

Seq Scan on farm farm2_ (cost=0.00..385.02 rows=15,402 width=88) (actual time=0.004..2.805 rows=15,404 loops=1)

32. 0.739 1.233 ↓ 1.0 2,683 1

Hash (cost=69.81..69.81 rows=2,681 width=95) (actual time=1.233..1.233 rows=2,683 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 397kB
33. 0.494 0.494 ↓ 1.0 2,683 1

Seq Scan on division division3_ (cost=0.00..69.81 rows=2,681 width=95) (actual time=0.004..0.494 rows=2,683 loops=1)

34. 1.056 1.924 ↓ 1.0 2,993 1

Hash (cost=93.71..93.71 rows=2,992 width=697) (actual time=1.924..1.924 rows=2,993 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 504kB
35. 0.868 0.868 ↓ 1.0 2,993 1

Seq Scan on company company4_ (cost=0.00..93.71 rows=2,992 width=697) (actual time=0.005..0.868 rows=2,993 loops=1)

  • Filter: enabled
  • Rows Removed by Filter: 280
36. 0.006 0.010 ↑ 1.0 20 1

Hash (cost=1.20..1.20 rows=20 width=549) (actual time=0.010..0.010 rows=20 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
37. 0.004 0.004 ↑ 1.0 20 1

Seq Scan on company_alias companyali5_ (cost=0.00..1.20 rows=20 width=549) (actual time=0.003..0.004 rows=20 loops=1)

38. 0.005 0.010 ↑ 1.0 6 1

Hash (cost=1.06..1.06 rows=6 width=1,048) (actual time=0.010..0.010 rows=6 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
39. 0.005 0.005 ↑ 1.0 6 1

Seq Scan on company_hierarchy companyhie6_ (cost=0.00..1.06 rows=6 width=1,048) (actual time=0.004..0.005 rows=6 loops=1)

40. 0.274 0.436 ↑ 1.0 298 1

Hash (cost=239.98..239.98 rows=298 width=2,421) (actual time=0.436..0.436 rows=298 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 322kB
41. 0.162 0.162 ↑ 1.0 298 1

Seq Scan on integration integratio24_ (cost=0.00..239.98 rows=298 width=2,421) (actual time=0.003..0.162 rows=298 loops=1)

42. 60.087 97.672 ↑ 1.0 57,819 1

Hash (cost=4,111.19..4,111.19 rows=57,819 width=1,544) (actual time=97.672..97.672 rows=57,819 loops=1)

  • Buckets: 4096 Batches: 32 Memory Usage: 902kB
43. 37.585 37.585 ↑ 1.0 57,819 1

Seq Scan on flight flights10_ (cost=0.00..4,111.19 rows=57,819 width=1,544) (actual time=0.094..37.585 rows=57,819 loops=1)

44.          

SubPlan (forHash Join)

45. 0.000 173.488 ↑ 1.0 1 10,843

Result (cost=20.92..20.93 rows=1 width=8) (actual time=0.016..0.016 rows=1 loops=10,843)

46.          

Initplan (forResult)

47. 21.686 108.430 ↑ 1.0 1 10,843

Aggregate (cost=12.47..12.48 rows=1 width=8) (actual time=0.010..0.010 rows=1 loops=10,843)

48. 86.744 86.744 ↓ 2.0 2 10,843

Index Scan using idx_flight_field_date_status_id on flight flights12_ (cost=0.42..12.47 rows=1 width=8) (actual time=0.005..0.008 rows=2 loops=10,843)

  • Index Cond: ((field_id = field0_.id) AND (date >= (CURRENT_DATE - 90)) AND ((status)::text = 'COMPLETED'::text))
  • Filter: (released AND ((provider)::text = ANY ('{Terravion_2019,Aeroptic}'::text[])))
  • Rows Removed by Filter: 0
49. 130.116 162.645 ↑ 1.0 1 10,843

Limit (cost=0.41..8.44 rows=1 width=8) (actual time=0.014..0.015 rows=1 loops=10,843)

50. 32.529 32.529 ↑ 1.0 1 10,843

Index Only Scan using idx_flight_field_date_status_id on flight flights11_ (cost=0.41..8.44 rows=1 width=8) (actual time=0.002..0.003 rows=1 loops=10,843)

  • Index Cond: ((field_id = field0_.id) AND (date = $6) AND (id IS NOT NULL))
  • Heap Fetches: 10088
51. 25.220 25.220 ↑ 1.0 1 5,044

Index Scan using geo_data_pkey on geo_data geodata7_ (cost=0.29..3.01 rows=1 width=2,823) (actual time=0.005..0.005 rows=1 loops=5,044)

  • Index Cond: (field0_.geo_data_id = id)
52. 1,316.484 1,316.484 ↑ 1.1 784 5,044

Seq Scan on grid grid9_ (cost=0.00..276.88 rows=888 width=3,437) (actual time=0.092..0.261 rows=784 loops=5,044)

53. 0.000 0.000 ↓ 0.0 0 5,044

Index Scan using field_impact_pkey on field_impact anomalyimp13_ (cost=0.42..0.61 rows=1 width=76) (actual time=0.000..0.000 rows=0 loops=5,044)

  • Index Cond: (flights10_.anomaly_impact_id = id)
54. 0.000 0.000 ↓ 0.0 0 5,044

Index Scan using field_impact_pkey on field_impact weedimpact14_ (cost=0.42..0.61 rows=1 width=76) (actual time=0.000..0.000 rows=0 loops=5,044)

  • Index Cond: (flights10_.weed_impact_id = id)
55. 0.000 0.000 ↓ 0.0 0 5,044

Index Scan using field_impact_pkey on field_impact changeimpa15_ (cost=0.42..0.61 rows=1 width=76) (actual time=0.000..0.000 rows=0 loops=5,044)

  • Index Cond: (flights10_.change_impact_id = id)
56. 0.000 0.000 ↓ 0.0 0 5,044

Index Scan using thermal_impact_pkey on thermal_impact thermalimp16_ (cost=0.29..0.34 rows=1 width=32) (actual time=0.000..0.000 rows=0 loops=5,044)

  • Index Cond: (flights10_.thermal_impact_id = id)
57. 45.396 45.396 ↑ 1.0 2 5,044

Index Scan using pa_flight_id_hidden on problem_alert problemale21_ (cost=0.29..1.30 rows=2 width=16) (actual time=0.006..0.009 rows=2 loops=5,044)

  • Index Cond: ((flight_id = flights10_.id) AND (hidden = false))
  • Filter: (NOT hidden)
58. 9.394 9.394 ↑ 2.0 2 9,394

Seq Scan on alert_rule alertrule22_ (cost=0.00..1.04 rows=4 width=16) (actual time=0.001..0.001 rows=2 loops=9,394)

59. 18.788 18.788 ↑ 1.0 1 9,394

Seq Scan on badge badge23_ (cost=0.00..1.07 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=9,394)

  • Filter: ((key_name)::text = 'HEAT_SEEKER'::text)
  • Rows Removed by Filter: 4
60. 338,656.391 352,856.706 ↑ 1.2 33,410 6,499

GroupAggregate (cost=13,803.96..14,637.14 rows=41,657 width=40) (actual time=0.010..54.294 rows=33,410 loops=6,499)

  • Group Key: cts.field_crop_types_id
61. 14,190.024 14,200.315 ↑ 1.2 33,415 6,499

Sort (cost=13,803.96..13,908.11 rows=41,662 width=524) (actual time=0.004..2.185 rows=33,415 loops=6,499)

  • Sort Key: cts.field_crop_types_id
  • Sort Method: quicksort Memory: 3319kB
62. 7.379 10.291 ↑ 1.0 41,662 1

Hash Join (cost=1.41..779.14 rows=41,662 width=524) (actual time=0.033..10.291 rows=41,662 loops=1)

  • Hash Cond: (cts.crop_type_id = ct.id)
63. 2.899 2.899 ↑ 1.0 41,662 1

Seq Scan on field_crop_type cts (cost=0.00..642.62 rows=41,662 width=16) (actual time=0.007..2.899 rows=41,662 loops=1)

64. 0.006 0.013 ↑ 1.0 18 1

Hash (cost=1.18..1.18 rows=18 width=524) (actual time=0.013..0.013 rows=18 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
65. 0.007 0.007 ↑ 1.0 18 1

Seq Scan on crop_type ct (cost=0.00..1.18 rows=18 width=524) (actual time=0.005..0.007 rows=18 loops=1)

66. 84.487 84.487 ↓ 0.0 0 6,499

Index Scan using UK9ceb4a1709bdc15f7c0cf372e4b6 on weather_observation weatherobs17_ (cost=0.42..4.19 rows=1 width=1,564) (actual time=0.013..0.013 rows=0 loops=6,499)

  • Index Cond: ((date = flights10_.date) AND (field_id = field0_.id))
67. 7,246.385 7,246.385 ↑ 1.1 9,750 6,499

Seq Scan on deere_field deerefield18_ (cost=0.00..424.87 rows=10,287 width=16) (actual time=0.094..1.115 rows=9,750 loops=6,499)

68. 5,966.082 5,966.082 ↑ 1.1 7,931 6,499

Seq Scan on climate_field climatefie19_ (cost=0.00..379.83 rows=8,783 width=16) (actual time=0.086..0.918 rows=7,931 loops=6,499)

69. 786.379 786.379 ↑ 1.0 972 6,499

Seq Scan on spensa_field spensafiel20_ (cost=0.00..48.72 rows=972 width=16) (actual time=0.002..0.121 rows=972 loops=6,499)

70.          

SubPlan (forNested Loop Left Join)

71. 38.994 136.479 ↑ 1.0 1 6,499

Aggregate (cost=12.47..12.48 rows=1 width=8) (actual time=0.021..0.021 rows=1 loops=6,499)

72. 97.485 97.485 ↓ 2.0 2 6,499

Index Scan using idx_flight_field_date_status_id on flight flights25_ (cost=0.42..12.47 rows=1 width=8) (actual time=0.012..0.015 rows=2 loops=6,499)

  • Index Cond: ((field_id = field0_.id) AND (date >= (CURRENT_DATE - 90)) AND ((status)::text = 'COMPLETED'::text))
  • Filter: (released AND ((provider)::text = ANY ('{Terravion_2019,Aeroptic}'::text[])))
  • Rows Removed by Filter: 0
73. 25.993 103.984 ↑ 1.0 1 6,499

Aggregate (cost=32.72..32.73 rows=1 width=8) (actual time=0.016..0.016 rows=1 loops=6,499)

74.          

Initplan (forAggregate)

75. 0.003 0.003 ↑ 2.0 1 1

Seq Scan on season season27_ (cost=0.00..1.04 rows=2 width=8) (actual time=0.003..0.003 rows=1 loops=1)

  • Filter: is_default
  • Rows Removed by Filter: 3
76. 38.994 77.988 ↑ 1.0 2 6,499

Bitmap Heap Scan on flight flight26_ (cost=4.49..31.67 rows=2 width=8) (actual time=0.010..0.012 rows=2 loops=6,499)

  • Recheck Cond: ((field_id = field0_.id) AND ((status)::text = 'COMPLETED'::text))
  • Filter: (released AND (season_id = $2))
  • Rows Removed by Filter: 0
  • Heap Blocks: exact=18554
77. 38.994 38.994 ↑ 2.3 3 6,499

Bitmap Index Scan on idx_flight_field_date_status_id (cost=0.00..4.49 rows=7 width=0) (actual time=0.006..0.006 rows=3 loops=6,499)

  • Index Cond: ((field_id = field0_.id) AND ((status)::text = 'COMPLETED'::text))
Planning time : 222.708 ms
Execution time : 401,259.043 ms