explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ByII

Settings
# exclusive inclusive rows x rows loops node
1. 1.396 71.116 ↓ 30.4 1,156 1

Nested Loop Left Join (cost=50.16..5,950.02 rows=38 width=513) (actual time=2.423..71.116 rows=1,156 loops=1)

  • Join Filter: (a.cityid = tcp.cityid)
  • Rows Removed by Join Filter: 4
2. 1.619 67.408 ↓ 30.4 1,156 1

Nested Loop (cost=49.87..5,934.69 rows=38 width=491) (actual time=2.406..67.408 rows=1,156 loops=1)

3. 1.463 64.633 ↓ 30.4 1,156 1

Nested Loop (cost=49.59..5,917.76 rows=38 width=487) (actual time=2.395..64.633 rows=1,156 loops=1)

  • Join Filter: (ca.vendorid = cpt.vendorid)
4. 0.774 55.078 ↓ 30.4 1,156 1

Nested Loop Left Join (cost=49.17..5,897.68 rows=38 width=494) (actual time=2.353..55.078 rows=1,156 loops=1)

  • Join Filter: (ub.id = cr.upsellingcompanyid)
  • Rows Removed by Join Filter: 1,970
5. 2.012 54.304 ↓ 30.4 1,156 1

Nested Loop (cost=49.17..5,895.53 rows=38 width=489) (actual time=2.343..54.304 rows=1,156 loops=1)

  • Join Filter: (b.restaurantid = cr.restaurantid)
6. 1.697 49.980 ↓ 30.4 1,156 1

Nested Loop Left Join (cost=48.88..5,876.62 rows=38 width=426) (actual time=2.327..49.980 rows=1,156 loops=1)

7. 2.141 45.971 ↓ 30.4 1,156 1

Nested Loop (cost=48.59..5,858.26 rows=38 width=401) (actual time=2.312..45.971 rows=1,156 loops=1)

  • Join Filter: (ca.vendorid = bd.branchid)
8. 1.375 41.518 ↓ 30.4 1,156 1

Nested Loop (cost=48.30..5,830.01 rows=38 width=347) (actual time=2.299..41.518 rows=1,156 loops=1)

9. 1.759 37.831 ↓ 30.4 1,156 1

Nested Loop (cost=48.01..5,575.31 rows=38 width=311) (actual time=2.283..37.831 rows=1,156 loops=1)

  • Join Filter: (b.restaurantid = br.restaurantid)
10. 1.142 33.760 ↓ 28.2 1,156 1

Nested Loop (cost=47.72..5,557.09 rows=41 width=299) (actual time=2.268..33.760 rows=1,156 loops=1)

  • Join Filter: (b.restaurantid = r.id)
11. 1.382 29.015 ↓ 13.6 1,201 1

Nested Loop (cost=47.43..5,485.43 rows=88 width=172) (actual time=2.252..29.015 rows=1,201 loops=1)

12. 1.208 25.231 ↓ 13.6 1,201 1

Nested Loop (cost=47.14..5,446.87 rows=88 width=153) (actual time=2.239..25.231 rows=1,201 loops=1)

13. 18.021 19.871 ↓ 4.8 1,384 1

Bitmap Heap Scan on tlb_vendor_deliveryarea_polygon ca (cost=46.84..3,452.51 rows=288 width=55) (actual time=2.200..19.871 rows=1,384 loops=1)

  • Recheck Cond: (deliveryareapolygon ~ '0101000020E610000063B48EAA26A64B4018963FDF16383940'::geometry)
  • Filter: ((NOT isdeleted) AND _st_contains(deliveryareapolygon, '0101000020E610000063B48EAA26A64B4018963FDF16383940'::geometry))
  • Rows Removed by Filter: 1,707
  • Heap Blocks: exact=3,015
14. 1.850 1.850 ↓ 3.8 3,322 1

Bitmap Index Scan on tlb_vendor_deliveryarea_polygon_deliveryareapolygon_idx (cost=0.00..46.77 rows=865 width=0) (actual time=1.850..1.850 rows=3,322 loops=1)

  • Index Cond: (deliveryareapolygon ~ '0101000020E610000063B48EAA26A64B4018963FDF16383940'::geometry)
15. 4.152 4.152 ↑ 1.0 1 1,384

Index Scan using mwq_branch_pkey on mwq_branch b (cost=0.29..6.92 rows=1 width=98) (actual time=0.003..0.003 rows=1 loops=1,384)

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

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

  • Index Cond: (referenceid = b.restaurantid)
  • Filter: ((NOT isdeleted) AND (typeid = 1))
17. 3.603 3.603 ↑ 1.0 1 1,201

Index Scan using mwq_restaurant_pkey on mwq_restaurant r (cost=0.29..0.80 rows=1 width=127) (actual time=0.003..0.003 rows=1 loops=1,201)

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

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

  • Index Cond: (restaurantid = sl.referenceid)
  • Filter: (isactive AND (NOT isdeleted))
19. 2.312 2.312 ↑ 1.0 1 1,156

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

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

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

  • Index Cond: (branchid = b.id)
21. 2.312 2.312 ↑ 1.0 1 1,156

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

  • Index Cond: (b.id = vendorid)
22. 2.312 2.312 ↑ 1.0 1 1,156

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

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

Materialize (cost=0.00..1.03 rows=2 width=9) (actual time=0.000..0.000 rows=2 loops=1,156)

24. 0.003 0.003 ↑ 1.0 2 1

Seq Scan on tgb_upsellingcompany ub (cost=0.00..1.02 rows=2 width=9) (actual time=0.002..0.003 rows=2 loops=1)

25. 8.092 8.092 ↑ 1.0 1 1,156

Index Scan using tlb_vendor_timingstatus_vendorid_idx on tlb_vendor_timingstatus cpt (cost=0.42..0.52 rows=1 width=5) (actual time=0.007..0.007 rows=1 loops=1,156)

  • Index Cond: (vendorid = bd.branchid)
26. 1.156 1.156 ↑ 1.0 1 1,156

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

  • Index Cond: (id = b.areaid)
27. 2.312 2.312 ↑ 1.0 1 1,156

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

  • Index Cond: (r.id = chainid)
  • Filter: (NOT isdeleted)
  • Rows Removed by Filter: 0