# | 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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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 |