explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 0UXv

Settings
# exclusive inclusive rows x rows loops node
1. 2,069.189 14,209.338 ↑ 46.3 1,302 1

GroupAggregate (cost=209,778.10..215,653.25 rows=60,258 width=192) (actual time=10,265.025..14,209.338 rows=1,302 loops=1)

  • Output: (to_char((cdg_date.jour)::timestamp with time zone, 'YYYY'::text)), struct_commune.code_pole, struct_commune.lib_pole, struct_commune.lib_ssserv1, struct_commune.code_uf, struct_commune.lib_uf, rh_fonction_regroupement.libelle_classification_bs, rh_contrat_foch.contrat_foch_libelle, (((sum(rh_f_paie.montant_salaire_brut) - sum(CASE WHEN (rh_type_paie.code_groupe_paie = 'SFR_AMT_ALL_VOL_RET'::text) THEN rh_f_paie.montant_rubrique_paie ELSE '0'::numeric END)) + sum(rh_f_paie.montant_cotisation_patronale)) - (sum(CASE WHEN (rh_type_paie.code_groupe_paie = 'SFR_AMT_ALL_VOL_RET'::text) THEN rh_f_paie.montant_rubrique_paie ELSE '0'::numeric END) * 0.59))
  • Group Key: struct_commune.code_pole, struct_commune.code_uf, rh_fonction_regroupement.libelle_classification_bs, (to_char((cdg_date.jour)::timestamp with time zone, 'YYYY'::text)), struct_commune.lib_pole, struct_commune.lib_ssserv1, struct_commune.lib_uf, rh_contrat_foch.contrat_foch_libelle
  • Filter: ((((sum(rh_f_paie.montant_salaire_brut) - sum(CASE WHEN (rh_type_paie.code_groupe_paie = 'SFR_AMT_ALL_VOL_RET'::text) THEN rh_f_paie.montant_rubrique_paie ELSE '0'::numeric END)) + sum(rh_f_paie.montant_cotisation_patronale)) - (sum(CASE WHEN (rh_type_paie.code_groupe_paie = 'SFR_AMT_ALL_VOL_RET'::text) THEN rh_f_paie.montant_rubrique_paie ELSE '0'::numeric END) * 0.59)) > '0'::numeric)
  • Rows Removed by Filter: 131
  • Buffers: shared hit=4629 read=170696, temp read=40195 written=40195
2. 10,659.490 12,140.149 ↓ 32.5 1,958,942 1

Sort (cost=209,778.10..209,928.74 rows=60,258 width=191) (actual time=10,264.627..12,140.149 rows=1,958,942 loops=1)

  • Output: (to_char((cdg_date.jour)::timestamp with time zone, 'YYYY'::text)), struct_commune.code_pole, struct_commune.lib_pole, struct_commune.lib_ssserv1, struct_commune.code_uf, struct_commune.lib_uf, rh_fonction_regroupement.libelle_classification_bs, rh_contrat_foch.contrat_foch_libelle, rh_f_paie.montant_salaire_brut, rh_type_paie.code_groupe_paie, rh_f_paie.montant_rubrique_paie, rh_f_paie.montant_cotisation_patronale
  • Sort Key: struct_commune.code_pole, struct_commune.code_uf, rh_fonction_regroupement.libelle_classification_bs, (to_char((cdg_date.jour)::timestamp with time zone, 'YYYY'::text)), struct_commune.lib_pole, struct_commune.lib_ssserv1, struct_commune.lib_uf, rh_contrat_foch.contrat_foch_libelle
  • Sort Method: external merge Disk: 321544kB
  • Buffers: shared hit=4629 read=170696, temp read=40195 written=40195
3. 0.000 1,480.659 ↓ 32.5 1,958,942 1

Gather (cost=1,687.73..204,993.96 rows=60,258 width=191) (actual time=9.190..1,480.659 rows=1,958,942 loops=1)

  • Output: (to_char((cdg_date.jour)::timestamp with time zone, 'YYYY'::text)), struct_commune.code_pole, struct_commune.lib_pole, struct_commune.lib_ssserv1, struct_commune.code_uf, struct_commune.lib_uf, rh_fonction_regroupement.libelle_classification_bs, rh_contrat_foch.contrat_foch_libelle, rh_f_paie.montant_salaire_brut, rh_type_paie.code_groupe_paie, rh_f_paie.montant_rubrique_paie, rh_f_paie.montant_cotisation_patronale
  • Workers Planned: 5
  • Workers Launched: 5
  • Buffers: shared hit=4629 read=170696
4. 482.908 1,971.752 ↓ 27.1 326,490 6 / 6

