explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iXoZ

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.014 324.949 ↑ 1.0 22 1

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

2. 0.035 324.891 ↑ 1.0 22 1

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

3. 0.105 324.790 ↑ 1.0 22 1

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

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

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

5. 0.019 324.203 ↑ 1.0 22 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
6. 20.128 324.184 ↑ 1.0 22 1

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

  • Merge Cond: (empresaacervo.codigo = base.codigo_empresa_acervo)
7. 248.282 248.282 ↑ 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.009..248.282 rows=213,346 loops=1)

8. 0.068 55.774 ↑ 1.0 22 1

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

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

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

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

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

11. 0.013 22.161 ↑ 1.0 22 1

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

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

Seq Scan on manuais_manual_edicao edicao (cost=0.00..1.22 rows=22 width=12) (actual time=22.137..22.148 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 : 194.372 ms
Execution time : 325.184 ms