explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JGbER

Settings
# exclusive inclusive rows x rows loops node
1. 1.949 66.900 ↓ 27.5 1,153 1

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

  • Output: r.id, r.id, r.restaurantgroupid, r.thumbnail_en, r.name_en, r.name_en, r.acceptscash, r.acceptsknet, r.acceptscc, r.hasbranchmenu, r.ismixoffers, r.gotalabatlogo, r.isupsellrestaurant, r.iscokerestaurant, r.isupsellhighlight, r.activatedon, r.status, r.postdatedorder, r.maxorderroutinglimit, r.promotionsort, r.newsort, r.sortorder, r.acceptsbb, r.isgrlrequired, r.cateringavailable, b.id, b.status, b.routingmethod, b.forcemap, b.slug, b.id, b.name_en, b.acceptcardondelivery, b.istalabatgo, b.isprovidetracking, b.latitude, b.longtitude, b.areaid, bd.rating, bd.hascoupon, bd.hasmealdeal, bd.promotionicon_en, bd.activatedon, bd.ratingscount, bd.bestactivediscount_en, bd.moreactivediscount, bd.bestactivepromotion_en, bd.moreactivepromotion, bd.hascokecombomeals, bd.hasramadandeals, bd.hasvoucher, vda.deliveryareastatus, vda.minimumordervalue, (date_part('epoch'::text, vda.deliverytime) / '60'::double precision), vda.deliveryfeevalue, vda.deliveryfeetype, vda.municipalitytaxvalue, vda.municipalitytaxtype, vda.touristtaxtype, vda.touristtaxvalue, cr.alt_deliverycharge_txt_en, cr.alt_touristtax_txt_en, cr.alt_talabatcharge_txt_en, cr.alt_municipalitytax_txt_en, cr.cuisines_en, cr.campaignfilters, cr.verticaltype, cr.upsellingicon, cr.upsellingcompanyid, ca.shrinktags, br.hascoupon, br.hasmealdeal, br.includetaxondelivery, br.includetaxoncoupon, br.reviewscount, vdr.finalrank, vdr.finalrank, vdr.activationrank, vdr.vendorratingrank, vdr.ordersrank, vdr.failraterank, vdr.reorderrank, sl.slugtext, cpt.isinworkingtime, a.cityid, ub.upsellingcompany, cr.isdarkstore, tcp.median_price_tag
  • Inner Unique: true
  • Join Filter: (ca.vendorid = cpt.vendorid)
  • Buffers: shared hit=42,004
2. 1.239 62.645 ↓ 30.3 1,153 1

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

  • Output: ca.shrinktags, ca.vendorid, vda.deliveryareastatus, vda.minimumordervalue, vda.deliverytime, vda.deliveryfeevalue, vda.deliveryfeetype, vda.municipalitytaxvalue, vda.municipalitytaxtype, vda.touristtaxtype, vda.touristtaxvalue, b.id, b.status, b.routingmethod, b.forcemap, b.slug, b.name_en, b.acceptcardondelivery, b.istalabatgo, b.isprovidetracking, b.latitude, b.longtitude, b.areaid, bd.rating, bd.hascoupon, bd.hasmealdeal, bd.promotionicon_en, bd.activatedon, bd.ratingscount, bd.bestactivediscount_en, bd.moreactivediscount, bd.bestactivepromotion_en, bd.moreactivepromotion, bd.hascokecombomeals, bd.hasramadandeals, bd.hasvoucher, bd.branchid, vdr.finalrank, vdr.activationrank, vdr.vendorratingrank, vdr.ordersrank, vdr.failraterank, vdr.reorderrank, r.id, r.restaurantgroupid, r.thumbnail_en, r.name_en, r.acceptscash, r.acceptsknet, r.acceptscc, r.hasbranchmenu, r.ismixoffers, r.gotalabatlogo, r.isupsellrestaurant, r.iscokerestaurant, r.isupsellhighlight, r.activatedon, r.status, r.postdatedorder, r.maxorderroutinglimit, r.promotionsort, r.newsort, r.sortorder, r.acceptsbb, r.isgrlrequired, r.cateringavailable, sl.slugtext, br.hascoupon, br.hasmealdeal, br.includetaxondelivery, br.includetaxoncoupon, br.reviewscount, cr.alt_deliverycharge_txt_en, cr.alt_touristtax_txt_en, cr.alt_talabatcharge_txt_en, cr.alt_municipalitytax_txt_en, cr.cuisines_en, cr.campaignfilters, cr.verticaltype, cr.upsellingicon, cr.upsellingcompanyid, cr.isdarkstore, ub.upsellingcompany, a.cityid, tcp.median_price_tag
  • Inner Unique: true
  • Join Filter: (a.cityid = tcp.cityid)
  • Rows Removed by Join Filter: 4
  • Buffers: shared hit=38,531
