explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nSN2

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 78,062.671 ↓ 0.0 0 1

Limit (cost=5,530,957,498,269.76..5,530,957,498,327.01 rows=100 width=877) (actual time=78,062.671..78,062.671 rows=0 loops=1)

2. 0.000 78,062.667 ↓ 0.0 0 1

Result (cost=5,530,957,498,269.76..41,546,195,872,552.25 rows=62,908,713,317,524 width=877) (actual time=78,062.667..78,062.667 rows=0 loops=1)

3. 0.015 78,062.667 ↓ 0.0 0 1

Sort (cost=5,530,957,498,269.76..5,688,229,281,563.57 rows=62,908,713,317,524 width=841) (actual time=78,062.667..78,062.667 rows=0 loops=1)

  • Sort Key: r.reservation_end_time DESC, r.id
  • Sort Method: quicksort Memory: 25kB
4. 0.003 78,062.652 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.41..3,126,631,709,855.16 rows=62,908,713,317,524 width=841) (actual time=78,062.651..78,062.652 rows=0 loops=1)

5. 0.000 78,062.649 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.41..2,322,749,140.37 rows=17,234,295,969 width=834) (actual time=78,062.649..78,062.649 rows=0 loops=1)

6. 0.002 78,062.649 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.41..1,019,627,997.06 rows=929,072,559 width=838) (actual time=78,062.649..78,062.649 rows=0 loops=1)

7. 0.001 78,062.647 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.41..724,147,059.50 rows=275,280,758 width=756) (actual time=78,062.647..78,062.647 rows=0 loops=1)

8. 0.000 78,062.646 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.41..431,771,450.60 rows=107,321,933 width=591) (actual time=78,062.646..78,062.646 rows=0 loops=1)

9. 0.272 78,062.647 ↓ 0.0 0 1

Nested Loop (cost=1.13..8,895,978.63 rows=107,321,933 width=583) (actual time=78,062.646..78,062.647 rows=0 loops=1)

10. 1.485 78,062.222 ↑ 701,450.5 153 1

Nested Loop (cost=0.00..7,554,429.25 rows=107,321,933 width=499) (actual time=2,337.682..78,062.222 rows=153 loops=1)

11. 1.263 78,049.721 ↑ 13,840.5 153 1

Nested Loop (cost=0.00..3,397,148.39 rows=2,117,603 width=482) (actual time=2,337.625..78,049.721 rows=153 loops=1)

12. 1.386 78,038.513 ↑ 481.1 153 1

Nested Loop Left Join (cost=0.00..2,677,626.00 rows=73,604 width=464) (actual time=2,337.566..78,038.513 rows=153 loops=1)

13. 1.557 78,034.067 ↑ 56.5 153 1

Nested Loop Left Join (cost=0.00..2,625,580.38 rows=8,639 width=443) (actual time=2,337.532..78,034.067 rows=153 loops=1)

14. 1.758 78,027.155 ↑ 6.6 153 1

Nested Loop (cost=0.00..2,619,471.54 rows=1,014 width=447) (actual time=2,337.497..78,027.155 rows=153 loops=1)

15. 36,710.009 78,014.993 ↓ 1.3 153 1

Nested Loop Left Join (cost=0.00..2,618,754.62 rows=119 width=418) (actual time=2,337.433..78,014.993 rows=153 loops=1)

  • Join Filter: (r.trip_id = ubn.trip_id)
  • Rows Removed by Join Filter: 167,554,181
16. 276.798 355.452 ↓ 1.3 153 1

Nested Loop (cost=0.00..7,933.64 rows=119 width=410) (actual time=176.898..355.452 rows=153 loops=1)

  • Join Filter: (r.company_id = c.id)
  • Rows Removed by Join Filter: 613,836
17. 2.407 2.407 ↑ 1.0 4,013 1

Seq Scan on company c (cost=0.00..282.24 rows=4,024 width=22) (actual time=0.017..2.407 rows=4,013 loops=1)

18. 74.780 76.247 ↓ 1.3 153 4,013

Materialize (cost=0.00..468.86 rows=119 width=396) (actual time=0.000..0.019 rows=153 loops=4,013)

19. 0.021 1.467 ↓ 1.3 153 1

Append (cost=0.00..468.26 rows=119 width=396) (actual time=0.082..1.467 rows=153 loops=1)

20. 0.005 0.005 ↓ 0.0 0 1

