# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 1.253 | 39.457 | ↓ 517.0 | 517 | 1 |
→
Nested Loop (cost=1,002.53..16,989.20 rows=1 width=1,054) (actual time=2.062..39.457 rows=517 loops=1) |
2. | 1.166 | 36.653 | ↓ 517.0 | 517 | 1 |
→
Nested Loop (cost=1,002.25..16,988.83 rows=1 width=1,024) (actual time=2.046..36.653 rows=517 loops=1)
|
3. | 0.825 | 33.419 | ↓ 517.0 | 517 | 1 |
→
Nested Loop Left Join (cost=1,001.96..16,988.41 rows=1 width=1,035) (actual time=2.035..33.419 rows=517 loops=1) |
4. | 2.166 | 32.077 | ↓ 517.0 | 517 | 1 |
→
Nested Loop (cost=1,001.82..16,988.25 rows=1 width=917) (actual time=2.029..32.077 rows=517 loops=1) |
5. | 1.373 | 26.809 | ↓ 517.0 | 517 | 1 |
→
Nested Loop (cost=1,001.41..16,986.17 rows=1 width=875) (actual time=2.016..26.809 rows=517 loops=1) |
6. | 1.495 | 23.368 | ↓ 517.0 | 517 | 1 |
→
Nested Loop (cost=1,001.13..16,985.82 rows=1 width=863) (actual time=2.006..23.368 rows=517 loops=1)
|
7. | 0.109 | 19.805 | ↓ 517.0 | 517 | 1 |
→
Nested Loop (cost=1,000.85..16,985.47 rows=1 width=797) (actual time=1.993..19.805 rows=517 loops=1) |
8. | 0.000 | 17.628 | ↓ 51.7 | 517 | 1 |
→
Gather (cost=1,000.57..16,981.43 rows=10 width=277) (actual time=1.979..17.628 rows=517 loops=1)
|
9. | 1.154 | 20.965 | ↓ 43.0 | 172 | 3 |
→
Nested Loop (cost=0.57..15,980.43 rows=4 width=277) (actual time=0.161..20.965 rows=172 loops=3) |
10. | 1.206 | 19.807 | ↓ 24.7 | 173 | 3 |
→
Nested Loop (cost=0.29..15,977.23 rows=7 width=159) (actual time=0.150..19.807 rows=173 loops=3) |
11. | 18.596 | 18.596 | ↓ 21.6 | 173 | 3 |
→
Parallel Seq Scan on tlb_vendordelivery_area ca (cost=0.00..15,945.31 rows=8 width=72) (actual time=0.120..18.596 rows=173 loops=3)
|
12. | 0.005 | 0.005 | ↑ 1.0 | 1 | 520 |
→
Index Scan using mwq_branch_pkey on mwq_branch b (cost=0.29..3.99 rows=1 width=87) (actual time=0.005..0.005 rows=1 loops=520)
|
13. | 0.004 | 0.004 | ↑ 1.0 | 1 | 519 |
→
Index Scan using mwq_restaurant_pkey on mwq_restaurant r (cost=0.28..0.46 rows=1 width=118) (actual time=0.004..0.004 rows=1 loops=519)
|
14. | 2.068 | 2.068 | ↑ 1.0 | 1 | 517 |
→
Index Scan using tlb_slug_referenceid_idx on tlb_slug sl (cost=0.28..0.39 rows=1 width=520) (actual time=0.004..0.004 rows=1 loops=517)
|
15. | 2.068 | 2.068 | ↑ 1.0 | 1 | 517 |
→
Index Scan using tlb_branch_details_branchid_brndtype_idx on tlb_branch_details bd (cost=0.29..0.34 rows=1 width=66) (actual time=0.004..0.004 rows=1 loops=517)
|
16. | 2.068 | 2.068 | ↑ 1.0 | 1 | 517 |
→
Index Scan using tlb_restaurant_brand_rest_brand_idx on tlb_restaurant_brand br (cost=0.28..0.34 rows=1 width=12) (actual time=0.004..0.004 rows=1 loops=517)
|
17. | 3.102 | 3.102 | ↑ 1.0 | 1 | 517 |
→
Index Scan using "tlb_CommonRestuarantFields_restid_idx" on tlb_commonrestuarantfields cr (cost=0.41..2.07 rows=1 width=58) (actual time=0.005..0.006 rows=1 loops=517)
|
18. | 0.517 | 0.517 | ↓ 0.0 | 0 | 517 |
→
Index Scan using tgb_upsellingcompany_pkey on tgb_upsellingcompany ub (cost=0.14..0.16 rows=1 width=122) (actual time=0.001..0.001 rows=0 loops=517)
|
19. | 2.068 | 2.068 | ↑ 1.0 | 1 | 517 |
→
Index Scan using tlb_vendor_timingstatus_pkey on tlb_vendor_timingstatus cpt (cost=0.29..0.41 rows=1 width=5) (actual time=0.004..0.004 rows=1 loops=517)
|
20. | 1.551 | 1.551 | ↑ 1.0 | 1 | 517 |
→
Index Scan using mwq_area_pkey on mwq_area a (cost=0.28..0.36 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=517)
|
Planning time | : | 8.797 ms |
---|