explain.depesz.com

PostgreSQL's explain analyze made readable

Result: zbv

Settings
# exclusive inclusive rows x rows loops node
1. 15.394 50.620 ↑ 1.0 3,944 1

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

  • Hash Cond: (precatorios.processo_principal_id = processo_principais.id)
2. 4.900 33.560 ↑ 1.0 3,944 1

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

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

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

4. 4.624 28.345 ↑ 1.0 3,944 1

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

  • Buckets: 4096 Batches: 1 Memory Usage: 961kB
5. 2.942 23.721 ↑ 1.0 3,944 1

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

  • Hash Cond: (rubrica_eventos.tipo_rubrica_id = tipo_rubricas.id)
6. 4.420 20.742 ↑ 1.0 3,944 1

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

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

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

8. 1.323 15.181 ↑ 1.0 1,234 1

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

  • Buckets: 2048 Batches: 1 Memory Usage: 246kB
9. 0.954 13.858 ↑ 1.0 1,234 1

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

  • Hash Cond: (precatorio_participantes.tipo_papel_id = tipo_papeis.id)
10. 0.994 12.895 ↑ 1.0 1,234 1

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

  • Hash Cond: (precatorio_participantes.participante_id = participantes.id)
11. 0.965 9.345 ↑ 1.0 1,234 1

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

  • Hash Cond: (precatorio_participantes.precatorio_id = precatorios.id)
12. 0.930 6.885 ↑ 1.0 1,234 1

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

  • Hash Cond: (evento_financeiros.tipo_evento_financeiro_id = tipo_evento_financeiros.id)
13. 2.718 5.937 ↑ 1.0 1,234 1

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

  • Hash Cond: (precatorio_participantes.id = evento_financeiros.precatorio_participante_id)
14. 1.977 1.977 ↑ 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.977 rows=7,524 loops=1)

15. 0.569 1.242 ↑ 1.0 1,234 1

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

  • Buckets: 2048 Batches: 1 Memory Usage: 113kB
16. 0.673 0.673 ↑ 1.0 1,234 1

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

17. 0.005 0.018 ↑ 1.0 9 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
18. 0.013 0.013 ↑ 1.0 9 1

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

19. 0.634 1.495 ↑ 1.0 1,908 1

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

  • Buckets: 2048 Batches: 1 Memory Usage: 106kB
20. 0.861 0.861 ↑ 1.0 1,908 1

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

21. 1.229 2.556 ↑ 1.0 3,142 1

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

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

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

23. 0.004 0.009 ↑ 1.0 6 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
24. 0.005 0.005 ↑ 1.0 6 1

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

25. 0.019 0.037 ↑ 1.0 35 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
26. 0.018 0.018 ↑ 1.0 35 1

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

27. 0.804 1.666 ↑ 1.0 2,064 1

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

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

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

Planning time : 7.648 ms
Execution time : 51.463 ms