explain.depesz.com

PostgreSQL's explain analyze made readable

Result: E6FA

Settings
# exclusive inclusive rows x rows loops node
1. 4.902 361,077.446 ↑ 1.0 1 1

Aggregate (cost=19,564,810.86..19,564,810.87 rows=1 width=8) (actual time=361,077.446..361,077.446 rows=1 loops=1)

2. 3.087 361,072.544 ↓ 746.4 13,436 1

Append (cost=3,027.91..19,564,810.63 rows=18 width=699) (actual time=313,606.805..361,072.544 rows=13,436 loops=1)

3. 14.900 341,457.808 ↓ 764.7 13,000 1

Subquery Scan on *SELECT* 1 (cost=3,027.91..19,389,603.47 rows=17 width=445) (actual time=313,606.804..341,457.808 rows=13,000 loops=1)

4. 73,116.807 341,442.908 ↓ 764.7 13,000 1

Gather (cost=3,027.91..19,389,603.25 rows=17 width=445) (actual time=313,606.798..341,442.908 rows=13,000 loops=1)

  • Workers Planned: 3
  • Workers Launched: 3
5. 3.316 268,326.101 ↓ 650.0 3,250 4

Hash Left Join (cost=2,027.91..19,388,558.25 rows=5 width=349) (actual time=261,355.767..268,326.101 rows=3,250 loops=4)

  • Hash Cond: ((v.id_dealer_pro)::text = (r.id_dealer)::text)
6. 33.104 268,322.741 ↓ 650.0 3,250 4

Nested Loop Left Join (cost=2,025.40..19,388,555.66 rows=5 width=326) (actual time=261,355.733..268,322.741 rows=3,250 loops=4)

7. 7.995 268,289.628 ↓ 650.0 3,250 4

Nested Loop Left Join (cost=2,024.97..19,388,553.45 rows=5 width=268) (actual time=261,355.728..268,289.628 rows=3,250 loops=4)

8. 8.284 268,281.632 ↓ 650.0 3,250 4

Nested Loop Left Join (cost=2,024.85..19,388,552.73 rows=5 width=258) (actual time=261,355.720..268,281.632 rows=3,250 loops=4)

9. 11.091 268,273.347 ↓ 650.0 3,250 4

Nested Loop Left Join (cost=2,024.71..19,388,551.98 rows=5 width=251) (actual time=261,355.711..268,273.347 rows=3,250 loops=4)

10. 624.243 268,262.254 ↓ 650.0 3,250 4

Hash Join (cost=2,024.58..19,388,551.21 rows=5 width=243) (actual time=261,355.707..268,262.254 rows=3,250 loops=4)

  • Hash Cond: (a.id_vendeur = v.id_vendeur)
11. 2,756.307 267,637.863 ↓ 1.3 4,956,642 4

Hash Left Join (cost=2,016.42..19,378,675.38 rows=3,759,110 width=236) (actual time=28.982..267,637.863 rows=4,956,642 loops=4)

  • Hash Cond: (a.id_phase = p.id_phase)
12. 2,656.183 264,872.776 ↓ 1.3 4,956,642 4

Hash Left Join (cost=1,268.75..19,368,058.61 rows=3,759,110 width=232) (actual time=20.065..264,872.776 rows=4,956,642 loops=4)

  • Hash Cond: (a.id_generation = ge.id_generation)
13. 2,476.863 262,204.519 ↓ 1.3 4,956,642 4

Hash Left Join (cost=625.35..19,357,545.73 rows=3,759,110 width=234) (actual time=7.822..262,204.519 rows=4,956,642 loops=4)

  • Hash Cond: (a.id_smodele = sm.id_smodele)
14. 2,653.861 259,725.110 ↓ 1.3 4,956,642 4

Hash Left Join (cost=483.15..19,347,526.65 rows=3,759,110 width=231) (actual time=5.233..259,725.110 rows=4,956,642 loops=4)

  • Hash Cond: (a.id_modele = m.id_modele)