Seq Scan on reservation r (cost=0.00..0.00 rows=1 width=1,060) (actual time=0.005..0.005 rows=0 loops=1)

  • Filter: (user_id = 1,604)
21. 0.025 0.025 ↓ 0.0 0 1

Index Scan using be_reservation_user_id_idx on reservation r_1 (cost=0.29..43.17 rows=12 width=374) (actual time=0.025..0.025 rows=0 loops=1)

  • Index Cond: (user_id = 1,604)
22. 0.012 0.012 ↓ 0.0 0 1

Index Scan using de_reservation_user_id_idx on reservation r_2 (cost=0.42..109.27 rows=27 width=427) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: (user_id = 1,604)
23. 1.364 1.364 ↓ 2.8 153 1

Index Scan using fr_reservation_user_id_idx on reservation r_3 (cost=0.42..209.71 rows=54 width=387) (actual time=0.040..1.364 rows=153 loops=1)

  • Index Cond: (user_id = 1,604)
24. 0.018 0.018 ↓ 0.0 0 1

Index Scan using it_reservation_user_id_idx on reservation r_4 (cost=0.42..60.24 rows=14 width=399) (actual time=0.018..0.018 rows=0 loops=1)

  • Index Cond: (user_id = 1,604)
25. 0.002 0.012 ↓ 0.0 0 1

Bitmap Heap Scan on reservation r_5 (cost=4.33..24.71 rows=6 width=283) (actual time=0.012..0.012 rows=0 loops=1)

  • Recheck Cond: (user_id = 1,604)
26. 0.010 0.010 ↓ 0.0 0 1

Bitmap Index Scan on lu_reservation_user_id_idx (cost=0.00..4.33 rows=6 width=0) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: (user_id = 1,604)
27. 0.010 0.010 ↓ 0.0 0 1

Index Scan using uk_reservation_user_id_idx on reservation r_6 (cost=0.29..21.15 rows=5 width=382) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: (user_id = 1,604)
28. 40,191.332 40,949.532 ↑ 1.0 1,095,126 153

Materialize (cost=0.00..27,694.89 rows=1,095,126 width=12) (actual time=0.009..267.644 rows=1,095,126 loops=153)

29. 758.200 758.200 ↑ 1.0 1,095,126 1

Seq Scan on mv_user_booking_number ubn (cost=0.00..16,871.26 rows=1,095,126 width=12) (actual time=0.028..758.200 rows=1,095,126 loops=1)

30. 3.672 10.404 ↑ 7.0 1 153

Append (cost=0.00..5.95 rows=7 width=33) (actual time=0.055..0.068 rows=1 loops=153)

31. 0.153 0.153 ↓ 0.0 0 153

Seq Scan on parking p (cost=0.00..0.00 rows=1 width=126) (actual time=0.001..0.001 rows=0 loops=153)

  • Filter: (r.departure_parking_id = id)
32. 2.295 2.295 ↓ 0.0 0 153

Index Scan using parking_be_pkey on parking p_1 (cost=0.14..0.53 rows=1 width=32) (actual time=0.015..0.015 rows=0 loops=153)

  • Index Cond: (id = r.departure_parking_id)
33. 1.224 1.224 ↓ 0.0 0 153

Index Scan using parking_de_pkey on parking p_2 (cost=0.27..1.77 rows=1 width=35) (actual time=0.008..0.008 rows=0 loops=153)

  • Index Cond: (id = r.departure_parking_id)
34. 2.142 2.142 ↑ 1.0 1 153

Index Scan using parking_fr_pkey on parking p_3 (cost=0.28..2.28 rows=1 width=32) (actual time=0.014..0.014 rows=1 loops=153)

  • Index Cond: (id = r.departure_parking_id)
35. 0.153 0.153 ↓ 0.0 0 153

Index Scan using parking_it_pkey on parking p_4 (cost=0.14..0.43 rows=1 width=27) (actual time=0.001..0.001 rows=0 loops=153)

  • Index Cond: (id = r.departure_parking_id)
36. 0.153 0.153 ↓ 0.0 0 153

Index Scan using parking_lu_pkey on parking p_5 (cost=0.13..0.25 rows=1 width=126) (actual time=0.001..0.001 rows=0 loops=153)

  • Index Cond: (id = r.departure_parking_id)
37. 0.612 0.612 ↓ 0.0 0 153

Index Scan using parking_uk_pkey on parking p_6 (cost=0.14..0.70 rows=1 width=37) (actual time=0.004..0.004 rows=0 loops=153)

  • Index Cond: (id = r.departure_parking_id)
