explain.depesz.com

PostgreSQL's explain analyze made readable

Result: msVB

Settings
# exclusive inclusive rows x rows loops node
1. 0.718 52.082 ↓ 1,155.0 1,155 1

Nested Loop Left Join (cost=3.48..22,345.60 rows=1 width=626) (actual time=0.372..52.082 rows=1,155 loops=1)

  • Join Filter: (a.cityid = tcp.cityid)
  • Rows Removed by Join Filter: 4
2. 0.752 49.054 ↓ 1,155.0 1,155 1

Nested Loop (cost=3.19..22,345.25 rows=1 width=604) (actual time=0.362..49.054 rows=1,155 loops=1)

3. 0.664 47.147 ↓ 1,155.0 1,155 1

Nested Loop (cost=2.91..22,344.91 rows=1 width=600) (actual time=0.355..47.147 rows=1,155 loops=1)

  • Join Filter: (ca.vendorid = cpt.vendorid)
4. 1.733 44.173 ↓ 1,155.0 1,155 1

Nested Loop Left Join (cost=2.61..22,344.58 rows=1 width=607) (actual time=0.348..44.173 rows=1,155 loops=1)

  • Join Filter: (ub.id = cr.upsellingcompanyid)
  • Rows Removed by Join Filter: 1,970
5. 0.954 42.440 ↓ 1,155.0 1,155 1

Nested Loop (cost=2.61..22,343.53 rows=1 width=489) (actual time=0.339..42.440 rows=1,155 loops=1)

  • Join Filter: (b.restaurantid = cr.restaurantid)
6. 0.749 39.176 ↓ 1,155.0 1,155 1

Nested Loop (cost=2.32..22,343.17 rows=1 width=426) (actual time=0.331..39.176 rows=1,155 loops=1)

  • Join Filter: (b.restaurantid = br.restaurantid)
7. 1.471 36.117 ↓ 1,155.0 1,155 1

Nested Loop (cost=2.03..22,342.83 rows=1 width=414) (actual time=0.324..36.117 rows=1,155 loops=1)

  • Join Filter: (b.restaurantid = r.id)
8. 0.589 32.246 ↓ 1,200.0 1,200 1

Nested Loop (cost=1.74..22,342.37 rows=1 width=287) (actual time=0.316..32.246 rows=1,200 loops=1)

9. 0.589 29.257 ↓ 1,200.0 1,200 1

Nested Loop Left Join (cost=1.45..22,342.02 rows=1 width=268) (actual time=0.310..29.257 rows=1,200 loops=1)

10. 1.181 26.268 ↓ 1,200.0 1,200 1

Nested Loop (cost=1.16..22,341.68 rows=1 width=243) (actual time=0.305..26.268 rows=1,200 loops=1)

  • Join Filter: (ca.vendorid = b.id)
11. 1.067 22.323 ↓ 1,382.0 1,382 1

Nested Loop (cost=0.87..22,341.28 rows=1 width=145) (actual time=0.297..22.323 rows=1,382 loops=1)

12. 0.501 18.492 ↓ 1,382.0 1,382 1

Nested Loop (cost=0.58..22,338.76 rows=1 width=91) (actual time=0.290..18.492 rows=1,382 loops=1)

13. 15.227 15.227 ↓ 1,382.0 1,382 1

Index Scan using tlb_vendor_deliveryarea_polygon_deliveryareapolygon_idx on tlb_vendor_deliveryarea_polygon ca (cost=0.29..22,336.25 rows=1 width=55) (actual time=0.281..15.227 rows=1,382 loops=1)

  • Index Cond: (deliveryareapolygon ~ '0101000020E610000063B48EAA26A64B4018963FDF16383940'::geometry)
  • Filter: ((NOT isdeleted) AND st_contains(deliveryareapolygon, '0101000020E610000063B48EAA26A64B4018963FDF16383940'::geometry))
  • Rows Removed by Filter: 1,706
14. 2.764 2.764 ↑ 1.0 1 1,382