15. 257,027.552 257,069.574 ↓ 1.3 4,956,642 4

Nested Loop (cost=395.47..19,337,556.98 rows=3,759,110 width=222) (actual time=3.527..257,069.574 rows=4,956,642 loops=4)

16. 8.391 14.810 ↑ 1.2 9,395 4

Hash Left Join (cost=395.04..12,925.52 rows=11,675 width=29) (actual time=0.888..14.810 rows=9,395 loops=4)

  • Hash Cond: (g.id_pays = pays.id_pays)
17. 3.647 6.361 ↑ 1.2 9,395 4

Parallel Bitmap Heap Scan on geographie g (cost=390.93..12,760.87 rows=11,675 width=17) (actual time=0.761..6.361 rows=9,395 loops=4)

  • Recheck Cond: (id_pays = 'ES'::bpchar)
  • Heap Blocks: exact=325
18. 2.714 2.714 ↓ 1.0 37,579 1

Bitmap Index Scan on geographie_id_pays_id_geographie_idx (cost=0.00..381.88 rows=36,194 width=0) (actual time=2.714..2.714 rows=37,579 loops=1)

  • Index Cond: (id_pays = 'ES'::bpchar)
19. 0.004 0.058 ↑ 1.0 1 4

Hash (cost=4.10..4.10 rows=1 width=15) (actual time=0.057..0.058 rows=1 loops=4)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
20. 0.005 0.054 ↑ 1.0 1 4

Nested Loop Left Join (cost=0.14..4.10 rows=1 width=15) (actual time=0.049..0.054 rows=1 loops=4)

21. 0.025 0.025 ↑ 1.0 1 4

Seq Scan on pays (cost=0.00..1.71 rows=1 width=7) (actual time=0.021..0.025 rows=1 loops=4)

  • Filter: (id_pays = 'ES'::bpchar)
  • Rows Removed by Filter: 56
22. 0.024 0.024 ↑ 1.0 1 4

Index Scan using devise_pkey on devise (cost=0.14..2.36 rows=1 width=12) (actual time=0.024..0.024 rows=1 loops=4)

  • Index Cond: (pays.id_devise = id_devise)
23. 0.056 27.212 ↑ 35.8 528 37,579

Append (cost=0.42..1,466.29 rows=18,892 width=200) (actual time=0.057..27.212 rows=528 loops=37,579)

24. 0.003 0.003 ↓ 0.0 0 37,579

Index Scan using annonce_dead_partition_2012_id_geographie_idx on annonce_dead_partition_2012 a (cost=0.42..4.97 rows=133 width=198) (actual time=0.003..0.003 rows=0 loops=37,579)

  • Index Cond: (id_geographie = g.id_geographie)
25. 0.003 0.003 ↓ 0.0 0 37,579

Index Scan using annonce_dead_partition_2013_id_geographie_idx on annonce_dead_partition_2013 a_1 (cost=0.43..24.41 rows=502 width=199) (actual time=0.003..0.003 rows=0 loops=37,579)

  • Index Cond: (id_geographie = g.id_geographie)
26. 0.196 0.196 ↑ 42.3 15 37,579

Index Scan using annonce_dead_partition_2014_id_geographie_idx on annonce_dead_partition_2014 a_2 (cost=0.43..31.20 rows=634 width=201) (actual time=0.011..0.196 rows=15 loops=37,579)

  • Index Cond: (id_geographie = g.id_geographie)
27. 0.197 0.197 ↑ 22.4 40 37,579

Index Scan using annonce_dead_partition_2015_id_geographie_idx1 on annonce_dead_partition_2015 a_3 (cost=0.43..42.19 rows=894 width=203) (actual time=0.010..0.197 rows=40 loops=37,579)

  • Index Cond: (id_geographie = g.id_geographie)
