explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IkmP

Settings
# exclusive inclusive rows x rows loops node
1. 1,991.284 34,496.330 ↓ 1.0 535,892 1

Gather (cost=31,700.70..147,080.67 rows=535,790 width=646) (actual time=5,591.476..34,496.330 rows=535,892 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 68.946 32,505.046 ↑ 1.2 178,631 3

Hash Left Join (cost=30,700.70..92,501.67 rows=223,246 width=646) (actual time=4,937.030..32,505.046 rows=178,631 loops=3)

  • Hash Cond: (sm001000_pi2_repartition_annuel_enveloppbase.sm001000_pi_ni_vue_proj_infr = sm001000_pi2_projette_3ext.sm001000_pi2_projet_infrastructureid)
3. 65.734 32,333.826 ↑ 1.2 178,631 3

Hash Left Join (cost=23,940.43..82,922.92 rows=223,246 width=612) (actual time=4,834.521..32,333.826 rows=178,631 loops=3)

  • Hash Cond: (sm001000_pi2_repartition_annuel_enveloppbase.sm001000_pi2_dossier_transfertid = sm001000_pi2_projette_2ext.sm001000_pi2_dossier_transfertid)
4. 132.811 32,265.976 ↑ 1.2 178,631 3

Hash Left Join (cost=23,657.19..79,821.22 rows=223,246 width=605) (actual time=4,832.380..32,265.976 rows=178,631 loops=3)

  • Hash Cond: (sm001000_pi2_repartition_annuel_enveloppbase.sm001000_pi2_projet_infrastructureid = sm001000_pi2_projette_1ext.sm001000_pi2_projet_infrastructureid)
5. 63.814 31,997.493 ↑ 1.2 178,631 3

Hash Left Join (cost=16,896.92..70,242.51 rows=223,246 width=571) (actual time=4,695.226..31,997.493 rows=178,631 loops=3)

  • Hash Cond: (sm001000_pi2_repartition_annuel_enveloppbase.sm001000_pi9_motif_penaliteid = sm001000_pi2_est_associe_a_3ext.sm001000_pi9_motif_penaliteid)
6. 85.639 31,933.669 ↑ 1.2 178,631 3

Hash Left Join (cost=16,895.83..67,423.07 rows=223,246 width=551) (actual time=4,695.206..31,933.669 rows=178,631 loops=3)

  • Hash Cond: (sm001000_pi2_repartition_annuel_enveloppbase.sm001000_pi9_type_programmeid = sm001000_pi2_concerne_8ext.sm001000_pi9_type_programmeid)
7. 65.611 31,848.007 ↑ 1.2 178,631 3

Hash Left Join (cost=16,894.78..65,594.07 rows=223,246 width=541) (actual time=4,695.167..31,848.007 rows=178,631 loops=3)

  • Hash Cond: (sm001000_pi2_repartition_annuel_enveloppbase.sm001000_pi2_reclamation_depenseid = sm001000_pi2_concerne_34ext.sm001000_pi2_reclamation_depenseid)
8. 62.254 31,765.725 ↑ 1.2 178,631 3

Hash Left Join (cost=15,378.69..61,259.50 rows=223,246 width=513) (actual time=4,678.428..31,765.725 rows=178,631 loops=3)

  • Hash Cond: (sm001000_pi2_repartition_annuel_enveloppbase.sm001000_pi_ni_vue_proj_infr = sm001000_pi2_projette_3.sm001000_pi2_projet_infrastructureid)
9. 67.209 31,674.561 ↑ 1.2 178,631 3

Hash Left Join (cost=8,618.42..51,680.75 rows=223,246 width=509) (actual time=4,649.271..31,674.561 rows=178,631 loops=3)

  • Hash Cond: (sm001000_pi2_repartition_annuel_enveloppbase.sm001000_pi2_dossier_transfertid = sm001000_pi2_projette_2.sm001000_pi2_dossier_transfertid)
10. 127.470 31,351.765 ↑ 1.2 178,631 3

Hash Left Join (cost=8,335.18..48,579.04 rows=223,246 width=505) (actual time=4,393.647..31,351.765 rows=178,631 loops=3)

  • Hash Cond: (sm001000_pi2_repartition_annuel_enveloppbase.sm001000_pi2_projet_infrastructureid = sm001000_pi2_projette_1.sm001000_pi2_projet_infrastructureid)
11. 58.792 30,275.575 ↑ 1.2 178,631 3

Hash Left Join (cost=1,574.91..39,000.33 rows=223,246 width=501) (actual time=3,444.694..30,275.575 rows=178,631 loops=3)

  • Hash Cond: (sm001000_pi2_repartition_annuel_enveloppbase.sm001000_pi9_motif_penaliteid = sm001000_pi2_est_associe_a_3.sm001000_pi9_motif_penaliteid)
12. 74.749 30,216.769 ↑ 1.2 178,631 3

Hash Left Join (cost=1,573.82..36,180.90 rows=223,246 width=497) (actual time=3,444.668..30,216.769 rows=178,631 loops=3)

  • Hash Cond: (sm001000_pi2_repartition_annuel_enveloppbase.sm001000_pi9_type_programmeid = sm001000_pi2_concerne_8.sm001000_pi9_type_programmeid)
13. 60.806 30,141.999 ↑ 1.2 178,631 3

Hash Left Join (cost=1,572.78..34,351.89 rows=223,246 width=493) (actual time=3,444.626..30,141.999 rows=178,631 loops=3)

  • Hash Cond: (sm001000_pi2_repartition_annuel_enveloppbase.sm001000_pi2_reclamation_depenseid = sm001000_pi2_concerne_34.sm001000_pi2_reclamation_depenseid)
14. 74.122 26,712.922 ↑ 1.2 178,631 3

Hash Left Join (cost=56.69..30,017.32 rows=223,246 width=489) (actual time=76.298..26,712.922 rows=178,631 loops=3)

  • Hash Cond: (sm001000_pi2_repartition_annuel_enveloppbase.organizationid = organization_sm001000_pi2_repartition_annuel_envelopp.organizationid)
15. 74.413 26,638.783 ↑ 1.2 178,631 3

Hash Left Join (cost=55.66..29,177.01 rows=223,246 width=478) (actual time=76.270..26,638.783 rows=178,631 loops=3)

  • Hash Cond: (sm001000_pi2_repartition_annuel_enveloppbase.modifiedby = lk_sm001000_pi2_repartition_annuel_envelopp_modifiedby.systemuserid)
16. 139.059 26,564.177 ↑ 1.2 178,631 3

Hash Left Join (cost=27.83..26,335.24 rows=223,246 width=456) (actual time=76.068..26,564.177 rows=178,631 loops=3)

  • Hash Cond: (sm001000_pi2_repartition_annuel_enveloppbase.createdby = lk_sm001000_pi2_repartition_annuel_envelopp_createdby.systemuserid)
17. 26,416.530 26,416.530 ↑ 1.2 178,631 3

Parallel Seq Scan on sm001000_pi2_repartition_annuel_enveloppbase (cost=0.00..23,493.46 rows=223,246 width=434) (actual time=67.316..26,416.530 rows=178,631 loops=3)

18. 0.110 8.588 ↑ 1.0 437 3

Hash (cost=22.37..22.37 rows=437 width=38) (actual time=8.588..8.588 rows=437 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 38kB
19. 8.478 8.478 ↑ 1.0 437 3

Seq Scan on systemuserbase lk_sm001000_pi2_repartition_annuel_envelopp_createdby (cost=0.00..22.37 rows=437 width=38) (actual time=0.504..8.478 rows=437 loops=3)

20. 0.099 0.193 ↑ 1.0 437 3

Hash (cost=22.37..22.37 rows=437 width=38) (actual time=0.193..0.193 rows=437 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 38kB
21. 0.094 0.094 ↑ 1.0 437 3

Seq Scan on systemuserbase lk_sm001000_pi2_repartition_annuel_envelopp_modifiedby (cost=0.00..22.37 rows=437 width=38) (actual time=0.003..0.094 rows=437 loops=3)

22. 0.006 0.017 ↑ 1.0 1 3

Hash (cost=1.01..1.01 rows=1 width=27) (actual time=0.017..0.017 rows=1 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
23. 0.011 0.011 ↑ 1.0 1 3

Seq Scan on organizationbase organization_sm001000_pi2_repartition_annuel_envelopp (cost=0.00..1.01 rows=1 width=27) (actual time=0.011..0.011 rows=1 loops=3)

24. 5.367 3,368.271 ↑ 1.0 14,804 3

Hash (cost=1,331.04..1,331.04 rows=14,804 width=20) (actual time=3,368.271..3,368.271 rows=14,804 loops=3)

  • Buckets: 16384 Batches: 1 Memory Usage: 880kB
25. 3,362.904 3,362.904 ↑ 1.0 14,804 3

Seq Scan on sm001000_pi2_reclamation_depensebase sm001000_pi2_concerne_34 (cost=0.00..1,331.04 rows=14,804 width=20) (actual time=123.589..3,362.904 rows=14,804 loops=3)

26. 0.003 0.021 ↑ 1.0 2 3

Hash (cost=1.02..1.02 rows=2 width=20) (actual time=0.021..0.021 rows=2 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
27. 0.018 0.018 ↑ 1.0 2 3

Seq Scan on sm001000_pi9_type_programmebase sm001000_pi2_concerne_8 (cost=0.00..1.02 rows=2 width=20) (actual time=0.017..0.018 rows=2 loops=3)

28. 0.003 0.014 ↑ 1.0 4 3

Hash (cost=1.04..1.04 rows=4 width=20) (actual time=0.014..0.014 rows=4 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
29. 0.011 0.011 ↑ 1.0 4 3

Seq Scan on sm001000_pi9_motif_penalitebase sm001000_pi2_est_associe_a_3 (cost=0.00..1.04 rows=4 width=20) (actual time=0.010..0.011 rows=4 loops=3)

30. 19.706 948.720 ↓ 1.0 40,431 3

Hash (cost=6,255.12..6,255.12 rows=40,412 width=20) (actual time=948.720..948.720 rows=40,431 loops=3)

  • Buckets: 65536 Batches: 1 Memory Usage: 2566kB
31. 929.014 929.014 ↓ 1.0 40,431 3

Seq Scan on sm001000_pi2_projet_infrastructurebase sm001000_pi2_projette_1 (cost=0.00..6,255.12 rows=40,412 width=20) (actual time=0.011..929.014 rows=40,431 loops=3)

32. 0.851 255.587 ↑ 1.0 2,233 3

Hash (cost=255.33..255.33 rows=2,233 width=20) (actual time=255.587..255.587 rows=2,233 loops=3)

  • Buckets: 4096 Batches: 1 Memory Usage: 146kB
33. 254.736 254.736 ↑ 1.0 2,233 3

Seq Scan on sm001000_pi2_dossier_transfertbase sm001000_pi2_projette_2 (cost=0.00..255.33 rows=2,233 width=20) (actual time=0.945..254.736 rows=2,233 loops=3)

34. 8.803 28.910 ↓ 1.0 40,431 3

Hash (cost=6,255.12..6,255.12 rows=40,412 width=20) (actual time=28.910..28.910 rows=40,431 loops=3)

  • Buckets: 65536 Batches: 1 Memory Usage: 2566kB
35. 20.107 20.107 ↓ 1.0 40,431 3

Seq Scan on sm001000_pi2_projet_infrastructurebase sm001000_pi2_projette_3 (cost=0.00..6,255.12 rows=40,412 width=20) (actual time=0.008..20.107 rows=40,431 loops=3)

36. 3.476 16.671 ↑ 1.0 14,804 3

Hash (cost=1,331.04..1,331.04 rows=14,804 width=44) (actual time=16.671..16.671 rows=14,804 loops=3)

  • Buckets: 16384 Batches: 1 Memory Usage: 1235kB
37. 13.195 13.195 ↑ 1.0 14,804 3

Seq Scan on sm001000_pi2_reclamation_depensebase sm001000_pi2_concerne_34ext (cost=0.00..1,331.04 rows=14,804 width=44) (actual time=0.007..13.195 rows=14,804 loops=3)

38. 0.017 0.023 ↑ 1.0 2 3

Hash (cost=1.02..1.02 rows=2 width=26) (actual time=0.023..0.023 rows=2 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
39. 0.006 0.006 ↑ 1.0 2 3

Seq Scan on sm001000_pi9_type_programmebase sm001000_pi2_concerne_8ext (cost=0.00..1.02 rows=2 width=26) (actual time=0.005..0.006 rows=2 loops=3)

40. 0.005 0.010 ↑ 1.0 4 3

Hash (cost=1.04..1.04 rows=4 width=36) (actual time=0.010..0.010 rows=4 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
41. 0.005 0.005 ↑ 1.0 4 3

Seq Scan on sm001000_pi9_motif_penalitebase sm001000_pi2_est_associe_a_3ext (cost=0.00..1.04 rows=4 width=36) (actual time=0.004..0.005 rows=4 loops=3)

42. 15.816 135.672 ↓ 1.0 40,431 3

Hash (cost=6,255.12..6,255.12 rows=40,412 width=50) (actual time=135.672..135.672 rows=40,431 loops=3)

  • Buckets: 65536 Batches: 1 Memory Usage: 3771kB
43. 119.856 119.856 ↓ 1.0 40,431 3

Seq Scan on sm001000_pi2_projet_infrastructurebase sm001000_pi2_projette_1ext (cost=0.00..6,255.12 rows=40,412 width=50) (actual time=0.016..119.856 rows=40,431 loops=3)

44. 0.498 2.116 ↑ 1.0 2,233 3

Hash (cost=255.33..255.33 rows=2,233 width=23) (actual time=2.116..2.116 rows=2,233 loops=3)

  • Buckets: 4096 Batches: 1 Memory Usage: 154kB
45. 1.618 1.618 ↑ 1.0 2,233 3

Seq Scan on sm001000_pi2_dossier_transfertbase sm001000_pi2_projette_2ext (cost=0.00..255.33 rows=2,233 width=23) (actual time=0.008..1.618 rows=2,233 loops=3)

46. 14.639 102.274 ↓ 1.0 40,431 3

Hash (cost=6,255.12..6,255.12 rows=40,412 width=50) (actual time=102.274..102.274 rows=40,431 loops=3)

  • Buckets: 65536 Batches: 1 Memory Usage: 3771kB
47. 87.635 87.635 ↓ 1.0 40,431 3

Seq Scan on sm001000_pi2_projet_infrastructurebase sm001000_pi2_projette_3ext (cost=0.00..6,255.12 rows=40,412 width=50) (actual time=0.007..87.635 rows=40,431 loops=3)

Planning time : 808.685 ms