# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 5.492 | 53.620 | ↓ 699.0 | 699 | 1 |
→
Nested Loop Left Join (cost=24.65..68.22 rows=1 width=1,515) (actual time=0.325..53.620 rows=699 loops=1) |
2. |
CTE basic_data |
|||||
3. | 0.008 | 0.095 | ↑ 1.0 | 1 | 1 |
→
Nested Loop (cost=0.72..21.05 rows=1 width=532) (actual time=0.074..0.095 rows=1 loops=1)
|
4. | 0.006 | 0.077 | ↑ 1.0 | 1 | 1 |
→
Nested Loop (cost=0.72..19.25 rows=1 width=535) (actual time=0.063..0.077 rows=1 loops=1)
|
5. | 0.003 | 0.060 | ↑ 1.0 | 1 | 1 |
→
Nested Loop (cost=0.72..17.46 rows=1 width=530) (actual time=0.053..0.060 rows=1 loops=1) |
6. | 0.000 | 0.054 | ↑ 1.0 | 1 | 1 |
→
Nested Loop (cost=0.57..16.90 rows=1 width=10) (actual time=0.048..0.054 rows=1 loops=1) |
7. | 0.004 | 0.051 | ↑ 1.0 | 1 | 1 |
→
Nested Loop (cost=0.43..16.72 rows=1 width=10) (actual time=0.045..0.051 rows=1 loops=1) |
8. | 0.044 | 0.044 | ↑ 1.0 | 1 | 1 |
→
Index Scan using mwq_areapolygons_polygongeo on mwq_areapolygons ap (cost=0.14..8.41 rows=1 width=4) (actual time=0.040..0.044 rows=1 loops=1)
|
9. | 0.003 | 0.003 | ↑ 1.0 | 1 | 1 |
→
Index Scan using mwq_area_pkey on mwq_area a_1 (cost=0.28..8.30 rows=1 width=10) (actual time=0.003..0.003 rows=1 loops=1)
|
10. | 0.003 | 0.003 | ↑ 1.0 | 1 | 1 |
→
Index Scan using mwq_city_pkey on mwq_city ct (cost=0.14..0.16 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=1)
|
11. | 0.003 | 0.003 | ↑ 1.0 | 1 | 1 |
→
Index Scan using tgb_countrysettings_pkey on tgb_countrysettings cs (cost=0.14..0.55 rows=1 width=520) (actual time=0.003..0.003 rows=1 loops=1)
|
12. | 0.011 | 0.011 | ↑ 1.0 | 7 | 1 |
→
Seq Scan on tgb_featurecountry fc (cost=0.00..1.70 rows=7 width=5) (actual time=0.007..0.011 rows=7 loops=1)
|
13. | 0.010 | 0.010 | ↑ 1.0 | 7 | 1 |
→
Seq Scan on tgb_featurecountry fc2 (cost=0.00..1.70 rows=7 width=5) (actual time=0.007..0.010 rows=7 loops=1)
|
14. |
Initplan (forNested Loop Left Join) |
|||||
15. | 0.002 | 0.002 | ↑ 1.0 | 1 | 1 |
→
CTE Scan on basic_data (cost=0.00..0.02 rows=1 width=1) (actual time=0.001..0.002 rows=1 loops=1) |
16. | 0.000 | 0.000 | ↑ 1.0 | 1 | 1 |
→
CTE Scan on basic_data basic_data_1 (cost=0.00..0.02 rows=1 width=1) (actual time=0.000..0.000 rows=1 loops=1) |
17. | 0.001 | 0.001 | ↑ 1.0 | 1 | 1 |
→
CTE Scan on basic_data basic_data_2 (cost=0.00..0.02 rows=1 width=1) (actual time=0.001..0.001 rows=1 loops=1) |
18. | 0.000 | 0.000 | ↑ 1.0 | 1 | 1 |
→
CTE Scan on basic_data basic_data_3 (cost=0.00..0.02 rows=1 width=1) (actual time=0.000..0.000 rows=1 loops=1) |
19. | 0.001 | 0.001 | ↑ 1.0 | 1 | 1 |
→
CTE Scan on basic_data basic_data_4 (cost=0.00..0.02 rows=1 width=1) (actual time=0.000..0.001 rows=1 loops=1) |
20. | 0.001 | 0.001 | ↑ 1.0 | 1 | 1 |
→
CTE Scan on basic_data basic_data_5 (cost=0.00..0.02 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=1) |
21. | 0.000 | 0.000 | ↑ 1.0 | 1 | 1 |
→
CTE Scan on basic_data basic_data_6 (cost=0.00..0.02 rows=1 width=1) (actual time=0.000..0.000 rows=1 loops=1) |
22. | 0.001 | 0.001 | ↑ 1.0 | 1 | 1 |
→
CTE Scan on basic_data basic_data_7 (cost=0.00..0.02 rows=1 width=1) (actual time=0.000..0.001 rows=1 loops=1) |
23. | 0.001 | 0.001 | ↑ 1.0 | 1 | 1 |
→
CTE Scan on basic_data basic_data_8 (cost=0.00..0.02 rows=1 width=516) (actual time=0.000..0.001 rows=1 loops=1) |
24. | 0.100 | 0.100 | ↑ 1.0 | 1 | 1 |
→
CTE Scan on basic_data basic_data_9 (cost=0.00..0.02 rows=1 width=4) (actual time=0.077..0.100 rows=1 loops=1) |
25. | 0.957 | 46.623 | ↓ 699.0 | 699 | 1 |
→
Nested Loop Left Join (cost=3.13..46.49 rows=1 width=1,000) (actual time=0.171..46.623 rows=699 loops=1) |
26. | 1.118 | 43.569 | ↓ 699.0 | 699 | 1 |
→
Nested Loop Left Join (cost=2.84..45.92 rows=1 width=927) (actual time=0.164..43.569 rows=699 loops=1) |
27. | 1.304 | 40.354 | ↓ 699.0 | 699 | 1 |
→
Nested Loop Left Join (cost=2.55..45.45 rows=1 width=823) (actual time=0.158..40.354 rows=699 loops=1) |
28. | 0.975 | 36.254 | ↓ 699.0 | 699 | 1 |
→
Nested Loop (cost=2.13..37.00 rows=1 width=819) (actual time=0.147..36.254 rows=699 loops=1) |
29. | 1.112 | 33.881 | ↓ 699.0 | 699 | 1 |
→
Nested Loop (cost=1.85..36.60 rows=1 width=815) (actual time=0.144..33.881 rows=699 loops=1) |
30. | 1.324 | 29.973 | ↓ 699.0 | 699 | 1 |
→
Nested Loop (cost=1.43..28.15 rows=1 width=800) (actual time=0.137..29.973 rows=699 loops=1)
|
31. | 1.068 | 26.552 | ↓ 699.0 | 699 | 1 |
→
Nested Loop (cost=1.14..27.58 rows=1 width=785) (actual time=0.124..26.552 rows=699 loops=1)
|
32. | 1.008 | 22.688 | ↓ 699.0 | 699 | 1 |
→
Nested Loop (cost=0.85..26.58 rows=1 width=607) (actual time=0.112..22.688 rows=699 loops=1) |
33. | 5.484 | 19.583 | ↓ 699.0 | 699 | 1 |
→
Nested Loop (cost=0.57..18.27 rows=1 width=583) (actual time=0.105..19.583 rows=699 loops=1)
|
34. | 0.936 | 7.109 | ↓ 699.0 | 699 | 1 |
→
Nested Loop (cost=0.57..16.87 rows=1 width=147) (actual time=0.095..7.109 rows=699 loops=1) |
35. | 3.333 | 3.333 | ↓ 710.0 | 710 | 1 |
→
Index Scan using tgb_coveragepolygon_polygongeo on tgb_coveragepolygon ca (cost=0.28..8.55 rows=1 width=44) (actual time=0.082..3.333 rows=710 loops=1)
|
36. | 2.840 | 2.840 | ↑ 1.0 | 1 | 710 |
→
Index Scan using mwq_branch_pkey on mwq_branch b (cost=0.29..8.30 rows=1 width=107) (actual time=0.003..0.004 rows=1 loops=710)
|
37. | 6.990 | 6.990 | ↓ 3.6 | 29 | 699 |
→
Seq Scan on tlb_deliverytimes tdt (cost=0.00..1.30 rows=8 width=438) (actual time=0.001..0.010 rows=29 loops=699)
|
38. | 2.097 | 2.097 | ↑ 1.0 | 1 | 699 |
→
Index Scan using tlb_restaurantbrand_resttid_brndid_idx on tlb_restaurant_brand brandrestaurant (cost=0.29..8.30 rows=1 width=24) (actual time=0.003..0.003 rows=1 loops=699)
|
39. | 2.796 | 2.796 | ↑ 1.0 | 1 | 699 |
→
Index Scan using mwq_restaurant_pkey on mwq_restaurant r (cost=0.29..0.98 rows=1 width=178) (actual time=0.003..0.004 rows=1 loops=699)
|
40. | 2.097 | 2.097 | ↑ 1.0 | 1 | 699 |
→
Index Scan using tlb_slug_referenceid_idx on tlb_slug sl (cost=0.29..0.56 rows=1 width=23) (actual time=0.003..0.003 rows=1 loops=699)
|
41. | 2.796 | 2.796 | ↑ 1.0 | 1 | 699 |
→
Index Scan using tgb_coveragepolygon_additional_pkey on tgb_coveragepolygon_additional cpa (cost=0.42..8.44 rows=1 width=23) (actual time=0.004..0.004 rows=1 loops=699)
|
42. | 1.398 | 1.398 | ↑ 1.0 | 1 | 699 |
→
Index Scan using mwq_area_pkey on mwq_area a (cost=0.28..0.39 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=699)
|
43. | 2.796 | 2.796 | ↑ 1.0 | 1 | 699 |
→
Index Scan using "tlb_RestLstDynmc_restid_areaid_brndtyp_idx" on tlb_restaurantlistdynamic rld (cost=0.42..8.45 rows=1 width=20) (actual time=0.004..0.004 rows=1 loops=699)
|
44. | 2.097 | 2.097 | ↑ 1.0 | 1 | 699 |
→
Index Scan using tlb_branchdetails_branchid_idx on tlb_branch_details bd (cost=0.29..0.45 rows=1 width=108) (actual time=0.003..0.003 rows=1 loops=699)
|
45. | 2.097 | 2.097 | ↑ 1.0 | 1 | 699 |
→
Index Scan using "tlb_CommonRestuarantFields_restid_idx" on tlb_commonrestuarantfields cr (cost=0.29..0.56 rows=1 width=77) (actual time=0.002..0.003 rows=1 loops=699)
|
46. | 1.398 | 1.398 | ↓ 0.0 | 0 | 699 |
→
Index Scan using "tlb_Sponsored_Restaurant_rest_area_brnd_idx" on tlb_sponsored_restaurant sp (cost=0.28..0.44 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=699)
|