explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VUKX : Optimization for: Optimization for: plan #CgMh; plan #z7W4

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 1,482.716 11,244.811 ↓ 46.2 5,218,810 1

Hash Join (cost=608,029.86..656,649.41 rows=112,936 width=513) (actual time=7,866.519..11,244.811 rows=5,218,810 loops=1)

  • Hash Cond: (i1_.id_jdd = i2_.id_jdd)
2. 1,895.050 9,748.090 ↓ 17.1 400,645 1

Hash Join (cost=607,317.69..654,573.42 rows=23,442 width=513) (actual time=7,852.494..9,748.090 rows=400,645 loops=1)

  • Hash Cond: (g.cd_ref = i0_.cd_nom)
3. 0.902 1.110 ↑ 1.1 2,563 1

Bitmap Heap Scan on vm_requeteur_groupes g (cost=54.51..2,622.39 rows=2,850 width=4) (actual time=0.220..1.110 rows=2,563 loops=1)

  • Recheck Cond: (gid = 12)
4. 0.208 0.208 ↑ 1.1 2,563 1

Bitmap Index Scan on vm_requeteur_groupes_gid_idx (cost=0.00..53.80 rows=2,850 width=0) (actual time=0.208..0.208 rows=2,563 loops=1)

  • Index Cond: (gid = 12)
5. 542.123 7,851.930 ↓ 1.1 436,721 1

Hash (cost=575,259.35..575,259.35 rows=405,586 width=517) (actual time=7,851.930..7,851.930 rows=436,721 loops=1)

  • Buckets: 1024 Batches: 8192 (originally 256) Memory Usage: 3483kB
6. 3,723.169 7,309.807 ↓ 1.1 436,721 1

Hash Join (cost=204,525.88..575,259.35 rows=405,586 width=517) (actual time=1,312.044..7,309.807 rows=436,721 loops=1)

  • Hash Cond: (i0_.id_releve = i1_.rid)
7. 2,289.108 2,289.108 ↑ 1.0 4,124,641 1

Seq Scan on vm_requeteur_observations i0_ (cost=0.00..187,835.41 rows=4,124,641 width=105) (actual time=0.092..2,289.108 rows=4,124,641 loops=1)

8. 351.700 1,297.530 ↑ 1.0 395,935 1

Hash (cost=178,309.69..178,309.69 rows=395,935 width=412) (actual time=1,297.530..1,297.530 rows=395,935 loops=1)

  • Buckets: 1024 Batches: 256 Memory Usage: 595kB
9. 945.830 945.830 ↑ 1.0 395,935 1

Seq Scan on vm_requeteur_releves i1_ (cost=0.00..178,309.69 rows=395,935 width=412) (actual time=0.022..945.830 rows=395,935 loops=1)

  • Filter: ((departement)::text = '33'::text)
  • Rows Removed by Filter: 1688760
10. 2.954 14.005 ↓ 1.6 10,386 1

Hash (cost=630.51..630.51 rows=6,533 width=4) (actual time=14.005..14.005 rows=10,386 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 366kB
11. 3.272 11.051 ↓ 1.6 10,386 1

Hash Join (cost=400.50..630.51 rows=6,533 width=4) (actual time=5.252..11.051 rows=10,386 loops=1)

  • Hash Cond: (i2_.id_ca = i3_.id_ca)
12. 1.634 4.777 ↑ 1.0 3,279 1

Hash Right Join (cost=257.51..405.55 rows=3,328 width=8) (actual time=2.239..4.777 rows=3,279 loops=1)

  • Hash Cond: (i5_.id_jdd = i2_.id_jdd)
13. 0.933 0.933 ↑ 1.0 3,279 1

Seq Scan on jdd_contact_donnees i5_ (cost=0.00..102.28 rows=3,328 width=4) (actual time=0.008..0.933 rows=3,279 loops=1)

14. 0.715 2.210 ↑ 1.1 1,226 1

Hash (cost=240.56..240.56 rows=1,356 width=8) (actual time=2.210..2.210 rows=1,226 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 48kB
15. 1.495 1.495 ↑ 1.1 1,226 1

Seq Scan on jdd i2_ (cost=0.00..240.56 rows=1,356 width=8) (actual time=0.005..1.495 rows=1,226 loops=1)

16. 0.553 3.002 ↓ 1.2 1,044 1

Hash (cost=131.73..131.73 rows=901 width=4) (actual time=3.002..3.002 rows=1,044 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 37kB
17. 1.229 2.449 ↓ 1.2 1,044 1

Hash Right Join (cost=83.33..131.73 rows=901 width=4) (actual time=0.655..2.449 rows=1,044 loops=1)

  • Hash Cond: (i4_.id_ca = i3_.id_ca)
18. 0.590 0.590 ↓ 1.1 964 1

Seq Scan on ca_contact i4_ (cost=0.00..36.01 rows=901 width=4) (actual time=0.009..0.590 rows=964 loops=1)

19. 0.248 0.630 ↑ 1.1 409 1

Hash (cost=77.59..77.59 rows=459 width=4) (actual time=0.630..0.630 rows=409 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 15kB
20. 0.382 0.382 ↑ 1.1 409 1

Seq Scan on ca i3_ (cost=0.00..77.59 rows=459 width=4) (actual time=0.010..0.382 rows=409 loops=1)

Total runtime : 11,914.724 ms