explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MphI

Settings
# exclusive inclusive rows x rows loops node
1. 1.307 15.916 ↓ 35.5 709 1

Nested Loop (cost=145.55..1,455.96 rows=20 width=266) (actual time=5.531..15.916 rows=709 loops=1)

2. 0.935 13.181 ↓ 34.0 714 1

Nested Loop (cost=145.26..1,322.48 rows=21 width=155) (actual time=5.522..13.181 rows=714 loops=1)

  • Join Filter: (ca.restaurantid = brandrestaurant.restaurantid)
3. 0.874 10.818 ↓ 32.5 714 1

Nested Loop (cost=144.98..1,313.01 rows=22 width=157) (actual time=5.516..10.818 rows=714 loops=1)

  • Join Filter: (ca.restaurantid = r.id)
4. 0.523 7.802 ↓ 10.8 714 1

Hash Join (cost=144.70..1,257.66 rows=66 width=54) (actual time=5.504..7.802 rows=714 loops=1)

  • Hash Cond: (ca.restaurantid = sl.referenceid)
5. 1.818 2.197 ↓ 10.8 714 1

Bitmap Heap Scan on tgb_coveragepolygon ca (cost=10.42..1,123.04 rows=66 width=36) (actual time=0.405..2.197 rows=714 loops=1)

  • Recheck Cond: (polygongeo ~ '0101000020E6100000915F3FC406FF4740D7DCD1FF72553D40'::geometry)
  • Filter: ((restaurantstatus <> 3) AND _st_contains(polygongeo, '0101000020E6100000915F3FC406FF4740D7DCD1FF72553D40'::geometry))
  • Rows Removed by Filter: 1171
  • Heap Blocks: exact=106
6. 0.379 0.379 ↓ 6.7 1,885 1

Bitmap Index Scan on tgb_coveragepolygon_polygongeo_idx (cost=0.00..10.41 rows=283 width=0) (actual time=0.379..0.379 rows=1,885 loops=1)

  • Index Cond: (polygongeo ~ '0101000020E6100000915F3FC406FF4740D7DCD1FF72553D40'::geometry)
7. 2.232 5.082 ↑ 1.0 6,913 1

Hash (cost=116.30..116.30 rows=6,913 width=18) (actual time=5.082..5.082 rows=6,913 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 417kB
8. 2.850 2.850 ↑ 1.0 6,913 1

Seq Scan on tlb_slug sl (cost=0.00..116.30 rows=6,913 width=18) (actual time=0.007..2.850 rows=6,913 loops=1)

  • Filter: ((NOT isdeleted) AND (typeid = 1) AND (brandtype = 1))
  • Rows Removed by Filter: 9
9. 2.142 2.142 ↑ 1.0 1 714

Index Scan using mwq_restaurant_pkey on mwq_restaurant r (cost=0.28..0.84 rows=1 width=103) (actual time=0.002..0.003 rows=1 loops=714)

  • Index Cond: (id = sl.referenceid)
  • Filter: ((NOT isdeleted) AND (NOT isdeleted) AND (status <> 3) AND (status <> 3))
10. 1.428 1.428 ↑ 1.0 1 714

Index Scan using tlb_restaurantbrand_resttid_idx on tlb_restaurant_brand brandrestaurant (cost=0.28..0.43 rows=1 width=10) (actual time=0.002..0.002 rows=1 loops=714)

  • Index Cond: (restaurantid = sl.referenceid)
  • Filter: (isactive AND (NOT isdeleted) AND (brandtype = 1))
11. 1.428 1.428 ↑ 1.0 1 714

Index Scan using mwq_branch_pkey on mwq_branch b (cost=0.29..6.36 rows=1 width=64) (actual time=0.002..0.002 rows=1 loops=714)

  • Index Cond: (id = ca.branchid)
  • Filter: ((NOT isdeleted) AND (status <> 3))
  • Rows Removed by Filter: 0