explain.depesz.com

PostgreSQL's explain analyze made readable

Result: o0Yl

Settings
# exclusive inclusive rows x rows loops node
1. 1.798 2.742 ↑ 1.0 1,788 1

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

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

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

3. 0.492 0.707 ↑ 1.0 1,574 1

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

  • Buckets: 2,048 Batches: 1 Memory Usage: 213kB
4. 0.215 0.215 ↑ 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.002..0.215 rows=1,574 loops=1)

Planning time : 0.479 ms
Execution time : 2.913 ms