explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KduP

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

Unique (cost=29.25..29.27 rows=3 width=4) (actual time=0.186..0.186 rows=0 loops=1)

2. 0.043 0.186 ↓ 0.0 0 1

Sort (cost=29.25..29.26 rows=3 width=4) (actual time=0.186..0.186 rows=0 loops=1)

  • Sort Key: u.id_usuario
  • Sort Method: quicksort Memory: 25kB
3. 0.001 0.143 ↓ 0.0 0 1

Nested Loop (cost=0.28..29.23 rows=3 width=4) (actual time=0.143..0.143 rows=0 loops=1)

4. 0.142 0.142 ↓ 0.0 0 1

Seq Scan on syo_equipeusuario eu (cost=0.00..16.34 rows=3 width=4) (actual time=0.142..0.142 rows=0 loops=1)

  • Filter: (id_equipe = 1256)
  • Rows Removed by Filter: 907
5. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_syo_usuario on syo_usuario u (cost=0.28..4.29 rows=1 width=4) (never executed)

  • Index Cond: (id_usuario = eu.id_usuario)
  • Heap Fetches: 0
Planning time : 0.290 ms
Execution time : 0.214 ms