explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dRPu

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.251 957.860 ↑ 1.0 2,504 1

Append (cost=0.00..74,907.49 rows=2,504 width=95) (actual time=0.003..957.860 rows=2,504 loops=1)

2. 0.001 0.002 ↑ 1.0 1 1

Subquery Scan "*SELECT* 1" (cost=0.00..0.02 rows=1 width=0) (actual time=0.002..0.002 rows=1 loops=1)

3. 0.001 0.001 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.001..0.001 rows=1 loops=1)

4. 0.000 0.001 ↑ 1.0 1 1

Subquery Scan "*SELECT* 2" (cost=0.00..0.02 rows=1 width=0) (actual time=0.001..0.001 rows=1 loops=1)

5. 0.001 0.001 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.001..0.001 rows=1 loops=1)

6. 0.001 0.023 ↑ 1.0 1 1

Subquery Scan "*SELECT* 3" (cost=0.00..0.03 rows=1 width=0) (actual time=0.023..0.023 rows=1 loops=1)

7. 0.022 0.022 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.022..0.022 rows=1 loops=1)

8. 0.000 0.001 ↑ 1.0 1 1

Subquery Scan "*SELECT* 4" (cost=0.00..0.02 rows=1 width=0) (actual time=0.001..0.001 rows=1 loops=1)

9. 0.001 0.001 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.001..0.001 rows=1 loops=1)

10. 0.566 957.582 ↑ 1.0 2,500 1

Subquery Scan "*SELECT* 5" (cost=53,361.71..74,907.41 rows=2,500 width=95) (actual time=588.898..957.582 rows=2,500 loops=1)

11. 0.230 957.016 ↑ 1.0 2,500 1

Limit (cost=53,361.71..74,882.41 rows=2,500 width=95) (actual time=588.896..957.016 rows=2,500 loops=1)

12. 98.086 956.786 ↑ 2.3 2,500 1

Hash Join (cost=53,361.71..103,909.53 rows=5,872 width=95) (actual time=588.894..956.786 rows=2,500 loops=1)

  • Hash Cond: (cp.conparseq = cpc.conparseq)
13. 30.542 686.353 ↓ 2.6 123,382 1

Hash Left Join (cost=41,781.05..84,478.36 rows=47,794 width=97) (actual time=405.903..686.353 rows=123,382 loops=1)

  • Hash Cond: (cp.conparacocod = acr.acocod)
14. 44.815 654.715 ↓ 2.6 123,382 1

Nested Loop (cost=41,689.12..83,850.17 rows=47,794 width=61) (actual time=404.772..654.715 rows=123,382 loops=1)

15. 7.038 454.400 ↓ 2.2 15,550 1

Hash Join (cost=41,689.12..72,110.83 rows=7,081 width=47) (actual time=404.744..454.400 rows=15,550 loops=1)

  • Hash Cond: (d.carcod = car.carcod)
16. 33.852 447.323 ↑ 10.5 15,550 1

Hash Join (cost=41,683.92..69,855.65 rows=163,636 width=35) (actual time=404.668..447.323 rows=15,550 loops=1)

  • Hash Cond: ((c.carcod = d.carcod) AND (c.devcod = d.devcod))
17. 9.292 9.292 ↑ 12.1 31,034 1

Seq Scan on contrato c (cost=0.00..12,857.05 rows=375,305 width=31) (actual time=0.006..9.292 rows=31,034 loops=1)

18. 233.817 404.179 ↑ 1.0 657,917 1

Hash (cost=27,960.17..27,960.17 rows=657,917 width=20) (actual time=404.179..404.179 rows=657,917 loops=1)

19. 170.362 170.362 ↑ 1.0 657,917 1

Seq Scan on devedor d (cost=0.00..27,960.17 rows=657,917 width=20) (actual time=0.010..170.362 rows=657,917 loops=1)

20. 0.016 0.039 ↑ 1.3 40 1

Hash (cost=4.53..4.53 rows=53 width=20) (actual time=0.039..0.039 rows=40 loops=1)

21. 0.023 0.023 ↑ 1.3 40 1

Seq Scan on carteira car (cost=0.00..4.53 rows=53 width=20) (actual time=0.007..0.023 rows=40 loops=1)

22. 155.500 155.500 ↑ 1.4 8 15,550

Index Scan using contrato_parcela_iu0008 on contrato_parcela cp (cost=0.00..1.52 rows=11 width=30) (actual time=0.005..0.010 rows=8 loops=15,550)

  • Index Cond: (cp.concod = c.concod)
23. 0.211 1.096 ↑ 1.0 534 1

Hash (cost=84.96..84.96 rows=558 width=44) (actual time=1.096..1.096 rows=534 loops=1)

24. 0.307 0.885 ↑ 1.0 534 1

Hash Left Join (cost=49.71..84.96 rows=558 width=44) (actual time=0.493..0.885 rows=534 loops=1)

  • Hash Cond: (acr.acousuinc = usu.usucod)
25. 0.114 0.114 ↑ 1.0 534 1

Seq Scan on acordo acr (cost=0.00..27.58 rows=558 width=22) (actual time=0.007..0.114 rows=534 loops=1)

26. 0.248 0.464 ↑ 1.2 754 1

Hash (cost=38.76..38.76 rows=876 width=24) (actual time=0.464..0.464 rows=754 loops=1)

27. 0.216 0.216 ↑ 1.2 754 1

Seq Scan on usuario usu (cost=0.00..38.76 rows=876 width=24) (actual time=0.006..0.216 rows=754 loops=1)

28. 87.846 172.347 ↑ 1.0 311,010 1

Hash (cost=7,690.29..7,690.29 rows=311,229 width=14) (actual time=172.347..172.347 rows=311,010 loops=1)

29. 84.501 84.501 ↑ 1.0 311,010 1

Seq Scan on contrato_parcela_calculo cpc (cost=0.00..7,690.29 rows=311,229 width=14) (actual time=0.015..84.501 rows=311,010 loops=1)

Total runtime : 962.326 ms