3. 1.569 59.100 ↓ 30.3 1,153 1

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

  • Output: ca.shrinktags, ca.vendorid, vda.deliveryareastatus, vda.minimumordervalue, vda.deliverytime, vda.deliveryfeevalue, vda.deliveryfeetype, vda.municipalitytaxvalue, vda.municipalitytaxtype, vda.touristtaxtype, vda.touristtaxvalue, b.id, b.status, b.routingmethod, b.forcemap, b.slug, b.name_en, b.acceptcardondelivery, b.istalabatgo, b.isprovidetracking, b.latitude, b.longtitude, b.areaid, bd.rating, bd.hascoupon, bd.hasmealdeal, bd.promotionicon_en, bd.activatedon, bd.ratingscount, bd.bestactivediscount_en, bd.moreactivediscount, bd.bestactivepromotion_en, bd.moreactivepromotion, bd.hascokecombomeals, bd.hasramadandeals, bd.hasvoucher, bd.branchid, vdr.finalrank, vdr.activationrank, vdr.vendorratingrank, vdr.ordersrank, vdr.failraterank, vdr.reorderrank, r.id, r.restaurantgroupid, r.thumbnail_en, r.name_en, r.acceptscash, r.acceptsknet, r.acceptscc, r.hasbranchmenu, r.ismixoffers, r.gotalabatlogo, r.isupsellrestaurant, r.iscokerestaurant, r.isupsellhighlight, r.activatedon, r.status, r.postdatedorder, r.maxorderroutinglimit, r.promotionsort, r.newsort, r.sortorder, r.acceptsbb, r.isgrlrequired, r.cateringavailable, sl.slugtext, br.hascoupon, br.hasmealdeal, br.includetaxondelivery, br.includetaxoncoupon, br.reviewscount, cr.alt_deliverycharge_txt_en, cr.alt_touristtax_txt_en, cr.alt_talabatcharge_txt_en, cr.alt_municipalitytax_txt_en, cr.cuisines_en, cr.campaignfilters, cr.verticaltype, cr.upsellingicon, cr.upsellingcompanyid, cr.isdarkstore, ub.upsellingcompany, a.cityid
  • Inner Unique: true
  • Buffers: shared hit=35,072
