explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xbJU

Settings
# exclusive inclusive rows x rows loops node
1. 0.419 47.296 ↓ 1,155.0 1,155 1

Nested Loop Left Join (cost=3.48..22,371.69 rows=1 width=626) (actual time=0.253..47.296 rows=1,155 loops=1)

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

Nested Loop (cost=3.19..22,371.34 rows=1 width=604) (actual time=0.247..44.567 rows=1,155 loops=1)

  • Join Filter: (b.restaurantid = r.id)
3. 1.733 41.077 ↓ 1,200.0 1,200 1

Nested Loop Left Join (cost=2.90..22,370.89 rows=1 width=493) (actual time=0.240..41.077 rows=1,200 loops=1)

  • Join Filter: (ub.id = cr.upsellingcompanyid)
  • Rows Removed by Join Filter: 2,056
4. 0.587 39.344 ↓ 1,200.0 1,200 1

Nested Loop (cost=2.90..22,369.84 rows=1 width=375) (actual time=0.234..39.344 rows=1,200 loops=1)

  • Join Filter: (b.restaurantid = cr.restaurantid)
5. 0.430 36.357 ↓ 1,200.0 1,200 1

Nested Loop (cost=2.61..22,369.48 rows=1 width=296) (actual time=0.229..36.357 rows=1,200 loops=1)

  • Join Filter: (b.restaurantid = br.restaurantid)
6. 0.603 33.527 ↓ 1,200.0 1,200 1

Nested Loop (cost=2.32..22,369.13 rows=1 width=284) (actual time=0.224..33.527 rows=1,200 loops=1)

7. 0.207 31.724 ↓ 1,200.0 1,200 1

Nested Loop (cost=2.04..22,368.79 rows=1 width=280) (actual time=0.220..31.724 rows=1,200 loops=1)

8. 0.237 29.117 ↓ 1,200.0 1,200 1

Nested Loop (cost=1.74..22,366.28 rows=1 width=244) (actual time=0.215..29.117 rows=1,200 loops=1)

9. 0.579 26.480 ↓ 1,200.0 1,200 1

Nested Loop (cost=1.45..22,365.93 rows=1 width=225) (actual time=0.211..26.480 rows=1,200 loops=1)

  • Join Filter: (ca.vendorid = bd.branchid)
10. 0.157 23.501 ↓ 1,200.0 1,200 1

Nested Loop Left Join (cost=1.16..22,365.58 rows=1 width=183) (actual time=0.206..23.501 rows=1,200 loops=1)

11. 0.144 20.944 ↓ 1,200.0 1,200 1

Nested Loop (cost=0.87..22,365.23 rows=1 width=158) (actual time=0.202..20.944 rows=1,200 loops=1)

  • Join Filter: (ca.vendorid = cpt.vendorid)
12. 0.888 18.400 ↓ 1,200.0 1,200 1

Nested Loop (cost=0.58..22,364.88 rows=1 width=153) (actual time=0.198..18.400 rows=1,200 loops=1)

13. 14.748 14.748 ↓ 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,362.37 rows=1 width=55) (actual time=0.190..14.748 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 mwq_branch_pkey on mwq_branch b (cost=0.29..2.51 rows=1 width=98) (actual time=0.002..0.002 rows=1 loops=1,382)

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

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

  • Index Cond: (vendorid = b.id)
16. 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)
17. 2.400 2.400 ↑ 1.0 1 1,200

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

  • Index Cond: (branchid = cpt.vendorid)
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 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,200)

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

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,200)

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

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,200)

  • Index Cond: (restaurantid = sl.referenceid)
  • Filter: (isactive AND (NOT isdeleted))
22. 2.400 2.400 ↑ 1.0 1 1,200

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,200)

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

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,200)

24. 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
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