38. 2.448 5.355 ↑ 7.0 1 153

Append (cost=0.00..5.95 rows=7 width=4) (actual time=0.017..0.035 rows=1 loops=153)

39. 0.000 0.000 ↓ 0.0 0 153

Seq Scan on parking a_p (cost=0.00..0.00 rows=1 width=4) (actual time=0.000..0.000 rows=0 loops=153)

  • Filter: (r.arrival_parking_id = id)
40. 0.306 0.306 ↓ 0.0 0 153

Index Only Scan using parking_be_pkey on parking a_p_1 (cost=0.14..0.53 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=153)

  • Index Cond: (id = r.arrival_parking_id)
  • Heap Fetches: 0
41. 0.306 0.306 ↓ 0.0 0 153

Index Only Scan using parking_de_pkey on parking a_p_2 (cost=0.27..1.77 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=153)

  • Index Cond: (id = r.arrival_parking_id)
  • Heap Fetches: 3
42. 0.612 0.612 ↑ 1.0 1 153

Index Only Scan using parking_fr_pkey on parking a_p_3 (cost=0.28..2.28 rows=1 width=4) (actual time=0.004..0.004 rows=1 loops=153)

  • Index Cond: (id = r.arrival_parking_id)
  • Heap Fetches: 150
43. 0.765 0.765 ↓ 0.0 0 153

Index Only Scan using parking_it_pkey on parking a_p_4 (cost=0.14..0.43 rows=1 width=4) (actual time=0.005..0.005 rows=0 loops=153)

  • Index Cond: (id = r.arrival_parking_id)
  • Heap Fetches: 0
44. 0.459 0.459 ↓ 0.0 0 153

Index Only Scan using parking_lu_pkey on parking a_p_5 (cost=0.13..0.25 rows=1 width=4) (actual time=0.003..0.003 rows=0 loops=153)

  • Index Cond: (id = r.arrival_parking_id)
  • Heap Fetches: 0
45. 0.459 0.459 ↓ 0.0 0 153

Index Only Scan using parking_uk_pkey on parking a_p_6 (cost=0.14..0.70 rows=1 width=4) (actual time=0.003..0.003 rows=0 loops=153)

  • Index Cond: (id = r.arrival_parking_id)
  • Heap Fetches: 0
46. 2.142 3.060 ↓ 0.0 0 153

Append (cost=0.00..5.95 rows=7 width=29) (actual time=0.020..0.020 rows=0 loops=153)

47. 0.000 0.000 ↓ 0.0 0 153

Seq Scan on parking w_p (cost=0.00..0.00 rows=1 width=122) (actual time=0.000..0.000 rows=0 loops=153)

  • Filter: (r.waypoint = id)
48. 0.153 0.153 ↓ 0.0 0 153

Index Scan using parking_be_pkey on parking w_p_1 (cost=0.14..0.53 rows=1 width=28) (actual time=0.001..0.001 rows=0 loops=153)

  • Index Cond: (r.waypoint = id)
49. 0.153 0.153 ↓ 0.0 0 153

Index Scan using parking_de_pkey on parking w_p_2 (cost=0.27..1.77 rows=1 width=31) (actual time=0.001..0.001 rows=0 loops=153)

  • Index Cond: (r.waypoint = id)
50. 0.153 0.153 ↓ 0.0 0 153

Index Scan using parking_fr_pkey on parking w_p_3 (cost=0.28..2.28 rows=1 width=28) (actual time=0.001..0.001 rows=0 loops=153)

  • Index Cond: (r.waypoint = id)
51. 0.153 0.153 ↓ 0.0 0 153

Index Scan using parking_it_pkey on parking w_p_4 (cost=0.14..0.43 rows=1 width=23) (actual time=0.001..0.001 rows=0 loops=153)

  • Index Cond: (r.waypoint = id)
52. 0.153 0.153 ↓ 0.0 0 153

Index Scan using parking_lu_pkey on parking w_p_5 (cost=0.13..0.25 rows=1 width=122) (actual time=0.001..0.001 rows=0 loops=153)

  • Index Cond: (r.waypoint = id)
53. 0.153 0.153 ↓ 0.0 0 153

Index Scan using parking_uk_pkey on parking w_p_6 (cost=0.14..0.70 rows=1 width=33) (actual time=0.001..0.001 rows=0 loops=153)

  • Index Cond: (r.waypoint = id)
54. 3.213 9.945 ↑ 7.0 1 153