Hash Left Join (cost=687.73..197,727.13 rows=12,052 width=191) (actual time=7.353..1,971.752 rows=326,490 loops=6)

  • Output: to_char((cdg_date.jour)::timestamp with time zone, 'YYYY'::text), struct_commune.code_pole, struct_commune.lib_pole, struct_commune.lib_ssserv1, struct_commune.code_uf, struct_commune.lib_uf, rh_fonction_regroupement.libelle_classification_bs, rh_contrat_foch.contrat_foch_libelle, rh_f_paie.montant_salaire_brut, rh_type_paie.code_groupe_paie, rh_f_paie.montant_rubrique_paie, rh_f_paie.montant_cotisation_patronale
  • Hash Cond: (rh_fonction.id = rh_fonction_regroupement.rh_fonction_id)
  • Buffers: shared hit=2984 read=170696
  • Worker 0: actual time=8.623..2309.941 rows=382315 loops=1
  • Buffers: shared hit=478 read=28292
  • Worker 1: actual time=5.947..2282.774 rows=405079 loops=1
  • Buffers: shared hit=508 read=31310
  • Worker 2: actual time=5.790..2289.308 rows=370368 loops=1
  • Buffers: shared hit=496 read=29096
  • Worker 3: actual time=5.988..2303.209 rows=402186 loops=1
  • Buffers: shared hit=561 read=32208
  • Worker 4: actual time=10.570..2256.507 rows=394185 loops=1
  • Buffers: shared hit=484 read=30196
5. 131.821 1,488.588 ↓ 27.1 326,490 6 / 6

Hash Join (cost=672.66..197,495.31 rows=12,052 width=158) (actual time=7.059..1,488.588 rows=326,490 loops=6)

  • Output: struct_commune.code_pole, struct_commune.lib_pole, struct_commune.lib_ssserv1, struct_commune.code_uf, struct_commune.lib_uf, rh_f_paie.montant_salaire_brut, rh_f_paie.montant_rubrique_paie, rh_f_paie.montant_cotisation_patronale, rh_fonction.id, rh_type_paie.code_groupe_paie, rh_contrat_foch.contrat_foch_libelle, cdg_date.jour
  • Hash Cond: (unite_cdg.id = securite_helper.elt_struct_id)
  • Buffers: shared hit=2936 read=170696
  • Worker 0: actual time=8.285..1723.152 rows=382315 loops=1
  • Buffers: shared hit=470 read=28292
  • Worker 1: actual time=5.689..1721.442 rows=405079 loops=1
  • Buffers: shared hit=500 read=31310
  • Worker 2: actual time=5.515..1704.566 rows=370368 loops=1
  • Buffers: shared hit=488 read=29096
  • Worker 3: actual time=5.715..1730.685 rows=402186 loops=1
  • Buffers: shared hit=553 read=32208
  • Worker 4: actual time=10.172..1676.864 rows=394185 loops=1
  • Buffers: shared hit=476 read=30196
6. 137.745 1,355.137 ↓ 14.3 326,490 6 / 6

Hash Join (cost=546.29..197,205.86 rows=22,887 width=170) (actual time=5.336..1,355.137 rows=326,490 loops=6)

  • Output: unite_cdg.id, struct_commune.code_pole, struct_commune.lib_pole, struct_commune.lib_ssserv1, struct_commune.code_uf, struct_commune.lib_uf, struct_commune.id_elt_struct, rh_f_paie.montant_salaire_brut, rh_f_paie.montant_rubrique_paie, rh_f_paie.montant_cotisation_patronale, rh_f_paie.elt_struct_id, rh_fonction.id, rh_type_paie.code_groupe_paie, rh_contrat_foch.contrat_foch_libelle, cdg_date.jour
  • Hash Cond: (rh_f_paie.rh_type_paie_id = rh_type_paie.id)
  • Buffers: shared hit=2629 read=170696
  • Worker 0: actual time=6.100..1562.117 rows=382315 loops=1
  • Buffers: shared hit=416 read=28292
  • Worker 1: actual time=4.310..1558.369 rows=405079 loops=1
  • Buffers: shared hit=446 read=31310
  • Worker 2: actual time=4.077..1548.409 rows=370368 loops=1
  • Buffers: shared hit=434 read=29096
  • Worker 3: actual time=4.323..1568.755 rows=402186 loops=1
  • Buffers: shared hit=499 read=32208
  • Worker 4: actual time=7.884..1523.051 rows=394185 loops=1
  • Buffers: shared hit=422 read=30196
7. 163.641 1,216.632 ↓ 14.3 326,490 6 / 6

