explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SOIx

Settings
# exclusive inclusive rows x rows loops node
1. 0.107 0.301 ↓ 1.0 566 1

Sort (cost=54.18..55.59 rows=564 width=34) (actual time=0.277..0.301 rows=566 loops=1)

  • Sort Key: m.created
  • Sort Method: quicksort Memory: 69kB
2. 0.111 0.194 ↓ 1.0 566 1

Hash Join (cost=6.01..28.41 rows=564 width=34) (actual time=0.057..0.194 rows=566 loops=1)

  • Hash Cond: (d.movimiento_id = m.id)
3. 0.040 0.040 ↓ 1.0 566 1

Seq Scan on inv_movimientos_detalles d (cost=0.00..14.64 rows=564 width=16) (actual time=0.009..0.040 rows=566 loops=1)

4. 0.022 0.043 ↑ 1.0 134 1

Hash (cost=4.34..4.34 rows=134 width=26) (actual time=0.043..0.043 rows=134 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 16kB
5. 0.021 0.021 ↑ 1.0 134 1

Seq Scan on inv_movimientos m (cost=0.00..4.34 rows=134 width=26) (actual time=0.004..0.021 rows=134 loops=1)

Planning time : 0.193 ms
Execution time : 0.335 ms