explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vIeM

Settings
# exclusive inclusive rows x rows loops node
1. 1.152 14.766 ↓ 1.0 10,005 1

Hash Left Join (cost=676.61..1,541.45 rows=9,910 width=144) (actual time=3.544..14.766 rows=10,005 loops=1)

  • Hash Cond: (produto.id_produto = produto_foto.id_produto)
2. 1.851 13.614 ↓ 1.0 10,005 1

Hash Join (cost=649.73..1,469.97 rows=9,910 width=112) (actual time=3.537..13.614 rows=10,005 loops=1)

  • Hash Cond: (produto.id_prod_unidade = prod_unidade.id_prod_unidade)
3. 2.045 11.759 ↓ 1.0 10,005 1

Hash Join (cost=648.69..1,332.67 rows=9,910 width=95) (actual time=3.526..11.759 rows=10,005 loops=1)

  • Hash Cond: (prod_subgrupo.id_prod_grupo = prod_grupo.id_prod_grupo)
4. 2.252 8.089 ↓ 1.0 10,005 1

Hash Join (cost=330.82..878.22 rows=9,996 width=95) (actual time=1.858..8.089 rows=10,005 loops=1)

  • Hash Cond: (produto.id_prod_subgrupo = prod_subgrupo.id_prod_subgrupo)
5. 4.029 4.029 ↓ 1.0 10,005 1

Seq Scan on produto (cost=0.00..409.95 rows=9,996 width=87) (actual time=0.005..4.029 rows=10,005 loops=1)

  • Filter: (vendido_atendimento AND ((tipo_produto_composicao)::integer <> 3))
6. 0.976 1.808 ↑ 1.0 10,001 1

Hash (cost=204.81..204.81 rows=10,081 width=16) (actual time=1.808..1.808 rows=10,001 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 597kB
7. 0.832 0.832 ↑ 1.0 10,001 1

Seq Scan on prod_subgrupo (cost=0.00..204.81 rows=10,081 width=16) (actual time=0.002..0.832 rows=10,001 loops=1)

8. 0.879 1.625 ↓ 1.0 10,001 1

Hash (cost=192.94..192.94 rows=9,994 width=8) (actual time=1.625..1.625 rows=10,001 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 519kB
9. 0.746 0.746 ↓ 1.0 10,001 1

Seq Scan on prod_grupo (cost=0.00..192.94 rows=9,994 width=8) (actual time=0.002..0.746 rows=10,001 loops=1)

10. 0.003 0.004 ↑ 1.0 2 1

Hash (cost=1.02..1.02 rows=2 width=25) (actual time=0.004..0.004 rows=2 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
11. 0.001 0.001 ↑ 1.0 2 1

Seq Scan on prod_unidade (cost=0.00..1.02 rows=2 width=25) (actual time=0.001..0.001 rows=2 loops=1)

12. 0.000 0.000 ↓ 0.0 0 1

Hash (cost=17.50..17.50 rows=750 width=40) (actual time=0.000..0.000 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
13. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on produto_foto (cost=0.00..17.50 rows=750 width=40) (actual time=0.000..0.000 rows=0 loops=1)

Planning time : 0.553 ms
Execution time : 15.204 ms