explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vTt4v

Settings
# exclusive inclusive rows x rows loops node
1. 4.509 157.510 ↓ 58.0 522 1

Nested Loop (cost=2.52..28,217.26 rows=9 width=584) (actual time=0.178..157.510 rows=522 loops=1)

  • Output: r.id, (date_part('epoch'::text, ca.delivery_time) / '60'::double precision), date_part('minutes'::text, ca.delivery_time), r.restaurantgroupid, r.thumbnail_en, r.name_en, r.name_en, r.acceptscash, r.acceptsknet, r.acceptscc, r.hasbranchmenu, r.istalabatdelivery, r.ismixoffers, r.gotalabatlogo, r.isupsellrestaurant, r.iscokerestaurant, r.isupsellhighlight, r.activatedon, r.status, r.postdatedorder, r.countryid, r.maxorderroutinglimit, r.promotionsort, r.newsort, r.sortorder, r.acceptsbb, r.isgrlrequired, 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, ca.coveragepolygonstatus, ca.minimum_order_value, date_part('Minute'::text, ca.delivery_time), ca.delivery_fee_value, ca.delivery_fee_type, ca.talabatcharges, ca.municipalitytax, ca.municipalitytaxtype, ca.touristtaxtype, ca.touristtax, 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, br.hascoupon, br.hasmealdeal, br.includetaxondelivery, br.includetaxoncoupon, br.reviewscount, sl.slugtext, cpt.isinworkingtime, a.cityid, ub.upsellingcompany
2. 1.876 150.391 ↓ 58.0 522 1

Nested Loop (cost=2.24..28,213.22 rows=9 width=554) (actual time=0.165..150.391 rows=522 loops=1)

  • Output: ca.delivery_time, ca.coveragepolygonstatus, ca.minimum_order_value, ca.delivery_fee_value, ca.delivery_fee_type, ca.talabatcharges, ca.municipalitytax, ca.municipalitytaxtype, ca.touristtaxtype, ca.touristtax, 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, r.id, r.restaurantgroupid, r.thumbnail_en, r.name_en, r.acceptscash, r.acceptsknet, r.acceptscc, r.hasbranchmenu, r.istalabatdelivery, r.ismixoffers, r.gotalabatlogo, r.isupsellrestaurant, r.iscokerestaurant, r.isupsellhighlight, r.activatedon, r.status, r.postdatedorder, r.countryid, r.maxorderroutinglimit, r.promotionsort, r.newsort, r.sortorder, r.acceptsbb, r.isgrlrequired, 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, ub.upsellingcompany, cpt.isinworkingtime
  • Join Filter: (ca.vendor_id = cpt.vendor_id)
3. 3.587 144.339 ↓ 58.0 522 1

Nested Loop Left Join (cost=1.95..28,209.97 rows=9 width=565) (actual time=0.157..144.339 rows=522 loops=1)

  • Output: ca.delivery_time, ca.coveragepolygonstatus, ca.minimum_order_value, ca.delivery_fee_value, ca.delivery_fee_type, ca.talabatcharges, ca.municipalitytax, ca.municipalitytaxtype, ca.touristtaxtype, ca.touristtax, ca.vendor_id, 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, r.id, r.restaurantgroupid, r.thumbnail_en, r.name_en, r.acceptscash, r.acceptsknet, r.acceptscc, r.hasbranchmenu, r.istalabatdelivery, r.ismixoffers, r.gotalabatlogo, r.isupsellrestaurant, r.iscokerestaurant, r.isupsellhighlight, r.activatedon, r.status, r.postdatedorder, r.countryid, r.maxorderroutinglimit, r.promotionsort, r.newsort, r.sortorder, r.acceptsbb, r.isgrlrequired, 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, ub.upsellingcompany
  • Join Filter: (ub.id = cr.upsellingcompanyid)
  • Rows Removed by Join Filter: 937
4. 3.865 139.708 ↓ 58.0 522 1

Nested Loop (cost=1.95..28,208.67 rows=9 width=447) (actual time=0.140..139.708 rows=522 loops=1)

  • Output: ca.delivery_time, ca.coveragepolygonstatus, ca.minimum_order_value, ca.delivery_fee_value, ca.delivery_fee_type, ca.talabatcharges, ca.municipalitytax, ca.municipalitytaxtype, ca.touristtaxtype, ca.touristtax, ca.vendor_id, 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, r.id, r.restaurantgroupid, r.thumbnail_en, r.name_en, r.acceptscash, r.acceptsknet, r.acceptscc, r.hasbranchmenu, r.istalabatdelivery, r.ismixoffers, r.gotalabatlogo, r.isupsellrestaurant, r.iscokerestaurant, r.isupsellhighlight, r.activatedon, r.status, r.postdatedorder, r.countryid, r.maxorderroutinglimit, r.promotionsort, r.newsort, r.sortorder, r.acceptsbb, r.isgrlrequired, 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