Hash Join (cost=506.22..196,851.10 rows=22,887 width=156) (actual time=4.552..1,216.632 rows=326,490 loops=6)

  • Output: unite_cdg.id, struct_commune.code_pole, struct_commune.lib_pole, struct_commune.lib_ssserv1, struct_commune.code_uf, struct_commune.lib_uf, struct_commune.id_elt_struct, rh_f_paie.montant_salaire_brut, rh_f_paie.montant_rubrique_paie, rh_f_paie.montant_cotisation_patronale, rh_f_paie.elt_struct_id, rh_f_paie.rh_type_paie_id, rh_fonction.id, rh_contrat_foch.contrat_foch_libelle, cdg_date.jour
  • Hash Cond: (rh_f_paie.elt_struct_id = unite_cdg.id)
  • Buffers: shared hit=2527 read=170696
  • Worker 0: actual time=5.165..1392.705 rows=382315 loops=1
  • Buffers: shared hit=399 read=28292
  • Worker 1: actual time=3.650..1393.580 rows=405079 loops=1
  • Buffers: shared hit=429 read=31310
  • Worker 2: actual time=3.415..1382.715 rows=370368 loops=1
  • Buffers: shared hit=417 read=29096
  • Worker 3: actual time=3.639..1402.743 rows=402186 loops=1
  • Buffers: shared hit=482 read=32208
  • Worker 4: actual time=6.885..1361.957 rows=394185 loops=1
  • Buffers: shared hit=405 read=30196
8. 134.063 1,051.177 ↓ 14.3 326,490 6 / 6

Hash Join (cost=28.88..196,059.07 rows=22,887 width=65) (actual time=2.709..1,051.177 rows=326,490 loops=6)

  • Output: rh_f_paie.montant_salaire_brut, rh_f_paie.montant_rubrique_paie, rh_f_paie.montant_cotisation_patronale, rh_f_paie.elt_struct_id, rh_f_paie.rh_type_paie_id, rh_fonction.id, rh_contrat_foch.contrat_foch_libelle, cdg_date.jour
  • Hash Cond: (rh_f_paie.rh_contrat_foch_id = rh_contrat_foch.id)
  • Buffers: shared hit=2168 read=170696
  • Worker 0: actual time=2.949..1192.140 rows=382315 loops=1
  • Buffers: shared hit=339 read=28292
  • Worker 1: actual time=1.953..1192.231 rows=405079 loops=1
  • Buffers: shared hit=369 read=31310
  • Worker 2: actual time=1.758..1187.915 rows=370368 loops=1
  • Buffers: shared hit=357 read=29096
  • Worker 3: actual time=2.129..1203.046 rows=402186 loops=1
  • Buffers: shared hit=422 read=32208
  • Worker 4: actual time=4.369..1170.866 rows=394185 loops=1
  • Buffers: shared hit=345 read=30196
9. 184.329 917.041 ↓ 12.0 356,878 6 / 6

Hash Join (cost=27.31..195,717.05 rows=29,753 width=33) (actual time=2.551..917.041 rows=356,878 loops=6)

  • Output: rh_f_paie.montant_salaire_brut, rh_f_paie.montant_rubrique_paie, rh_f_paie.montant_cotisation_patronale, rh_f_paie.elt_struct_id, rh_f_paie.rh_type_paie_id, rh_f_paie.rh_contrat_foch_id, rh_fonction.id, cdg_date.jour
  • Hash Cond: ((rh_f_paie.annee = cdg_date.annee) AND (rh_f_paie.mois = cdg_date.mois))
  • Buffers: shared hit=2077 read=170696
  • Worker 0: actual time=2.753..1031.472 rows=407923 loops=1
  • Buffers: shared hit=321 read=28292
  • Worker 1: actual time=1.792..1028.873 rows=440514 loops=1
  • Buffers: shared hit=351 read=31310
  • Worker 2: actual time=1.599..1030.664 rows=393335 loops=1
  • Buffers: shared hit=339 read=29096
  • Worker 3: actual time=1.982..1039.073 rows=436283 loops=1
  • Buffers: shared hit=404 read=32208
  • Worker 4: actual time=4.129..1017.061 rows=428477 loops=1
  • Buffers: shared hit=327 read=30196
10. 338.761 731.234 ↓ 2.0 536,839 6 / 6

Hash Join (cost=11.27..186,573.88 rows=271,680 width=37) (actual time=0.866..731.234 rows=536,839 loops=6)

  • Output: rh_f_paie.montant_salaire_brut, rh_f_paie.montant_rubrique_paie, rh_f_paie.montant_cotisation_patronale, rh_f_paie.elt_struct_id, rh_f_paie.rh_type_paie_id, rh_f_paie.rh_contrat_foch_id, rh_f_paie.annee, rh_f_paie.mois, rh_fonction.id
  • Hash Cond: (rh_f_paie.rh_fonction_id = rh_fonction.id)
  • Buffers: shared hit=1975 read=170696
  • Worker 0: actual time=0.838..811.804 rows=565046 loops=1
  • Buffers: shared hit=301 read=28292
  • Worker 1: actual time=0.419..813.142 rows=641743 loops=1
  • Buffers: shared hit=331 read=31310
  • Worker 2: actual time=0.436..813.973 rows=547918 loops=1
  • Buffers: shared hit=319 read=29096
  • Worker 3: actual time=0.857..823.564 rows=634094 loops=1
  • Buffers: shared hit=384 read=32208
  • Worker 4: actual time=2.113..806.276 rows=622026 loops=1
  • Buffers: shared hit=307 read=30196
