explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EjHS : Optimization for: ///1; plan #ScuS

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Sort (cost=17.57..17.57 rows=1 width=152) (actual rows= loops=)

  • Sort Key: e.giorno, e.ordine
2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.30..17.56 rows=1 width=152) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.15..9.38 rows=1 width=136) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Seq Scan on esercizio_in_programma e (cost=0.00..1.20 rows=1 width=104) (actual rows= loops=)

  • Filter: ((nomeprogramma)::text = 'P2'::text)
5. 0.000 0.000 ↓ 0.0

Index Scan using esercizio_pkey on esercizio es (cost=0.15..8.17 rows=1 width=64) (actual rows= loops=)

  • Index Cond: ((nome)::text = (e.nomeesercizio)::text)
6. 0.000 0.000 ↓ 0.0

Index Scan using tut_pkey on tut t (cost=0.15..8.17 rows=1 width=48) (actual rows= loops=)

  • Index Cond: ((id)::text = (e.tut)::text)