Append (cost=0.00..9.71 rows=7 width=22) (actual time=0.043..0.065 rows=1 loops=153)

55. 0.000 0.000 ↓ 0.0 0 153

Seq Scan on vehicle v (cost=0.00..0.00 rows=1 width=130) (actual time=0.000..0.000 rows=0 loops=153)

  • Filter: (r.vehicle_id = id)
56. 1.071 1.071 ↓ 0.0 0 153

Index Scan using vehicle_be_pkey on vehicle v_1 (cost=0.14..0.60 rows=1 width=20) (actual time=0.007..0.007 rows=0 loops=153)

  • Index Cond: (id = r.vehicle_id)
57. 1.224 1.224 ↓ 0.0 0 153

Index Scan using vehicle_de_pkey on vehicle v_2 (cost=0.28..3.08 rows=1 width=22) (actual time=0.008..0.008 rows=0 loops=153)

  • Index Cond: (id = r.vehicle_id)
58. 2.295 2.295 ↑ 1.0 1 153

Index Scan using vehicle_fr_pkey on vehicle v_3 (cost=0.28..4.13 rows=1 width=22) (actual time=0.014..0.015 rows=1 loops=153)

  • Index Cond: (id = r.vehicle_id)
59. 0.765 0.765 ↓ 0.0 0 153

Index Scan using vehicle_it_pkey on vehicle v_4 (cost=0.14..1.00 rows=1 width=20) (actual time=0.005..0.005 rows=0 loops=153)

  • Index Cond: (id = r.vehicle_id)
60. 0.612 0.612 ↓ 0.0 0 153

Index Scan using vehicle_lu_pkey on vehicle v_5 (cost=0.14..0.25 rows=1 width=130) (actual time=0.004..0.004 rows=0 loops=153)

  • Index Cond: (id = r.vehicle_id)
61. 0.765 0.765 ↓ 0.0 0 153

Index Scan using vehicle_uk_pkey on vehicle v_6 (cost=0.15..0.64 rows=1 width=20) (actual time=0.005..0.005 rows=0 loops=153)

  • Index Cond: (id = r.vehicle_id)
62. 2.907 11.016 ↑ 7.0 1 153

Append (cost=0.00..1.89 rows=7 width=25) (actual time=0.048..0.072 rows=1 loops=153)

63. 0.000 0.000 ↓ 0.0 0 153

Seq Scan on vehicle_model vm (cost=0.00..0.00 rows=1 width=244) (actual time=0.000..0.000 rows=0 loops=153)

  • Filter: (v.vehicle_model_id = id)
64. 1.377 1.377 ↓ 0.0 0 153

Index Scan using vehicle_model_be_pkey on vehicle_model vm_1 (cost=0.27..0.30 rows=1 width=21) (actual time=0.009..0.009 rows=0 loops=153)

  • Index Cond: (id = v.vehicle_model_id)
65. 1.224 1.224 ↓ 0.0 0 153

Index Scan using vehicle_model_de_pkey on vehicle_model vm_2 (cost=0.28..0.35 rows=1 width=21) (actual time=0.008..0.008 rows=0 loops=153)

  • Index Cond: (id = v.vehicle_model_id)
66. 3.060 3.060 ↑ 1.0 1 153

Index Scan using vehicle_model_fr_pkey on vehicle_model vm_3 (cost=0.28..0.48 rows=1 width=26) (actual time=0.020..0.020 rows=1 loops=153)

  • Index Cond: (id = v.vehicle_model_id)
67. 1.071 1.071 ↓ 0.0 0 153

Index Scan using vehicle_model_it_pkey on vehicle_model vm_4 (cost=0.27..0.30 rows=1 width=22) (actual time=0.007..0.007 rows=0 loops=153)

  • Index Cond: (id = v.vehicle_model_id)
68. 0.459 0.459 ↓ 0.0 0 153

Index Scan using vehicle_model_lu_pkey on vehicle_model vm_5 (cost=0.14..0.15 rows=1 width=244) (actual time=0.003..0.003 rows=0 loops=153)

  • Index Cond: (id = v.vehicle_model_id)
69. 0.918 0.918 ↓ 0.0 0 153

Index Scan using vehicle_model_uk_pkey on vehicle_model vm_6 (cost=0.28..0.31 rows=1 width=28) (actual time=0.006..0.006 rows=0 loops=153)

  • Index Cond: (id = v.vehicle_model_id)
70. 0.122 0.153 ↓ 0.0 0 153

