explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mcb

Settings
# exclusive inclusive rows x rows loops node
1. 0.245 1.034 ↑ 26.0 2 1

GroupAggregate (cost=52.15..54.56 rows=52 width=91) (actual time=0.963..1.034 rows=2 loops=1)

  • Group Key: t.seat, t.orden
2. 0.058 0.789 ↑ 14.3 7 1

Sort (cost=52.15..52.40 rows=100 width=91) (actual time=0.786..0.789 rows=7 loops=1)

  • Sort Key: t.seat, t.orden
  • Sort Method: quicksort Memory: 27kB
3. 0.038 0.731 ↑ 14.3 7 1

Subquery Scan on t (cost=0.42..48.83 rows=100 width=91) (actual time=0.257..0.731 rows=7 loops=1)

4. 0.107 0.693 ↑ 14.3 7 1

Nested Loop Left Join (cost=0.42..47.83 rows=100 width=87) (actual time=0.244..0.693 rows=7 loops=1)

  • Join Filter: (p.id = dv.promo)
  • Rows Removed by Join Filter: 105
5. 0.014 0.537 ↓ 7.0 7 1

Nested Loop (cost=0.42..44.67 rows=1 width=79) (actual time=0.199..0.537 rows=7 loops=1)

6. 0.030 0.488 ↓ 7.0 7 1

Nested Loop (cost=0.28..44.49 rows=1 width=83) (actual time=0.180..0.488 rows=7 loops=1)

7. 0.395 0.395 ↓ 7.0 7 1

Seq Scan on detalle_ventas dv (cost=0.00..36.19 rows=1 width=57) (actual time=0.160..0.395 rows=7 loops=1)

  • Filter: (venta = 349)
  • Rows Removed by Filter: 927
8. 0.063 0.063 ↑ 1.0 1 7

Index Scan using recetas_pkey on recetas r (cost=0.28..8.30 rows=1 width=30) (actual time=0.009..0.009 rows=1 loops=7)

  • Index Cond: (id = dv.producto)
9. 0.035 0.035 ↑ 1.0 1 7

Index Only Scan using lineas_pkey on lineas l (cost=0.14..0.17 rows=1 width=4) (actual time=0.004..0.005 rows=1 loops=7)

  • Index Cond: (id = r.linea)
  • Heap Fetches: 7
10. 0.049 0.049 ↑ 1.9 15 7

Seq Scan on promociones p (cost=0.00..2.28 rows=28 width=12) (actual time=0.003..0.007 rows=15 loops=7)

Planning time : 1.662 ms
Execution time : 1.284 ms