explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nO6Jb

Settings
# exclusive inclusive rows x rows loops node
1. 0.915 51.690 ↓ 1.0 234 1

Unique (cost=10,207.90..10,534.80 rows=229 width=13,175) (actual time=50.750..51.690 rows=234 loops=1)

2. 1.587 50.775 ↓ 1.0 234 1

Sort (cost=10,207.90..10,208.48 rows=229 width=13,175) (actual time=50.749..50.775 rows=234 loops=1)

  • Sort Key: shuttleord0_.shuttle_order_id, country3_.country_id, shuttlesch4_.shuttle_schedule_id, transportc5_.transport_classification_capacity_id, sporttype6_.sport_type_id, checkpoint7_.check_point_id, rushpoi8_.rush_poi_id, zone9_.zone_id, infrastruc10_.transport_infrastructure_object_id, poi11_.poi_id, platform12_.platform_id, shuttletri13_.work_task_id, shuttlewor14_.order_id, person15_.person_id, organizati16_.organization_id, regiondict17_.region_id, operationm18_.operation_mode_id, organizati19_.organization_id, regiondict20_.region_id, person21_.person_id, organizati22_.organization_id, regiondict23_.region_id, transport24_.transport_id, person25_.person_id, organizati26_.organization_id, regiondict27_.region_id, person28_.person_id, organizati29_.organization_id, regiondict30_.region_id, person31_.person_id, organizati32_.organization_id, regiondict33_.region_id, person34_.person_id, organizati35_.organization_id, regiondict36_.region_id, dependentt37_.work_task_id, routetrack38_.route_track_id, checkpoint39_.check_point_id, rushpoi40_.rush_poi_id, zone41_.zone_id, infrastruc42_.transport_infrastructure_object_id, poi43_.poi_id, platform44_.platform_id, person45_.person_id, organizati46_.organization_id, regiondict47_.region_id, shuttleord0_.accompanying_contacts, shuttleord0_.baggage, shuttleord0_.child_car_seat, shuttleord0_.comment, shuttleord0_.country_id, shuttleord0_.customer_id, shuttleord0_.from_check_point_id, shuttleord0_.changes_confirmation_request_date, shuttleord0_.meeting_contacts, shuttleord0_.person_count, shuttleord0_.shuttle_trip_id, shuttleord0_.sport_type_id, shuttleord0_.shuttle_order_status, shuttleord0_.to_check_point_id, shuttleord0_.transfer_type, shuttleord0_.transport_classification_capacity_id, shuttleord0_.transport_service_code, shuttleord0_.wheelchair, country3_.alpha_2_iso_3166, country3_.alpha_3_iso_3166, country3_.name, shuttlesch4_.finish_time, shuttlesch4_.shuttle_order_id, shuttlesch4_.start_time, transportc5_.capacity_group, transportc5_.category, transportc5_.length, transportc5_.level_class, transportc5_.order_number, transportc5_.seat_passengers, transportc5_.total_passengers, sporttype6_.external_id, sporttype6_.name, checkpoint7_.transport_infrastructure_object_id, checkpoint7_.platform_id, checkpoint7_.poi_id, checkpoint7_.rush_poi_id, checkpoint7_.zone_id, rushpoi8_.address, rushpoi8_.label, rushpoi8_.point, zone9_.center, zone9_.zone_color, zone9_.data_text, zone9_.label, zone9_.zone_opacity, zone9_.size, zone9_.zone_type, zone9_.zone_geometry_id, zone9_.zone_group_id, infrastruc10_.address, infrastruc10_.gate, infrastruc10_.max_height, infrastruc10_.max_weight, infrastruc10_.protect, infrastruc10_.type, infrastruc10_.zone_id, poi11_.address, poi11_.city, poi11_.external_id, poi11_.label, poi11_.point, poi11_.street, platform12_.address, platform12_.building_type, platform12_.bus_station_area, platform12_.bus_station_type, platform12_.city_id, platform12_.count_ticket_window, platform12_.directions, platform12_.email, platform12_.fax, platform12_.flow_capacity, platform12_.has_bench, platform12_.has_pavilion, platform12_.has_pocket, platform12_.has_road_sign_5_13, platform12_.has_room, platform12_.has_timetable, platform12_.holder_organization, platform12_.label, platform12_.municipality_id, platform12_.phone, platform12_.receptionist, platform12_.region_id, platform12_.room_area, platform12_.time_zone, platform12_.transfer_hub_station, platform12_.transfer_main_station, shuttletri13_1_.begin_datetime, shuttletri13_1_.begin_timezone, shuttletri13_1_.comment, shuttletri13_1_.completed, shuttletri13_1_.end_datetime, shuttletri13_1_.end_timezone, shuttletri13_1_.force_completed, shuttletri13_1_.label, shuttletri13_1_.read_only, shuttletri13_.baggage, shuttletri13_.child_car_seat, shuttletri13_.hidden, shuttletri13_.changes_confirmation_date, shuttletri13_.need_changes_confirmation, shuttletri13_.person_count, shuttletri13_.planned_average_speed, shuttletri13_.related_trip_id, shuttletri13_.route_track_id, shuttletri13_.status, shuttletri13_.transport_classification_capacity_id, shuttletri13_.transport_service_code, shuttletri13_.wheelchair, shuttletri13_.shuttle_work_order_id, shuttlewor14_1_.begin_fuel_remains, shuttlewor14_1_.break_periods, shuttlewor14_1_.devices_fuel_consumption, shuttlewor14_1_.dispatcher, shuttlewor14_1_.empty_running_fuel_consumption, shuttlewor14_1_.empty_running_miliage, shuttlewor14_1_.empty_running_time, shuttlewor14_1_.end_fuel_remains, shuttlewor14_1_.first_driver, shuttlewor14_1_.fuel_consumption, shuttlewor14_1_.fuel_sensor_id, shuttlewor14_1_.fueling_before, shuttlewor14_1_.fueling_in_time, shuttlewor14_1_.list_number, shuttlewor14_1_.mechanic_in, shuttlewor14_1_.mechanic_out, shuttlewor14_1_.milliage, shuttlewor14_1_.motohours_idle, shuttlewor14_1_.motohours_move, shuttlewor14_1_.operation_mode, shuttlewor14_1_.passing_driver, shuttlewor14_1_.remains_fuel_type, shuttlewor14_1_.report_begin_fuel_remains, shuttlewor14_1_.report_devices_fuel_consumption, shuttlewor14_1_.report_empty_running_fuel_consumption, shuttlewor14_1_.report_empty_running_milliage, shuttlewor14_1_.report_empty_running_time, shuttlewor14_1_.report_end_fuel_remains, shuttlewor14_1_.report_fuel_consumption, shuttlewor14_1_.report_fueling_before, shuttlewor14_1_.report_fueling_in_time, shuttlewor14_1_.report_milliage, shuttlewor14_1_.report_motohours_idle, shuttlewor14_1_.report_motohours_move, shuttlewor14_1_.report_work_time, shuttlewor14_1_.second_driver, shuttlewor14_1_.is_template, shuttlewor14_1_.template_name, shuttlewor14_1_.transport_id, shuttlewor14_1_.transporter, shuttlewor14_1_.voyage_prepare_time, shuttlewor14_1_.work_date, shuttlewor14_1_.work_periods, shuttlewor14_1_.work_time, person15_.birthday, person15_.driver_license, person15_.email, person15_.esia_id, person15_.external_id, person15_.firstname, person15_.function, person15_.number, person15_.organization_id, person15_.patronymic, person15_.phone, person15_.surname, organizati16_.actual_address, organizati16_.bank_id, organizati16_.correspondent_account, organizati16_.is_customer, organizati16_.director_person_id, organizati16_.email, organizati16_.esia_id, organizati16_.external_id, organizati16_.fax, organizati16_.is_holder, organizati16_.id_taxpayer, organizati16_.is_state_organization, organizati16_.label, organizati16_.legal_address, organizati16_.ogrn, organizati16_.is_operator, organizati16_.order_number, organizati16_.phone, organizati16_.region_id, organizati16_.is_service, organizati16_.settlement_account, organizati16_.is_transporter, regiondict17_.code, regiondict17_.name, operationm18_.fuel_and_lubricants_coefficient, operationm18_.label, organizati19_.actual_address, organizati19_.bank_id, organizati19_.correspondent_account, organizati19_.is_customer, organizati19_.director_person_id, organizati19_.email, organizati19_.esia_id, organizati19_.external_id, organizati19_.fax, organizati19_.is_holder, organizati19_.id_taxpayer, organizati19_.is_state_organization, organizati19_.label, organizati19_.legal_address, organizati19_.ogrn, organizati19_.is_operator, organizati19_.order_number, organizati19_.phone, organizati19_.region_id, organizati19_.is_service, organizati19_.settlement_account, organizati19_.is_transporter, regiondict20_.code, regiondict20_.name, person21_.birthday, person21_.driver_license, person21_.email, person21_.esia_id, person21_.external_id, person21_.firstname, person21_.function, person21_.number, person21_.organization_id, person21_.patronymic, person21_.phone, person21_.surname, organizati22_.actual_address, organizati22_.bank_id, organizati22_.correspondent_account, organizati22_.is_customer, organizati22_.director_person_id, organizati22_.email, organizati22_.esia_id, organizati22_.external_id, organizati22_.fax, organizati22_.is_holder, organizati22_.id_taxpayer, organizati22_.is_state_organization, organizati22_.label, organizati22_.legal_address, organizati22_.ogrn, organizati22_.is_operator, organizati22_.order_number, organizati22_.phone, organizati22_.region_id, organizati22_.is_service, organizati22_.settlement_account, organizati22_.is_transporter, regiondict23_.code, regiondict23_.name, transport24_.cam_urls, transport24_.garage_number, transport24_.graduation_year, transport24_.is_passenger_carrier, transport24_.label, transport24_.license_plate, transport24_.maintenance_date, transport24_.min_parking_duration, transport24_.owner_organization_id, transport24_.transport_group_id, transport24_.transport_model_id, transport24_.transport_service_code, person25_.birthday, person25_.driver_license, person25_.email, person25_.esia_id, person25_.external_id, person25_.firstname, person25_.function, person25_.number, person25_.organization_id, person25_.patronymic, person25_.phone, person25_.surname, organizati26_.actual_address, organizati26_.bank_id, organizati26_.correspondent_account, organizati26_.is_customer, organizati26_.director_person_id, organizati26_.email, organizati26_.esia_id, organizati26_.external_id, organizati26_.fax, organizati26_.is_holder, organizati26_.id_taxpayer, organizati26_.is_state_organization, organizati26_.label, organizati26_.legal_address, organizati26_.ogrn, organizati26_.is_operator, organizati26_.order_number, organizati26_.phone, organizati26_.region_id, organizati26_.is_service, organizati26_.settlement_account, organizati26_.is_transporter, regiondict27_.code, regiondict27_.name, person28_.birthday, person28_.driver_license, person28_.email, person28_.esia_id, person28_.external_id, person28_.firstname, person28_.function, person28_.number, person28_.organization_id, person28_.patronymic, person28_.phone, person28_.surname, organizati29_.actual_address, organizati29_.bank_id, organizati29_.correspondent_account, organizati29_.is_customer, organizati29_.director_person_id, organizati29_.email, organizati29_.esia_id, organizati29_.external_id, organizati29_.fax, organizati29_.is_holder, organizati29_.id_taxpayer, organizati29_.is_state_organization, organizati29_.label, organizati29_.legal_address, organizati29_.ogrn, organizati29_.is_operator, organizati29_.order_number, organizati29_.phone, organizati29_.region_id, organizati29_.is_service, organizati29_.settlement_account, organizati29_.is_transporter, regiondict30_.code, regiondict30_.name, person31_.birthday, person31_.driver_license, person31_.email, person31_.esia_id, person31_.external_id, person31_.firstname, person31_.function, person31_.number, person31_.organization_id, person31_.patronymic, person31_.phone, person31_.surname, organizati32_.actual_address, organizati32_.bank_id, organizati32_.correspondent_account, organizati32_.is_customer, organizati32_.director_person_id, organizati32_.email, organizati32_.esia_id, organizati32_.external_id, organizati32_.fax, organizati32_.is_holder, organizati32_.id_taxpayer, organizati32_.is_state_organization, organizati32_.label, organizati32_.legal_address, organizati32_.ogrn, organizati32_.is_operator, organizati32_.order_number, organizati32_.phone, organizati32_.region_id, organizati32_.is_service, organizati32_.settlement_account, organizati32_.is_transporter, regiondict33_.code, regiondict33_.name, person34_.birthday, person34_.driver_license, person34_.email, person34_.esia_id, person34_.external_id, person34_.firstname, person34_.function, person34_.number, person34_.organization_id, person34_.patronymic, person34_.phone, person34_.surname, organizati35_.actual_address, organizati35_.bank_id, organizati35_.correspondent_account, organizati35_.is_customer, organizati35_.director_person_id, organizati35_.email, organizati35_.esia_id, organizati35_.external_id, organizati35_.fax, organizati35_.is_holder, organizati35_.id_taxpayer, organizati35_.is_state_organization, organizati35_.label, organizati35_.legal_address, organizati35_.ogrn, organizati35_.is_operator, organizati35_.order_number, organizati35_.phone, organizati35_.region_id, organizati35_.is_service, organizati35_.settlement_account, organizati35_.is_transporter, regiondict36_.code, regiondict36_.name, dependentt37_.baggage, dependentt37_.child_car_seat, dependentt37_.changes_confirmation_date, dependentt37_.need_changes_confirmation, dependentt37_.person_count, dependentt37_.planned_average_speed, dependentt37_.related_trip_id, dependentt37_.route_track_id, dependentt37_.status, dependentt37_.transport_classification_capacity_id, dependentt37_.transport_service_code, dependentt37_.wheelchair, dependentt37_.shuttle_work_order_id, ((SubPlan 1)), ((SubPlan 2)), routetrack38_.created, routetrack38_.from_check_point_id, routetrack38_.label, routetrack38_.path, routetrack38_.path_width, routetrack38_.permanent, routetrack38_.to_check_point_id, checkpoint39_.transport_infrastructure_object_id, checkpoint39_.platform_id, checkpoint39_.poi_id, checkpoint39_.rush_poi_id, checkpoint39_.zone_id, rushpoi40_.address, rushpoi40_.label, rushpoi40_.point, zone41_.center, zone41_.zone_color, zone41_.data_text, zone41_.label, zone41_.zone_opacity, zone41_.size, zone41_.zone_type, zone41_.zone_geometry_id, zone41_.zone_group_id, infrastruc42_.address, infrastruc42_.gate, infrastruc42_.max_height, infrastruc42_.max_weight, infrastruc42_.protect, infrastruc42_.type, infrastruc42_.zone_id, poi43_.address, poi43_.city, poi43_.external_id, poi43_.label, poi43_.point, poi43_.street, platform44_.address, platform44_.building_type, platform44_.bus_station_area, platform44_.bus_station_type, platform44_.city_id, platform44_.count_ticket_window, platform44_.directions, platform44_.email, platform44_.fax, platform44_.flow_capacity, platform44_.has_bench, platform44_.has_pavilion, platform44_.has_pocket, platform44_.has_road_sign_5_13, platform44_.has_room, platform44_.has_timetable, platform44_.holder_organization, platform44_.label, platform44_.municipality_id, platform44_.phone, platform44_.receptionist, platform44_.region_id, platform44_.room_area, platform44_.time_zone, platform44_.transfer_hub_station, platform44_.transfer_main_station, person45_.birthday, person45_.driver_license, person45_.email, person45_.esia_id, person45_.external_id, person45_.firstname, person45_.function, person45_.number, person45_.organization_id, person45_.patronymic, person45_.phone, person45_.surname, organizati46_.actual_address, organizati46_.bank_id, organizati46_.correspondent_account, organizati46_.is_customer, organizati46_.director_person_id, organizati46_.email, organizati46_.esia_id, organizati46_.external_id, organizati46_.fax, organizati46_.is_holder, organizati46_.id_taxpayer, organizati46_.is_state_organization, organizati46_.label, organizati46_.legal_address, organizati46_.ogrn, organizati46_.is_operator, organizati46_.order_number, organizati46_.phone, organizati46_.region_id, organizati46_.is_service, organizati46_.settlement_account, organizati46_.is_transporter, regiondict47_.code, regiondict47_.name
  • Sort Method: quicksort Memory: 433kB