4. 0.936 56.378 ↓ 30.3 1,153 1

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

  • Output: ca.shrinktags, ca.vendorid, vda.deliveryareastatus, vda.minimumordervalue, vda.deliverytime, vda.deliveryfeevalue, vda.deliveryfeetype, vda.municipalitytaxvalue, vda.municipalitytaxtype, vda.touristtaxtype, vda.touristtaxvalue, b.id, b.status, b.routingmethod, b.forcemap, b.slug, b.name_en, b.acceptcardondelivery, b.istalabatgo, b.isprovidetracking, b.latitude, b.longtitude, b.areaid, bd.rating, bd.hascoupon, bd.hasmealdeal, bd.promotionicon_en, bd.activatedon, bd.ratingscount, bd.bestactivediscount_en, bd.moreactivediscount, bd.bestactivepromotion_en, bd.moreactivepromotion, bd.hascokecombomeals, bd.hasramadandeals, bd.hasvoucher, bd.branchid, vdr.finalrank, vdr.activationrank, vdr.vendorratingrank, vdr.ordersrank, vdr.failraterank, vdr.reorderrank, r.id, r.restaurantgroupid, r.thumbnail_en, r.name_en, r.acceptscash, r.acceptsknet, r.acceptscc, r.hasbranchmenu, r.ismixoffers, r.gotalabatlogo, r.isupsellrestaurant, r.iscokerestaurant, r.isupsellhighlight, r.activatedon, r.status, r.postdatedorder, r.maxorderroutinglimit, r.promotionsort, r.newsort, r.sortorder, r.acceptsbb, r.isgrlrequired, r.cateringavailable, sl.slugtext, br.hascoupon, br.hasmealdeal, br.includetaxondelivery, br.includetaxoncoupon, br.reviewscount, cr.alt_deliverycharge_txt_en, cr.alt_touristtax_txt_en, cr.alt_talabatcharge_txt_en, cr.alt_municipalitytax_txt_en, cr.cuisines_en, cr.campaignfilters, cr.verticaltype, cr.upsellingicon, cr.upsellingcompanyid, cr.isdarkstore, ub.upsellingcompany
  • Inner Unique: true
  • Join Filter: (ub.id = cr.upsellingcompanyid)
  • Rows Removed by Join Filter: 1,966
  • Buffers: shared hit=31,613
5. 2.145 55.442 ↓ 30.3 1,153 1

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

  • Output: ca.shrinktags, ca.vendorid, vda.deliveryareastatus, vda.minimumordervalue, vda.deliverytime, vda.deliveryfeevalue, vda.deliveryfeetype, vda.municipalitytaxvalue, vda.municipalitytaxtype, vda.touristtaxtype, vda.touristtaxvalue, b.id, b.status, b.routingmethod, b.forcemap, b.slug, b.name_en, b.acceptcardondelivery, b.istalabatgo, b.isprovidetracking, b.latitude, b.longtitude, b.areaid, bd.rating, bd.hascoupon, bd.hasmealdeal, bd.promotionicon_en, bd.activatedon, bd.ratingscount, bd.bestactivediscount_en, bd.moreactivediscount, bd.bestactivepromotion_en, bd.moreactivepromotion, bd.hascokecombomeals, bd.hasramadandeals, bd.hasvoucher, bd.branchid, vdr.finalrank, vdr.activationrank, vdr.vendorratingrank, vdr.ordersrank, vdr.failraterank, vdr.reorderrank, r.id, r.restaurantgroupid, r.thumbnail_en, r.name_en, r.acceptscash, r.acceptsknet, r.acceptscc, r.hasbranchmenu, r.ismixoffers, r.gotalabatlogo, r.isupsellrestaurant, r.iscokerestaurant, r.isupsellhighlight, r.activatedon, r.status, r.postdatedorder, r.maxorderroutinglimit, r.promotionsort, r.newsort, r.sortorder, r.acceptsbb, r.isgrlrequired, r.cateringavailable, sl.slugtext, br.hascoupon, br.hasmealdeal, br.includetaxondelivery, br.includetaxoncoupon, br.reviewscount, cr.alt_deliverycharge_txt_en, cr.alt_touristtax_txt_en, cr.alt_talabatcharge_txt_en, cr.alt_municipalitytax_txt_en, cr.cuisines_en, cr.campaignfilters, cr.verticaltype, cr.upsellingicon, cr.upsellingcompanyid, cr.isdarkstore
  • Join Filter: (b.restaurantid = cr.restaurantid)
  • Buffers: shared hit=31,612