11. 392.131 392.131 ↑ 1.2 681,400 6 / 6

Parallel Seq Scan on rh.rh_f_paie (cost=0.00..180,797.40 rows=815,040 width=37) (actual time=0.299..392.131 rows=681,400 loops=6)

  • Output: rh_f_paie.rh_personnel_id, rh_f_paie.annee, rh_f_paie.mois, rh_f_paie.rh_contrat_id, rh_f_paie.rh_fonction_id, rh_f_paie.rh_statut_id, rh_f_paie.rh_type_paie_id, rh_f_paie.code_groupe_paie, rh_f_paie.elt_struct_id, rh_f_paie.contrat_code, rh_f_paie.contrat_libelle, rh_f_paie.is_vacataire_sur_un_mois, rh_f_paie.rh_contrat_foch_id, rh_f_paie.montant_cotisation_patronale, rh_f_paie.montant_hs_rem, rh_f_paie.montant_salaire_brut, rh_f_paie.montant_indemnite_prime, rh_f_paie.montant_rubrique_paie, rh_f_paie.nb_jour_cet, rh_f_paie.montant_cet, rh_f_paie.nb_base_rubrique_paie, rh_f_paie.montant_salaire_brut_par_type
  • Buffers: shared hit=1951 read=170696
  • Worker 0: actual time=0.265..422.174 rows=719165 loops=1
  • Buffers: shared hit=297 read=28292
  • Worker 1: actual time=0.109..432.180 rows=816863 loops=1
  • Buffers: shared hit=327 read=31310
  • Worker 2: actual time=0.131..424.419 rows=695682 loops=1
  • Buffers: shared hit=315 read=29096
  • Worker 3: actual time=0.118..435.176 rows=805272 loops=1
  • Buffers: shared hit=380 read=32208
  • Worker 4: actual time=0.945..425.855 rows=790290 loops=1
  • Buffers: shared hit=303 read=30196
12. 0.070 0.342 ↓ 2.4 274 6 / 6

Hash (cost=9.86..9.86 rows=113 width=4) (actual time=0.342..0.342 rows=274 loops=6)

  • Output: rh_fonction.id
  • Buckets: 1024 Batches: 1 Memory Usage: 18kB
  • Buffers: shared hit=24
  • Worker 0: actual time=0.436..0.436 rows=274 loops=1
  • Buffers: shared hit=4
  • Worker 1: actual time=0.290..0.290 rows=274 loops=1
  • Buffers: shared hit=4
  • Worker 2: actual time=0.284..0.284 rows=274 loops=1
  • Buffers: shared hit=4
  • Worker 3: actual time=0.275..0.275 rows=274 loops=1
  • Buffers: shared hit=4
  • Worker 4: actual time=0.467..0.467 rows=274 loops=1
  • Buffers: shared hit=4
13. 0.167 0.272 ↓ 2.4 274 6 / 6

Hash Join (cost=1.05..9.86 rows=113 width=4) (actual time=0.079..0.272 rows=274 loops=6)

  • Output: rh_fonction.id
  • Hash Cond: (rh_fonction.is_pm_pnm_code = type_personnel.id)
  • Buffers: shared hit=24
  • Worker 0: actual time=0.095..0.332 rows=274 loops=1
  • Buffers: shared hit=4
  • Worker 1: actual time=0.076..0.248 rows=274 loops=1
  • Buffers: shared hit=4
  • Worker 2: actual time=0.077..0.235 rows=274 loops=1
  • Buffers: shared hit=4
  • Worker 3: actual time=0.071..0.227 rows=274 loops=1
  • Buffers: shared hit=4
  • Worker 4: actual time=0.123..0.365 rows=274 loops=1
  • Buffers: shared hit=4
14. 0.072 0.072 ↑ 1.0 340 6 / 6

Seq Scan on alias_mat.rh_fonction (cost=0.00..6.40 rows=340 width=8) (actual time=0.019..0.072 rows=340 loops=6)

  • Output: rh_fonction.id, rh_fonction.code, rh_fonction.libelle, rh_fonction.is_pm_pnm, rh_fonction.is_pm_pnm_code
  • Buffers: shared hit=18
  • Worker 0: actual time=0.021..0.080 rows=340 loops=1
  • Buffers: shared hit=3
  • Worker 1: actual time=0.018..0.068 rows=340 loops=1
  • Buffers: shared hit=3
  • Worker 2: actual time=0.018..0.069 rows=340 loops=1
  • Buffers: shared hit=3
  • Worker 3: actual time=0.017..0.063 rows=340 loops=1
  • Buffers: shared hit=3
  • Worker 4: actual time=0.029..0.095 rows=340 loops=1
  • Buffers: shared hit=3
15. 0.005 0.033 ↑ 1.0 1 6 / 6

