explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PvXc

Settings
# exclusive inclusive rows x rows loops node
1. 37.194 93.404 ↑ 1.0 3,944 1

Sort (cost=1,356.73..1,366.59 rows=3,944 width=212) (actual time=91.832..93.404 rows=3,944 loops=1)

  • Sort Key: precatorios.id, participantes.nome, tipo_papeis.descricao, evento_financeiros.data_evento, evento_financeiros.id, configuracao_rubrica_precatorios.ordem_apresentacao
  • Sort Method: quicksort Memory: 2130kB
2. 18.637 56.210 ↑ 1.0 3,944 1

Hash Join (cost=963.72..1,121.16 rows=3,944 width=212) (actual time=31.597..56.210 rows=3,944 loops=1)

  • Hash Cond: (precatorios.processo_principal_id = processo_principais.id)
3. 5.692 36.139 ↑ 1.0 3,944 1

Hash Right Join (cost=885.28..909.61 rows=3,944 width=195) (actual time=30.106..36.139 rows=3,944 loops=1)

  • Hash Cond: ((configuracao_rubrica_precatorios.precatorio_id = precatorios.id) AND (configuracao_rubrica_precatorios.tipo_rubrica_id = tipo_rubricas.id))
4. 0.379 0.379 ↑ 1.0 793 1

Seq Scan on configuracao_rubrica_precatorios (cost=0.00..15.93 rows=793 width=12) (actual time=0.010..0.379 rows=793 loops=1)

5. 5.747 30.068 ↑ 1.0 3,944 1

Hash (cost=826.12..826.12 rows=3,944 width=191) (actual time=30.068..30.068 rows=3,944 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 961kB
6. 3.308 24.321 ↑ 1.0 3,944 1

Hash Join (cost=619.22..826.12 rows=3,944 width=191) (actual time=14.420..24.321 rows=3,944 loops=1)

  • Hash Cond: (rubrica_eventos.tipo_rubrica_id = tipo_rubricas.id)
7. 5.315 20.978 ↑ 1.0 3,944 1

Hash Join (cost=617.44..770.11 rows=3,944 width=168) (actual time=14.374..20.978 rows=3,944 loops=1)

  • Hash Cond: (rubrica_eventos.evento_financeiro_id = evento_financeiros.id)
8. 1.315 1.315 ↑ 1.0 3,944 1

Seq Scan on rubrica_eventos (cost=0.00..98.44 rows=3,944 width=32) (actual time=0.007..1.315 rows=3,944 loops=1)

9. 1.227 14.348 ↑ 1.0 1,234 1

Hash (cost=602.01..602.01 rows=1,234 width=144) (actual time=14.348..14.348 rows=1,234 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 246kB
10. 0.915 13.121 ↑ 1.0 1,234 1

Hash Join (cost=262.73..602.01 rows=1,234 width=144) (actual time=4.927..13.121 rows=1,234 loops=1)

  • Hash Cond: (precatorio_participantes.tipo_papel_id = tipo_papeis.id)
11. 0.964 12.198 ↑ 1.0 1,234 1

Hash Join (cost=261.59..583.91 rows=1,234 width=136) (actual time=4.910..12.198 rows=1,234 loops=1)

  • Hash Cond: (precatorio_participantes.participante_id = participantes.id)
12. 0.906 8.918 ↑ 1.0 1,234 1

Hash Join (cost=131.90..437.25 rows=1,234 width=108) (actual time=2.577..8.918 rows=1,234 loops=1)

  • Hash Cond: (precatorio_participantes.precatorio_id = precatorios.id)
13. 0.900 6.622 ↑ 1.0 1,234 1

Hash Join (cost=46.97..335.35 rows=1,234 width=100) (actual time=1.170..6.622 rows=1,234 loops=1)

  • Hash Cond: (evento_financeiros.tipo_evento_financeiro_id = tipo_evento_financeiros.id)
14. 2.690 5.696 ↑ 1.0 1,234 1

Hash Join (cost=45.77..317.18 rows=1,234 width=77) (actual time=1.123..5.696 rows=1,234 loops=1)

  • Hash Cond: (precatorio_participantes.id = evento_financeiros.precatorio_participante_id)
15. 1.919 1.919 ↑ 1.0 7,524 1

Seq Scan on precatorio_participantes (cost=0.00..193.24 rows=7,524 width=48) (actual time=0.006..1.919 rows=7,524 loops=1)

16. 0.513 1.087 ↑ 1.0 1,234 1

Hash (cost=30.34..30.34 rows=1,234 width=37) (actual time=1.087..1.087 rows=1,234 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 113kB
17. 0.574 0.574 ↑ 1.0 1,234 1

Seq Scan on evento_financeiros (cost=0.00..30.34 rows=1,234 width=37) (actual time=0.008..0.574 rows=1,234 loops=1)

18. 0.019 0.026 ↑ 1.0 9 1

Hash (cost=1.09..1.09 rows=9 width=31) (actual time=0.026..0.026 rows=9 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
19. 0.007 0.007 ↑ 1.0 9 1

Seq Scan on tipo_evento_financeiros (cost=0.00..1.09 rows=9 width=31) (actual time=0.004..0.007 rows=9 loops=1)

20. 0.605 1.390 ↑ 1.0 1,908 1

Hash (cost=61.08..61.08 rows=1,908 width=16) (actual time=1.390..1.390 rows=1,908 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 106kB
21. 0.785 0.785 ↑ 1.0 1,908 1

Seq Scan on precatorios (cost=0.00..61.08 rows=1,908 width=16) (actual time=0.009..0.785 rows=1,908 loops=1)

22. 1.216 2.316 ↑ 1.0 3,142 1

Hash (cost=90.42..90.42 rows=3,142 width=36) (actual time=2.316..2.316 rows=3,142 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 242kB
23. 1.100 1.100 ↑ 1.0 3,142 1

Seq Scan on participantes (cost=0.00..90.42 rows=3,142 width=36) (actual time=0.007..1.100 rows=3,142 loops=1)

24. 0.004 0.008 ↑ 1.0 6 1

Hash (cost=1.06..1.06 rows=6 width=16) (actual time=0.008..0.008 rows=6 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
25. 0.004 0.004 ↑ 1.0 6 1

Seq Scan on tipo_papeis (cost=0.00..1.06 rows=6 width=16) (actual time=0.003..0.004 rows=6 loops=1)

26. 0.018 0.035 ↑ 1.0 35 1

Hash (cost=1.35..1.35 rows=35 width=31) (actual time=0.035..0.035 rows=35 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
27. 0.017 0.017 ↑ 1.0 35 1

Seq Scan on tipo_rubricas (cost=0.00..1.35 rows=35 width=31) (actual time=0.006..0.017 rows=35 loops=1)

28. 0.712 1.434 ↑ 1.0 2,064 1

Hash (cost=52.64..52.64 rows=2,064 width=33) (actual time=1.434..1.434 rows=2,064 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 178kB
29. 0.722 0.722 ↑ 1.0 2,064 1

Seq Scan on processo_principais (cost=0.00..52.64 rows=2,064 width=33) (actual time=0.011..0.722 rows=2,064 loops=1)

Planning time : 6.718 ms
Execution time : 94.165 ms