3. 1.028 49.188 ↓ 1.0 234 1

Hash Join (cost=2,564.87..10,198.93 rows=229 width=13,175) (actual time=26.499..49.188 rows=234 loops=1)

  • Hash Cond: (shuttleord0_.shuttle_order_id = (shuttlesch1_.shuttle_order_id)::integer)
4. 0.944 35.175 ↓ 1.0 234 1

Hash Left Join (cost=2,556.57..4,336.80 rows=229 width=13,115) (actual time=26.138..35.175 rows=234 loops=1)

  • Hash Cond: ((checkpoint39_.platform_id)::integer = platform44_.platform_id)
5. 0.994 34.112 ↓ 1.0 234 1

Nested Loop Left Join (cost=2,550.85..4,330.46 rows=229 width=12,883) (actual time=26.001..34.112 rows=234 loops=1)

6. 0.794 33.118 ↓ 1.0 234 1

Hash Left Join (cost=2,550.43..2,561.28 rows=229 width=12,716) (actual time=25.988..33.118 rows=234 loops=1)

  • Hash Cond: ((person45_.organization_id)::integer = organizati46_.organization_id)
7. 0.799 32.245 ↓ 1.0 234 1

Hash Left Join (cost=2,546.78..2,556.75 rows=229 width=11,672) (actual time=25.889..32.245 rows=234 loops=1)

  • Hash Cond: ((shuttleord0_.customer_id)::integer = person45_.person_id)