Hash (cost=1.04..1.04 rows=1 width=4) (actual time=0.033..0.033 rows=1 loops=6)

  • Output: type_personnel.id
  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=6
  • Worker 0: actual time=0.037..0.037 rows=1 loops=1
  • Buffers: shared hit=1
  • Worker 1: actual time=0.033..0.033 rows=1 loops=1
  • Buffers: shared hit=1
  • Worker 2: actual time=0.032..0.032 rows=1 loops=1
  • Buffers: shared hit=1
  • Worker 3: actual time=0.029..0.029 rows=1 loops=1
  • Buffers: shared hit=1
  • Worker 4: actual time=0.051..0.051 rows=1 loops=1
  • Buffers: shared hit=1
16. 0.028 0.028 ↑ 1.0 1 6 / 6

Seq Scan on alias_mat.type_personnel (cost=0.00..1.04 rows=1 width=4) (actual time=0.026..0.028 rows=1 loops=6)

  • Output: type_personnel.id
  • Filter: (type_personnel.code = 'PNM'::text)
  • Rows Removed by Filter: 2
  • Buffers: shared hit=6
  • Worker 0: actual time=0.029..0.030 rows=1 loops=1
  • Buffers: shared hit=1
  • Worker 1: actual time=0.027..0.028 rows=1 loops=1
  • Buffers: shared hit=1
  • Worker 2: actual time=0.026..0.028 rows=1 loops=1
  • Buffers: shared hit=1
  • Worker 3: actual time=0.023..0.025 rows=1 loops=1
  • Buffers: shared hit=1
  • Worker 4: actual time=0.040..0.043 rows=1 loops=1
  • Buffers: shared hit=1
17. 0.066 1.478 ↓ 4.4 145 6 / 6

Hash (cost=15.55..15.55 rows=33 width=12) (actual time=1.478..1.478 rows=145 loops=6)

  • Output: cdg_date.jour, cdg_date.annee, cdg_date.mois
  • Buckets: 1024 Batches: 1 Memory Usage: 15kB
  • Buffers: shared hit=102
  • Worker 0: actual time=1.883..1.883 rows=145 loops=1
  • Buffers: shared hit=20
  • Worker 1: actual time=1.347..1.347 rows=145 loops=1
  • Buffers: shared hit=20
  • Worker 2: actual time=1.142..1.142 rows=145 loops=1
  • Buffers: shared hit=20
  • Worker 3: actual time=1.105..1.105 rows=145 loops=1
  • Buffers: shared hit=20
  • Worker 4: actual time=1.980..1.980 rows=145 loops=1
  • Buffers: shared hit=20
18. 1.412 1.412 ↓ 4.4 145 6 / 6

Seq Scan on alias_mat.cdg_date (cost=0.00..15.55 rows=33 width=12) (actual time=0.362..1.412 rows=145 loops=6)

  • Output: cdg_date.jour, cdg_date.annee, cdg_date.mois
  • Filter: ((to_char((cdg_date.jour)::timestamp with time zone, 'YYYY'::text) >= to_char((('now'::cstring)::date + '-1 years -1 mons'::interval), 'YYYY'::text)) AND (to_char((cdg_date.jour)::timestamp with time zone, 'MM'::text) <= to_char((('now'::cstring)::date + '-1 mons'::interval), 'MM'::text)))
  • Rows Removed by Filter: 156
  • Buffers: shared hit=102
  • Worker 0: actual time=0.461..1.811 rows=145 loops=1
  • Buffers: shared hit=20
  • Worker 1: actual time=0.366..1.278 rows=145 loops=1
  • Buffers: shared hit=20
  • Worker 2: actual time=0.389..1.096 rows=145 loops=1
  • Buffers: shared hit=20
  • Worker 3: actual time=0.320..1.044 rows=145 loops=1
  • Buffers: shared hit=20
  • Worker 4: actual time=0.546..1.892 rows=145 loops=1
  • Buffers: shared hit=20
19. 0.012 0.073 ↑ 1.0 20 6 / 6

Hash (cost=1.32..1.32 rows=20 width=44) (actual time=0.073..0.073 rows=20 loops=6)

  • Output: rh_contrat_foch.contrat_foch_libelle, rh_contrat_foch.id
  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
  • Buffers: shared hit=21
  • Worker 0: actual time=0.089..0.089 rows=20 loops=1
  • Buffers: shared hit=4
  • Worker 1: actual time=0.064..0.064 rows=20 loops=1
  • Buffers: shared hit=4
  • Worker 2: actual time=0.080..0.080 rows=20 loops=1
  • Buffers: shared hit=4
  • Worker 3: actual time=0.068..0.068 rows=20 loops=1
  • Buffers: shared hit=4
  • Worker 4: actual time=0.104..0.104 rows=20 loops=1
  • Buffers: shared hit=4
20. 0.061 0.061 ↑ 1.0 20 6 / 6

