# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 5.013 | 40.921 | ↓ 698.0 | 698 | 1 |
→
Nested Loop Left Join (cost=24.65..57.70 rows=1 width=1,265) (actual time=0.748..40.921 rows=698 loops=1) |
2. |
CTE basic_data |
|||||
3. | 0.004 | 0.085 | ↑ 1.0 | 1 | 1 |
→
Nested Loop (cost=0.72..21.05 rows=1 width=532) (actual time=0.064..0.085 rows=1 loops=1)
|
4. | 0.005 | 0.072 | ↑ 1.0 | 1 | 1 |
→
Nested Loop (cost=0.72..19.25 rows=1 width=535) (actual time=0.058..0.072 rows=1 loops=1)
|
5. | 0.002 | 0.057 | ↑ 1.0 | 1 | 1 |
→
Nested Loop (cost=0.72..17.46 rows=1 width=530) (actual time=0.051..0.057 rows=1 loops=1) |
6. | 0.001 | 0.051 | ↑ 1.0 | 1 | 1 |
→
Nested Loop (cost=0.57..16.90 rows=1 width=10) (actual time=0.046..0.051 rows=1 loops=1) |
7. | 0.001 | 0.048 | ↑ 1.0 | 1 | 1 |
→
Nested Loop (cost=0.43..16.72 rows=1 width=10) (actual time=0.044..0.048 rows=1 loops=1) |
8. | 0.043 | 0.043 | ↑ 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.043 rows=1 loops=1)
|
9. | 0.004 | 0.004 | ↑ 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.004 rows=1 loops=1)
|
10. | 0.002 | 0.002 | ↑ 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.002..0.002 rows=1 loops=1)
|
11. | 0.004 | 0.004 | ↑ 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.004 rows=1 loops=1)
|
12. | 0.010 | 0.010 | ↑ 1.0 | 7 | 1 |
→
Seq Scan on tgb_featurecountry fc (cost=0.00..1.70 rows=7 width=5) (actual time=0.006..0.010 rows=7 loops=1)
|
13. | 0.009 | 0.009 | ↑ 1.0 | 7 | 1 |
→
Seq Scan on tgb_featurecountry fc2 (cost=0.00..1.70 rows=7 width=5) (actual time=0.003..0.009 rows=7 loops=1)
|
14. |
Initplan (forNested Loop Left Join) |
|||||
15. | 0.001 | 0.001 | ↑ 1.0 | 1 | 1 |
→
CTE Scan on basic_data (cost=0.00..0.02 rows=1 width=1) (actual time=0.001..0.001 rows=1 loops=1) |
16. | 0.001 | 0.001 | ↑ 1.0 | 1 | 1 |
→
CTE Scan on basic_data basic_data_1 (cost=0.00..0.02 rows=1 width=1) (actual time=0.001..0.001 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.000..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.001..0.001 rows=1 loops=1) |
20. | 0.000 | 0.000 | ↑ 1.0 | 1 | 1 |
→
CTE Scan on basic_data basic_data_5 (cost=0.00..0.02 rows=1 width=4) (actual time=0.000..0.000 rows=1 loops=1) |
21. | 0.001 | 0.001 | ↑ 1.0 | 1 | 1 |
→
CTE Scan on basic_data basic_data_6 (cost=0.00..0.02 rows=1 width=1) (actual time=0.001..0.001 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.001..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.001..0.001 rows=1 loops=1) |
24. | 0.093 | 0.093 | ↑ 1.0 | 1 | 1 |
→
CTE Scan on basic_data basic_data_9 (cost=0.00..0.02 rows=1 width=4) (actual time=0.072..0.093 rows=1 loops=1) |
25. | 0.996 | 34.412 | ↓ 698.0 | 698 | 1 |
→
Nested Loop (cost=3.13..35.96 rows=1 width=564) (actual time=0.609..34.412 rows=698 loops=1)
|
26. | 1.237 | 31.322 | ↓ 698.0 | 698 | 1 |
→
Nested Loop (cost=2.84..35.64 rows=1 width=507) (actual time=0.602..31.322 rows=698 loops=1)
|
27. | 1.041 | 27.988 | ↓ 699.0 | 699 | 1 |
→
Nested Loop (cost=2.55..35.18 rows=1 width=407) (actual time=0.594..27.988 rows=699 loops=1) |
28. | 1.091 | 25.549 | ↓ 699.0 | 699 | 1 |
→
Nested Loop (cost=2.27..34.78 rows=1 width=403) (actual time=0.589..25.549 rows=699 loops=1) |
29. | 1.347 | 21.662 | ↓ 699.0 | 699 | 1 |
→
Nested Loop (cost=1.85..26.33 rows=1 width=388) (actual time=0.582..21.662 rows=699 loops=1)
|
30. | 1.048 | 18.218 | ↓ 699.0 | 699 | 1 |
→
Nested Loop (cost=1.56..25.98 rows=1 width=365) (actual time=0.576..18.218 rows=699 loops=1)
|
31. | 1.726 | 15.073 | ↓ 699.0 | 699 | 1 |
→
Nested Loop (cost=1.28..25.66 rows=1 width=341) (actual time=0.570..15.073 rows=699 loops=1)
|
32. | 1.174 | 11.250 | ↓ 699.0 | 699 | 1 |
→
Nested Loop (cost=0.99..25.32 rows=1 width=163) (actual time=0.561..11.250 rows=699 loops=1) |
33. | 0.983 | 7.280 | ↓ 699.0 | 699 | 1 |
→
Nested Loop (cost=0.57..16.87 rows=1 width=151) (actual time=0.546..7.280 rows=699 loops=1) |
34. | 3.457 | 3.457 | ↓ 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.535..3.457 rows=710 loops=1)
|
35. | 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)
|
36. | 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)
|
37. | 2.097 | 2.097 | ↑ 1.0 | 1 | 699 |
→
Index Scan using mwq_restaurant_pkey on mwq_restaurant r (cost=0.29..0.32 rows=1 width=178) (actual time=0.003..0.003 rows=1 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..0.31 rows=1 width=24) (actual time=0.003..0.003 rows=1 loops=699)
|
39. | 2.097 | 2.097 | ↑ 1.0 | 1 | 699 |
→
Index Scan using tlb_slug_referenceid_idx on tlb_slug sl (cost=0.29..0.34 rows=1 width=23) (actual time=0.003..0.003 rows=1 loops=699)
|
40. | 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)
|
41. | 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)
|
42. | 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)
|
43. | 2.094 | 2.094 | ↑ 1.0 | 1 | 698 |
→
Index Scan using "tlb_CommonRestuarantFields_restid_idx" on tlb_commonrestuarantfields cr (cost=0.29..0.30 rows=1 width=77) (actual time=0.002..0.003 rows=1 loops=698)
|
44. | 1.396 | 1.396 | ↓ 0.0 | 0 | 698 |
→
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=698)
|