5. 0.848 130.623 ↓ 58.0 522 1

Nested Loop (cost=1.54..28,174.87 rows=9 width=405) (actual time=0.132..130.623 rows=522 loops=1)

  • Output: ca.delivery_time, ca.coveragepolygonstatus, ca.minimum_order_value, ca.delivery_fee_value, ca.delivery_fee_type, ca.talabatcharges, ca.municipalitytax, ca.municipalitytaxtype, ca.touristtaxtype, ca.touristtax, ca.vendor_id, 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.istalabatdelivery, r.ismixoffers, r.gotalabatlogo, r.isupsellrestaurant, r.iscokerestaurant, r.isupsellhighlight, r.activatedon, r.status, r.postdatedorder, r.countryid, r.maxorderroutinglimit, r.promotionsort, r.newsort, r.sortorder, r.acceptsbb, r.isgrlrequired, sl.slugtext, sl.referenceid, br.hascoupon, br.hasmealdeal, br.includetaxondelivery, br.includetaxoncoupon, br.reviewscount, br.restaurantid
6. 1.540 126.643 ↓ 58.0 522 1

Nested Loop (cost=1.26..28,171.76 rows=9 width=387) (actual time=0.125..126.643 rows=522 loops=1)

  • Output: ca.delivery_time, ca.coveragepolygonstatus, ca.minimum_order_value, ca.delivery_fee_value, ca.delivery_fee_type, ca.talabatcharges, ca.municipalitytax, ca.municipalitytaxtype, ca.touristtaxtype, ca.touristtax, ca.vendor_id, 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.istalabatdelivery, r.ismixoffers, r.gotalabatlogo, r.isupsellrestaurant, r.iscokerestaurant, r.isupsellhighlight, r.activatedon, r.status, r.postdatedorder, r.countryid, r.maxorderroutinglimit, r.promotionsort, r.newsort, r.sortorder, r.acceptsbb, r.isgrlrequired, br.hascoupon, br.hasmealdeal, br.includetaxondelivery, br.includetaxoncoupon, br.reviewscount, br.restaurantid
7. 2.974 122.493 ↓ 52.2 522 1

Nested Loop (cost=0.98..28,167.91 rows=10 width=375) (actual time=0.119..122.493 rows=522 loops=1)

  • Output: ca.delivery_time, ca.coveragepolygonstatus, ca.minimum_order_value, ca.delivery_fee_value, ca.delivery_fee_type, ca.talabatcharges, ca.municipalitytax, ca.municipalitytaxtype, ca.touristtaxtype, ca.touristtax, ca.vendor_id, 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.istalabatdelivery, r.ismixoffers, r.gotalabatlogo, r.isupsellrestaurant, r.iscokerestaurant, r.isupsellhighlight, r.activatedon, r.status, r.postdatedorder, r.countryid, r.maxorderroutinglimit, r.promotionsort, r.newsort, r.sortorder, r.acceptsbb, r.isgrlrequired
8. 5.419 116.375 ↓ 30.8 524 1

Nested Loop (cost=0.70..28,155.90 rows=17 width=257) (actual time=0.111..116.375 rows=524 loops=1)

  • Output: ca.delivery_time, ca.coveragepolygonstatus, ca.minimum_order_value, ca.delivery_fee_value, ca.delivery_fee_type, ca.talabatcharges, ca.municipalitytax, ca.municipalitytaxtype, ca.touristtaxtype, ca.touristtax, ca.vendor_id, 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
  • Join Filter: (ca.vendor_id = b.id)
9. 4.161 107.288 ↓ 27.6 524 1

Nested Loop (cost=0.41..28,147.04 rows=19 width=170) (actual time=0.099..107.288 rows=524 loops=1)

  • Output: ca.delivery_time, ca.coveragepolygonstatus, ca.minimum_order_value, ca.delivery_fee_value, ca.delivery_fee_type, ca.talabatcharges, ca.municipalitytax, ca.municipalitytaxtype, ca.touristtaxtype, ca.touristtax, ca.vendor_id, 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
10. 97.352 97.352 ↓ 27.6 525 1