Seq Scan on rh.rh_contrat_foch (cost=0.00..1.32 rows=20 width=44) (actual time=0.054..0.061 rows=20 loops=6)

  • Output: rh_contrat_foch.contrat_foch_libelle, rh_contrat_foch.id
  • Filter: ((rh_contrat_foch.contrat_foch_code)::text <> 'JNSUP'::text)
  • Rows Removed by Filter: 6
  • Buffers: shared hit=21
  • Worker 0: actual time=0.063..0.072 rows=20 loops=1
  • Buffers: shared hit=4
  • Worker 1: actual time=0.048..0.055 rows=20 loops=1
  • Buffers: shared hit=4
  • Worker 2: actual time=0.064..0.069 rows=20 loops=1
  • Buffers: shared hit=4
  • Worker 3: actual time=0.052..0.059 rows=20 loops=1
  • Buffers: shared hit=4
  • Worker 4: actual time=0.079..0.089 rows=20 loops=1
  • Buffers: shared hit=4
21. 0.291 1.814 ↑ 1.0 640 6 / 6

Hash (cost=469.34..469.34 rows=640 width=91) (actual time=1.814..1.814 rows=640 loops=6)

  • Output: unite_cdg.id, struct_commune.code_pole, struct_commune.lib_pole, struct_commune.lib_ssserv1, struct_commune.code_uf, struct_commune.lib_uf, struct_commune.id_elt_struct
  • Buckets: 1024 Batches: 1 Memory Usage: 62kB
  • Buffers: shared hit=359
  • Worker 0: actual time=2.185..2.185 rows=640 loops=1
  • Buffers: shared hit=60
  • Worker 1: actual time=1.669..1.669 rows=640 loops=1
  • Buffers: shared hit=60
  • Worker 2: actual time=1.628..1.628 rows=640 loops=1
  • Buffers: shared hit=60
  • Worker 3: actual time=1.485..1.485 rows=640 loops=1
  • Buffers: shared hit=60
  • Worker 4: actual time=2.470..2.470 rows=640 loops=1
  • Buffers: shared hit=60
22. 0.461 1.523 ↑ 1.0 640 6 / 6

Hash Join (cost=40.65..469.34 rows=640 width=91) (actual time=0.598..1.523 rows=640 loops=6)

  • Output: unite_cdg.id, struct_commune.code_pole, struct_commune.lib_pole, struct_commune.lib_ssserv1, struct_commune.code_uf, struct_commune.lib_uf, struct_commune.id_elt_struct
  • Hash Cond: (struct_commune.id_elt_struct = unite_cdg.id)
  • Buffers: shared hit=359
  • Worker 0: actual time=0.722..1.838 rows=640 loops=1
  • Buffers: shared hit=60
  • Worker 1: actual time=0.600..1.432 rows=640 loops=1
  • Buffers: shared hit=60
  • Worker 2: actual time=0.494..1.383 rows=640 loops=1
  • Buffers: shared hit=60
  • Worker 3: actual time=0.459..1.241 rows=640 loops=1
  • Buffers: shared hit=60
  • Worker 4: actual time=0.835..2.081 rows=640 loops=1
  • Buffers: shared hit=60
23. 0.510 0.679 ↑ 1.0 640 6 / 6

Bitmap Heap Scan on alias_mat.struct_commune (cost=17.25..437.14 rows=640 width=87) (actual time=0.190..0.679 rows=640 loops=6)

  • Output: struct_commune.id, struct_commune.id_elt_struct, struct_commune.code_elt_struct, struct_commune.libelle_elt_struct, struct_commune.type_elt_struct, struct_commune.code_hie, struct_commune.libelle_hie, struct_commune.code_uf, struct_commune.lib_uf, struct_commune.code_um, struct_commune.lib_um, struct_commune.code_service, struct_commune.lib_service, struct_commune.code_pole, struct_commune.lib_pole, struct_commune.code_geo, struct_commune.lib_geo, struct_commune.code_jur, struct_commune.lib_jur, struct_commune.code_rgpt_unite, struct_commune.lib_rgpt_unite, struct_commune.code_rgpt_etab, struct_commune.lib_rgpt_etab, struct_commune.code_ent, struct_commune.lib_ent, struct_commune.code_ssserv1, struct_commune.lib_ssserv1, struct_commune.code_ssserv2, struct_commune.lib_ssserv2, struct_commune.code_ssserv3, struct_commune.lib_ssserv3, struct_commune.code_ca, struct_commune.lib_ca, struct_commune.code_cr, struct_commune.lib_cr, struct_commune.src_type, struct_commune.src_id, struct_commune.d_ins, struct_commune.d_upd, struct_commune.code_etf, struct_commune.lib_etf, struct_commune.code_etm, struct_commune.lib_etm, struct_commune.lib_jur_court, struct_commune.lib_geo_court, struct_commune.is_defaut_unite, struct_commune.is_defaut_et
  • Recheck Cond: (struct_commune.code_hie = 'PMSIPILOT_14'::text)
  • Heap Blocks: exact=45
  • Buffers: shared hit=305
  • Worker 0: actual time=0.233..0.793 rows=640 loops=1
  • Buffers: shared hit=51
  • Worker 1: actual time=0.199..0.665 rows=640 loops=1
  • Buffers: shared hit=51
  • Worker 2: actual time=0.157..0.695 rows=640 loops=1
  • Buffers: shared hit=51
  • Worker 3: actual time=0.146..0.587 rows=640 loops=1
  • Buffers: shared hit=51
  • Worker 4: actual time=0.262..0.967 rows=640 loops=1
  • Buffers: shared hit=51
