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