explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CuGE

Settings
# exclusive inclusive rows x rows loops node
1. 1.313 12.767 ↑ 1.0 1,788 1

Sort (cost=776.13..780.70 rows=1,829 width=128) (actual time=12.546..12.767 rows=1,788 loops=1)

  • Sort Key: pedido.pedido_manipulacao_id DESC
  • Sort Method: quicksort Memory: 523kB
2. 5.423 11.454 ↑ 1.0 1,788 1

Hash Join (cost=560.56..677.03 rows=1,829 width=128) (actual time=5.473..11.454 rows=1,788 loops=1)

  • Hash Cond: (formula.pedido_manipulacao_id = pedido.pedido_manipulacao_id)
3. 0.587 0.587 ↑ 1.1 1,788 1

Seq Scan on man_formula formula (cost=0.00..72.55 rows=1,955 width=8) (actual time=0.006..0.587 rows=1,788 loops=1)

  • Filter: (NOT excluido)
4. 0.644 5.444 ↑ 1.0 1,574 1

Hash (cost=540.89..540.89 rows=1,574 width=128) (actual time=5.444..5.444 rows=1,574 loops=1)

  • Buckets: 2,048 Batches: 1 Memory Usage: 271kB
5. 0.687 4.800 ↑ 1.0 1,574 1

Hash Left Join (cost=456.46..540.89 rows=1,574 width=128) (actual time=3.226..4.800 rows=1,574 loops=1)

  • Hash Cond: (pedido.cliente_contato_id = contato_cliente.contato_id)
6. 0.504 2.539 ↑ 1.0 1,574 1

Hash Left Join (cost=228.23..291.62 rows=1,574 width=107) (actual time=1.642..2.539 rows=1,574 loops=1)

  • Hash Cond: (pedido.funcionario_contato_id = contato_funcionario.contato_id)
7. 0.403 0.403 ↑ 1.0 1,574 1

Seq Scan on man_pedido_manipulacao pedido (cost=0.00..41.74 rows=1,574 width=86) (actual time=0.002..0.403 rows=1,574 loops=1)

  • Filter: (NOT excluido)
8. 0.824 1.632 ↑ 1.0 6,677 1

Hash (cost=144.77..144.77 rows=6,677 width=29) (actual time=1.632..1.632 rows=6,677 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 484kB
9. 0.808 0.808 ↑ 1.0 6,677 1

Seq Scan on cad_contato contato_funcionario (cost=0.00..144.77 rows=6,677 width=29) (actual time=0.006..0.808 rows=6,677 loops=1)

10. 0.903 1.574 ↑ 1.0 6,677 1

Hash (cost=144.77..144.77 rows=6,677 width=29) (actual time=1.574..1.574 rows=6,677 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 484kB
11. 0.671 0.671 ↑ 1.0 6,677 1

Seq Scan on cad_contato contato_cliente (cost=0.00..144.77 rows=6,677 width=29) (actual time=0.003..0.671 rows=6,677 loops=1)

Planning time : 0.373 ms
Execution time : 12.892 ms