explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WBVe

Settings
# exclusive inclusive rows x rows loops node
1. 0.037 1.278 ↑ 1.0 10 1

Unique (cost=132.44..132.49 rows=10 width=4) (actual time=1.221..1.278 rows=10 loops=1)

2. 0.058 1.241 ↑ 1.0 10 1

Sort (cost=132.44..132.47 rows=10 width=4) (actual time=1.218..1.241 rows=10 loops=1)

  • Sort Key: u.id_usuario
  • Sort Method: quicksort Memory: 25kB
3. 0.066 1.183 ↑ 1.0 10 1

Nested Loop (cost=0.28..132.28 rows=10 width=4) (actual time=0.059..1.183 rows=10 loops=1)

4. 1.037 1.037 ↑ 1.0 10 1

Seq Scan on syo_equipeusuario eu (cost=0.00..105.23 rows=10 width=4) (actual time=0.041..1.037 rows=10 loops=1)

  • Filter: (id_equipe = 37)
  • Rows Removed by Filter: 5852
5. 0.080 0.080 ↑ 1.0 1 10

Index Only Scan using pk_syo_usuario on syo_usuario u (cost=0.28..2.69 rows=1 width=4) (actual time=0.006..0.008 rows=1 loops=10)

  • Index Cond: (id_usuario = eu.id_usuario)
  • Heap Fetches: 4
Planning time : 0.236 ms
Execution time : 1.340 ms