28. 2.140 2.140 ↑ 55.1 48 37,579

Index Scan using annonce_dead_partition_2016_id_geographie_idx on annonce_dead_partition_2016 a_4 (cost=0.56..166.33 rows=2,647 width=204) (actual time=0.019..2.140 rows=48 loops=37,579)

  • Index Cond: (id_geographie = g.id_geographie)
29. 2.858 2.858 ↑ 39.8 110 37,579

Index Scan using annonce_dead_partition_2017_id_geographie_idx on annonce_dead_partition_2017 a_5 (cost=0.56..254.24 rows=4,378 width=204) (actual time=0.018..2.858 rows=110 loops=37,579)

  • Index Cond: (id_geographie = g.id_geographie)
30. 4.332 4.332 ↑ 39.2 110 37,579

Index Scan using annonce_dead_partition_2018_id_geographie_idx on annonce_dead_partition_2018 a_6 (cost=0.57..324.65 rows=4,312 width=198) (actual time=0.025..4.332 rows=110 loops=37,579)

  • Index Cond: (id_geographie = g.id_geographie)
31. 17.427 17.427 ↑ 26.3 205 37,579

Index Scan using annonce_dead_partition_2019_id_geographie_idx on annonce_dead_partition_2019 a_7 (cost=0.57..523.84 rows=5,392 width=198) (actual time=0.032..17.427 rows=205 loops=37,579)

  • Index Cond: (id_geographie = g.id_geographie)
32. 0.847 1.675 ↑ 1.0 2,919 4

Hash (cost=51.19..51.19 rows=2,919 width=17) (actual time=1.675..1.675 rows=2,919 loops=4)

  • Buckets: 4096 Batches: 1 Memory Usage: 178kB
33. 0.828 0.828 ↑ 1.0 2,919 4

Seq Scan on modele m (cost=0.00..51.19 rows=2,919 width=17) (actual time=0.022..0.828 rows=2,919 loops=4)

34. 1.064 2.546 ↑ 1.0 4,098 4

Hash (cost=90.98..90.98 rows=4,098 width=11) (actual time=2.545..2.546 rows=4,098 loops=4)

  • Buckets: 8192 Batches: 1 Memory Usage: 245kB
35. 1.482 1.482 ↑ 1.0 4,098 4

Seq Scan on smodele sm (cost=0.00..90.98 rows=4,098 width=11) (actual time=0.017..1.482 rows=4,098 loops=4)

36. 5.064 12.074 ↑ 1.0 20,862 4

Hash (cost=382.62..382.62 rows=20,862 width=6) (actual time=12.074..12.074 rows=20,862 loops=4)

  • Buckets: 32768 Batches: 1 Memory Usage: 1072kB
37. 7.010 7.010 ↑ 1.0 20,862 4

Seq Scan on generation ge (cost=0.00..382.62 rows=20,862 width=6) (actual time=0.022..7.010 rows=20,862 loops=4)

38. 4.092 8.780 ↑ 1.0 25,319 4

Hash (cost=431.19..431.19 rows=25,319 width=8) (actual time=8.780..8.780 rows=25,319 loops=4)

  • Buckets: 32768 Batches: 1 Memory Usage: 1246kB
39. 4.688 4.688 ↑ 1.0 25,319 4

Seq Scan on phase p (cost=0.00..431.19 rows=25,319 width=8) (actual time=0.031..4.688 rows=25,319 loops=4)

40. 0.007 0.148 ↓ 1.5 9 4

Hash (cost=8.08..8.08 rows=6 width=15) (actual time=0.148..0.148 rows=9 loops=4)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
41. 0.141 0.141 ↓ 1.5 9 4

Index Scan using vendeur_id_dealer_pro_idx on vendeur v (cost=0.43..8.08 rows=6 width=15) (actual time=0.088..0.141 rows=9 loops=4)

  • Index Cond: ((id_dealer_pro)::text = 'REN-72405092'::text)
