explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Dms4 : DEV -> segunda execucao -> indice no campo "supports_takeout" -> order by com o campo "distance" -> sem os campo "supports_delivery" no SELECT e WHERE

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 7.978 ↓ 0.0 0 1

Limit (cost=2,348.31..2,348.39 rows=30 width=550) (actual time=7.977..7.978 rows=0 loops=1)

2. 0.008 7.976 ↓ 0.0 0 1

Sort (cost=2,348.31..2,348.50 rows=74 width=550) (actual time=7.975..7.976 rows=0 loops=1)

  • Sort Key: t2.distance, t2.score DESC, t2.merchant_short_id
  • Sort Method: quicksort Memory: 25kB
3. 0.001 7.968 ↓ 0.0 0 1

Subquery Scan on t2 (cost=2,291.74..2,346.13 rows=74 width=550) (actual time=7.968..7.968 rows=0 loops=1)

  • Filter: (t2.group_rn <= 1)
4. 0.003 7.967 ↓ 0.0 0 1

WindowAgg (cost=2,291.74..2,323.37 rows=222 width=499) (actual time=7.966..7.967 rows=0 loops=1)

5. 0.010 7.964 ↓ 0.0 0 1

Sort (cost=2,291.74..2,292.29 rows=222 width=615) (actual time=7.964..7.964 rows=0 loops=1)

  • Sort Key: merc.group_id, ((merc.available AND (COALESCE(merc.connected, false) OR merc.always_online) AND COALESCE((true), false))) DESC, merc.chain_priority DESC, d.distance, (
  • Sort Method: quicksort Memory: 25kB
6. 0.001 7.954 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.26..2,283.09 rows=222 width=615) (actual time=7.953..7.954 rows=0 loops=1)

7. 0.246 7.953 ↓ 0.0 0 1

Nested Loop (cost=0.98..2,012.43 rows=222 width=537) (actual time=7.952..7.953 rows=0 loops=1)

8. 4.992 6.471 ↑ 1.1 206 1

Nested Loop Left Join (cost=0.72..1,967.22 rows=222 width=505) (actual time=0.104..6.471 rows=206 loops=1)

  • Filter: COALESCE((true), false)
  • Rows Removed by Filter: 14
  • -> Index Only Scan using merchant_shifts_merchant_short_id_dow_shift_range_excl on merchant_shifts shift (cost=0.43..2.54 rows=1 width=31) (actual time=0.017
9. 1.479 1.479 ↑ 2.0 220 1

Index Scan using idx_merchant_test1 on merchants merc (cost=0.29..796.37 rows=443 width=518) (actual time=0.019..1.479 rows=220 loops=1)

  • Index Cond: (supports_takeout = true)
  • Filter: (supports_takeout AND (NOT supports_dark_kitchen) AND available AND (COALESCE(connected, false) OR always_online) AND (channels && '{IFOOD}'::tex
  • Rows Removed by Filter: 998
  • Index Cond: ((merchant_short_id = merc.merchant_short_id) AND (dow = (date_part('dow'::text, timezone((merc.timezone)::text, now())))::integer) AND (shif
  • Heap Fetches: 16
10. 1.236 1.236 ↓ 0.0 0 206

Function Scan on round d (cost=0.26..0.36 rows=1 width=32) (actual time=0.006..0.006 rows=0 loops=206)

  • Filter: (distance <= 15.0)
  • Rows Removed by Filter: 1
11. 0.000 0.000 ↓ 0.0 0

Index Scan using chain_external_id_key on merchant_chain chain (cost=0.28..1.21 rows=1 width=82) (never executed)

  • Index Cond: ((merc.group_id)::text = (external_id)::text)
Planning time : 0.993 ms
Execution time : 8.199 ms