24. 0.169 0.169 ↑ 1.0 640 6 / 6

Bitmap Index Scan on idx_struct_commune_code_hie (cost=0.00..17.09 rows=640 width=0) (actual time=0.169..0.169 rows=640 loops=6)

  • Index Cond: (struct_commune.code_hie = 'PMSIPILOT_14'::text)
  • Buffers: shared hit=35
  • Worker 0: actual time=0.212..0.212 rows=640 loops=1
  • Buffers: shared hit=6
  • Worker 1: actual time=0.177..0.177 rows=640 loops=1
  • Buffers: shared hit=6
  • Worker 2: actual time=0.139..0.139 rows=640 loops=1
  • Buffers: shared hit=6
  • Worker 3: actual time=0.132..0.132 rows=640 loops=1
  • Buffers: shared hit=6
  • Worker 4: actual time=0.222..0.222 rows=640 loops=1
  • Buffers: shared hit=6
25. 0.159 0.383 ↑ 1.0 640 6 / 6

Hash (cost=15.40..15.40 rows=640 width=4) (actual time=0.383..0.383 rows=640 loops=6)

  • Output: unite_cdg.id
  • Buckets: 1024 Batches: 1 Memory Usage: 31kB
  • Buffers: shared hit=54
  • Worker 0: actual time=0.460..0.460 rows=640 loops=1
  • Buffers: shared hit=9
  • Worker 1: actual time=0.370..0.370 rows=640 loops=1
  • Buffers: shared hit=9
  • Worker 2: actual time=0.314..0.314 rows=640 loops=1
  • Buffers: shared hit=9
  • Worker 3: actual time=0.291..0.291 rows=640 loops=1
  • Buffers: shared hit=9
  • Worker 4: actual time=0.535..0.535 rows=640 loops=1
  • Buffers: shared hit=9
26. 0.224 0.224 ↑ 1.0 640 6 / 6

Seq Scan on alias_mat.unite_cdg (cost=0.00..15.40 rows=640 width=4) (actual time=0.033..0.224 rows=640 loops=6)

  • Output: unite_cdg.id
  • Buffers: shared hit=54
  • Worker 0: actual time=0.034..0.263 rows=640 loops=1
  • Buffers: shared hit=9
  • Worker 1: actual time=0.058..0.248 rows=640 loops=1
  • Buffers: shared hit=9
  • Worker 2: actual time=0.027..0.181 rows=640 loops=1
  • Buffers: shared hit=9
  • Worker 3: actual time=0.025..0.159 rows=640 loops=1
  • Buffers: shared hit=9
  • Worker 4: actual time=0.042..0.333 rows=640 loops=1
  • Buffers: shared hit=9
27. 0.339 0.760 ↑ 1.0 1,025 6 / 6

Hash (cost=27.25..27.25 rows=1,025 width=22) (actual time=0.760..0.760 rows=1,025 loops=6)

  • Output: rh_type_paie.code_groupe_paie, rh_type_paie.id
  • Buckets: 2048 Batches: 1 Memory Usage: 72kB
  • Buffers: shared hit=102
  • Worker 0: actual time=0.907..0.907 rows=1025 loops=1
  • Buffers: shared hit=17
  • Worker 1: actual time=0.638..0.638 rows=1025 loops=1
  • Buffers: shared hit=17
  • Worker 2: actual time=0.640..0.640 rows=1025 loops=1
  • Buffers: shared hit=17
  • Worker 3: actual time=0.663..0.663 rows=1025 loops=1
  • Buffers: shared hit=17
  • Worker 4: actual time=0.965..0.965 rows=1025 loops=1
  • Buffers: shared hit=17
28. 0.421 0.421 ↑ 1.0 1,025 6 / 6

Seq Scan on rh.rh_type_paie (cost=0.00..27.25 rows=1,025 width=22) (actual time=0.027..0.421 rows=1,025 loops=6)

  • Output: rh_type_paie.code_groupe_paie, rh_type_paie.id
  • Buffers: shared hit=102
  • Worker 0: actual time=0.025..0.507 rows=1025 loops=1
  • Buffers: shared hit=17
  • Worker 1: actual time=0.019..0.358 rows=1025 loops=1
  • Buffers: shared hit=17
  • Worker 2: actual time=0.043..0.357 rows=1025 loops=1
  • Buffers: shared hit=17
  • Worker 3: actual time=0.021..0.370 rows=1025 loops=1
  • Buffers: shared hit=17
  • Worker 4: actual time=0.032..0.527 rows=1025 loops=1
  • Buffers: shared hit=17