6. 1.915 50.991 ↓ 30.3 1,153 1

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

  • Output: ca.shrinktags, ca.vendorid, vda.deliveryareastatus, vda.minimumordervalue, vda.deliverytime, vda.deliveryfeevalue, vda.deliveryfeetype, vda.municipalitytaxvalue, vda.municipalitytaxtype, vda.touristtaxtype, vda.touristtaxvalue, b.id, b.status, b.routingmethod, b.forcemap, b.slug, b.name_en, b.acceptcardondelivery, b.istalabatgo, b.isprovidetracking, b.latitude, b.longtitude, b.areaid, b.restaurantid, bd.rating, bd.hascoupon, bd.hasmealdeal, bd.promotionicon_en, bd.activatedon, bd.ratingscount, bd.bestactivediscount_en, bd.moreactivediscount, bd.bestactivepromotion_en, bd.moreactivepromotion, bd.hascokecombomeals, bd.hasramadandeals, bd.hasvoucher, bd.branchid, vdr.finalrank, vdr.activationrank, vdr.vendorratingrank, vdr.ordersrank, vdr.failraterank, vdr.reorderrank, r.id, r.restaurantgroupid, r.thumbnail_en, r.name_en, r.acceptscash, r.acceptsknet, r.acceptscc, r.hasbranchmenu, r.ismixoffers, r.gotalabatlogo, r.isupsellrestaurant, r.iscokerestaurant, r.isupsellhighlight, r.activatedon, r.status, r.postdatedorder, r.maxorderroutinglimit, r.promotionsort, r.newsort, r.sortorder, r.acceptsbb, r.isgrlrequired, r.cateringavailable, sl.slugtext, sl.referenceid, br.hascoupon, br.hasmealdeal, br.includetaxondelivery, br.includetaxoncoupon, br.reviewscount, br.restaurantid
  • Inner Unique: true
  • Buffers: shared hit=28,144
7. 1.364 46.770 ↓ 30.3 1,153 1

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

  • Output: ca.shrinktags, ca.vendorid, vda.deliveryareastatus, vda.minimumordervalue, vda.deliverytime, vda.deliveryfeevalue, vda.deliveryfeetype, vda.municipalitytaxvalue, vda.municipalitytaxtype, vda.touristtaxtype, vda.touristtaxvalue, b.id, b.status, b.routingmethod, b.forcemap, b.slug, b.name_en, b.acceptcardondelivery, b.istalabatgo, b.isprovidetracking, b.latitude, b.longtitude, b.areaid, b.restaurantid, bd.rating, bd.hascoupon, bd.hasmealdeal, bd.promotionicon_en, bd.activatedon, bd.ratingscount, bd.bestactivediscount_en, bd.moreactivediscount, bd.bestactivepromotion_en, bd.moreactivepromotion, bd.hascokecombomeals, bd.hasramadandeals, bd.hasvoucher, bd.branchid, r.id, r.restaurantgroupid, r.thumbnail_en, r.name_en, r.acceptscash, r.acceptsknet, r.acceptscc, r.hasbranchmenu, r.ismixoffers, r.gotalabatlogo, r.isupsellrestaurant, r.iscokerestaurant, r.isupsellhighlight, r.activatedon, r.status, r.postdatedorder, r.maxorderroutinglimit, r.promotionsort, r.newsort, r.sortorder, r.acceptsbb, r.isgrlrequired, r.cateringavailable, sl.slugtext, sl.referenceid, br.hascoupon, br.hasmealdeal, br.includetaxondelivery, br.includetaxoncoupon, br.reviewscount, br.restaurantid
  • Join Filter: (ca.vendorid = bd.branchid)
  • Buffers: shared hit=24,685