42. 0.002 0.002 ↑ 1.0 1 13,000

Index Scan using carrosserie_pkey on carrosserie c (cost=0.14..0.16 rows=1 width=12) (actual time=0.002..0.002 rows=1 loops=13,000)

  • Index Cond: (id_carrosserie = a.id_carrosserie)
43. 0.001 0.001 ↑ 1.0 1 13,000

Index Scan using energie_pkey on energie e (cost=0.13..0.15 rows=1 width=11) (actual time=0.001..0.001 rows=1 loops=13,000)

  • Index Cond: (id_energie = a.id_energie)
44. 0.001 0.001 ↑ 1.0 1 13,000

Index Scan using boite_pkey on boite b (cost=0.13..0.15 rows=1 width=14) (actual time=0.001..0.001 rows=1 loops=13,000)

  • Index Cond: (id_boite = a.id_boite)
45. 0.009 0.009 ↑ 1.0 1 13,000

Index Scan using vehicule_pkey on vehicule ve (cost=0.42..0.44 rows=1 width=62) (actual time=0.009..0.009 rows=1 loops=13,000)

  • Index Cond: (id_veh = a.id_veh)
46. 0.005 0.044 ↑ 1.0 1 1

Hash (cost=2.50..2.50 rows=1 width=35) (actual time=0.044..0.044 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
47. 0.039 0.039 ↑ 1.0 1 1

Index Scan using dealer_pkey on dealer r (cost=0.28..2.50 rows=1 width=35) (actual time=0.038..0.039 rows=1 loops=1)

  • Index Cond: ((id_dealer)::text = 'REN-72405092'::text)
48.          

SubPlan (forGather)

49. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..2.52 rows=100 width=8) (never executed)

50. 0.000 0.000 ↓ 0.0 0

ProjectSet (cost=0.00..0.52 rows=100 width=4) (never executed)

51. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

52. 2.293 19,611.649 ↓ 436.0 436 1

Nested Loop Left Join (cost=3,025.82..175,207.07 rows=1 width=820) (actual time=9,591.678..19,611.649 rows=436 loops=1)

  • Join Filter: ((v_1.id_dealer_pro)::text = (r_1.id_dealer)::text)
53. 0.479 19,605.432 ↓ 436.0 436 1

Nested Loop Left Join (cost=3,025.53..175,201.99 rows=1 width=812) (actual time=9,591.611..19,605.432 rows=436 loops=1)

54. 0.462 19,602.337 ↓ 436.0 436 1

Nested Loop Left Join (cost=3,025.11..175,201.55 rows=1 width=754) (actual time=9,591.601..19,602.337 rows=436 loops=1)

55. 0.541 19,601.003 ↓ 436.0 436 1

Nested Loop Left Join (cost=3,024.98..175,201.39 rows=1 width=744) (actual time=9,591.588..19,601.003 rows=436 loops=1)

56. 0.000 19,599.590 ↓ 436.0 436 1

Nested Loop Left Join (cost=3,024.85..175,201.24 rows=1 width=737) (actual time=9,591.572..19,599.590 rows=436 loops=1)

57. 3,048.081 20,058.114 ↓ 436.0 436 1

Gather (cost=3,024.71..175,201.08 rows=1 width=729) (actual time=9,591.553..20,058.114 rows=436 loops=1)

  • Workers Planned: 3
  • Workers Launched: 3
58. 51.103 17,010.033 ↓ 109.0 109 4

Hash Join (cost=2,024.71..174,200.98 rows=1 width=729) (actual time=15,377.491..17,010.033 rows=109 loops=4)

  • Hash Cond: (a_8.id_vendeur = v_1.id_vendeur)
59. 205.993 16,958.413 ↓ 2.5 409,595 4

Hash Left Join (cost=2,016.56..173,759.75 rows=164,983 width=722) (actual time=35.874..16,958.413 rows=409,595 loops=4)

  • Hash Cond: (a_8.id_phase = p_1.id_phase)
