explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wntu : Optimization for: plan #iXoZ

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.013 177.092 ↑ 1.0 22 1

Nested Loop Left Join (cost=70.95..482.88 rows=22 width=211) (actual time=176.693..177.092 rows=22 loops=1)

2. 0.021 177.035 ↑ 1.0 22 1

Nested Loop (cost=70.52..309.98 rows=22 width=192) (actual time=176.688..177.035 rows=22 loops=1)

3. 0.063 176.948 ↑ 1.0 22 1

Hash Right Join (cost=70.10..137.08 rows=22 width=173) (actual time=176.674..176.948 rows=22 loops=1)

  • Hash Cond: (publicado.codigo = edicao.codigo_ultima_publicacao)
4. 0.455 0.455 ↑ 1.0 492 1

Seq Scan on manuais_manual publicado (cost=0.00..64.92 rows=492 width=36) (actual time=0.156..0.455 rows=492 loops=1)

5. 0.020 176.430 ↑ 1.0 22 1

Hash (cost=69.82..69.82 rows=22 width=145) (actual time=176.430..176.430 rows=22 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
6. 19.762 176.410 ↑ 1.0 22 1

Merge Join (cost=69.51..69.82 rows=22 width=145) (actual time=0.674..176.410 rows=22 loops=1)

  • Merge Cond: (empresaacervo.codigo = base.codigo_empresa_acervo)
7. 155.988 155.988 ↑ 2.8 213,346 1

Index Scan using estrutura_entidade_pkey on estrutura_entidade empresaacervo (cost=0.42..57,747.64 rows=605,013 width=27) (actual time=0.011..155.988 rows=213,346 loops=1)

8. 0.039 0.660 ↑ 1.0 22 1

Sort (cost=68.97..69.03 rows=22 width=122) (actual time=0.657..0.660 rows=22 loops=1)

  • Sort Key: base.codigo_empresa_acervo
  • Sort Method: quicksort Memory: 28kB
9. 0.095 0.621 ↑ 1.0 22 1

Hash Join (cost=1.50..68.48 rows=22 width=122) (actual time=0.288..0.621 rows=22 loops=1)

  • Hash Cond: (base.codigo = edicao.codigo)
10. 0.500 0.500 ↑ 1.0 492 1

Seq Scan on manuais_manual base (cost=0.00..64.92 rows=492 width=114) (actual time=0.144..0.500 rows=492 loops=1)

11. 0.011 0.026 ↑ 1.0 22 1

Hash (cost=1.22..1.22 rows=22 width=12) (actual time=0.026..0.026 rows=22 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
12. 0.015 0.015 ↑ 1.0 22 1

Seq Scan on manuais_manual_edicao edicao (cost=0.00..1.22 rows=22 width=12) (actual time=0.009..0.015 rows=22 loops=1)

13. 0.066 0.066 ↑ 1.0 1 22

Index Scan using estrutura_entidade_pkey on estrutura_entidade criador (cost=0.42..7.85 rows=1 width=27) (actual time=0.003..0.003 rows=1 loops=22)

  • Index Cond: (codigo = base.codigo_usuario_criador)
14. 0.044 0.044 ↑ 1.0 1 22

Index Scan using estrutura_entidade_pkey on estrutura_entidade aprovador (cost=0.42..7.85 rows=1 width=27) (actual time=0.002..0.002 rows=1 loops=22)

  • Index Cond: (base.codigo_usuario_aprovador = codigo)
Planning time : 1.168 ms
Execution time : 177.202 ms