8. 1.661 41.947 ↓ 30.3 1,153 1

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

  • Output: ca.shrinktags, ca.vendorid, vda.deliveryareastatus, vda.minimumordervalue, vda.deliverytime, vda.deliveryfeevalue, vda.deliveryfeetype, vda.municipalitytaxvalue, vda.municipalitytaxtype, vda.touristtaxtype, vda.touristtaxvalue, b.id, b.status, b.routingmethod, b.forcemap, b.slug, b.name_en, b.acceptcardondelivery, b.istalabatgo, b.isprovidetracking, b.latitude, b.longtitude, b.areaid, b.restaurantid, r.id, r.restaurantgroupid, r.thumbnail_en, r.name_en, r.acceptscash, r.acceptsknet, r.acceptscc, r.hasbranchmenu, r.ismixoffers, r.gotalabatlogo, r.isupsellrestaurant, r.iscokerestaurant, r.isupsellhighlight, r.activatedon, r.status, r.postdatedorder, r.maxorderroutinglimit, r.promotionsort, r.newsort, r.sortorder, r.acceptsbb, r.isgrlrequired, r.cateringavailable, sl.slugtext, sl.referenceid, br.hascoupon, br.hasmealdeal, br.includetaxondelivery, br.includetaxoncoupon, br.reviewscount, br.restaurantid
  • Inner Unique: true
  • Buffers: shared hit=21,217
9. 0.808 37.980 ↓ 30.3 1,153 1

Nested Loop (cost=47.92..5,401.61 rows=38 width=311) (actual time=2.142..37.980 rows=1,153 loops=1)

  • Output: ca.shrinktags, ca.vendordeliveryareaid, ca.vendorid, b.id, b.status, b.routingmethod, b.forcemap, b.slug, b.name_en, b.acceptcardondelivery, b.istalabatgo, b.isprovidetracking, b.latitude, b.longtitude, b.areaid, b.restaurantid, r.id, r.restaurantgroupid, r.thumbnail_en, r.name_en, r.acceptscash, r.acceptsknet, r.acceptscc, r.hasbranchmenu, r.ismixoffers, r.gotalabatlogo, r.isupsellrestaurant, r.iscokerestaurant, r.isupsellhighlight, r.activatedon, r.status, r.postdatedorder, r.maxorderroutinglimit, r.promotionsort, r.newsort, r.sortorder, r.acceptsbb, r.isgrlrequired, r.cateringavailable, sl.slugtext, sl.referenceid, br.hascoupon, br.hasmealdeal, br.includetaxondelivery, br.includetaxoncoupon, br.reviewscount, br.restaurantid
  • Join Filter: (b.restaurantid = br.restaurantid)
  • Buffers: shared hit=17,748
10. 1.186 33.713 ↓ 28.1 1,153 1

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

  • Output: ca.shrinktags, ca.vendordeliveryareaid, ca.vendorid, b.id, b.status, b.routingmethod, b.forcemap, b.slug, b.name_en, b.acceptcardondelivery, b.istalabatgo, b.isprovidetracking, b.latitude, b.longtitude, b.areaid, b.restaurantid, r.id, r.restaurantgroupid, r.thumbnail_en, r.name_en, r.acceptscash, r.acceptsknet, r.acceptscc, r.hasbranchmenu, r.ismixoffers, r.gotalabatlogo, r.isupsellrestaurant, r.iscokerestaurant, r.isupsellhighlight, r.activatedon, r.status, r.postdatedorder, r.maxorderroutinglimit, r.promotionsort, r.newsort, r.sortorder, r.acceptsbb, r.isgrlrequired, r.cateringavailable, sl.slugtext, sl.referenceid
  • Inner Unique: true
  • Join Filter: (b.restaurantid = r.id)
  • Buffers: shared hit=14,281
11. 1.584 28.933 ↓ 13.8 1,198 1

Nested Loop (cost=47.34..5,313.40 rows=87 width=172) (actual time=2.109..28.933 rows=1,198 loops=1)

  • Output: ca.shrinktags, ca.vendordeliveryareaid, ca.vendorid, b.id, b.status, b.routingmethod, b.forcemap, b.slug, b.name_en, b.acceptcardondelivery, b.istalabatgo, b.isprovidetracking, b.latitude, b.longtitude, b.areaid, b.restaurantid, sl.slugtext, sl.referenceid
  • Buffers: shared hit=10,681