60. 200.471 16,739.411 ↓ 2.5 409,595 4

Hash Left Join (cost=1,268.88..172,578.93 rows=164,983 width=718) (actual time=22.703..16,739.411 rows=409,595 loops=4)

  • Hash Cond: (a_8.id_generation = ge_1.id_generation)
61. 191.608 16,526.102 ↓ 2.5 409,595 4

Hash Left Join (cost=625.49..171,502.38 rows=164,983 width=720) (actual time=9.707..16,526.102 rows=409,595 loops=4)

  • Hash Cond: (a_8.id_smodele = sm_1.id_smodele)
62. 203.716 16,331.834 ↓ 2.5 409,595 4

Hash Left Join (cost=483.28..170,926.70 rows=164,983 width=717) (actual time=6.996..16,331.834 rows=409,595 loops=4)

  • Hash Cond: (a_8.id_modele = m_1.id_modele)
63. 16,112.550 16,126.406 ↓ 2.5 409,595 4

Nested Loop (cost=395.60..170,405.31 rows=164,983 width=708) (actual time=5.250..16,126.406 rows=409,595 loops=4)

64. 5.043 12.184 ↑ 1.2 9,395 4

Hash Left Join (cost=395.04..12,925.52 rows=11,675 width=29) (actual time=2.997..12.184 rows=9,395 loops=4)

  • Hash Cond: (g_1.id_pays = pays_1.id_pays)
65. 0.391 7.082 ↑ 1.2 9,395 4

Parallel Bitmap Heap Scan on geographie g_1 (cost=390.93..12,760.87 rows=11,675 width=17) (actual time=2.880..7.082 rows=9,395 loops=4)

  • Recheck Cond: (id_pays = 'ES'::bpchar)
  • Heap Blocks: exact=236
66. 6.691 6.691 ↓ 1.0 37,579 1

Bitmap Index Scan on geographie_id_pays_id_geographie_idx (cost=0.00..381.88 rows=36,194 width=0) (actual time=6.691..6.691 rows=37,579 loops=1)

  • Index Cond: (id_pays = 'ES'::bpchar)
67. 0.007 0.059 ↑ 1.0 1 4

Hash (cost=4.10..4.10 rows=1 width=15) (actual time=0.058..0.059 rows=1 loops=4)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
68. 0.004 0.052 ↑ 1.0 1 4

Nested Loop Left Join (cost=0.14..4.10 rows=1 width=15) (actual time=0.046..0.052 rows=1 loops=4)

69. 0.022 0.022 ↑ 1.0 1 4

Seq Scan on pays pays_1 (cost=0.00..1.71 rows=1 width=7) (actual time=0.017..0.022 rows=1 loops=4)

  • Filter: (id_pays = 'ES'::bpchar)
  • Rows Removed by Filter: 56
70. 0.026 0.026 ↑ 1.0 1 4

Index Scan using devise_pkey on devise devise_1 (cost=0.14..2.36 rows=1 width=12) (actual time=0.026..0.026 rows=1 loops=4)

  • Index Cond: (pays_1.id_devise = id_devise)
71. 1.672 1.672 ↓ 4.0 44 37,579

Index Scan using refresh_vo_all on annonce a_8 (cost=0.56..13.38 rows=11 width=687) (actual time=0.020..1.672 rows=44 loops=37,579)

  • Index Cond: (id_geographie = g_1.id_geographie)
72. 0.895 1.712 ↑ 1.0 2,919 4

Hash (cost=51.19..51.19 rows=2,919 width=17) (actual time=1.712..1.712 rows=2,919 loops=4)

  • Buckets: 4096 Batches: 1 Memory Usage: 178kB
73. 0.817 0.817 ↑ 1.0 2,919 4

