explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oWJD

Settings
# exclusive inclusive rows x rows loops node
1. 0.841 24.191 ↓ 517.0 517 1

Nested Loop (cost=5.43..264.37 rows=1 width=1,054) (actual time=0.395..24.191 rows=517 loops=1)

2. 0.461 22.316 ↓ 517.0 517 1

Nested Loop (cost=5.14..264.00 rows=1 width=1,024) (actual time=0.385..22.316 rows=517 loops=1)

  • Join Filter: (ca.vendor_id = cpt.vendorid)
3. 0.851 20.304 ↓ 517.0 517 1

Nested Loop Left Join (cost=4.86..263.58 rows=1 width=1,035) (actual time=0.377..20.304 rows=517 loops=1)

4. 0.725 19.453 ↓ 517.0 517 1

Nested Loop (cost=4.72..263.42 rows=1 width=917) (actual time=0.374..19.453 rows=517 loops=1)

  • Join Filter: (b.restaurantid = br.restaurantid)
5. 1.181 17.177 ↓ 517.0 517 1

Nested Loop (cost=4.43..263.08 rows=1 width=921) (actual time=0.367..17.177 rows=517 loops=1)

  • Join Filter: (b.restaurantid = r.id)
6. 0.889 14.439 ↓ 519.0 519 1

Nested Loop (cost=4.15..262.69 rows=1 width=803) (actual time=0.359..14.439 rows=519 loops=1)

7. 0.704 11.474 ↓ 519.0 519 1

Nested Loop (cost=3.74..260.60 rows=1 width=745) (actual time=0.352..11.474 rows=519 loops=1)

  • Join Filter: (ca.vendor_id = bd.branchid)
8. 0.487 9.213 ↓ 519.0 519 1

Nested Loop (cost=3.45..260.25 rows=1 width=679) (actual time=0.345..9.213 rows=519 loops=1)

9. 0.956 7.169 ↓ 30.5 519 1

Nested Loop (cost=3.18..253.38 rows=17 width=159) (actual time=0.338..7.169 rows=519 loops=1)

10. 4.419 4.653 ↓ 27.4 520 1

Bitmap Heap Scan on tlb_vendordelivery_area ca (cost=2.89..177.56 rows=19 width=72) (actual time=0.325..4.653 rows=520 loops=1)

  • Recheck Cond: (coverage_polygon ~ '0101000020E6100000429770E82D0A48405376FA415D4C3D40'::geometry)
  • Filter: ((NOT isdeleted) AND (coveragepolygonstatus = ANY ('{0,1,2}'::integer[])) AND _st_contains(coverage_polygon, '0101000020E6100000429770E82D0A48405376FA415D4C3D40'::geometry))
  • Rows Removed by Filter: 326
  • Heap Blocks: exact=776
11. 0.234 0.234 ↓ 10.4 846 1

Bitmap Index Scan on tlb_vendordelivery_area_coverage_polygon_idx (cost=0.00..2.89 rows=81 width=0) (actual time=0.234..0.234 rows=846 loops=1)

  • Index Cond: (coverage_polygon ~ '0101000020E6100000429770E82D0A48405376FA415D4C3D40'::geometry)
12. 1.560 1.560 ↑ 1.0 1 520

Index Scan using mwq_branch_pkey on mwq_branch b (cost=0.29..3.99 rows=1 width=87) (actual time=0.003..0.003 rows=1 loops=520)

  • Index Cond: (id = ca.vendor_id)
  • Filter: ((NOT isdeleted) AND (status = ANY ('{0,1,2}'::integer[])))
13. 1.557 1.557 ↑ 1.0 1 519

Index Scan using tlb_slug_referenceid_idx on tlb_slug sl (cost=0.28..0.39 rows=1 width=520) (actual time=0.002..0.003 rows=1 loops=519)

  • Index Cond: (referenceid = b.restaurantid)
  • Filter: ((NOT isdeleted) AND (typeid = 1))
14. 1.557 1.557 ↑ 1.0 1 519

Index Scan using tlb_branch_details_branchid_brndtype_idx on tlb_branch_details bd (cost=0.29..0.34 rows=1 width=66) (actual time=0.002..0.003 rows=1 loops=519)

  • Index Cond: (branchid = b.id)
15. 2.076 2.076 ↑ 1.0 1 519

Index Scan using "tlb_CommonRestuarantFields_restid_idx" on tlb_commonrestuarantfields cr (cost=0.41..2.07 rows=1 width=58) (actual time=0.003..0.004 rows=1 loops=519)

  • Index Cond: (restaurantid = b.restaurantid)
16. 1.557 1.557 ↑ 1.0 1 519

Index Scan using mwq_restaurant_pkey on mwq_restaurant r (cost=0.28..0.38 rows=1 width=118) (actual time=0.003..0.003 rows=1 loops=519)

  • Index Cond: (id = cr.restaurantid)
  • Filter: ((NOT isdeleted) AND (NOT isdeleted) AND (status = ANY ('{0,1,2}'::integer[])))
  • Rows Removed by Filter: 0
17. 1.551 1.551 ↑ 1.0 1 517

Index Scan using tlb_restaurant_brand_rest_brand_idx on tlb_restaurant_brand br (cost=0.28..0.32 rows=1 width=12) (actual time=0.002..0.003 rows=1 loops=517)

  • Index Cond: (restaurantid = cr.restaurantid)
  • Filter: (isactive AND (NOT isdeleted))
18. 0.000 0.000 ↓ 0.0 0 517

Index Scan using tgb_upsellingcompany_pkey on tgb_upsellingcompany ub (cost=0.14..0.16 rows=1 width=122) (actual time=0.000..0.000 rows=0 loops=517)

  • Index Cond: (id = cr.upsellingcompanyid)
19. 1.551 1.551 ↑ 1.0 1 517

Index Scan using tlb_vendor_timingstatus_pkey on tlb_vendor_timingstatus cpt (cost=0.29..0.41 rows=1 width=5) (actual time=0.003..0.003 rows=1 loops=517)

  • Index Cond: (vendorid = bd.branchid)
20. 1.034 1.034 ↑ 1.0 1 517

Index Scan using mwq_area_pkey on mwq_area a (cost=0.28..0.36 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=517)

  • Index Cond: (id = b.areaid)
Planning time : 6.806 ms
Execution time : 24.545 ms