8. 0.740 29.146 ↓ 1.0 234 1

Hash Left Join (cost=2,432.05..2,441.42 rows=229 width=11,499) (actual time=23.568..29.146 rows=234 loops=1)

  • Hash Cond: ((checkpoint39_.transport_infrastructure_object_id)::integer = infrastruc42_.transport_infrastructure_object_id)
9. 0.721 28.353 ↓ 1.0 234 1

Hash Left Join (cost=2,428.23..2,436.99 rows=229 width=11,395) (actual time=23.503..28.353 rows=234 loops=1)

  • Hash Cond: ((checkpoint39_.zone_id)::integer = zone41_.zone_id)
10. 0.718 27.480 ↓ 1.0 234 1

Hash Left Join (cost=2,419.48..2,427.64 rows=229 width=11,258) (actual time=23.337..27.480 rows=234 loops=1)

  • Hash Cond: ((checkpoint39_.rush_poi_id)::integer = rushpoi40_.rush_poi_id)
11. 0.802 26.725 ↓ 1.0 234 1

Hash Left Join (cost=2,416.31..2,423.86 rows=229 width=11,158) (actual time=23.287..26.725 rows=234 loops=1)

  • Hash Cond: ((shuttleord0_.to_check_point_id)::integer = checkpoint39_.check_point_id)
12. 0.805 25.850 ↓ 1.0 234 1

Hash Left Join (cost=2,411.80..2,418.74 rows=229 width=11,134) (actual time=23.202..25.850 rows=234 loops=1)

  • Hash Cond: ((shuttletri13_.route_track_id)::integer = routetrack38_.route_track_id)
13. 0.718 24.907 ↓ 1.0 234 1

Hash Left Join (cost=2,402.46..2,408.79 rows=229 width=10,277) (actual time=23.051..24.907 rows=234 loops=1)

  • Hash Cond: ((organizati35_.region_id)::integer = regiondict36_.region_id)
