explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lYW3

Settings
# exclusive inclusive rows x rows loops node
1. 1.291 65.556 ↓ 30.3 1,153 1

Nested Loop Left Join (cost=49.95..5,768.35 rows=38 width=557) (actual time=2.209..65.556 rows=1,153 loops=1)

  • Join Filter: (a.cityid = tcp.cityid)
  • Rows Removed by Join Filter: 4
2. 1.539 61.959 ↓ 30.3 1,153 1

Nested Loop (cost=49.67..5,752.99 rows=38 width=535) (actual time=2.187..61.959 rows=1,153 loops=1)

3. 1.574 59.267 ↓ 30.3 1,153 1

Nested Loop (cost=49.38..5,736.04 rows=38 width=531) (actual time=2.172..59.267 rows=1,153 loops=1)

  • Join Filter: (ca.vendorid = cpt.vendorid)
4. 0.849 55.387 ↓ 30.3 1,153 1

Nested Loop Left Join (cost=49.09..5,721.58 rows=38 width=528) (actual time=2.155..55.387 rows=1,153 loops=1)

  • Join Filter: (ub.id = cr.upsellingcompanyid)
  • Rows Removed by Join Filter: 1,966
5. 1.965 54.538 ↓ 30.3 1,153 1

Nested Loop (cost=49.09..5,719.44 rows=38 width=523) (actual time=2.146..54.538 rows=1,153 loops=1)

  • Join Filter: (b.restaurantid = cr.restaurantid)
6. 1.682 50.267 ↓ 30.3 1,153 1

Nested Loop Left Join (cost=48.80..5,700.74 rows=38 width=433) (actual time=2.129..50.267 rows=1,153 loops=1)

7. 1.545 46.279 ↓ 30.3 1,153 1

Nested Loop (cost=48.51..5,682.69 rows=38 width=408) (actual time=2.112..46.279 rows=1,153 loops=1)

  • Join Filter: (ca.vendorid = bd.branchid)
8. 0.891 41.275 ↓ 30.3 1,153 1

Nested Loop (cost=48.22..5,655.36 rows=38 width=348) (actual time=2.098..41.275 rows=1,153 loops=1)

9. 0.955 36.925 ↓ 30.3 1,153 1

Nested Loop (cost=47.92..5,401.84 rows=38 width=312) (actual time=2.083..36.925 rows=1,153 loops=1)

  • Join Filter: (b.restaurantid = br.restaurantid)
10. 1.093 32.511 ↓ 28.1 1,153 1

Nested Loop (cost=47.63..5,384.10 rows=41 width=300) (actual time=2.067..32.511 rows=1,153 loops=1)

  • Join Filter: (b.restaurantid = r.id)
11. 1.390 27.824 ↓ 13.8 1,198 1

Nested Loop (cost=47.34..5,313.58 rows=87 width=173) (actual time=2.053..27.824 rows=1,198 loops=1)

12. 0.794 24.038 ↓ 13.8 1,198 1

Nested Loop (cost=47.05..5,275.43 rows=87 width=154) (actual time=2.042..24.038 rows=1,198 loops=1)

13. 17.434 19.116 ↓ 4.8 1,376 1

Bitmap Heap Scan on tlb_vendor_deliveryarea_polygon ca (cost=46.76..3,410.01 rows=285 width=55) (actual time=2.005..19.116 rows=1,376 loops=1)

  • Recheck Cond: (deliveryareapolygon ~ '0101000020E610000063B48EAA26A64B4018963FDF16383940'::geometry)
  • Filter: ((NOT isdeleted) AND _st_contains(deliveryareapolygon, '0101000020E610000063B48EAA26A64B4018963FDF16383940'::geometry))
  • Rows Removed by Filter: 1,699
  • Heap Blocks: exact=2,823
14. 1.682 1.682 ↓ 3.6 3,086 1

Bitmap Index Scan on tlb_vendor_deliveryarea_polygon_deliveryareapolygon_idx (cost=0.00..46.69 rows=854 width=0) (actual time=1.682..1.682 rows=3,086 loops=1)

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

Index Scan using mwq_branch_pkey on mwq_branch b (cost=0.29..6.55 rows=1 width=99) (actual time=0.003..0.003 rows=1 loops=1,376)

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

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

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

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

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

Index Scan using tlb_restaurant_brand_restaurantid_idx on tlb_restaurant_brand br (cost=0.29..0.42 rows=1 width=12) (actual time=0.003..0.003 rows=1 loops=1,153)

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

Index Scan using tlb_vendor_deliveryarea_pk on tlb_vendor_deliveryarea vda (cost=0.29..6.67 rows=1 width=52) (actual time=0.003..0.003 rows=1 loops=1,153)

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

Index Scan using tlb_branch_details_branchid_idx on tlb_branch_details bd (cost=0.29..0.71 rows=1 width=60) (actual time=0.003..0.003 rows=1 loops=1,153)

  • Index Cond: (branchid = b.id)
  • Filter: (hideinlisting IS NOT TRUE)
21. 2.306 2.306 ↑ 1.0 1 1,153

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

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

Index Scan using "tlb_CommonRestuarantFields_restid_idx" on tlb_commonrestuarantfields cr (cost=0.29..0.48 rows=1 width=106) (actual time=0.002..0.002 rows=1 loops=1,153)

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

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

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. 2.306 2.306 ↑ 1.0 1 1,153

Index Scan using tlb_vendor_timingstatus_vendorid_idx on tlb_vendor_timingstatus cpt (cost=0.29..0.37 rows=1 width=15) (actual time=0.002..0.002 rows=1 loops=1,153)

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

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

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

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

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