explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 0Fq6 : Teste

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

Unique (cost=19.39..19.42 rows=3 width=192) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=19.39..19.39 rows=3 width=192) (actual rows= loops=)

  • Sort Key: es.nome_esporte, m.nome_modalidade, m.categoria
3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.51..19.36 rows=3 width=192) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=2.36..5.06 rows=1 width=204) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.21..4.80 rows=1 width=134) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Hash Join (cost=2.06..3.88 rows=1 width=8) (actual rows= loops=)

  • Hash Cond: (ae.codigo_atleta = i.codigo_integrante)
7. 0.000 0.000 ↓ 0.0

Seq Scan on atleta_equipe ae (cost=0.00..1.64 rows=64 width=16) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Hash (cost=2.05..2.05 rows=1 width=4) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Seq Scan on integrante i (cost=0.00..2.05 rows=1 width=4) (actual rows= loops=)

  • Filter: ((nome_integrante)::text = 'Helen Cox'::text)
10. 0.000 0.000 ↓ 0.0

Index Scan using modalidade_pkey on modalidade m (cost=0.15..0.92 rows=1 width=126) (actual rows= loops=)

  • Index Cond: (codigo_modalidade = ae.codigo_modalidade)
11. 0.000 0.000 ↓ 0.0

Index Scan using esporte_pkey on esporte es (cost=0.15..0.26 rows=1 width=82) (actual rows= loops=)

  • Index Cond: (codigo_esporte = m.codigo_esporte)
12. 0.000 0.000 ↓ 0.0

Index Only Scan using equipe_pkey on equipe e (cost=0.15..14.21 rows=9 width=8) (actual rows= loops=)

  • Index Cond: (codigo_modalidade = m.codigo_modalidade)