12. 1.199 24.953 ↓ 13.8 1,198 1

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

  • Output: ca.shrinktags, ca.vendordeliveryareaid, ca.vendorid, b.id, b.status, b.routingmethod, b.forcemap, b.slug, b.name_en, b.acceptcardondelivery, b.istalabatgo, b.isprovidetracking, b.latitude, b.longtitude, b.areaid, b.restaurantid
  • Inner Unique: true
  • Buffers: shared hit=7,084
13. 17.908 19.635 ↓ 4.8 1,373 1

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

  • Output: ca.id, ca.vendorid, ca.vendordeliveryareaid, ca.deliveryareahash, ca.shrinktags, ca.deliveryareapolygon, ca.isdeleted, ca.createdon, ca.lastupdatedon
  • Recheck Cond: (ca.deliveryareapolygon ~ '0101000020E610000063B48EAA26A64B4018963FDF16383940'::geometry)
  • Filter: ((NOT ca.isdeleted) AND _st_contains(ca.deliveryareapolygon, '0101000020E610000063B48EAA26A64B4018963FDF16383940'::geometry))
  • Rows Removed by Filter: 1,697
  • Heap Blocks: exact=2,814
  • Buffers: shared hit=2,962
14. 1.727 1.727 ↓ 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.727..1.727 rows=3,075 loops=1)

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

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

  • Output: b.id, b.restaurantid, b.areaid, b.description, b.phone, b.fax, b.faxbackup, b.status, b.routingmethod, b.localesetting, b.isdeleted, b.lastupdated, b.createdon, b.email, b.iscouponavailable, b.ismealdealavailable, b.followupno, b.address, b.acceptsdc, b.acceptscc, b.postdatedorder, b.acceptcardondelivery, b.name_en, b.name_ar, b.preorderdays, b.notes, b.deliverynoteen, b.deliverynotear, b.taxflag, b.wlapendtime, b.alternateroutingmethod, b.latitude, b.longtitude, b.forcemap, b.istalabatgo, b.isprovidetracking, b.isprovideorderstatus, b.isprovideorderstatusnotification, b.salesforceid, b.ismixgemdiscount, b.ishaspolygons, b.slug, b.maplocation
  • Index Cond: (b.id = ca.vendorid)
  • Filter: ((NOT b.isdeleted) AND b.istalabatgo AND (b.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 public.tlb_slug sl (cost=0.29..0.43 rows=1 width=19) (actual time=0.002..0.002 rows=1 loops=1,198)

  • Output: sl.id, sl.referenceid, sl.typeid, sl.slugtext, sl.cityid, sl.brandtype, sl.countryid, sl.createdon, sl.lastupdatedon, sl.isactive, sl.isdeleted, sl.restaurantgroupid
  • Index Cond: (sl.referenceid = b.restaurantid)
  • Filter: ((NOT sl.isdeleted) AND (sl.typeid = 1))
  • Buffers: shared hit=3,597
17. 3.594 3.594 ↑ 1.0 1 1,198

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

  • Output: r.id, r.oldcode, r.name, r.countryid, r.restaurantgroupid, r.summary, r.description, r.thumbnail, r.url, r.cateringavailable, r.inloyaltyprogram, r.acceptsknet, r.acceptscc, r.maxorderroutinglimit, r.talabatcommission, r.commissiontype, r.maximumcommission, r.annualfees, r.postdatedorder, r.promotionsort, r.newsort, r.minimumorderamount, r.discounttype, r.discount, r.cateringacceptsknet, r.cateringacceptscc, r.status, r.sortorder, r.isdeleted, r.lastupdated, r.createdon, r.activatedon, r.hasmunicipalitytax, r.typeid, r.isautodescription, r.autocapitalletters, r.sortorderfavorite, r.canrectrackorderrequest, r.iscouponavailable, r.refname, r.rating, r.restdivcode, r.ismealdealavailable, r.acceptsccondel, r.ccdelterms, r.checkoutdisclaimer, r.ismixoffers, r.offersautoselection, r.acceptsbb, r.couponsort, r.hasbranchmenu, r.acceptsboloro, r.name_en, r.name_ar, r.thumbnail_en, r.thumbnail_ar, r.description_en, r.description_ar, r.delinquencyflagvalue, r.checkoutdisclaimer_en, r.checkoutdisclaimer_ar, r.refname_en, r.refname_ar, r.menudesc_en, r.menudesc_ar, r.acceptscash, r.istalabatdelivery, r.gotalabatlogo, r.isupsellrestaurant, r.iscokerestaurant, r.isupsellhighlight, r.salesforceid, r.autoacceptorders, r.isgrlrequired
  • Index Cond: (r.id = sl.referenceid)
  • Filter: ((NOT r.isdeleted) AND (r.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 public.tlb_restaurant_brand br (cost=0.29..0.42 rows=1 width=12) (actual time=0.002..0.003 rows=1 loops=1,153)

  • Output: br.id, br.restaurantid, br.brandtype, br.promotionicon, br.activedon, br.deactivatedon, br.isactive, br.createdon, br.lastupdatedon, br.isdeleted, br.commissiontype, br.commission, br.currentpendingcommission, br.includedelchincommision, br.hasmealdeal, br.hascoupon, br.subcommissiontype, br.ratings, br.includetaxondelivery, br.includetaxoncoupon, br.reviewscount, br.ratingscount, br.excludetaxfromcomm, br.packagingrating, br.deliveryrating, br.valuerating, br.qualityrating, br.registrationfees, br.renewalfees, br.contractstartdate, br.contractenddate, br.talabatletter, br.legalcontract, br.originalcopy, br.signatures, br.fakeordercommissiontype, br.fakeordercommission, br.activationdate, br.inactivationdate, br.axcode, br.refcode, br.istgopaidbyrestaurant, br.vatenabled, br.ibanavailable
  • Index Cond: (br.restaurantid = sl.referenceid)
  • Filter: (br.isactive AND (NOT br.isdeleted))
  • Buffers: shared hit=3,467
19. 2.306 2.306 ↑ 1.0 1 1,153

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

  • Output: vda.id, vda.vendorid, vda.porygondeliveryareaid, vda.deliveryareastatus, vda.deliveryfeetype, vda.deliveryfeevalue, vda.minimumordervalue, vda.deliverytime, vda.municipalitytaxtype, vda.municipalitytaxvalue, vda.touristtaxtype, vda.touristtaxvalue, vda.isdeleted, vda.createdon, vda.lastupdatedon
  • Index Cond: (vda.id = ca.vendordeliveryareaid)
  • Filter: (vda.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 public.tlb_branch_details bd (cost=0.29..0.70 rows=1 width=54) (actual time=0.003..0.003 rows=1 loops=1,153)

  • Output: bd.id, bd.branchid, bd.brandtype, bd.rating, bd.acceptpreorderonclosed, bd.promotionicon, bd.summary, bd.activatedon, bd.deactivatedon, bd.createdon, bd.lastupdated, bd.commissiontype, bd.maximumcommission, bd.brandcommission, bd.promotionicon_en, bd.promotionicon_ar, bd.deliverynoteen, bd.deliverynotear, bd.hasmealdeal, bd.hascoupon, bd.reviewscount, bd.ratingscount, bd.showmapinwla, bd.bestactivediscount_en, bd.bestactivediscount_ar, bd.moreactivediscount, bd.bestactivepromotion_en, bd.bestactivepromotion_ar, bd.moreactivepromotion, bd.hascokecombomeals, bd.hasramadandeals, bd.hasvoucher, bd.vatinclusive, bd.vatenabled, bd.vatpercentage, bd.altdeliverychargetxt_en, bd.altdeliverychargetxt_ar, bd.ismiddleware, bd.contactlessdelivery, bd.tgopromptvendorconfirmation, bd.preorderminutes, bd.hideinlisting
  • Index Cond: (bd.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 public.tlb_vendor_dynamicrank vdr (cost=0.29..0.47 rows=1 width=29) (actual time=0.002..0.002 rows=1 loops=1,153)

  • Output: vdr.id, vdr.vendorid, vdr.finalrank, vdr.createdon, vdr.lastupdatedon, vdr.activatedon, vdr.totaldays, vdr.activationrank, vdr.avgrating, vdr.vendorratingrank, vdr.totalorders, vdr.ordersrank, vdr.failedorders, vdr.failraterank, vdr.uniquecustomers, vdr.reorderrank
  • Index Cond: (b.id = vdr.vendorid)
  • Buffers: shared hit=3,459
22. 2.306 2.306 ↑ 1.0 1 1,153

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

  • Output: cr.id, cr.restaurantid, cr.hasthermalprinter, cr.alt_deliverycharge_txt, cr.alt_touristtax_txt, cr.alt_municipalitytax_txt, cr.alt_talabatcharge_txt, cr.billingemail, cr.address, cr.includedelchincommision, cr.deliverynotes, cr.deliverytimeflag, cr.restclassid, cr.alt_deliverycharge_txt_en, cr.alt_deliverycharge_txt_ar, cr.alt_touristtax_txt_en, cr.alt_touristtax_txt_ar, cr.alt_municipalitytax_txt_en, cr.alt_municipalitytax_txt_ar, cr.alt_talabatcharge_txt_en, cr.alt_talabatcharge_txt_ar, cr.isshowtopbanner, cr.restbackimgar, cr.restbackimgen, cr.restspecialimgen, cr.restspecialimgar, cr.cuisines_en, cr.cuisines_ar, cr.hasivr, cr.cocacolatext_en, cr.cocacolatext_ar, cr.upsellingicon, cr.lastupdated, cr.keyaccount, cr.enableamp, cr.campaignfilters, cr.verticaltype, cr.upsellingcompanyid, cr.isdarkstore, cr.excludeevents, cr.listingfilters_txt_ar, cr.listingfilters_txt_en
  • Index Cond: (cr.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)

  • Output: ub.upsellingcompany, ub.id
  • Buffers: shared hit=1
24. 0.003 0.003 ↑ 1.0 2 1

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

  • Output: ub.upsellingcompany, ub.id
  • Buffers: shared hit=1
25. 1.153 1.153 ↑ 1.0 1 1,153

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

  • Output: a.id, a.oldid, a.cityid, a.name, a.status, a.isdeleted, a.lastupdated, a.createdon, a.name_en, a.name_ar, a.polygon, a.polygoncenter, a.isdisabled, a.ismapenabled, a.isgrlarea, a.modifieddateutc
  • Index Cond: (a.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 public.tlb_chain_pricetags tcp (cost=0.29..0.39 rows=1 width=10) (actual time=0.002..0.002 rows=1 loops=1,153)

  • Output: tcp.id, tcp.chainid, tcp.countryid, tcp.cityid, tcp.cuisine_name, tcp.chain_name, tcp.chain_avg, tcp.chain_median, tcp.cuisine_avg, tcp.cuisine_median, tcp.avg_ratio, tcp.median_ratio, tcp.median_percentile_rank, tcp.median_price_tag, tcp.isdeleted, tcp.createdon, tcp.lastupdatedon
  • Index Cond: (r.id = tcp.chainid)
  • Filter: (NOT tcp.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 public.tlb_vendor_timingstatus cpt (cost=0.29..0.37 rows=1 width=5) (actual time=0.002..0.002 rows=1 loops=1,153)

  • Output: cpt.vendorid, cpt.countryid, cpt.isinworkingtime, cpt.nextworktimechange, cpt.dayofwork
  • Index Cond: (cpt.vendorid = bd.branchid)
  • Buffers: shared hit=3,473