29. 0.087 1.630 ↓ 1.6 337 6 / 6

Hash (cost=123.68..123.68 rows=216 width=4) (actual time=1.630..1.630 rows=337 loops=6)

  • Output: securite_helper.elt_struct_id
  • Buckets: 1024 Batches: 1 Memory Usage: 20kB
  • Buffers: shared hit=237
  • Worker 0: actual time=2.078..2.078 rows=337 loops=1
  • Buffers: shared hit=40
  • Worker 1: actual time=1.283..1.283 rows=337 loops=1
  • Buffers: shared hit=40
  • Worker 2: actual time=1.352..1.352 rows=337 loops=1
  • Buffers: shared hit=40
  • Worker 3: actual time=1.293..1.293 rows=337 loops=1
  • Buffers: shared hit=40
  • Worker 4: actual time=2.126..2.126 rows=337 loops=1
  • Buffers: shared hit=40
30. 0.195 1.543 ↓ 1.6 337 6 / 6

HashAggregate (cost=121.52..123.68 rows=216 width=4) (actual time=1.488..1.543 rows=337 loops=6)

  • Output: securite_helper.elt_struct_id
  • Group Key: securite_helper.elt_struct_id
  • Buffers: shared hit=237
  • Worker 0: actual time=1.898..1.962 rows=337 loops=1
  • Buffers: shared hit=40
  • Worker 1: actual time=1.174..1.217 rows=337 loops=1
  • Buffers: shared hit=40
  • Worker 2: actual time=1.244..1.286 rows=337 loops=1
  • Buffers: shared hit=40
  • Worker 3: actual time=1.184..1.224 rows=337 loops=1
  • Buffers: shared hit=40
  • Worker 4: actual time=1.948..2.015 rows=337 loops=1
  • Buffers: shared hit=40
31. 1.348 1.348 ↑ 1.0 337 6 / 6

Seq Scan on secu.temp_security_view securite_helper (cost=0.00..120.68 rows=337 width=4) (actual time=0.064..1.348 rows=337 loops=6)

  • Output: securite_helper.elt_struct_id
  • Filter: (securite_helper.user_id = 'RHgestion'::text)
  • Rows Removed by Filter: 6357
  • Buffers: shared hit=237
  • Worker 0: actual time=0.069..1.733 rows=337 loops=1
  • Buffers: shared hit=40
  • Worker 1: actual time=0.062..1.051 rows=337 loops=1
  • Buffers: shared hit=40
  • Worker 2: actual time=0.060..1.117 rows=337 loops=1
  • Buffers: shared hit=40
  • Worker 3: actual time=0.064..1.067 rows=337 loops=1
  • Buffers: shared hit=40
  • Worker 4: actual time=0.107..1.770 rows=337 loops=1
  • Buffers: shared hit=40
32. 0.101 0.256 ↑ 1.0 314 6 / 6

Hash (cost=11.14..11.14 rows=314 width=13) (actual time=0.256..0.256 rows=314 loops=6)

  • Output: rh_fonction_regroupement.libelle_classification_bs, rh_fonction_regroupement.rh_fonction_id
  • Buckets: 1024 Batches: 1 Memory Usage: 23kB
  • Buffers: shared hit=48
  • Worker 0: actual time=0.295..0.295 rows=314 loops=1
  • Buffers: shared hit=8
  • Worker 1: actual time=0.226..0.226 rows=314 loops=1
  • Buffers: shared hit=8
  • Worker 2: actual time=0.240..0.240 rows=314 loops=1
  • Buffers: shared hit=8
  • Worker 3: actual time=0.235..0.235 rows=314 loops=1
  • Buffers: shared hit=8
  • Worker 4: actual time=0.344..0.344 rows=314 loops=1
  • Buffers: shared hit=8
33. 0.155 0.155 ↑ 1.0 314 6 / 6

Seq Scan on rh.rh_fonction_regroupement (cost=0.00..11.14 rows=314 width=13) (actual time=0.025..0.155 rows=314 loops=6)

  • Output: rh_fonction_regroupement.libelle_classification_bs, rh_fonction_regroupement.rh_fonction_id
  • Buffers: shared hit=48
  • Worker 0: actual time=0.029..0.171 rows=314 loops=1
  • Buffers: shared hit=8
  • Worker 1: actual time=0.023..0.146 rows=314 loops=1
  • Buffers: shared hit=8
  • Worker 2: actual time=0.024..0.157 rows=314 loops=1
  • Buffers: shared hit=8
  • Worker 3: actual time=0.025..0.153 rows=314 loops=1
  • Buffers: shared hit=8
  • Worker 4: actual time=0.040..0.206 rows=314 loops=1
  • Buffers: shared hit=8