explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OoNo

Settings
# exclusive inclusive rows x rows loops node
1. 2.250 3.398 ↑ 1.0 1,788 1

Hash Join (cost=61.42..156.88 rows=1,788 width=315) (actual time=0.904..3.398 rows=1,788 loops=1)

  • Hash Cond: (formula.pedido_manipulacao_id = pedido.pedido_manipulacao_id)
2. 0.290 0.290 ↑ 1.0 1,788 1

Seq Scan on man_formula formula (cost=0.00..70.88 rows=1,788 width=226) (actual time=0.006..0.290 rows=1,788 loops=1)

3. 0.598 0.858 ↑ 1.0 1,574 1

Hash (cost=41.74..41.74 rows=1,574 width=89) (actual time=0.858..0.858 rows=1,574 loops=1)

  • Buckets: 2,048 Batches: 1 Memory Usage: 213kB
4. 0.260 0.260 ↑ 1.0 1,574 1

Seq Scan on man_pedido_manipulacao pedido (cost=0.00..41.74 rows=1,574 width=89) (actual time=0.003..0.260 rows=1,574 loops=1)

Planning time : 0.626 ms
Execution time : 3.659 ms