explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uzrn

Settings
# exclusive inclusive rows x rows loops node
1. 5,503.566 5,769.390 ↑ 1.0 1 1

Aggregate (cost=266,794.22..266,794.26 rows=1 width=1,144) (actual time=5,769.389..5,769.390 rows=1 loops=1)

2. 108.657 265.824 ↑ 1.0 134,895 1

Hash Join (cost=154.26..6,446.82 rows=134,895 width=67) (actual time=2.750..265.824 rows=134,895 loops=1)

  • Hash Cond: (medicaoindicador.unidadenegocioid = unidadenegocio.id)
3. 107.902 155.945 ↑ 1.0 134,895 1

Hash Join (cost=97.88..4,535.64 rows=134,895 width=67) (actual time=1.513..155.945 rows=134,895 loops=1)

  • Hash Cond: (medicaoindicador.indicadorid = indicador.id)
4. 46.549 46.549 ↑ 1.0 134,895 1

Seq Scan on medicoeseerros medicaoindicador (cost=0.00..2,582.95 rows=134,895 width=35) (actual time=0.006..46.549 rows=134,895 loops=1)

5. 0.125 1.494 ↓ 1.0 311 1

Hash (cost=94.06..94.06 rows=306 width=40) (actual time=1.494..1.494 rows=311 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 33kB
6. 0.193 1.369 ↓ 1.0 311 1

Hash Join (cost=18.17..94.06 rows=306 width=40) (actual time=0.336..1.369 rows=311 loops=1)

  • Hash Cond: (indicador.classificacaoinvestimentoid = classificacaoinvestimento.id)
7. 0.170 1.093 ↓ 1.0 311 1

Hash Join (cost=13.63..85.31 rows=306 width=48) (actual time=0.245..1.093 rows=311 loops=1)

  • Hash Cond: (indicador.classificacaoramoatividadeid = classificacaoramoatividade.id)
8. 0.198 0.857 ↓ 1.0 311 1

Hash Join (cost=9.09..76.56 rows=306 width=56) (actual time=0.170..0.857 rows=311 loops=1)

  • Hash Cond: (indicador.classificacaogestaoid = classificacaogestao.id)
9. 0.345 0.579 ↓ 1.0 311 1

Hash Join (cost=4.54..67.81 rows=306 width=42) (actual time=0.079..0.579 rows=311 loops=1)

  • Hash Cond: (indicador.classificacaodepartamentoid = classificacaodepartamento.id)
10. 0.167 0.167 ↓ 1.0 311 1

Seq Scan on indicador (cost=0.00..59.06 rows=306 width=50) (actual time=0.003..0.167 rows=311 loops=1)

11. 0.038 0.067 ↓ 1.1 119 1

Hash (cost=3.13..3.13 rows=113 width=8) (actual time=0.067..0.067 rows=119 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 13kB
12. 0.029 0.029 ↓ 1.1 119 1

Seq Scan on classificacaoindicador classificacaodepartamento (cost=0.00..3.13 rows=113 width=8) (actual time=0.002..0.029 rows=119 loops=1)

13. 0.041 0.080 ↓ 1.1 119 1

Hash (cost=3.13..3.13 rows=113 width=30) (actual time=0.080..0.080 rows=119 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 16kB
14. 0.039 0.039 ↓ 1.1 119 1

Seq Scan on classificacaoindicador classificacaogestao (cost=0.00..3.13 rows=113 width=30) (actual time=0.002..0.039 rows=119 loops=1)

15. 0.051 0.066 ↓ 1.1 119 1

Hash (cost=3.13..3.13 rows=113 width=8) (actual time=0.066..0.066 rows=119 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 13kB
16. 0.015 0.015 ↓ 1.1 119 1

Seq Scan on classificacaoindicador classificacaoramoatividade (cost=0.00..3.13 rows=113 width=8) (actual time=0.003..0.015 rows=119 loops=1)

17. 0.051 0.083 ↓ 1.1 119 1

Hash (cost=3.13..3.13 rows=113 width=8) (actual time=0.083..0.083 rows=119 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 13kB
18. 0.032 0.032 ↓ 1.1 119 1

Seq Scan on classificacaoindicador classificacaoinvestimento (cost=0.00..3.13 rows=113 width=8) (actual time=0.004..0.032 rows=119 loops=1)

19. 0.362 1.222 ↑ 1.1 947 1

Hash (cost=43.41..43.41 rows=1,037 width=8) (actual time=1.222..1.222 rows=947 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 53kB
20. 0.408 0.860 ↑ 1.1 947 1

Hash Join (cost=8.13..43.41 rows=1,037 width=8) (actual time=0.192..0.860 rows=947 loops=1)

  • Hash Cond: (unidadenegocio.organizacaoid = organizacao.id)
21. 0.292 0.292 ↑ 1.1 947 1

Seq Scan on unidadenegocio (cost=0.00..22.37 rows=1,037 width=16) (actual time=0.009..0.292 rows=947 loops=1)

22. 0.081 0.160 ↓ 1.2 269 1

Hash (cost=5.28..5.28 rows=228 width=8) (actual time=0.160..0.160 rows=269 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 19kB
23. 0.079 0.079 ↓ 1.2 269 1

Seq Scan on organizacao (cost=0.00..5.28 rows=228 width=8) (actual time=0.005..0.079 rows=269 loops=1)