Materialize (cost=1.13..25.21 rows=1 width=92) (actual time=0.001..0.001 rows=0 loops=153)

71. 0.001 0.031 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.13..25.21 rows=1 width=92) (actual time=0.031..0.031 rows=0 loops=1)

72. 0.000 0.030 ↓ 0.0 0 1

Nested Loop (cost=0.84..16.89 rows=1 width=83) (actual time=0.030..0.030 rows=0 loops=1)

73. 0.030 0.030 ↓ 0.0 0 1

Index Scan using basic_user_id_idx on basic_user bu (cost=0.42..8.44 rows=1 width=68) (actual time=0.030..0.030 rows=0 loops=1)

  • Index Cond: (id = 1,604)
  • Filter: ((login)::text = 'yoann.leber@viacesi.fr'::text)
  • Rows Removed by Filter: 1
74. 0.000 0.000 ↓ 0.0 0

Index Scan using user_user_id_idx on "user" u (cost=0.42..8.44 rows=1 width=15) (never executed)

  • Index Cond: (user_id = 1,604)
75. 0.000 0.000 ↓ 0.0 0

Index Scan using economic_unit_id_idx on economic_unit eu (cost=0.29..8.30 rows=1 width=17) (never executed)

  • Index Cond: (u.economic_unit_id = id)
76. 0.000 0.000 ↓ 0.0 0

Index Scan using account_pkey on account a (cost=0.28..3.93 rows=1 width=12) (never executed)

  • Index Cond: (id = r.account_id)
77. 0.000 0.000 ↓ 0.0 0

Append (cost=0.00..2.65 rows=7 width=168) (never executed)

78. 0.000 0.000 ↓ 0.0 0

Seq Scan on reservation_agreement ra (cost=0.00..0.00 rows=1 width=696) (never executed)

  • Filter: (r.reservation_agreement_id = id)
79. 0.000 0.000 ↓ 0.0 0

Index Scan using reservation_agreement_be_pkey on reservation_agreement ra_1 (cost=0.14..0.29 rows=1 width=696) (never executed)

  • Index Cond: (r.reservation_agreement_id = id)
80. 0.000 0.000 ↓ 0.0 0

Index Scan using reservation_agreement_de_pkey on reservation_agreement ra_2 (cost=0.14..0.50 rows=1 width=59) (never executed)

  • Index Cond: (r.reservation_agreement_id = id)
81. 0.000 0.000 ↓ 0.0 0

Index Scan using reservation_agreement_fr_pkey on reservation_agreement ra_3 (cost=0.15..1.01 rows=1 width=55) (never executed)

  • Index Cond: (r.reservation_agreement_id = id)
82. 0.000 0.000 ↓ 0.0 0

Index Scan using reservation_agreement_it_pkey on reservation_agreement ra_4 (cost=0.14..0.33 rows=1 width=696) (never executed)

  • Index Cond: (r.reservation_agreement_id = id)
83. 0.000 0.000 ↓ 0.0 0

Index Scan using reservation_agreement_lu_pkey on reservation_agreement ra_5 (cost=0.13..0.25 rows=1 width=696) (never executed)

  • Index Cond: (r.reservation_agreement_id = id)
84. 0.000 0.000 ↓ 0.0 0

Index Scan using reservation_agreement_uk_pkey on reservation_agreement ra_6 (cost=0.14..0.29 rows=1 width=696) (never executed)

  • Index Cond: (r.reservation_agreement_id = id)
85. 0.000 0.000 ↓ 0.0 0

Append (cost=0.00..1.00 rows=7 width=90) (never executed)

86. 0.000 0.000 ↓ 0.0 0

Seq Scan on geographical_site gs (cost=0.00..0.00 rows=1 width=122) (never executed)

  • Filter: (p.geographical_site_id = id)
87. 0.000 0.000 ↓ 0.0 0

Index Scan using geographical_site_be_pkey on geographical_site gs_1 (cost=0.13..0.16 rows=1 width=122) (never executed)

  • Index Cond: (p.geographical_site_id = id)
88. 0.000 0.000 ↓ 0.0 0

Index Scan using geographical_site_de_pkey on geographical_site gs_2 (cost=0.14..0.17 rows=1 width=16) (never executed)

  • Index Cond: (p.geographical_site_id = id)
89. 0.000 0.000 ↓ 0.0 0

Index Scan using geographical_site_fr_pkey on geographical_site gs_3 (cost=0.14..0.17 rows=1 width=22) (never executed)

  • Index Cond: (p.geographical_site_id = id)