Index Scan using tlb_vendor_deliveryarea_pk on tlb_vendor_deliveryarea vda (cost=0.29..2.51 rows=1 width=52) (actual time=0.002..0.002 rows=1 loops=1,382)

  • Index Cond: (id = ca.vendordeliveryareaid)
  • Filter: (deliveryareastatus = ANY ('{0,1,2}'::integer[]))
15. 2.764 2.764 ↑ 1.0 1 1,382

Index Scan using tlb_branch_details_branchid_idx on tlb_branch_details bd (cost=0.29..2.51 rows=1 width=54) (actual time=0.002..0.002 rows=1 loops=1,382)

  • Index Cond: (branchid = ca.vendorid)
16. 2.764 2.764 ↑ 1.0 1 1,382

Index Scan using mwq_branch_pkey on mwq_branch b (cost=0.29..0.38 rows=1 width=98) (actual time=0.002..0.002 rows=1 loops=1,382)

  • Index Cond: (id = bd.branchid)
  • Filter: ((NOT isdeleted) AND istalabatgo AND (status = ANY ('{0,1,2}'::integer[])))
  • Rows Removed by Filter: 0
17. 2.400 2.400 ↑ 1.0 1 1,200

Index Scan using tlb_vendor_dynamicrank_vendorid_idx on tlb_vendor_dynamicrank vdr (cost=0.29..0.34 rows=1 width=29) (actual time=0.002..0.002 rows=1 loops=1,200)

  • Index Cond: (vendorid = b.id)
18. 2.400 2.400 ↑ 1.0 1 1,200

Index Scan using tlb_slug_referenceid_idx on tlb_slug sl (cost=0.29..0.34 rows=1 width=19) (actual time=0.002..0.002 rows=1 loops=1,200)

  • Index Cond: (referenceid = b.restaurantid)
  • Filter: ((NOT isdeleted) AND (typeid = 1))
19. 2.400 2.400 ↑ 1.0 1 1,200

Index Scan using mwq_restaurant_pkey on mwq_restaurant r (cost=0.29..0.44 rows=1 width=127) (actual time=0.002..0.002 rows=1 loops=1,200)

  • Index Cond: (id = sl.referenceid)
  • Filter: ((NOT isdeleted) AND (status = ANY ('{0,1,2}'::integer[])))
  • Rows Removed by Filter: 0
20. 2.310 2.310 ↑ 1.0 1 1,155

Index Scan using tlb_restaurant_brand_restaurantid_idx on tlb_restaurant_brand br (cost=0.29..0.33 rows=1 width=12) (actual time=0.002..0.002 rows=1 loops=1,155)

  • Index Cond: (restaurantid = sl.referenceid)
  • Filter: (isactive AND (NOT isdeleted))
21. 2.310 2.310 ↑ 1.0 1 1,155

Index Scan using "tlb_CommonRestuarantFields_restid_idx" on tlb_commonrestuarantfields cr (cost=0.29..0.35 rows=1 width=79) (actual time=0.002..0.002 rows=1 loops=1,155)

  • Index Cond: (restaurantid = sl.referenceid)
22. 0.000 0.000 ↑ 1.0 2 1,155

Seq Scan on tgb_upsellingcompany ub (cost=0.00..1.02 rows=2 width=122) (actual time=0.000..0.000 rows=2 loops=1,155)

23. 2.310 2.310 ↑ 1.0 1 1,155

Index Scan using tlb_vendor_timingstatus_vendorid_idx on tlb_vendor_timingstatus cpt (cost=0.29..0.32 rows=1 width=5) (actual time=0.002..0.002 rows=1 loops=1,155)

  • Index Cond: (vendorid = bd.branchid)
24. 1.155 1.155 ↑ 1.0 1 1,155

Index Scan using mwq_area_pkey on mwq_area a (cost=0.29..0.34 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=1,155)

  • Index Cond: (id = b.areaid)
25. 2.310 2.310 ↑ 1.0 1 1,155

Index Scan using tlb_chain_pricetags_un on tlb_chain_pricetags tcp (cost=0.29..0.33 rows=1 width=10) (actual time=0.002..0.002 rows=1 loops=1,155)

  • Index Cond: (chainid = r.id)
  • Filter: (NOT isdeleted)
  • Rows Removed by Filter: 0
Planning time : 5.915 ms
Execution time : 52.293 ms