14. 1.181 24.156 ↓ 1.0 234 1

Hash Right Join (cost=2,399.43..2,405.13 rows=229 width=10,229) (actual time=22.996..24.156 rows=234 loops=1)

  • Hash Cond: ((dependentt37_.related_trip_id)::integer = (shuttletri13_.work_task_id)::integer)
15. 0.037 0.037 ↑ 1.0 190 1

Seq Scan on shuttle_trips dependentt37_ (cost=0.00..4.90 rows=190 width=60) (actual time=0.015..0.037 rows=190 loops=1)

16. 0.713 22.938 ↑ 1.0 229 1

Hash (cost=2,396.57..2,396.57 rows=229 width=10,169) (actual time=22.938..22.938 rows=229 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 263kB
17. 0.621 22.225 ↑ 1.0 229 1

Hash Left Join (cost=2,387.40..2,396.57 rows=229 width=10,169) (actual time=17.008..22.225 rows=229 loops=1)

  • Hash Cond: ((person34_.organization_id)::integer = organizati35_.organization_id)
18. 0.569 21.580 ↑ 1.0 229 1

Hash Left Join (cost=2,386.20..2,394.77 rows=229 width=9,173) (actual time=16.967..21.580 rows=229 loops=1)

  • Hash Cond: ((shuttlewor14_1_.mechanic_in)::integer = person34_.person_id)
19. 0.545 18.787 ↑ 1.0 229 1

Hash Left Join (cost=2,271.47..2,279.43 rows=229 width=9,000) (actual time=14.735..18.787 rows=229 loops=1)

  • Hash Cond: ((person28_.organization_id)::integer = organizati29_.organization_id)
20. 0.535 18.192 ↑ 1.0 229 1

Hash Left Join (cost=2,267.83..2,274.90 rows=229 width=7,956) (actual time=14.679..18.192 rows=229 loops=1)

  • Hash Cond: ((person31_.organization_id)::integer = organizati32_.organization_id)
21. 0.519 17.594 ↑ 1.0 229 1

Hash Left Join (cost=2,264.18..2,270.37 rows=229 width=6,912) (actual time=14.596..17.594 rows=229 loops=1)

  • Hash Cond: ((shuttlewor14_1_.dispatcher)::integer = person31_.person_id)
22. 0.522 14.779 ↑ 1.0 229 1

Hash Left Join (cost=2,149.45..2,155.04 rows=229 width=6,739) (actual time=12.277..14.779 rows=229 loops=1)

  • Hash Cond: ((shuttlewor14_1_.transport_id)::integer = transport24_.transport_id)
23. 0.474 14.114 ↑ 1.0 229 1

Hash Left Join (cost=2,142.37..2,147.34 rows=229 width=6,609) (actual time=12.119..14.114 rows=229 loops=1)

  • Hash Cond: ((person21_.organization_id)::integer = organizati22_.organization_id)
24. 0.489 13.584 ↑ 1.0 229 1

Hash Left Join (cost=2,138.72..2,142.81 rows=229 width=5,565) (actual time=12.050..13.584 rows=229 loops=1)

  • Hash Cond: ((person25_.organization_id)::integer = organizati26_.organization_id)
25. 0.457 13.027 ↑ 1.0 229 1

Hash Left Join (cost=2,135.08..2,138.28 rows=229 width=4,521) (actual time=11.965..13.027 rows=229 loops=1)

  • Hash Cond: ((shuttlewor14_1_.first_driver)::integer = person25_.person_id)
26. 0.601 10.301 ↑ 1.0 229 1

Merge Right Join (cost=2,020.35..2,022.94 rows=229 width=4,348) (actual time=9.681..10.301 rows=229 loops=1)

  • Merge Cond: (person28_.person_id = (shuttlewor14_1_.passing_driver)::integer)
27. 0.012 0.012 ↑ 3,677.0 1 1

Index Scan using persons_pkey on persons person28_ (cost=0.28..159.96 rows=3,677 width=173) (actual time=0.012..0.012 rows=1 loops=1)

28. 0.429 9.688 ↑ 1.0 229 1

Sort (cost=2,019.29..2,019.86 rows=229 width=4,175) (actual time=9.662..9.688 rows=229 loops=1)

  • Sort Key: shuttlewor14_1_.passing_driver
  • Sort Method: quicksort Memory: 220kB
29. 0.392 9.259 ↑ 1.0 229 1

Hash Left Join (cost=2,004.66..2,010.31 rows=229 width=4,175) (actual time=7.071..9.259 rows=229 loops=1)

  • Hash Cond: ((organizati19_.region_id)::integer = regiondict20_.region_id)
30. 0.415 8.836 ↑ 1.0 229 1

Hash Left Join (cost=2,001.64..2,006.65 rows=229 width=4,127) (actual time=7.033..8.836 rows=229 loops=1)

  • Hash Cond: ((shuttlewor14_1_.transporter)::integer = organizati19_.organization_id)
31. 0.324 8.410 ↑ 1.0 229 1

Hash Left Join (cost=2,000.43..2,004.57 rows=229 width=3,131) (actual time=7.011..8.410 rows=229 loops=1)

  • Hash Cond: ((shuttlewor14_1_.operation_mode)::integer = operationm18_.operation_mode_id)
32. 0.326 8.080 ↑ 1.0 229 1

Hash Left Join (cost=1,999.37..2,002.90 rows=229 width=3,091) (actual time=7.000..8.080 rows=229 loops=1)

  • Hash Cond: ((person15_.organization_id)::integer = organizati16_.organization_id)
33. 0.311 7.696 ↑ 1.0 229 1

Hash Left Join (cost=1,995.72..1,998.37 rows=229 width=2,047) (actual time=6.931..7.696 rows=229 loops=1)

  • Hash Cond: ((shuttlewor14_1_.second_driver)::integer = person15_.person_id)
34. 0.450 5.147 ↑ 1.0 229 1

Merge Right Join (cost=1,880.99..1,883.04 rows=229 width=1,874) (actual time=4.680..5.147 rows=229 loops=1)

  • Merge Cond: (person21_.person_id = (shuttlewor14_1_.mechanic_out)::integer)
35. 0.014 0.014 ↑ 245.1 15 1

Index Scan using persons_pkey on persons person21_ (cost=0.28..159.96 rows=3,677 width=173) (actual time=0.005..0.014 rows=15 loops=1)

36. 0.367 4.683 ↑ 1.0 229 1

Sort (cost=1,879.88..1,880.46 rows=229 width=1,701) (actual time=4.658..4.683 rows=229 loops=1)

  • Sort Key: shuttlewor14_1_.mechanic_out
  • Sort Method: quicksort Memory: 174kB
37. 0.375 4.316 ↑ 1.0 229 1

Nested Loop Left Join (cost=78.85..1,870.91 rows=229 width=1,701) (actual time=2.409..4.316 rows=229 loops=1)

38. 0.347 3.941 ↑ 1.0 229 1

Hash Left Join (cost=78.43..101.73 rows=229 width=1,534) (actual time=2.401..3.941 rows=229 loops=1)

  • Hash Cond: ((checkpoint7_.platform_id)::integer = platform12_.platform_id)
39. 0.238 3.489 ↑ 1.0 229 1

Hash Left Join (cost=72.71..95.39 rows=229 width=1,302) (actual time=2.290..3.489 rows=229 loops=1)

  • Hash Cond: ((checkpoint7_.transport_infrastructure_object_id)::integer = infrastruc10_.transport_infrastructure_object_id)
40. 0.348 3.198 ↑ 1.0 229 1

Hash Right Join (cost=68.88..90.97 rows=229 width=1,198) (actual time=2.230..3.198 rows=229 loops=1)

  • Hash Cond: ((shuttletri13_.work_task_id)::integer = (shuttleord0_.shuttle_trip_id)::integer)
41. 0.205 1.109 ↑ 1.0 190 1

Hash Left Join (cost=20.45..40.04 rows=190 width=503) (actual time=0.483..1.109 rows=190 loops=1)

  • Hash Cond: ((shuttlewor14_.order_id)::integer = shuttlewor14_1_.order_id)
42. 0.103 0.645 ↑ 1.0 190 1

Hash Left Join (cost=10.66..29.73 rows=190 width=188) (actual time=0.216..0.645 rows=190 loops=1)

  • Hash Cond: ((shuttletri13_.shuttle_work_order_id)::integer = (shuttlewor14_.order_id)::integer)
43. 0.252 0.502 ↑ 1.0 190 1

Hash Right Join (cost=7.28..25.83 rows=190 width=184) (actual time=0.166..0.502 rows=190 loops=1)

  • Hash Cond: (shuttletri13_1_.work_task_id = (shuttletri13_.work_task_id)::integer)
44. 0.111 0.111 ↑ 1.0 835 1

Seq Scan on work_tasks shuttletri13_1_ (cost=0.00..16.35 rows=835 width=127) (actual time=0.008..0.111 rows=835 loops=1)

45. 0.062 0.139 ↑ 1.0 190 1

Hash (cost=4.90..4.90 rows=190 width=61) (actual time=0.139..0.139 rows=190 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 24kB
46. 0.077 0.077 ↑ 1.0 190 1

Seq Scan on shuttle_trips shuttletri13_ (cost=0.00..4.90 rows=190 width=61) (actual time=0.010..0.077 rows=190 loops=1)

47. 0.025 0.040 ↑ 1.0 106 1

Hash (cost=2.06..2.06 rows=106 width=4) (actual time=0.040..0.040 rows=106 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
48. 0.015 0.015 ↑ 1.0 106 1

Seq Scan on shuttle_work_orders shuttlewor14_ (cost=0.00..2.06 rows=106 width=4) (actual time=0.005..0.015 rows=106 loops=1)

49. 0.109 0.259 ↑ 1.0 213 1

Hash (cost=7.13..7.13 rows=213 width=319) (actual time=0.259..0.259 rows=213 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 45kB
50. 0.150 0.150 ↑ 1.0 213 1

Seq Scan on common_orders shuttlewor14_1_ (cost=0.00..7.13 rows=213 width=319) (actual time=0.008..0.150 rows=213 loops=1)

51. 0.166 1.741 ↑ 1.0 229 1

Hash (cost=45.57..45.57 rows=229 width=695) (actual time=1.741..1.741 rows=229 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 46kB
52. 0.148 1.575 ↑ 1.0 229 1

Hash Left Join (cost=37.04..45.57 rows=229 width=695) (actual time=0.635..1.575 rows=229 loops=1)

  • Hash Cond: ((checkpoint7_.zone_id)::integer = zone9_.zone_id)
53. 0.130 1.280 ↑ 1.0 229 1

Hash Left Join (cost=28.29..36.22 rows=229 width=558) (actual time=0.484..1.280 rows=229 loops=1)

  • Hash Cond: ((checkpoint7_.rush_poi_id)::integer = rushpoi8_.rush_poi_id)
54. 0.159 1.117 ↑ 1.0 229 1

Hash Left Join (cost=25.12..32.44 rows=229 width=458) (actual time=0.447..1.117 rows=229 loops=1)

  • Hash Cond: ((shuttleord0_.from_check_point_id)::integer = checkpoint7_.check_point_id)
55. 0.104 0.889 ↑ 1.0 229 1

Hash Left Join (cost=20.61..27.32 rows=229 width=434) (actual time=0.375..0.889 rows=229 loops=1)

  • Hash Cond: ((shuttleord0_.sport_type_id)::integer = sporttype6_.sport_type_id)
56. 0.106 0.775 ↑ 1.0 229 1

Hash Left Join (cost=19.36..25.47 rows=229 width=366) (actual time=0.361..0.775 rows=229 loops=1)

  • Hash Cond: ((shuttleord0_.transport_classification_capacity_id)::integer = transportc5_.transport_classification_capacity_id)
57. 0.103 0.648 ↑ 1.0 229 1

Hash Left Join (cost=17.80..23.30 rows=229 width=250) (actual time=0.336..0.648 rows=229 loops=1)

  • Hash Cond: ((shuttleord0_.country_id)::integer = country3_.country_id)
58. 0.190 0.420 ↑ 1.0 229 1

Hash Right Join (cost=9.15..14.05 rows=229 width=216) (actual time=0.205..0.420 rows=229 loops=1)

  • Hash Cond: ((shuttlesch4_.shuttle_order_id)::integer = shuttleord0_.shuttle_order_id)
59. 0.035 0.035 ↑ 1.0 229 1

Seq Scan on shuttle_schedules shuttlesch4_ (cost=0.00..4.29 rows=229 width=24) (actual time=0.005..0.035 rows=229 loops=1)

60. 0.088 0.195 ↑ 1.0 229 1

Hash (cost=6.29..6.29 rows=229 width=192) (actual time=0.195..0.195 rows=229 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 35kB
61. 0.107 0.107 ↑ 1.0 229 1

Seq Scan on shuttle_orders shuttleord0_ (cost=0.00..6.29 rows=229 width=192) (actual time=0.008..0.107 rows=229 loops=1)

62. 0.060 0.125 ↑ 1.0 251 1

Hash (cost=5.51..5.51 rows=251 width=34) (actual time=0.125..0.125 rows=251 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 25kB
63. 0.065 0.065 ↑ 1.0 251 1

Seq Scan on countries country3_ (cost=0.00..5.51 rows=251 width=34) (actual time=0.008..0.065 rows=251 loops=1)

64. 0.009 0.021 ↑ 1.0 25 1

Hash (cost=1.25..1.25 rows=25 width=116) (actual time=0.021..0.021 rows=25 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
65. 0.012 0.012 ↑ 1.0 25 1

Seq Scan on transport_classification_capacities transportc5_ (cost=0.00..1.25 rows=25 width=116) (actual time=0.005..0.012 rows=25 loops=1)

66. 0.003 0.010 ↑ 1.0 11 1

Hash (cost=1.11..1.11 rows=11 width=68) (actual time=0.010..0.010 rows=11 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
67. 0.007 0.007 ↑ 1.0 11 1

Seq Scan on sport_types sporttype6_ (cost=0.00..1.11 rows=11 width=68) (actual time=0.004..0.007 rows=11 loops=1)

68. 0.032 0.069 ↑ 1.0 156 1

Hash (cost=2.56..2.56 rows=156 width=24) (actual time=0.069..0.069 rows=156 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 15kB
69. 0.037 0.037 ↑ 1.0 156 1

Seq Scan on check_points checkpoint7_ (cost=0.00..2.56 rows=156 width=24) (actual time=0.006..0.037 rows=156 loops=1)

70. 0.015 0.033 ↑ 1.0 52 1

Hash (cost=2.52..2.52 rows=52 width=100) (actual time=0.032..0.033 rows=52 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 17kB
71. 0.018 0.018 ↑ 1.0 52 1

Seq Scan on rush_poi rushpoi8_ (cost=0.00..2.52 rows=52 width=100) (actual time=0.006..0.018 rows=52 loops=1)

72. 0.072 0.147 ↑ 1.0 211 1

Hash (cost=6.11..6.11 rows=211 width=137) (actual time=0.147..0.147 rows=211 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 40kB
73. 0.075 0.075 ↑ 1.0 211 1

Seq Scan on zones zone9_ (cost=0.00..6.11 rows=211 width=137) (actual time=0.006..0.075 rows=211 loops=1)

74. 0.025 0.053 ↑ 1.0 81 1

Hash (cost=2.81..2.81 rows=81 width=104) (actual time=0.053..0.053 rows=81 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 17kB
75. 0.028 0.028 ↑ 1.0 81 1

Seq Scan on transport_infrastructure_objects infrastruc10_ (cost=0.00..2.81 rows=81 width=104) (actual time=0.007..0.028 rows=81 loops=1)

76. 0.044 0.105 ↑ 1.0 121 1

Hash (cost=4.21..4.21 rows=121 width=232) (actual time=0.105..0.105 rows=121 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 25kB
77. 0.061 0.061 ↑ 1.0 121 1

Seq Scan on platforms platform12_ (cost=0.00..4.21 rows=121 width=232) (actual time=0.007..0.061 rows=121 loops=1)

78. 0.000 0.000 ↓ 0.0 0 229

Index Scan using poi_pkey on poi poi11_ (cost=0.42..7.69 rows=1 width=167) (actual time=0.000..0.000 rows=0 loops=229)

  • Index Cond: ((checkpoint7_.poi_id)::integer = poi_id)
79. 1.085 2.238 ↑ 1.0 3,677 1

Hash (cost=68.77..68.77 rows=3,677 width=173) (actual time=2.238..2.238 rows=3,677 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 282kB
80. 1.153 1.153 ↑ 1.0 3,677 1

Seq Scan on persons person15_ (cost=0.00..68.77 rows=3,677 width=173) (actual time=0.008..1.153 rows=3,677 loops=1)

81. 0.005 0.058 ↑ 1.0 9 1

Hash (cost=3.53..3.53 rows=9 width=1,044) (actual time=0.058..0.058 rows=9 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
82. 0.024 0.053 ↑ 1.0 9 1

Hash Right Join (cost=1.20..3.53 rows=9 width=1,044) (actual time=0.031..0.053 rows=9 loops=1)

  • Hash Cond: (regiondict17_.region_id = (organizati16_.region_id)::integer)
83. 0.013 0.013 ↑ 1.0 90 1

Seq Scan on regions regiondict17_ (cost=0.00..1.90 rows=90 width=48) (actual time=0.006..0.013 rows=90 loops=1)

84. 0.005 0.016 ↑ 1.0 9 1

Hash (cost=1.09..1.09 rows=9 width=996) (actual time=0.016..0.016 rows=9 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
85. 0.011 0.011 ↑ 1.0 9 1

Seq Scan on organizations organizati16_ (cost=0.00..1.09 rows=9 width=996) (actual time=0.007..0.011 rows=9 loops=1)

86. 0.002 0.006 ↑ 1.0 3 1

Hash (cost=1.03..1.03 rows=3 width=40) (actual time=0.006..0.006 rows=3 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
87. 0.004 0.004 ↑ 1.0 3 1

Seq Scan on operation_modes operationm18_ (cost=0.00..1.03 rows=3 width=40) (actual time=0.004..0.004 rows=3 loops=1)

88. 0.005 0.011 ↑ 1.0 9 1

Hash (cost=1.09..1.09 rows=9 width=996) (actual time=0.011..0.011 rows=9 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
89. 0.006 0.006 ↑ 1.0 9 1

Seq Scan on organizations organizati19_ (cost=0.00..1.09 rows=9 width=996) (actual time=0.003..0.006 rows=9 loops=1)

90. 0.017 0.031 ↑ 1.0 90 1

Hash (cost=1.90..1.90 rows=90 width=48) (actual time=0.030..0.031 rows=90 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 16kB
91. 0.014 0.014 ↑ 1.0 90 1

Seq Scan on regions regiondict20_ (cost=0.00..1.90 rows=90 width=48) (actual time=0.006..0.014 rows=90 loops=1)

92. 1.113 2.269 ↑ 1.0 3,677 1

Hash (cost=68.77..68.77 rows=3,677 width=173) (actual time=2.269..2.269 rows=3,677 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 282kB
93. 1.156 1.156 ↑ 1.0 3,677 1

Seq Scan on persons person25_ (cost=0.00..68.77 rows=3,677 width=173) (actual time=0.023..1.156 rows=3,677 loops=1)

94. 0.007 0.068 ↑ 1.0 9 1

Hash (cost=3.53..3.53 rows=9 width=1,044) (actual time=0.068..0.068 rows=9 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
95. 0.029 0.061 ↑ 1.0 9 1

Hash Right Join (cost=1.20..3.53 rows=9 width=1,044) (actual time=0.042..0.061 rows=9 loops=1)

  • Hash Cond: (regiondict27_.region_id = (organizati26_.region_id)::integer)
96. 0.013 0.013 ↑ 1.0 90 1

Seq Scan on regions regiondict27_ (cost=0.00..1.90 rows=90 width=48) (actual time=0.006..0.013 rows=90 loops=1)

97. 0.007 0.019 ↑ 1.0 9 1

Hash (cost=1.09..1.09 rows=9 width=996) (actual time=0.019..0.019 rows=9 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
98. 0.012 0.012 ↑ 1.0 9 1

Seq Scan on organizations organizati26_ (cost=0.00..1.09 rows=9 width=996) (actual time=0.008..0.012 rows=9 loops=1)

99. 0.007 0.056 ↑ 1.0 9 1

Hash (cost=3.53..3.53 rows=9 width=1,044) (actual time=0.056..0.056 rows=9 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
100. 0.026 0.049 ↑ 1.0 9 1

Hash Right Join (cost=1.20..3.53 rows=9 width=1,044) (actual time=0.029..0.049 rows=9 loops=1)

  • Hash Cond: (regiondict23_.region_id = (organizati22_.region_id)::integer)
101. 0.011 0.011 ↑ 1.0 90 1

Seq Scan on regions regiondict23_ (cost=0.00..1.90 rows=90 width=48) (actual time=0.004..0.011 rows=90 loops=1)

102. 0.005 0.012 ↑ 1.0 9 1

Hash (cost=1.09..1.09 rows=9 width=996) (actual time=0.012..0.012 rows=9 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
103. 0.007 0.007 ↑ 1.0 9 1

Seq Scan on organizations organizati22_ (cost=0.00..1.09 rows=9 width=996) (actual time=0.003..0.007 rows=9 loops=1)

104. 0.067 0.143 ↑ 1.0 226 1

Hash (cost=4.26..4.26 rows=226 width=130) (actual time=0.143..0.143 rows=226 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 24kB
105. 0.076 0.076 ↑ 1.0 226 1

Seq Scan on transports transport24_ (cost=0.00..4.26 rows=226 width=130) (actual time=0.011..0.076 rows=226 loops=1)

106. 1.174 2.296 ↑ 1.0 3,677 1

Hash (cost=68.77..68.77 rows=3,677 width=173) (actual time=2.296..2.296 rows=3,677 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 282kB
107. 1.122 1.122 ↑ 1.0 3,677 1

Seq Scan on persons person31_ (cost=0.00..68.77 rows=3,677 width=173) (actual time=0.007..1.122 rows=3,677 loops=1)

108. 0.006 0.063 ↑ 1.0 9 1

Hash (cost=3.53..3.53 rows=9 width=1,044) (actual time=0.063..0.063 rows=9 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
109. 0.027 0.057 ↑ 1.0 9 1

Hash Right Join (cost=1.20..3.53 rows=9 width=1,044) (actual time=0.037..0.057 rows=9 loops=1)

  • Hash Cond: (regiondict33_.region_id = (organizati32_.region_id)::integer)
110. 0.013 0.013 ↑ 1.0 90 1

Seq Scan on regions regiondict33_ (cost=0.00..1.90 rows=90 width=48) (actual time=0.006..0.013 rows=90 loops=1)

111. 0.005 0.017 ↑ 1.0 9 1

Hash (cost=1.09..1.09 rows=9 width=996) (actual time=0.017..0.017 rows=9 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
112. 0.012 0.012 ↑ 1.0 9 1

Seq Scan on organizations organizati32_ (cost=0.00..1.09 rows=9 width=996) (actual time=0.008..0.012 rows=9 loops=1)

113. 0.005 0.050 ↑ 1.0 9 1

Hash (cost=3.53..3.53 rows=9 width=1,044) (actual time=0.050..0.050 rows=9 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
114. 0.022 0.045 ↑ 1.0 9 1

Hash Right Join (cost=1.20..3.53 rows=9 width=1,044) (actual time=0.024..0.045 rows=9 loops=1)

  • Hash Cond: (regiondict30_.region_id = (organizati29_.region_id)::integer)
115. 0.011 0.011 ↑ 1.0 90 1

Seq Scan on regions regiondict30_ (cost=0.00..1.90 rows=90 width=48) (actual time=0.004..0.011 rows=90 loops=1)

116. 0.006 0.012 ↑ 1.0 9 1

Hash (cost=1.09..1.09 rows=9 width=996) (actual time=0.012..0.012 rows=9 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
117. 0.006 0.006 ↑ 1.0 9 1

Seq Scan on organizations organizati29_ (cost=0.00..1.09 rows=9 width=996) (actual time=0.003..0.006 rows=9 loops=1)

118. 1.074 2.224 ↑ 1.0 3,677 1

Hash (cost=68.77..68.77 rows=3,677 width=173) (actual time=2.224..2.224 rows=3,677 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 282kB
119. 1.150 1.150 ↑ 1.0 3,677 1

Seq Scan on persons person34_ (cost=0.00..68.77 rows=3,677 width=173) (actual time=0.007..1.150 rows=3,677 loops=1)

120. 0.008 0.024 ↑ 1.0 9 1

Hash (cost=1.09..1.09 rows=9 width=996) (actual time=0.024..0.024 rows=9 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
121. 0.016 0.016 ↑ 1.0 9 1

Seq Scan on organizations organizati35_ (cost=0.00..1.09 rows=9 width=996) (actual time=0.012..0.016 rows=9 loops=1)

122. 0.019 0.033 ↑ 1.0 90 1

Hash (cost=1.90..1.90 rows=90 width=48) (actual time=0.033..0.033 rows=90 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 16kB
123. 0.014 0.014 ↑ 1.0 90 1

Seq Scan on regions regiondict36_ (cost=0.00..1.90 rows=90 width=48) (actual time=0.006..0.014 rows=90 loops=1)

124. 0.076 0.138 ↑ 1.0 193 1

Hash (cost=6.93..6.93 rows=193 width=857) (actual time=0.138..0.138 rows=193 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 43kB
125. 0.062 0.062 ↑ 1.0 193 1

Seq Scan on route_tracks routetrack38_ (cost=0.00..6.93 rows=193 width=857) (actual time=0.006..0.062 rows=193 loops=1)

126. 0.035 0.073 ↑ 1.0 156 1

Hash (cost=2.56..2.56 rows=156 width=24) (actual time=0.073..0.073 rows=156 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 15kB
127. 0.038 0.038 ↑ 1.0 156 1

Seq Scan on check_points checkpoint39_ (cost=0.00..2.56 rows=156 width=24) (actual time=0.007..0.038 rows=156 loops=1)

128. 0.020 0.037 ↑ 1.0 52 1

Hash (cost=2.52..2.52 rows=52 width=100) (actual time=0.037..0.037 rows=52 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 17kB
129. 0.017 0.017 ↑ 1.0 52 1

Seq Scan on rush_poi rushpoi40_ (cost=0.00..2.52 rows=52 width=100) (actual time=0.005..0.017 rows=52 loops=1)

130. 0.081 0.152 ↑ 1.0 211 1

Hash (cost=6.11..6.11 rows=211 width=137) (actual time=0.152..0.152 rows=211 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 40kB
131. 0.071 0.071 ↑ 1.0 211 1

Seq Scan on zones zone41_ (cost=0.00..6.11 rows=211 width=137) (actual time=0.006..0.071 rows=211 loops=1)

132. 0.026 0.053 ↑ 1.0 81 1

Hash (cost=2.81..2.81 rows=81 width=104) (actual time=0.053..0.053 rows=81 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 17kB
133. 0.027 0.027 ↑ 1.0 81 1

Seq Scan on transport_infrastructure_objects infrastruc42_ (cost=0.00..2.81 rows=81 width=104) (actual time=0.006..0.027 rows=81 loops=1)

134. 1.169 2.300 ↑ 1.0 3,677 1

Hash (cost=68.77..68.77 rows=3,677 width=173) (actual time=2.300..2.300 rows=3,677 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 282kB
135. 1.131 1.131 ↑ 1.0 3,677 1

Seq Scan on persons person45_ (cost=0.00..68.77 rows=3,677 width=173) (actual time=0.007..1.131 rows=3,677 loops=1)

136. 0.011 0.079 ↑ 1.0 9 1

Hash (cost=3.53..3.53 rows=9 width=1,044) (actual time=0.079..0.079 rows=9 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
137. 0.039 0.068 ↑ 1.0 9 1

Hash Right Join (cost=1.20..3.53 rows=9 width=1,044) (actual time=0.048..0.068 rows=9 loops=1)

  • Hash Cond: (regiondict47_.region_id = (organizati46_.region_id)::integer)
138. 0.013 0.013 ↑ 1.0 90 1

Seq Scan on regions regiondict47_ (cost=0.00..1.90 rows=90 width=48) (actual time=0.006..0.013 rows=90 loops=1)

139. 0.007 0.016 ↑ 1.0 9 1

Hash (cost=1.09..1.09 rows=9 width=996) (actual time=0.016..0.016 rows=9 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
140. 0.009 0.009 ↑ 1.0 9 1

Seq Scan on organizations organizati46_ (cost=0.00..1.09 rows=9 width=996) (actual time=0.006..0.009 rows=9 loops=1)

141. 0.000 0.000 ↓ 0.0 0 234

Index Scan using poi_pkey on poi poi43_ (cost=0.42..7.69 rows=1 width=167) (actual time=0.000..0.000 rows=0 loops=234)

  • Index Cond: ((checkpoint39_.poi_id)::integer = poi_id)
142. 0.055 0.119 ↑ 1.0 121 1

Hash (cost=4.21..4.21 rows=121 width=232) (actual time=0.119..0.119 rows=121 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 25kB
143. 0.064 0.064 ↑ 1.0 121 1

Seq Scan on platforms platform44_ (cost=0.00..4.21 rows=121 width=232) (actual time=0.007..0.064 rows=121 loops=1)

144. 0.041 0.115 ↑ 1.0 229 1

Hash (cost=5.44..5.44 rows=229 width=4) (actual time=0.115..0.115 rows=229 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 17kB
145. 0.074 0.074 ↑ 1.0 229 1

Seq Scan on shuttle_schedules shuttlesch1_ (cost=0.00..5.44 rows=229 width=4) (actual time=0.021..0.074 rows=229 loops=1)

  • Filter: ((start_time >= '2018-02-10 17:00:00+00'::timestamp with time zone) AND (start_time < '2019-02-11 16:59:59+00'::timestamp with time zone))
146.          

SubPlan (forHash Join)

147. 0.468 6.552 ↓ 0.0 0 234

Limit (cost=7.67..12.54 rows=1 width=9) (actual time=0.028..0.028 rows=0 loops=234)

148. 0.824 6.084 ↓ 0.0 0 234

Hash Join (cost=7.67..12.54 rows=1 width=9) (actual time=0.026..0.026 rows=0 loops=234)

  • Hash Cond: (t.transport_id = (wo.transport_id)::integer)
149. 0.112 0.112 ↑ 1.6 137 7

Seq Scan on transports t (cost=0.00..4.26 rows=226 width=13) (actual time=0.003..0.016 rows=137 loops=7)

150. 0.234 5.148 ↓ 0.0 0 234

Hash (cost=7.66..7.66 rows=1 width=4) (actual time=0.022..0.022 rows=0 loops=234)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
151. 4.914 4.914 ↓ 0.0 0 234

Seq Scan on common_orders wo (cost=0.00..7.66 rows=1 width=4) (actual time=0.021..0.021 rows=0 loops=234)

  • Filter: (order_id = (dependentt37_.shuttle_work_order_id)::integer)
  • Rows Removed by Filter: 213
152. 0.234 6.318 ↓ 0.0 0 234

Limit (cost=7.95..13.01 rows=1 width=4) (actual time=0.027..0.027 rows=0 loops=234)

153. 0.213 6.084 ↓ 0.0 0 234

Nested Loop (cost=7.95..13.01 rows=1 width=4) (actual time=0.026..0.026 rows=0 loops=234)

154. 0.789 5.850 ↓ 0.0 0 234

Hash Join (cost=7.67..12.54 rows=1 width=4) (actual time=0.024..0.025 rows=0 loops=234)

  • Hash Cond: (t_1.transport_id = (wo_1.transport_id)::integer)
155. 0.147 0.147 ↑ 1.1 201 7

Seq Scan on transports t_1 (cost=0.00..4.26 rows=226 width=8) (actual time=0.002..0.021 rows=201 loops=7)

156. 0.234 4.914 ↓ 0.0 0 234

Hash (cost=7.66..7.66 rows=1 width=4) (actual time=0.021..0.021 rows=0 loops=234)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
157. 4.680 4.680 ↓ 0.0 0 234

Seq Scan on common_orders wo_1 (cost=0.00..7.66 rows=1 width=4) (actual time=0.020..0.020 rows=0 loops=234)

  • Filter: (order_id = (dependentt37_.shuttle_work_order_id)::integer)
  • Rows Removed by Filter: 213
158. 0.021 0.021 ↑ 1.0 1 7

Index Scan using transport_model_key on transport_models tm (cost=0.28..0.47 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=7)

  • Index Cond: (transport_model_id = (t_1.transport_model_id)::integer)