90. 0.000 0.000 ↓ 0.0 0

Index Scan using geographical_site_it_pkey on geographical_site gs_4 (cost=0.14..0.16 rows=1 width=122) (never executed)

  • Index Cond: (p.geographical_site_id = id)
91. 0.000 0.000 ↓ 0.0 0

Index Scan using geographical_site_lu_pkey on geographical_site gs_5 (cost=0.15..0.19 rows=1 width=122) (never executed)

  • Index Cond: (p.geographical_site_id = id)
92. 0.000 0.000 ↓ 0.0 0

Index Scan using geographical_site_uk_pkey on geographical_site gs_6 (cost=0.14..0.16 rows=1 width=122) (never executed)

  • Index Cond: (p.geographical_site_id = id)
93. 0.000 0.000 ↓ 0.0 0

Append (cost=0.00..1.33 rows=7 width=4) (never executed)

94. 0.000 0.000 ↓ 0.0 0

Seq Scan on box b (cost=0.00..0.00 rows=1 width=4) (never executed)

  • Filter: (id = v.box_id)
95. 0.000 0.000 ↓ 0.0 0

Index Only Scan using box_be_pkey on box b_1 (cost=0.14..0.17 rows=1 width=4) (never executed)

  • Index Cond: (id = v.box_id)
  • Heap Fetches: 0
96. 0.000 0.000 ↓ 0.0 0

Index Only Scan using box_de_pkey on box b_2 (cost=0.28..0.32 rows=1 width=4) (never executed)

  • Index Cond: (id = v.box_id)
  • Heap Fetches: 0
97. 0.000 0.000 ↓ 0.0 0

Index Only Scan using box_fr_pkey on box b_3 (cost=0.28..0.35 rows=1 width=4) (never executed)

  • Index Cond: (id = v.box_id)
  • Heap Fetches: 0
98. 0.000 0.000 ↓ 0.0 0

Index Only Scan using box_it_pkey on box b_4 (cost=0.14..0.17 rows=1 width=4) (never executed)

  • Index Cond: (id = v.box_id)
  • Heap Fetches: 0
99. 0.000 0.000 ↓ 0.0 0

Index Only Scan using box_lu_pkey on box b_5 (cost=0.14..0.16 rows=1 width=4) (never executed)

  • Index Cond: (id = v.box_id)
  • Heap Fetches: 0
100. 0.000 0.000 ↓ 0.0 0

Index Only Scan using box_uk_pkey on box b_6 (cost=0.14..0.17 rows=1 width=4) (never executed)

  • Index Cond: (id = v.box_id)
  • Heap Fetches: 0
101. 0.000 0.000 ↓ 0.0 0

Append (cost=0.00..35.21 rows=7 width=8) (never executed)

102. 0.000 0.000 ↓ 0.0 0

Seq Scan on trip_rating tr (cost=0.00..0.00 rows=1 width=8) (never executed)

  • Filter: (trip_id = r.trip_id)
103. 0.000 0.000 ↓ 0.0 0

Index Scan using trip_rating_be_pkey on trip_rating tr_1 (cost=0.29..6.02 rows=1 width=8) (never executed)

  • Index Cond: (trip_id = r.trip_id)
104. 0.000 0.000 ↓ 0.0 0

Index Scan using trip_rating_de_pkey on trip_rating tr_2 (cost=0.42..7.97 rows=1 width=8) (never executed)

  • Index Cond: (trip_id = r.trip_id)
105. 0.000 0.000 ↓ 0.0 0

Index Scan using trip_rating_fr_pkey on trip_rating tr_3 (cost=0.42..8.20 rows=1 width=8) (never executed)

  • Index Cond: (trip_id = r.trip_id)
106. 0.000 0.000 ↓ 0.0 0

Index Scan using trip_rating_it_pkey on trip_rating tr_4 (cost=0.29..7.30 rows=1 width=8) (never executed)

  • Index Cond: (trip_id = r.trip_id)
107. 0.000 0.000 ↓ 0.0 0

Index Scan using trip_rating_lu_pkey on trip_rating tr_5 (cost=0.15..0.37 rows=1 width=8) (never executed)

  • Index Cond: (trip_id = r.trip_id)
108. 0.000 0.000 ↓ 0.0 0

Index Scan using trip_rating_uk_pkey on trip_rating tr_6 (cost=0.29..5.35 rows=1 width=8) (never executed)