# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 5.655 | 53.138 | ↓ 698.0 | 698 | 1 |
→
Nested Loop Left Join (cost=24.65..68.25 rows=1 width=1,515) (actual time=0.796..53.138 rows=698 loops=1) |
2. |
CTE basic_data |
|||||
3. | 0.006 | 0.094 | ↑ 1.0 | 1 | 1 |
→
Nested Loop (cost=0.72..21.05 rows=1 width=532) (actual time=0.073..0.094 rows=1 loops=1)
|
4. | 0.008 | 0.077 | ↑ 1.0 | 1 | 1 |
→
Nested Loop (cost=0.72..19.25 rows=1 width=535) (actual time=0.064..0.077 rows=1 loops=1)
|
5. | 0.000 | 0.059 | ↑ 1.0 | 1 | 1 |
→
Nested Loop (cost=0.72..17.46 rows=1 width=530) (actual time=0.053..0.059 rows=1 loops=1) |
6. | 0.001 | 0.055 | ↑ 1.0 | 1 | 1 |
→
Nested Loop (cost=0.57..16.90 rows=1 width=10) (actual time=0.050..0.055 rows=1 loops=1) |
7. | 0.004 | 0.050 | ↑ 1.0 | 1 | 1 |
→
Nested Loop (cost=0.43..16.72 rows=1 width=10) (actual time=0.046..0.050 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.041..0.043 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.004 | 0.004 | ↑ 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.004 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.007..0.010 rows=7 loops=1)
|
13. | 0.011 | 0.011 | ↑ 1.0 | 7 | 1 |
→
Seq Scan on tgb_featurecountry fc2 (cost=0.00..1.70 rows=7 width=5) (actual time=0.005..0.011 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.000 | 0.000 | ↑ 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.000 rows=1 loops=1) |
18. | 0.001 | 0.001 | ↑ 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.001 rows=1 loops=1) |
19. | 0.000 | 0.000 | ↑ 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.000 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.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.000..0.001 rows=1 loops=1) |
22. | 0.000 | 0.000 | ↑ 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.000 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.097 | 0.097 | ↑ 1.0 | 1 | 1 |
→
CTE Scan on basic_data basic_data_9 (cost=0.00..0.02 rows=1 width=4) (actual time=0.076..0.097 rows=1 loops=1) |
25. | 1.023 | 45.984 | ↓ 698.0 | 698 | 1 |
→
Nested Loop (cost=3.13..46.51 rows=1 width=1,000) (actual time=0.643..45.984 rows=698 loops=1)
|
26. | 1.259 | 42.867 | ↓ 698.0 | 698 | 1 |
→
Nested Loop (cost=2.84..46.20 rows=1 width=943) (actual time=0.635..42.867 rows=698 loops=1)
|
27. | 1.046 | 39.511 | ↓ 699.0 | 699 | 1 |
→
Nested Loop (cost=2.55..45.73 rows=1 width=843) (actual time=0.626..39.511 rows=699 loops=1) |
28. | 1.043 | 35.669 | ↓ 699.0 | 699 | 1 |
→
Nested Loop (cost=2.13..37.27 rows=1 width=831) (actual time=0.616..35.669 rows=699 loops=1) |
29. | 1.186 | 33.228 | ↓ 699.0 | 699 | 1 |
→
Nested Loop (cost=1.85..36.87 rows=1 width=827) (actual time=0.612..33.228 rows=699 loops=1) |
30. | 0.702 | 29.246 | ↓ 699.0 | 699 | 1 |
→
Nested Loop (cost=1.43..28.42 rows=1 width=812) (actual time=0.604..29.246 rows=699 loops=1)
|
31. | 1.106 | 25.748 | ↓ 699.0 | 699 | 1 |
→
Nested Loop (cost=1.14..27.85 rows=1 width=789) (actual time=0.594..25.748 rows=699 loops=1)
|
32. | 5.988 | 21.846 | ↓ 699.0 | 699 | 1 |
→
Nested Loop (cost=0.85..26.86 rows=1 width=611) (actual time=0.580..21.846 rows=699 loops=1)
|
33. | 1.028 | 10.266 | ↓ 699.0 | 699 | 1 |
→
Nested Loop (cost=0.85..25.18 rows=1 width=175) (actual time=0.567..10.266 rows=699 loops=1) |
34. | 0.863 | 7.141 | ↓ 699.0 | 699 | 1 |
→
Nested Loop (cost=0.57..16.87 rows=1 width=151) (actual time=0.561..7.141 rows=699 loops=1) |
35. | 3.438 | 3.438 | ↓ 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.548..3.438 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. | 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)
|
38. | 5.592 | 5.592 | ↑ 1.0 | 30 | 699 |
→
Seq Scan on tlb_deliverytimes tdt (cost=0.00..1.30 rows=30 width=438) (actual time=0.001..0.008 rows=30 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.796 | 2.796 | ↑ 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.004 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.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)
|
46. | 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)
|