Seq Scan on modele m_1 (cost=0.00..51.19 rows=2,919 width=17) (actual time=0.026..0.817 rows=2,919 loops=4)

74. 1.178 2.660 ↑ 1.0 4,098 4

Hash (cost=90.98..90.98 rows=4,098 width=11) (actual time=2.660..2.660 rows=4,098 loops=4)

  • Buckets: 8192 Batches: 1 Memory Usage: 245kB
75. 1.482 1.482 ↑ 1.0 4,098 4

Seq Scan on smodele sm_1 (cost=0.00..90.98 rows=4,098 width=11) (actual time=0.014..1.482 rows=4,098 loops=4)

76. 5.560 12.838 ↑ 1.0 20,862 4

Hash (cost=382.62..382.62 rows=20,862 width=6) (actual time=12.837..12.838 rows=20,862 loops=4)

  • Buckets: 32768 Batches: 1 Memory Usage: 1072kB
77. 7.278 7.278 ↑ 1.0 20,862 4

Seq Scan on generation ge_1 (cost=0.00..382.62 rows=20,862 width=6) (actual time=0.022..7.278 rows=20,862 loops=4)

78. 6.012 13.009 ↑ 1.0 25,319 4

Hash (cost=431.19..431.19 rows=25,319 width=8) (actual time=13.009..13.009 rows=25,319 loops=4)

  • Buckets: 32768 Batches: 1 Memory Usage: 1246kB
79. 6.997 6.997 ↑ 1.0 25,319 4

Seq Scan on phase p_1 (cost=0.00..431.19 rows=25,319 width=8) (actual time=0.030..6.997 rows=25,319 loops=4)

80. 0.008 0.517 ↓ 1.5 9 4

Hash (cost=8.08..8.08 rows=6 width=15) (actual time=0.516..0.517 rows=9 loops=4)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
81. 0.509 0.509 ↓ 1.5 9 4

Index Scan using vendeur_id_dealer_pro_idx on vendeur v_1 (cost=0.43..8.08 rows=6 width=15) (actual time=0.459..0.509 rows=9 loops=4)

  • Index Cond: ((id_dealer_pro)::text = 'REN-72405092'::text)
82. 1.308 1.308 ↑ 1.0 1 436

Index Scan using carrosserie_pkey on carrosserie c_1 (cost=0.14..0.16 rows=1 width=12) (actual time=0.003..0.003 rows=1 loops=436)

  • Index Cond: (id_carrosserie = a_8.id_carrosserie)
83. 0.872 0.872 ↑ 1.0 1 436

Index Scan using energie_pkey on energie e_1 (cost=0.13..0.15 rows=1 width=11) (actual time=0.002..0.002 rows=1 loops=436)

  • Index Cond: (id_energie = a_8.id_energie)
84. 0.872 0.872 ↑ 1.0 1 436

Index Scan using boite_pkey on boite b_1 (cost=0.13..0.15 rows=1 width=14) (actual time=0.002..0.002 rows=1 loops=436)

  • Index Cond: (id_boite = a_8.id_boite)
85. 2.616 2.616 ↑ 1.0 1 436

Index Scan using vehicule_pkey on vehicule ve_1 (cost=0.42..0.44 rows=1 width=62) (actual time=0.006..0.006 rows=1 loops=436)

  • Index Cond: (id_veh = a_8.id_veh)
86. 3.924 3.924 ↑ 1.0 1 436

Index Scan using dealer_pkey on dealer r_1 (cost=0.28..2.50 rows=1 width=35) (actual time=0.009..0.009 rows=1 loops=436)

  • Index Cond: ((id_dealer)::text = 'REN-72405092'::text)
87.          

SubPlan (forNested Loop Left Join)

88. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..2.52 rows=100 width=8) (never executed)

89. 0.000 0.000 ↓ 0.0 0

ProjectSet (cost=0.00..0.52 rows=100 width=4) (never executed)

90. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

Planning time : 14.173 ms