explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oC9C

Settings
# exclusive inclusive rows x rows loops node
1. 1.643 64.799 ↓ 27.5 1,153 1

Nested Loop (cost=49.95..5,768.06 rows=42 width=513) (actual time=2.237..64.799 rows=1,153 loops=1)

  • Join Filter: (ca.vendorid = cpt.vendorid)
  • Buffers: shared hit=42,004
2. 1.166 60.850 ↓ 30.3 1,153 1

Nested Loop Left Join (cost=49.66..5,753.41 rows=38 width=500) (actual time=2.217..60.850 rows=1,153 loops=1)

  • Join Filter: (a.cityid = tcp.cityid)
  • Rows Removed by Join Filter: 4
  • Buffers: shared hit=38,531
3. 1.546 57.378 ↓ 30.3 1,153 1

Nested Loop (cost=49.37..5,738.24 rows=38 width=498) (actual time=2.198..57.378 rows=1,153 loops=1)

  • Buffers: shared hit=35,072
4. 0.862 54.679 ↓ 30.3 1,153 1

Nested Loop Left Join (cost=49.09..5,721.28 rows=38 width=494) (actual time=2.181..54.679 rows=1,153 loops=1)

  • Join Filter: (ub.id = cr.upsellingcompanyid)
  • Rows Removed by Join Filter: 1,966
  • Buffers: shared hit=31,613
5. 2.005 53.817 ↓ 30.3 1,153 1

Nested Loop (cost=49.09..5,719.13 rows=38 width=489) (actual time=2.171..53.817 rows=1,153 loops=1)

  • Join Filter: (b.restaurantid = cr.restaurantid)
  • Buffers: shared hit=31,612
6. 1.730 49.506 ↓ 30.3 1,153 1

Nested Loop Left Join (cost=48.80..5,700.43 rows=38 width=426) (actual time=2.155..49.506 rows=1,153 loops=1)

  • Buffers: shared hit=28,144
7. 1.118 45.470 ↓ 30.3 1,153 1

Nested Loop (cost=48.51..5,682.39 rows=38 width=401) (actual time=2.137..45.470 rows=1,153 loops=1)

  • Join Filter: (ca.vendorid = bd.branchid)
  • Buffers: shared hit=24,685
8. 1.397 40.893 ↓ 30.3 1,153 1

Nested Loop (cost=48.22..5,655.14 rows=38 width=347) (actual time=2.120..40.893 rows=1,153 loops=1)

  • Buffers: shared hit=21,217
9. 0.684 37.190 ↓ 30.3 1,153 1

Nested Loop (cost=47.92..5,401.62 rows=38 width=311) (actual time=2.104..37.190 rows=1,153 loops=1)

  • Join Filter: (b.restaurantid = br.restaurantid)
  • Buffers: shared hit=17,748
10. 1.099 33.047 ↓ 28.1 1,153 1

Nested Loop (cost=47.63..5,383.88 rows=41 width=299) (actual time=2.091..33.047 rows=1,153 loops=1)

  • Join Filter: (b.restaurantid = r.id)
  • Buffers: shared hit=14,281
11. 1.391 28.354 ↓ 13.8 1,198 1

Nested Loop (cost=47.34..5,313.41 rows=87 width=172) (actual time=2.078..28.354 rows=1,198 loops=1)

  • Buffers: shared hit=10,681
12. 1.116 24.567 ↓ 13.8 1,198 1

Nested Loop (cost=47.05..5,275.25 rows=87 width=153) (actual time=2.066..24.567 rows=1,198 loops=1)

  • Buffers: shared hit=7,084
13. 17.628 19.332 ↓ 4.8 1,373 1

Bitmap Heap Scan on tlb_vendor_deliveryarea_polygon ca (cost=46.76..3,409.83 rows=285 width=55) (actual time=2.027..19.332 rows=1,373 loops=1)

  • Recheck Cond: (deliveryareapolygon ~ '0101000020E610000063B48EAA26A64B4018963FDF16383940'::geometry)
  • Filter: ((NOT isdeleted) AND _st_contains(deliveryareapolygon, '0101000020E610000063B48EAA26A64B4018963FDF16383940'::geometry))
  • Rows Removed by Filter: 1,697
  • Heap Blocks: exact=2,814
  • Buffers: shared hit=2,962
14. 1.704 1.704 ↓ 3.6 3,075 1

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

  • Index Cond: (deliveryareapolygon ~ '0101000020E610000063B48EAA26A64B4018963FDF16383940'::geometry)
  • Buffers: shared hit=87
15. 4.119 4.119 ↑ 1.0 1 1,373

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

  • Index Cond: (id = ca.vendorid)
  • Filter: ((NOT isdeleted) AND istalabatgo AND (status = ANY ('{0,1,2}'::integer[])))
  • Rows Removed by Filter: 0
  • Buffers: shared hit=4,122
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))
  • Buffers: shared hit=3,597
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
  • Buffers: shared hit=3,600
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.002..0.003 rows=1 loops=1,153)

  • Index Cond: (restaurantid = sl.referenceid)
  • Filter: (isactive AND (NOT isdeleted))
  • Buffers: shared hit=3,467
19. 2.306 2.306 ↑ 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.002..0.002 rows=1 loops=1,153)

  • Index Cond: (id = ca.vendordeliveryareaid)
  • Filter: (deliveryareastatus = ANY ('{0,1,2}'::integer[]))
  • Buffers: shared hit=3,469
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.70 rows=1 width=54) (actual time=0.002..0.003 rows=1 loops=1,153)

  • Index Cond: (branchid = b.id)
  • Buffers: shared hit=3,468
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)
  • Buffers: shared hit=3,459
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=79) (actual time=0.002..0.002 rows=1 loops=1,153)

  • Index Cond: (restaurantid = sl.referenceid)
  • Buffers: shared hit=3,468
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)

  • Buffers: shared hit=1
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)

  • Buffers: shared hit=1
25. 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)
  • Buffers: shared hit=3,459
26. 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
  • Buffers: shared hit=3,459
27. 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=5) (actual time=0.002..0.002 rows=1 loops=1,153)

  • Index Cond: (vendorid = bd.branchid)
  • Buffers: shared hit=3,473