Seq Scan on public.tlb_vendordelivery_area ca (cost=0.00..27,986.68 rows=19 width=104) (actual time=0.087..97.352 rows=525 loops=1)

  • Output: ca.id, ca.vendor_id, ca.coveragepolygonstatus, ca.delivery_fee_type, ca.delivery_fee_value, ca.minimum_order_value, ca.delivery_time, ca.shrinking, ca.talabatcharges, ca.municipalitytax, ca.municipalitytaxtype, ca.touristtaxtype, ca.touristtax, ca.coverage_polygon, ca.isdeleted, ca.createdon, ca.lastupdatedon
  • Filter: ((NOT ca.isdeleted) AND (ca.coverage_polygon ~ '0101000020E6100000429770E82D0A48405376FA415D4C3D40'::geometry) AND (ca.coveragepolygonstatus = ANY ('{0,1,2}'::integer[])) AND _st_contains(ca.coverage_polygon, '0101000020E6100000429770E82D0A48405376FA415D4C3D40'::geometry))
  • Rows Removed by Filter: 80289
11. 5.775 5.775 ↑ 1.0 1 525

Index Scan using tlb_branch_details_branchid_brndtype_idx on public.tlb_branch_details bd (cost=0.41..8.43 rows=1 width=66) (actual time=0.010..0.011 rows=1 loops=525)

  • 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
  • Index Cond: (bd.branchid = ca.vendor_id)
12. 3.668 3.668 ↑ 1.0 1 524

Index Scan using mwq_branch_pkey on public.mwq_branch b (cost=0.29..0.45 rows=1 width=87) (actual time=0.007..0.007 rows=1 loops=524)

  • 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
  • Index Cond: (b.id = bd.branchid)
  • Filter: ((NOT b.isdeleted) AND (b.status = ANY ('{0,1,2}'::integer[])))
13. 3.144 3.144 ↑ 1.0 1 524

Index Scan using mwq_restaurant_pkey on public.mwq_restaurant r (cost=0.28..0.70 rows=1 width=118) (actual time=0.006..0.006 rows=1 loops=524)

  • 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 = b.restaurantid)
  • Filter: ((NOT r.isdeleted) AND (NOT r.isdeleted) AND (r.status = ANY ('{0,1,2}'::integer[])))
  • Rows Removed by Filter: 0
14. 2.610 2.610 ↑ 1.0 1 522

Index Scan using tlb_restaurant_brand_rest_brand_idx on public.tlb_restaurant_brand br (cost=0.28..0.38 rows=1 width=12) (actual time=0.005..0.005 rows=1 loops=522)

  • 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 = b.restaurantid)
  • Filter: (br.isactive AND (NOT br.isdeleted))
15. 3.132 3.132 ↑ 1.0 1 522

Index Scan using tlb_slug_referenceid_idx on public.tlb_slug sl (cost=0.28..0.33 rows=1 width=18) (actual time=0.005..0.006 rows=1 loops=522)

  • 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))
16. 5.220 5.220 ↑ 1.0 1 522

Index Scan using "tlb_CommonRestuarantFields_restid_idx" on public.tlb_commonrestuarantfields cr (cost=0.41..3.75 rows=1 width=58) (actual time=0.008..0.010 rows=1 loops=522)

  • 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
  • Index Cond: (cr.restaurantid = b.restaurantid)
17. 1.040 1.044 ↑ 1.0 2 522

Materialize (cost=0.00..1.03 rows=2 width=122) (actual time=0.001..0.002 rows=2 loops=522)

  • Output: ub.upsellingcompany, ub.id
18. 0.004 0.004 ↑ 1.0 2 1

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

  • Output: ub.upsellingcompany, ub.id
19. 4.176 4.176 ↑ 1.0 1 522

Index Scan using tlb_vendor_timingstatus_pkey on public.tlb_vendor_timingstatus cpt (cost=0.29..0.35 rows=1 width=5) (actual time=0.007..0.008 rows=1 loops=522)

  • Output: cpt.vendor_id, cpt.countryid, cpt.isinworkingtime, cpt.nextworktimechange, cpt.dayofwork
  • Index Cond: (cpt.vendor_id = bd.branchid)
20. 2.610 2.610 ↑ 1.0 1 522

Index Scan using mwq_area_pkey on public.mwq_area a (cost=0.28..0.43 rows=1 width=8) (actual time=0.004..0.005 rows=1 loops=522)

  • 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
  • Index Cond: (a.id = b.areaid)
Planning time : 6.483 ms
Execution time : 158.302 ms