"HashAggregate  (cost=50810.98..50810.99 rows=1 width=1528) (actual time=6691296.912..6691298.572 rows=1069 loops=1)"
"  Output: vue_mutphp4test.nommutcdt, vue_mutphp4test.premutcdt, vue_mutphp4test.auxadrsyn, vue_mutphp4test.voiadrsyn, vue_mutphp4test.bopadrsyn, vue_mutphp4test.copadrsyn, vue_mutphp4test.locadrsyn, vue_mutphp4test.quaadrsyn, vue_mutphp4test.cotadrsyn, vue_mutphp4test.ctcadrsyn, vue_mutphp4test.auxadr, vue_mutphp4test.voiadr, vue_mutphp4test.bopadr, vue_mutphp4test.copadr, vue_mutphp4test.locadr, vue_mutphp4test.quaadr, vue_mutphp4test.cotadr, vue_mutphp4test.ctcadr, vue_mutphp4test.auxadrvac, vue_mutphp4test.voiadrvac, vue_mutphp4test.bopadrvac, vue_mutphp4test.copadrvac, vue_mutphp4test.locadrvac, vue_mutphp4test.quaadrvac, vue_mutphp4test.cotadrvac, vue_mutphp4test.ctcadrvac"
"  Buffers: shared hit=3360827 read=14936236, temp read=4137546 written=4080184"
"  ->  Subquery Scan on vue_mutphp4test  (cost=50810.80..50810.91 rows=1 width=1528) (actual time=6691288.043..6691292.976 rows=1069 loops=1)"
"        Output: vue_mutphp4test.nommutcdt, vue_mutphp4test.premutcdt, vue_mutphp4test.auxadrsyn, vue_mutphp4test.voiadrsyn, vue_mutphp4test.bopadrsyn, vue_mutphp4test.copadrsyn, vue_mutphp4test.locadrsyn, vue_mutphp4test.quaadrsyn, vue_mutphp4test.cotadrsyn, vue_mutphp4test.ctcadrsyn, vue_mutphp4test.auxadr, vue_mutphp4test.voiadr, vue_mutphp4test.bopadr, vue_mutphp4test.copadr, vue_mutphp4test.locadr, vue_mutphp4test.quaadr, vue_mutphp4test.cotadr, vue_mutphp4test.ctcadr, vue_mutphp4test.auxadrvac, vue_mutphp4test.voiadrvac, vue_mutphp4test.bopadrvac, vue_mutphp4test.copadrvac, vue_mutphp4test.locadrvac, vue_mutphp4test.quaadrvac, vue_mutphp4test.cotadrvac, vue_mutphp4test.ctcadrvac"
"        Buffers: shared hit=3360827 read=14936236, temp read=4137546 written=4080184"
"        ->  HashAggregate  (cost=50810.80..50810.90 rows=1 width=936) (actual time=6691288.039..6691290.848 rows=1069 loops=1)"
"              Output: mutcandidats.cromutcdt, mutcandidats.nommutcdt, mutcandidats.premutcdt, mutdemandes.cromutdmd, disciplines.crodis, categories.crocat, operationsgroupes.crosgo, operationsgroupes.idesgo, operationtypes.crotop, operationtypes.croanntop, operationtypes.toutop, adherents.crosyn, adherents.idesyn, adherents.ustsyn, adherents.datdercotsyn, adherents.auxadrsyn, adherents.voiadrsyn, adherents.bopadrsyn, adherents.copadrsyn, adherents.locadrsyn, adherents.quaadrsyn, adherents.cotadrsyn, adherents.ctcadrsyn, acasyn.croaca, ssituations.crossi, ssituations.autssi, vacances.auxadrvac, vacances.voiadrvac, vacances.bopadrvac, vacances.copadrvac, vacances.locadrvac, vacances.quaadrvac, vacances.cotadrvac, vacances.ctcadrvac, acamutdmd.croaca, (CASE WHEN (mutrlt1.cromutrlt IS NOT NULL) THEN mutrlt1.croacamutrlt ELSE mutrlt2.croacamutrlt END), (CASE WHEN (mutrlt1.cromutrlt IS NOT NULL) THEN mutrlt1.croetamutrlt ELSE mutrlt2.croetamutrlt END), (CASE WHEN (mutrlt1.cromutrlt IS NOT NULL) THEN etarlt1.ideeta ELSE etarlt2.ideeta END), (CASE WHEN (mutrlt1.cromutrlt IS NOT NULL) THEN etarlt1.nometa ELSE etarlt2.nometa END), (CASE WHEN (mutrlt1.cromutrlt IS NOT NULL) THEN etarlt1.auxadreta ELSE etarlt2.auxadreta END), (CASE WHEN (mutrlt1.cromutrlt IS NOT NULL) THEN etarlt1.voiadreta ELSE etarlt2.voiadreta END), (CASE WHEN (mutrlt1.cromutrlt IS NOT NULL) THEN etarlt1.bopadreta ELSE etarlt2.bopadreta END), (CASE WHEN (mutrlt1.cromutrlt IS NOT NULL) THEN etarlt1.copadreta ELSE etarlt2.copadreta END), (CASE WHEN (mutrlt1.cromutrlt IS NOT NULL) THEN etarlt1.locadreta ELSE etarlt2.locadreta END), (CASE WHEN (mutrlt1.cromutrlt IS NOT NULL) THEN etarlt1.quaadreta ELSE etarlt2.quaadreta END), (CASE WHEN (mutrlt1.cromutrlt IS NOT NULL) THEN etarlt1.cotadreta ELSE etarlt2.cotadreta END), (CASE WHEN (mutrlt1.cromutrlt IS NOT NULL) THEN etarlt1.ctcadreta ELSE etarlt2.ctcadreta END), etaaffmutdmd.croeta, etaaffmutdmd.ideeta, etaaffmutdmd.nometa, etaaffmutdmd.auxadreta, etaaffmutdmd.voiadreta, etaaffmutdmd.bopadreta, etaaffmutdmd.copadreta, etaaffmutdmd.locadreta, etaaffmutdmd.quaadreta, etaaffmutdmd.cotadreta, etaaffmutdmd.ctcadreta, (CASE WHEN (adherents.copadrsyn IS NOT NULL) THEN adherents.auxadrsyn WHEN (etaexesyn.copadreta IS NOT NULL) THEN etaexesyn.nometa WHEN ((typeanc.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaeanc.copadreta IS NOT NULL)) THEN etaeanc.nometa WHEN ((typranc.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaranc.copadreta IS NOT NULL)) THEN etaranc.nometa WHEN ((typaffmutdmd.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaaffmutdmd.copadreta IS NOT NULL)) THEN etaaffmutdmd.nometa ELSE NULL::character varying END), (CASE WHEN (adherents.copadrsyn IS NOT NULL) THEN adherents.voiadrsyn WHEN (etaexesyn.copadreta IS NOT NULL) THEN etaexesyn.voiadreta WHEN ((typeanc.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaeanc.copadreta IS NOT NULL)) THEN etaeanc.voiadreta WHEN ((typranc.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaranc.copadreta IS NOT NULL)) THEN etaranc.voiadreta WHEN ((typaffmutdmd.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaaffmutdmd.copadreta IS NOT NULL)) THEN etaaffmutdmd.voiadreta ELSE NULL::character varying END), (CASE WHEN (adherents.copadrsyn IS NOT NULL) THEN adherents.bopadrsyn WHEN (etaexesyn.copadreta IS NOT NULL) THEN etaexesyn.bopadreta WHEN ((typeanc.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaeanc.copadreta IS NOT NULL)) THEN etaeanc.bopadreta WHEN ((typranc.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaranc.copadreta IS NOT NULL)) THEN etaranc.bopadreta WHEN ((typaffmutdmd.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaaffmutdmd.copadreta IS NOT NULL)) THEN etaaffmutdmd.bopadreta ELSE NULL::character varying END), (CASE WHEN (adherents.copadrsyn IS NOT NULL) THEN adherents.copadrsyn WHEN (etaexesyn.copadreta IS NOT NULL) THEN etaexesyn.copadreta WHEN ((typeanc.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaeanc.copadreta IS NOT NULL)) THEN etaeanc.copadreta WHEN ((typranc.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaranc.copadreta IS NOT NULL)) THEN etaranc.copadreta WHEN ((typaffmutdmd.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaaffmutdmd.copadreta IS NOT NULL)) THEN etaaffmutdmd.copadreta ELSE NULL::bpchar END), (CASE WHEN (adherents.copadrsyn IS NOT NULL) THEN adherents.locadrsyn WHEN (etaexesyn.copadreta IS NOT NULL) THEN etaexesyn.locadreta WHEN ((typeanc.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaeanc.copadreta IS NOT NULL)) THEN etaeanc.locadreta WHEN ((typranc.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaranc.copadreta IS NOT NULL)) THEN etaranc.locadreta WHEN ((typaffmutdmd.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaaffmutdmd.copadreta IS NOT NULL)) THEN etaaffmutdmd.locadreta ELSE NULL::character varying END), (CASE WHEN (adherents.copadrsyn IS NOT NULL) THEN adherents.quaadrsyn WHEN (etaexesyn.copadreta IS NOT NULL) THEN etaexesyn.quaadreta WHEN ((typeanc.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaeanc.copadreta IS NOT NULL)) THEN etaeanc.quaadreta WHEN ((typranc.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaranc.copadreta IS NOT NULL)) THEN etaranc.quaadreta WHEN ((typaffmutdmd.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaaffmutdmd.copadreta IS NOT NULL)) THEN etaaffmutdmd.quaadreta ELSE NULL::bpchar END), (CASE WHEN (adherents.copadrsyn IS NOT NULL) THEN adherents.cotadrsyn WHEN (etaexesyn.copadreta IS NOT NULL) THEN etaexesyn.cotadreta WHEN ((typeanc.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaeanc.copadreta IS NOT NULL)) THEN etaeanc.cotadreta WHEN ((typranc.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaranc.copadreta IS NOT NULL)) THEN etaranc.cotadreta WHEN ((typaffmutdmd.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaaffmutdmd.copadreta IS NOT NULL)) THEN etaaffmutdmd.cotadreta ELSE NULL::bpchar END), (CASE WHEN (adherents.copadrsyn IS NOT NULL) THEN adherents.ctcadrsyn WHEN (etaexesyn.copadreta IS NOT NULL) THEN etaexesyn.ctcadreta WHEN ((typeanc.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaeanc.copadreta IS NOT NULL)) THEN etaeanc.ctcadreta WHEN ((typranc.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaranc.copadreta IS NOT NULL)) THEN etaranc.ctcadreta WHEN ((typaffmutdmd.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaaffmutdmd.copadreta IS NOT NULL)) THEN etaaffmutdmd.ctcadreta ELSE NULL::character varying END)"
"              Buffers: shared hit=3360827 read=14936236, temp read=4137546 written=4080184"
"              ->  Nested Loop Left Join  (cost=18007.86..50810.64 rows=1 width=936) (actual time=5245.329..6691265.126 rows=1069 loops=1)"
"                    Output: mutcandidats.cromutcdt, mutcandidats.nommutcdt, mutcandidats.premutcdt, mutdemandes.cromutdmd, disciplines.crodis, categories.crocat, operationsgroupes.crosgo, operationsgroupes.idesgo, operationtypes.crotop, operationtypes.croanntop, operationtypes.toutop, adherents.crosyn, adherents.idesyn, adherents.ustsyn, adherents.datdercotsyn, adherents.auxadrsyn, adherents.voiadrsyn, adherents.bopadrsyn, adherents.copadrsyn, adherents.locadrsyn, adherents.quaadrsyn, adherents.cotadrsyn, adherents.ctcadrsyn, acasyn.croaca, ssituations.crossi, ssituations.autssi, vacances.auxadrvac, vacances.voiadrvac, vacances.bopadrvac, vacances.copadrvac, vacances.locadrvac, vacances.quaadrvac, vacances.cotadrvac, vacances.ctcadrvac, acamutdmd.croaca, CASE WHEN (mutrlt1.cromutrlt IS NOT NULL) THEN mutrlt1.croacamutrlt ELSE mutrlt2.croacamutrlt END, CASE WHEN (mutrlt1.cromutrlt IS NOT NULL) THEN mutrlt1.croetamutrlt ELSE mutrlt2.croetamutrlt END, CASE WHEN (mutrlt1.cromutrlt IS NOT NULL) THEN etarlt1.ideeta ELSE etarlt2.ideeta END, CASE WHEN (mutrlt1.cromutrlt IS NOT NULL) THEN etarlt1.nometa ELSE etarlt2.nometa END, CASE WHEN (mutrlt1.cromutrlt IS NOT NULL) THEN etarlt1.auxadreta ELSE etarlt2.auxadreta END, CASE WHEN (mutrlt1.cromutrlt IS NOT NULL) THEN etarlt1.voiadreta ELSE etarlt2.voiadreta END, CASE WHEN (mutrlt1.cromutrlt IS NOT NULL) THEN etarlt1.bopadreta ELSE etarlt2.bopadreta END, CASE WHEN (mutrlt1.cromutrlt IS NOT NULL) THEN etarlt1.copadreta ELSE etarlt2.copadreta END, CASE WHEN (mutrlt1.cromutrlt IS NOT NULL) THEN etarlt1.locadreta ELSE etarlt2.locadreta END, CASE WHEN (mutrlt1.cromutrlt IS NOT NULL) THEN etarlt1.quaadreta ELSE etarlt2.quaadreta END, CASE WHEN (mutrlt1.cromutrlt IS NOT NULL) THEN etarlt1.cotadreta ELSE etarlt2.cotadreta END, CASE WHEN (mutrlt1.cromutrlt IS NOT NULL) THEN etarlt1.ctcadreta ELSE etarlt2.ctcadreta END, etaaffmutdmd.croeta, etaaffmutdmd.ideeta, etaaffmutdmd.nometa, etaaffmutdmd.auxadreta, etaaffmutdmd.voiadreta, etaaffmutdmd.bopadreta, etaaffmutdmd.copadreta, etaaffmutdmd.locadreta, etaaffmutdmd.quaadreta, etaaffmutdmd.cotadreta, etaaffmutdmd.ctcadreta, CASE WHEN (adherents.copadrsyn IS NOT NULL) THEN adherents.auxadrsyn WHEN (etaexesyn.copadreta IS NOT NULL) THEN etaexesyn.nometa WHEN ((typeanc.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaeanc.copadreta IS NOT NULL)) THEN etaeanc.nometa WHEN ((typranc.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaranc.copadreta IS NOT NULL)) THEN etaranc.nometa WHEN ((typaffmutdmd.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaaffmutdmd.copadreta IS NOT NULL)) THEN etaaffmutdmd.nometa ELSE NULL::character varying END, CASE WHEN (adherents.copadrsyn IS NOT NULL) THEN adherents.voiadrsyn WHEN (etaexesyn.copadreta IS NOT NULL) THEN etaexesyn.voiadreta WHEN ((typeanc.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaeanc.copadreta IS NOT NULL)) THEN etaeanc.voiadreta WHEN ((typranc.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaranc.copadreta IS NOT NULL)) THEN etaranc.voiadreta WHEN ((typaffmutdmd.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaaffmutdmd.copadreta IS NOT NULL)) THEN etaaffmutdmd.voiadreta ELSE NULL::character varying END, CASE WHEN (adherents.copadrsyn IS NOT NULL) THEN adherents.bopadrsyn WHEN (etaexesyn.copadreta IS NOT NULL) THEN etaexesyn.bopadreta WHEN ((typeanc.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaeanc.copadreta IS NOT NULL)) THEN etaeanc.bopadreta WHEN ((typranc.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaranc.copadreta IS NOT NULL)) THEN etaranc.bopadreta WHEN ((typaffmutdmd.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaaffmutdmd.copadreta IS NOT NULL)) THEN etaaffmutdmd.bopadreta ELSE NULL::character varying END, CASE WHEN (adherents.copadrsyn IS NOT NULL) THEN adherents.copadrsyn WHEN (etaexesyn.copadreta IS NOT NULL) THEN etaexesyn.copadreta WHEN ((typeanc.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaeanc.copadreta IS NOT NULL)) THEN etaeanc.copadreta WHEN ((typranc.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaranc.copadreta IS NOT NULL)) THEN etaranc.copadreta WHEN ((typaffmutdmd.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaaffmutdmd.copadreta IS NOT NULL)) THEN etaaffmutdmd.copadreta ELSE NULL::bpchar END, CASE WHEN (adherents.copadrsyn IS NOT NULL) THEN adherents.locadrsyn WHEN (etaexesyn.copadreta IS NOT NULL) THEN etaexesyn.locadreta WHEN ((typeanc.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaeanc.copadreta IS NOT NULL)) THEN etaeanc.locadreta WHEN ((typranc.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaranc.copadreta IS NOT NULL)) THEN etaranc.locadreta WHEN ((typaffmutdmd.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaaffmutdmd.copadreta IS NOT NULL)) THEN etaaffmutdmd.locadreta ELSE NULL::character varying END, CASE WHEN (adherents.copadrsyn IS NOT NULL) THEN adherents.quaadrsyn WHEN (etaexesyn.copadreta IS NOT NULL) THEN etaexesyn.quaadreta WHEN ((typeanc.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaeanc.copadreta IS NOT NULL)) THEN etaeanc.quaadreta WHEN ((typranc.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaranc.copadreta IS NOT NULL)) THEN etaranc.quaadreta WHEN ((typaffmutdmd.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaaffmutdmd.copadreta IS NOT NULL)) THEN etaaffmutdmd.quaadreta ELSE NULL::bpchar END, CASE WHEN (adherents.copadrsyn IS NOT NULL) THEN adherents.cotadrsyn WHEN (etaexesyn.copadreta IS NOT NULL) THEN etaexesyn.cotadreta WHEN ((typeanc.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaeanc.copadreta IS NOT NULL)) THEN etaeanc.cotadreta WHEN ((typranc.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaranc.copadreta IS NOT NULL)) THEN etaranc.cotadreta WHEN ((typaffmutdmd.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaaffmutdmd.copadreta IS NOT NULL)) THEN etaaffmutdmd.cotadreta ELSE NULL::bpchar END, CASE WHEN (adherents.copadrsyn IS NOT NULL) THEN adherents.ctcadrsyn WHEN (etaexesyn.copadreta IS NOT NULL) THEN etaexesyn.ctcadreta WHEN ((typeanc.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaeanc.copadreta IS NOT NULL)) THEN etaeanc.ctcadreta WHEN ((typranc.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaranc.copadreta IS NOT NULL)) THEN etaranc.ctcadreta WHEN ((typaffmutdmd.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaaffmutdmd.copadreta IS NOT NULL)) THEN etaaffmutdmd.ctcadreta ELSE NULL::character varying END"
"                    Buffers: shared hit=3360827 read=14936236, temp read=4137546 written=4080184"
"                    ->  Nested Loop Left Join  (cost=18007.86..50807.39 rows=1 width=822) (actual time=5245.275..6691220.392 rows=1069 loops=1)"
"                          Output: mutcandidats.cromutcdt, mutcandidats.nommutcdt, mutcandidats.premutcdt, mutdemandes.cromutdmd, categories.crocat, disciplines.crodis, operationtypes.crotop, operationtypes.croanntop, operationtypes.toutop, operationsgroupes.crosgo, operationsgroupes.idesgo, acamutdmd.croaca, adherents.crosyn, adherents.idesyn, adherents.ustsyn, adherents.datdercotsyn, adherents.auxadrsyn, adherents.voiadrsyn, adherents.bopadrsyn, adherents.copadrsyn, adherents.locadrsyn, adherents.quaadrsyn, adherents.cotadrsyn, adherents.ctcadrsyn, ssituations.crossi, ssituations.autssi, acasyn.croaca, vacances.auxadrvac, vacances.voiadrvac, vacances.bopadrvac, vacances.copadrvac, vacances.locadrvac, vacances.quaadrvac, vacances.cotadrvac, vacances.ctcadrvac, etaexesyn.copadreta, etaexesyn.nometa, etaexesyn.voiadreta, etaexesyn.bopadreta, etaexesyn.locadreta, etaexesyn.quaadreta, etaexesyn.cotadreta, etaexesyn.ctcadreta, etaaffmutdmd.croeta, etaaffmutdmd.ideeta, etaaffmutdmd.nometa, etaaffmutdmd.auxadreta, etaaffmutdmd.voiadreta, etaaffmutdmd.bopadreta, etaaffmutdmd.copadreta, etaaffmutdmd.locadreta, etaaffmutdmd.quaadreta, etaaffmutdmd.cotadreta, etaaffmutdmd.ctcadreta, typaffmutdmd.idetyp, etaeanc.copadreta, etaeanc.nometa, etaeanc.voiadreta, etaeanc.bopadreta, etaeanc.locadreta, etaeanc.quaadreta, etaeanc.cotadreta, etaeanc.ctcadreta, typeanc.idetyp, etaranc.copadreta, etaranc.nometa, etaranc.voiadreta, etaranc.bopadreta, etaranc.locadreta, etaranc.quaadreta, etaranc.cotadreta, etaranc.ctcadreta, typranc.idetyp, mutrlt2.croacamutrlt, mutrlt2.croetamutrlt, mutrlt1.cromutrlt, mutrlt1.croacamutrlt, mutrlt1.croetamutrlt, etarlt1.ideeta, etarlt1.nometa, etarlt1.auxadreta, etarlt1.voiadreta, etarlt1.bopadreta, etarlt1.copadreta, etarlt1.locadreta, etarlt1.quaadreta, etarlt1.cotadreta, etarlt1.ctcadreta"
"                          Join Filter: (mutdemandes.cromutdmd = mutrlt2.cromutdmdmutrlt)"
"                          Buffers: shared hit=3360827 read=14936236, temp read=4137546 written=4080184"
"                          ->  Nested Loop Left Join  (cost=18000.26..40327.70 rows=1 width=814) (actual time=4419.177..5795850.581 rows=1069 loops=1)"
"                                Output: mutcandidats.cromutcdt, mutcandidats.nommutcdt, mutcandidats.premutcdt, mutdemandes.cromutdmd, categories.crocat, disciplines.crodis, operationtypes.crotop, operationtypes.croanntop, operationtypes.toutop, operationsgroupes.crosgo, operationsgroupes.idesgo, acamutdmd.croaca, adherents.crosyn, adherents.idesyn, adherents.ustsyn, adherents.datdercotsyn, adherents.auxadrsyn, adherents.voiadrsyn, adherents.bopadrsyn, adherents.copadrsyn, adherents.locadrsyn, adherents.quaadrsyn, adherents.cotadrsyn, adherents.ctcadrsyn, ssituations.crossi, ssituations.autssi, acasyn.croaca, vacances.auxadrvac, vacances.voiadrvac, vacances.bopadrvac, vacances.copadrvac, vacances.locadrvac, vacances.quaadrvac, vacances.cotadrvac, vacances.ctcadrvac, etaexesyn.copadreta, etaexesyn.nometa, etaexesyn.voiadreta, etaexesyn.bopadreta, etaexesyn.locadreta, etaexesyn.quaadreta, etaexesyn.cotadreta, etaexesyn.ctcadreta, etaaffmutdmd.croeta, etaaffmutdmd.ideeta, etaaffmutdmd.nometa, etaaffmutdmd.auxadreta, etaaffmutdmd.voiadreta, etaaffmutdmd.bopadreta, etaaffmutdmd.copadreta, etaaffmutdmd.locadreta, etaaffmutdmd.quaadreta, etaaffmutdmd.cotadreta, etaaffmutdmd.ctcadreta, typaffmutdmd.idetyp, etaeanc.copadreta, etaeanc.nometa, etaeanc.voiadreta, etaeanc.bopadreta, etaeanc.locadreta, etaeanc.quaadreta, etaeanc.cotadreta, etaeanc.ctcadreta, typeanc.idetyp, etaranc.copadreta, etaranc.nometa, etaranc.voiadreta, etaranc.bopadreta, etaranc.locadreta, etaranc.quaadreta, etaranc.cotadreta, etaranc.ctcadreta, typranc.idetyp, mutrlt1.cromutrlt, mutrlt1.croacamutrlt, mutrlt1.croetamutrlt, etarlt1.ideeta, etarlt1.nometa, etarlt1.auxadreta, etarlt1.voiadreta, etarlt1.bopadreta, etarlt1.copadreta, etarlt1.locadreta, etarlt1.quaadreta, etarlt1.cotadreta, etarlt1.ctcadreta"
"                                Join Filter: ((mutcandidats.cromutcdt = dmdanc.cromutcdtmutdmd) AND (operationtypes.croanntop = (topanc.croanntop + 1)))"
"                                Filter: ((adherents.copadrsyn <> ''::bpchar) OR (CASE WHEN (adherents.copadrsyn IS NOT NULL) THEN adherents.copadrsyn WHEN (etaexesyn.copadreta IS NOT NULL) THEN etaexesyn.copadreta WHEN ((typeanc.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaeanc.copadreta IS NOT NULL)) THEN etaeanc.copadreta WHEN ((typranc.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaranc.copadreta IS NOT NULL)) THEN etaranc.copadreta WHEN ((typaffmutdmd.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaaffmutdmd.copadreta IS NOT NULL)) THEN etaaffmutdmd.copadreta ELSE NULL::bpchar END <> ''::bpchar))"
"                                Buffers: shared hit=3111748 read=12729820, temp read=4137546 written=4080184"
"                                ->  Nested Loop Left Join  (cost=1411.79..13298.63 rows=1 width=620) (actual time=907.293..1324710.991 rows=1247 loops=1)"
"                                      Output: mutcandidats.cromutcdt, mutcandidats.nommutcdt, mutcandidats.premutcdt, mutdemandes.cromutdmd, categories.crocat, disciplines.crodis, operationtypes.crotop, operationtypes.croanntop, operationtypes.toutop, operationsgroupes.crosgo, operationsgroupes.idesgo, acamutdmd.croaca, adherents.crosyn, adherents.idesyn, adherents.ustsyn, adherents.datdercotsyn, adherents.auxadrsyn, adherents.voiadrsyn, adherents.bopadrsyn, adherents.copadrsyn, adherents.locadrsyn, adherents.quaadrsyn, adherents.cotadrsyn, adherents.ctcadrsyn, ssituations.crossi, ssituations.autssi, acasyn.croaca, vacances.auxadrvac, vacances.voiadrvac, vacances.bopadrvac, vacances.copadrvac, vacances.locadrvac, vacances.quaadrvac, vacances.cotadrvac, vacances.ctcadrvac, etaexesyn.copadreta, etaexesyn.nometa, etaexesyn.voiadreta, etaexesyn.bopadreta, etaexesyn.locadreta, etaexesyn.quaadreta, etaexesyn.cotadreta, etaexesyn.ctcadreta, etaaffmutdmd.croeta, etaaffmutdmd.ideeta, etaaffmutdmd.nometa, etaaffmutdmd.auxadreta, etaaffmutdmd.voiadreta, etaaffmutdmd.bopadreta, etaaffmutdmd.copadreta, etaaffmutdmd.locadreta, etaaffmutdmd.quaadreta, etaaffmutdmd.cotadreta, etaaffmutdmd.ctcadreta, typaffmutdmd.idetyp, mutrlt1.cromutrlt, mutrlt1.croacamutrlt, mutrlt1.croetamutrlt, etarlt1.ideeta, etarlt1.nometa, etarlt1.auxadreta, etarlt1.voiadreta, etarlt1.bopadreta, etarlt1.copadreta, etarlt1.locadreta, etarlt1.quaadreta, etarlt1.cotadreta, etarlt1.ctcadreta"
"                                      Join Filter: (mutdemandes.cromutdmd = mutrlt1.cromutdmdmutrlt)"
"                                      Buffers: shared hit=831065 read=2575373, temp read=432709 written=425227"
"                                      ->  Nested Loop Left Join  (cost=237.76..5044.10 rows=1 width=494) (actual time=29.739..279.646 rows=1247 loops=1)"
"                                            Output: mutcandidats.cromutcdt, mutcandidats.nommutcdt, mutcandidats.premutcdt, mutdemandes.cromutdmd, categories.crocat, disciplines.crodis, operationtypes.crotop, operationtypes.croanntop, operationtypes.toutop, operationsgroupes.crosgo, operationsgroupes.idesgo, acamutdmd.croaca, adherents.crosyn, adherents.idesyn, adherents.ustsyn, adherents.datdercotsyn, adherents.auxadrsyn, adherents.voiadrsyn, adherents.bopadrsyn, adherents.copadrsyn, adherents.locadrsyn, adherents.quaadrsyn, adherents.cotadrsyn, adherents.ctcadrsyn, ssituations.crossi, ssituations.autssi, acasyn.croaca, vacances.auxadrvac, vacances.voiadrvac, vacances.bopadrvac, vacances.copadrvac, vacances.locadrvac, vacances.quaadrvac, vacances.cotadrvac, vacances.ctcadrvac, etaexesyn.copadreta, etaexesyn.nometa, etaexesyn.voiadreta, etaexesyn.bopadreta, etaexesyn.locadreta, etaexesyn.quaadreta, etaexesyn.cotadreta, etaexesyn.ctcadreta, etaaffmutdmd.croeta, etaaffmutdmd.ideeta, etaaffmutdmd.nometa, etaaffmutdmd.auxadreta, etaaffmutdmd.voiadreta, etaaffmutdmd.bopadreta, etaaffmutdmd.copadreta, etaaffmutdmd.locadreta, etaaffmutdmd.quaadreta, etaaffmutdmd.cotadreta, etaaffmutdmd.ctcadreta, typaffmutdmd.idetyp"
"                                            Buffers: shared hit=20610 read=1468"
"                                            ->  Nested Loop Left Join  (cost=237.76..5043.82 rows=1 width=489) (actual time=29.727..255.524 rows=1247 loops=1)"
"                                                  Output: mutcandidats.cromutcdt, mutcandidats.nommutcdt, mutcandidats.premutcdt, mutdemandes.cromutdmd, categories.crocat, disciplines.crodis, operationtypes.crotop, operationtypes.croanntop, operationtypes.toutop, operationsgroupes.crosgo, operationsgroupes.idesgo, acamutdmd.croaca, adherents.crosyn, adherents.idesyn, adherents.ustsyn, adherents.datdercotsyn, adherents.auxadrsyn, adherents.voiadrsyn, adherents.bopadrsyn, adherents.copadrsyn, adherents.locadrsyn, adherents.quaadrsyn, adherents.cotadrsyn, adherents.ctcadrsyn, ssituations.crossi, ssituations.autssi, acasyn.croaca, vacances.auxadrvac, vacances.voiadrvac, vacances.bopadrvac, vacances.copadrvac, vacances.locadrvac, vacances.quaadrvac, vacances.cotadrvac, vacances.ctcadrvac, etaexesyn.copadreta, etaexesyn.nometa, etaexesyn.voiadreta, etaexesyn.bopadreta, etaexesyn.locadreta, etaexesyn.quaadreta, etaexesyn.cotadreta, etaexesyn.ctcadreta, etaaffmutdmd.croeta, etaaffmutdmd.ideeta, etaaffmutdmd.nometa, etaaffmutdmd.auxadreta, etaaffmutdmd.voiadreta, etaaffmutdmd.bopadreta, etaaffmutdmd.copadreta, etaaffmutdmd.locadreta, etaaffmutdmd.quaadreta, etaaffmutdmd.cotadreta, etaaffmutdmd.ctcadreta, etaaffmutdmd.crotypeta"
"                                                  Buffers: shared hit=18362 read=1468"
"                                                  ->  Nested Loop Left Join  (cost=237.76..5035.53 rows=1 width=371) (actual time=29.709..232.072 rows=1247 loops=1)"
"                                                        Output: mutcandidats.cromutcdt, mutcandidats.nommutcdt, mutcandidats.premutcdt, mutdemandes.cromutdmd, mutdemandes.croaffmutdmd, categories.crocat, disciplines.crodis, operationtypes.crotop, operationtypes.croanntop, operationtypes.toutop, operationsgroupes.crosgo, operationsgroupes.idesgo, acamutdmd.croaca, adherents.crosyn, adherents.idesyn, adherents.ustsyn, adherents.datdercotsyn, adherents.auxadrsyn, adherents.voiadrsyn, adherents.bopadrsyn, adherents.copadrsyn, adherents.locadrsyn, adherents.quaadrsyn, adherents.cotadrsyn, adherents.ctcadrsyn, ssituations.crossi, ssituations.autssi, acasyn.croaca, vacances.auxadrvac, vacances.voiadrvac, vacances.bopadrvac, vacances.copadrvac, vacances.locadrvac, vacances.quaadrvac, vacances.cotadrvac, vacances.ctcadrvac, etaexesyn.copadreta, etaexesyn.nometa, etaexesyn.voiadreta, etaexesyn.bopadreta, etaexesyn.locadreta, etaexesyn.quaadreta, etaexesyn.cotadreta, etaexesyn.ctcadreta"
"                                                        Buffers: shared hit=14989 read=1468"
"                                                        ->  Nested Loop Left Join  (cost=237.76..5027.25 rows=1 width=287) (actual time=29.702..222.562 rows=1247 loops=1)"
"                                                              Output: mutcandidats.cromutcdt, mutcandidats.nommutcdt, mutcandidats.premutcdt, mutdemandes.cromutdmd, mutdemandes.croaffmutdmd, categories.crocat, disciplines.crodis, operationtypes.crotop, operationtypes.croanntop, operationtypes.toutop, operationsgroupes.crosgo, operationsgroupes.idesgo, acamutdmd.croaca, adherents.crosyn, adherents.idesyn, adherents.ustsyn, adherents.datdercotsyn, adherents.auxadrsyn, adherents.voiadrsyn, adherents.bopadrsyn, adherents.copadrsyn, adherents.locadrsyn, adherents.quaadrsyn, adherents.cotadrsyn, adherents.ctcadrsyn, adherents.croetaexesyn, ssituations.crossi, ssituations.autssi, acasyn.croaca, vacances.auxadrvac, vacances.voiadrvac, vacances.bopadrvac, vacances.copadrvac, vacances.locadrvac, vacances.quaadrvac, vacances.cotadrvac, vacances.ctcadrvac"
"                                                              Buffers: shared hit=14842 read=1468"
"                                                              ->  Nested Loop Left Join  (cost=237.76..5018.97 rows=1 width=197) (actual time=29.695..212.459 rows=1247 loops=1)"
"                                                                    Output: mutcandidats.cromutcdt, mutcandidats.nommutcdt, mutcandidats.premutcdt, mutdemandes.cromutdmd, mutdemandes.croaffmutdmd, categories.crocat, disciplines.crodis, operationtypes.crotop, operationtypes.croanntop, operationtypes.toutop, operationsgroupes.crosgo, operationsgroupes.idesgo, acamutdmd.croaca, adherents.crosyn, adherents.idesyn, adherents.ustsyn, adherents.datdercotsyn, adherents.auxadrsyn, adherents.voiadrsyn, adherents.bopadrsyn, adherents.copadrsyn, adherents.locadrsyn, adherents.quaadrsyn, adherents.cotadrsyn, adherents.ctcadrsyn, adherents.croetaexesyn, ssituations.crossi, ssituations.autssi, acasyn.croaca"
"                                                                    Buffers: shared hit=14496 read=1460"
"                                                                    ->  Hash Left Join  (cost=237.76..5010.69 rows=1 width=197) (actual time=29.688..202.099 rows=1247 loops=1)"
"                                                                          Output: mutcandidats.cromutcdt, mutcandidats.nommutcdt, mutcandidats.premutcdt, mutdemandes.cromutdmd, mutdemandes.croaffmutdmd, categories.crocat, disciplines.crodis, operationtypes.crotop, operationtypes.croanntop, operationtypes.toutop, operationsgroupes.crosgo, operationsgroupes.idesgo, acamutdmd.croaca, adherents.crosyn, adherents.idesyn, adherents.ustsyn, adherents.datdercotsyn, adherents.auxadrsyn, adherents.voiadrsyn, adherents.bopadrsyn, adherents.copadrsyn, adherents.locadrsyn, adherents.quaadrsyn, adherents.cotadrsyn, adherents.ctcadrsyn, adherents.croacasyn, adherents.croetaexesyn, ssituations.crossi, ssituations.autssi"
"                                                                          Hash Cond: (adherents.crossisyn = ssituations.crossi)"
"                                                                          Filter: (((ssituations.autssi)::text ~~ 'N'::text) OR (ssituations.autssi IS NULL))"
"                                                                          Buffers: shared hit=14190 read=1460"
"                                                                          ->  Nested Loop Left Join  (cost=236.56..5009.46 rows=2 width=189) (actual time=29.606..191.017 rows=1838 loops=1)"
"                                                                                Output: mutcandidats.cromutcdt, mutcandidats.nommutcdt, mutcandidats.premutcdt, mutdemandes.cromutdmd, mutdemandes.croaffmutdmd, categories.crocat, disciplines.crodis, operationtypes.crotop, operationtypes.croanntop, operationtypes.toutop, operationsgroupes.crosgo, operationsgroupes.idesgo, acamutdmd.croaca, adherents.crosyn, adherents.idesyn, adherents.ustsyn, adherents.datdercotsyn, adherents.auxadrsyn, adherents.voiadrsyn, adherents.bopadrsyn, adherents.copadrsyn, adherents.locadrsyn, adherents.quaadrsyn, adherents.cotadrsyn, adherents.ctcadrsyn, adherents.crossisyn, adherents.croacasyn, adherents.croetaexesyn"
"                                                                                Buffers: shared hit=14190 read=1459"
"                                                                                ->  Nested Loop  (cost=236.56..5002.84 rows=2 width=71) (actual time=29.598..160.906 rows=1838 loops=1)"
"                                                                                      Output: mutcandidats.cromutcdt, mutcandidats.nommutcdt, mutcandidats.premutcdt, mutcandidats.crosynmutcdt, mutdemandes.cromutdmd, mutdemandes.croaffmutdmd, categories.crocat, disciplines.crodis, operationtypes.crotop, operationtypes.croanntop, operationtypes.toutop, operationsgroupes.crosgo, operationsgroupes.idesgo, acamutdmd.croaca"
"                                                                                      Buffers: shared hit=12508 read=905"
"                                                                                      ->  Index Scan using pk_croaca on public.academies acamutdmd  (cost=0.00..8.27 rows=1 width=4) (actual time=0.019..0.022 rows=1 loops=1)"
"                                                                                            Output: acamutdmd.croaca, acamutdmd.datmajaca, acamutdmd.ideaca, acamutdmd.libaca, acamutdmd.nomaca, acamutdmd.auxadraca, acamutdmd.voiadraca, acamutdmd.bopadraca, acamutdmd.copadraca, acamutdmd.locadraca, acamutdmd.telaca, acamutdmd.faxaca, acamutdmd.maiaca, acamutdmd.croguiaca, acamutdmd.numcptaca, acamutdmd.clecptaca, acamutdmd.emeaca, acamutdmd.datrqpaca, acamutdmd.defprlaca, acamutdmd.mulaca, acamutdmd.urlaca, acamutdmd.cropaycptaca, acamutdmd.cleibacptaca, acamutdmd.defprlrtraca, acamutdmd.mulrtraca"
"                                                                                            Index Cond: (acamutdmd.croaca = 22)"
"                                                                                            Buffers: shared hit=2"
"                                                                                      ->  Nested Loop  (cost=236.56..4994.55 rows=2 width=71) (actual time=29.572..156.012 rows=1838 loops=1)"
"                                                                                            Output: mutcandidats.cromutcdt, mutcandidats.nommutcdt, mutcandidats.premutcdt, mutcandidats.crosynmutcdt, mutdemandes.cromutdmd, mutdemandes.croacamutdmd, mutdemandes.croaffmutdmd, categories.crocat, disciplines.crodis, operationtypes.crotop, operationtypes.croanntop, operationtypes.toutop, operationsgroupes.crosgo, operationsgroupes.idesgo"
"                                                                                            Buffers: shared hit=12506 read=905"
"                                                                                            ->  Seq Scan on public.operationsgroupes  (cost=0.00..3.66 rows=1 width=17) (actual time=0.020..0.078 rows=1 loops=1)"
"                                                                                                  Output: operationsgroupes.crosgo, operationsgroupes.datmajsgo, operationsgroupes.idesgo, operationsgroupes.libsgo, operationsgroupes.croopesgo"
"                                                                                                  Filter: (operationsgroupes.crosgo = 19)"
"                                                                                                  Buffers: shared hit=1 read=1"
"                                                                                            ->  Nested Loop  (cost=236.56..4990.87 rows=2 width=58) (actual time=29.545..150.827 rows=1838 loops=1)"
"                                                                                                  Output: mutcandidats.cromutcdt, mutcandidats.nommutcdt, mutcandidats.premutcdt, mutcandidats.crosynmutcdt, mutdemandes.cromutdmd, mutdemandes.croacamutdmd, mutdemandes.croaffmutdmd, categories.crocat, disciplines.crodis, operationtypes.crotop, operationtypes.croanntop, operationtypes.toutop, operationtypes.crosgotop"
"                                                                                                  Buffers: shared hit=12505 read=904"
"                                                                                                  ->  Nested Loop  (cost=236.56..4988.31 rows=2 width=58) (actual time=29.532..125.133 rows=1838 loops=1)"
"                                                                                                        Output: mutcandidats.cromutcdt, mutcandidats.nommutcdt, mutcandidats.premutcdt, mutcandidats.crosynmutcdt, mutdemandes.cromutdmd, mutdemandes.crodismutdmd, mutdemandes.croacamutdmd, mutdemandes.croaffmutdmd, categories.crocat, operationtypes.crotop, operationtypes.croanntop, operationtypes.toutop, operationtypes.crosgotop"
"                                                                                                        Buffers: shared hit=8829 read=904"
"                                                                                                        ->  Nested Loop  (cost=236.56..4987.75 rows=2 width=58) (actual time=29.519..99.081 rows=1838 loops=1)"
"                                                                                                              Output: mutcandidats.cromutcdt, mutcandidats.nommutcdt, mutcandidats.premutcdt, mutcandidats.crosynmutcdt, mutdemandes.cromutdmd, mutdemandes.crocatmutdmd, mutdemandes.crodismutdmd, mutdemandes.croacamutdmd, mutdemandes.croaffmutdmd, operationtypes.crotop, operationtypes.croanntop, operationtypes.toutop, operationtypes.crosgotop"
"                                                                                                              Buffers: shared hit=5153 read=904"
"                                                                                                              ->  Hash Join  (cost=236.56..4971.16 rows=2 width=38) (actual time=29.489..45.029 rows=1838 loops=1)"
"                                                                                                                    Output: mutdemandes.cromutdmd, mutdemandes.cromutcdtmutdmd, mutdemandes.crocatmutdmd, mutdemandes.crodismutdmd, mutdemandes.croacamutdmd, mutdemandes.croaffmutdmd, operationtypes.crotop, operationtypes.croanntop, operationtypes.toutop, operationtypes.crosgotop"
"                                                                                                                    Hash Cond: (mutdemandes.crotopmutdmd = operationtypes.crotop)"
"                                                                                                                    Buffers: shared hit=10 read=523"
"                                                                                                                    ->  Bitmap Heap Scan on public.mutdemandes  (cost=227.19..4917.79 rows=11728 width=28) (actual time=2.574..23.423 rows=11896 loops=1)"
"                                                                                                                          Output: mutdemandes.cromutdmd, mutdemandes.datmajmutdmd, mutdemandes.cromutcdtmutdmd, mutdemandes.crotopmutdmd, mutdemandes.crodismutdmd, mutdemandes.crodisrctmutdmd, mutdemandes.nbrdismutdmd, mutdemandes.crocatmutdmd, mutdemandes.croadmmutdmd, mutdemandes.cromutsvcmutdmd, mutdemandes.croaffmutdmd, mutdemandes.croexemutdmd, mutdemandes.croacamutdmd, mutdemandes.obsmutdmd, mutdemandes.obsrltmutdmd, mutdemandes.nomcjtmutdmd, mutdemandes.prncjtmutdmd, mutdemandes.crodiscjtmutdmd, mutdemandes.croacacjtmutdmd, mutdemandes.extmutdmd, mutdemandes.cromutqltmutdmd, mutdemandes.cromutlitmutdmd, mutdemandes.accmutdmd, mutdemandes.prfmutdmd, mutdemandes.sspmutdmd, mutdemandes.croacaorimutdmd, mutdemandes.rarmutdmd"
"                                                                                                                          Recheck Cond: (mutdemandes.croacamutdmd = 22)"
"                                                                                                                          Buffers: shared hit=9 read=521"
"                                                                                                                          ->  Bitmap Index Scan on ix_acamutdmd  (cost=0.00..224.26 rows=11728 width=0) (actual time=2.433..2.433 rows=11896 loops=1)"
"                                                                                                                                Index Cond: (mutdemandes.croacamutdmd = 22)"
"                                                                                                                                Buffers: shared read=36"
"                                                                                                                    ->  Hash  (cost=9.36..9.36 rows=1 width=14) (actual time=0.058..0.058 rows=1 loops=1)"
"                                                                                                                          Output: operationtypes.crotop, operationtypes.croanntop, operationtypes.toutop, operationtypes.crosgotop"
"                                                                                                                          Buckets: 1024  Batches: 1  Memory Usage: 1kB"
"                                                                                                                          Buffers: shared hit=1 read=2"
"                                                                                                                          ->  Index Scan using ix_sgotop on public.operationtypes  (cost=0.00..9.36 rows=1 width=14) (actual time=0.048..0.051 rows=1 loops=1)"
"                                                                                                                                Output: operationtypes.crotop, operationtypes.croanntop, operationtypes.toutop, operationtypes.crosgotop"
"                                                                                                                                Index Cond: (operationtypes.crosgotop = 19)"
"                                                                                                                                Filter: (operationtypes.croanntop = 2011)"
"                                                                                                                                Buffers: shared hit=1 read=2"
"                                                                                                              ->  Index Scan using pk_cromutcdt on public.mutcandidats  (cost=0.00..8.28 rows=1 width=24) (actual time=0.020..0.022 rows=1 loops=1838)"
"                                                                                                                    Output: mutcandidats.cromutcdt, mutcandidats.datmajmutcdt, mutcandidats.crosynmutcdt, mutcandidats.nommutcdt, mutcandidats.premutcdt, mutcandidats.nomjefmutcdt, mutcandidats.nomrecmutcdt, mutcandidats.sexmutcdt, mutcandidats.datnaimutcdt"
"                                                                                                                    Index Cond: (mutcandidats.cromutcdt = mutdemandes.cromutcdtmutdmd)"
"                                                                                                                    Buffers: shared hit=5143 read=381"
"                                                                                                        ->  Index Scan using pk_crocat on public.categories  (cost=0.00..0.27 rows=1 width=4) (actual time=0.006..0.008 rows=1 loops=1838)"
"                                                                                                              Output: categories.crocat, categories.datmajcat, categories.idecat, categories.libcat, categories.crogcacat, categories.affcat"
"                                                                                                              Index Cond: (categories.crocat = mutdemandes.crocatmutdmd)"
"                                                                                                              Buffers: shared hit=3676"
"                                                                                                  ->  Index Scan using pk_crodis on public.disciplines  (cost=0.00..1.27 rows=1 width=4) (actual time=0.006..0.008 rows=1 loops=1838)"
"                                                                                                        Output: disciplines.crodis, disciplines.datmajdis, disciplines.idedis, disciplines.libdis, disciplines.affdis"
"                                                                                                        Index Cond: (disciplines.crodis = mutdemandes.crodismutdmd)"
"                                                                                                        Buffers: shared hit=3676"
"                                                                                ->  Index Scan using pk_crosyn on public.adherents  (cost=0.00..3.29 rows=1 width=126) (actual time=0.009..0.010 rows=0 loops=1838)"
"                                                                                      Output: adherents.crosyn, adherents.datmajsyn, adherents.idesyn, adherents.sexsyn, adherents.datnaisyn, adherents.nomsyn, adherents.presyn, adherents.nomjefsyn, adherents.nomrecsyn, adherents.nomjefrecsyn, adherents.auxadrsyn, adherents.voiadrsyn, adherents.bopadrsyn, adherents.copadrsyn, adherents.locadrsyn, adherents.quaadrsyn, adherents.cotadrsyn, adherents.ctcadrsyn, adherents.telsyn, adherents.tel2syn, adherents.faxsyn, adherents.maisyn, adherents.datdercotsyn, adherents.datderficsyn, adherents.croacasyn, adherents.crodissyn, adherents.crocatsyn, adherents.croechsyn, adherents.croadmsyn, adherents.crodetsyn, adherents.crosersyn, adherents.croselsyn, adherents.croetaaffsyn, adherents.croetaexesyn, adherents.autintsyn, adherents.autextsyn, adherents.nussyn, adherents.cousyn, adherents.cirsyn, adherents.ustsyn, adherents.memsyn, adherents.crorousyn, adherents.datrousyn, adherents.idefgrsyn, adherents.delsyn, adherents.datcarsyn, adherents.hisressyn, adherents.annressyn, adherents.adrrousyn, adherents.crosecrspsyn, adherents.numsecrspsyn, adherents.crossisyn, adherents.datprosyn, adherents.roumaisyn, adherents.croiutdelsyn, adherents.modautsyn, adherents.crodspsyn"
"                                                                                      Index Cond: (adherents.crosyn = mutcandidats.crosynmutcdt)"
"                                                                                      Buffers: shared hit=1682 read=554"
"                                                                          ->  Hash  (cost=1.09..1.09 rows=9 width=12) (actual time=0.051..0.051 rows=9 loops=1)"
"                                                                                Output: ssituations.crossi, ssituations.autssi"
"                                                                                Buckets: 1024  Batches: 1  Memory Usage: 1kB"
"                                                                                Buffers: shared read=1"
"                                                                                ->  Seq Scan on public.ssituations  (cost=0.00..1.09 rows=9 width=12) (actual time=0.023..0.036 rows=9 loops=1)"
"                                                                                      Output: ssituations.crossi, ssituations.autssi"
"                                                                                      Buffers: shared read=1"
"                                                                    ->  Index Scan using pk_croaca on public.academies acasyn  (cost=0.00..8.27 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=1247)"
"                                                                          Output: acasyn.croaca, acasyn.datmajaca, acasyn.ideaca, acasyn.libaca, acasyn.nomaca, acasyn.auxadraca, acasyn.voiadraca, acasyn.bopadraca, acasyn.copadraca, acasyn.locadraca, acasyn.telaca, acasyn.faxaca, acasyn.maiaca, acasyn.croguiaca, acasyn.numcptaca, acasyn.clecptaca, acasyn.emeaca, acasyn.datrqpaca, acasyn.defprlaca, acasyn.mulaca, acasyn.urlaca, acasyn.cropaycptaca, acasyn.cleibacptaca, acasyn.defprlrtraca, acasyn.mulrtraca"
"                                                                          Index Cond: (adherents.croacasyn = acasyn.croaca)"
"                                                                          Buffers: shared hit=306"
"                                                              ->  Index Scan using pk_crosynvac on public.vacances  (cost=0.00..8.27 rows=1 width=94) (actual time=0.002..0.002 rows=0 loops=1247)"
"                                                                    Output: vacances.crosynvac, vacances.datmajvac, vacances.auxadrvac, vacances.voiadrvac, vacances.bopadrvac, vacances.copadrvac, vacances.locadrvac, vacances.quaadrvac, vacances.cotadrvac, vacances.ctcadrvac, vacances.telvac, vacances.faxvac, vacances.maivac"
"                                                                    Index Cond: (adherents.crosyn = vacances.crosynvac)"
"                                                                    Buffers: shared hit=346 read=8"
"                                                        ->  Index Scan using pk_croeta on public.etablissements etaexesyn  (cost=0.00..8.27 rows=1 width=92) (actual time=0.002..0.002 rows=0 loops=1247)"
"                                                              Output: etaexesyn.croeta, etaexesyn.datmajeta, etaexesyn.ideeta, etaexesyn.crotypeta, etaexesyn.crodepeta, etaexesyn.crocometa, etaexesyn.nometa, etaexesyn.auxadreta, etaexesyn.voiadreta, etaexesyn.bopadreta, etaexesyn.copadreta, etaexesyn.locadreta, etaexesyn.quaadreta, etaexesyn.cotadreta, etaexesyn.ctcadreta, etaexesyn.teleta, etaexesyn.faxeta, etaexesyn.maieta, etaexesyn.nuseta, etaexesyn.coueta, etaexesyn.usteta, etaexesyn.croroueta, etaexesyn.datroueta, etaexesyn.deleta, etaexesyn.entetieta, etaexesyn.descoueta, etaexesyn.cormileta, etaexesyn.croseceta, etaexesyn.rareta, etaexesyn.apveta"
"                                                              Index Cond: (adherents.croetaexesyn = etaexesyn.croeta)"
"                                                              Buffers: shared hit=147"
"                                                  ->  Index Scan using pk_croeta on public.etablissements etaaffmutdmd  (cost=0.00..8.27 rows=1 width=122) (actual time=0.009..0.011 rows=1 loops=1247)"
"                                                        Output: etaaffmutdmd.croeta, etaaffmutdmd.datmajeta, etaaffmutdmd.ideeta, etaaffmutdmd.crotypeta, etaaffmutdmd.crodepeta, etaaffmutdmd.crocometa, etaaffmutdmd.nometa, etaaffmutdmd.auxadreta, etaaffmutdmd.voiadreta, etaaffmutdmd.bopadreta, etaaffmutdmd.copadreta, etaaffmutdmd.locadreta, etaaffmutdmd.quaadreta, etaaffmutdmd.cotadreta, etaaffmutdmd.ctcadreta, etaaffmutdmd.teleta, etaaffmutdmd.faxeta, etaaffmutdmd.maieta, etaaffmutdmd.nuseta, etaaffmutdmd.coueta, etaaffmutdmd.usteta, etaaffmutdmd.croroueta, etaaffmutdmd.datroueta, etaaffmutdmd.deleta, etaaffmutdmd.entetieta, etaaffmutdmd.descoueta, etaaffmutdmd.cormileta, etaaffmutdmd.croseceta, etaaffmutdmd.rareta, etaaffmutdmd.apveta"
"                                                        Index Cond: (mutdemandes.croaffmutdmd = etaaffmutdmd.croeta)"
"                                                        Buffers: shared hit=3373"
"                                            ->  Index Scan using pk_crotyp on public.types typaffmutdmd  (cost=0.00..0.27 rows=1 width=13) (actual time=0.005..0.013 rows=1 loops=1247)"
"                                                  Output: typaffmutdmd.crotyp, typaffmutdmd.datmajtyp, typaffmutdmd.idetyp, typaffmutdmd.libtyp, typaffmutdmd.crogtytyp"
"                                                  Index Cond: (etaaffmutdmd.crotypeta = typaffmutdmd.crotyp)"
"                                                  Buffers: shared hit=2248"
"                                      ->  Hash Left Join  (cost=1174.03..8024.73 rows=18384 width=130) (actual time=64.360..992.508 rows=72057 loops=1247)"
"                                            Output: mutrlt1.cromutrlt, mutrlt1.croacamutrlt, mutrlt1.croetamutrlt, mutrlt1.cromutdmdmutrlt, etarlt1.ideeta, etarlt1.nometa, etarlt1.auxadreta, etarlt1.voiadreta, etarlt1.bopadreta, etarlt1.copadreta, etarlt1.locadreta, etarlt1.quaadreta, etarlt1.cotadreta, etarlt1.ctcadreta"
"                                            Hash Cond: (mutrlt1.croetamutrlt = etarlt1.croeta)"
"                                            Buffers: shared hit=810455 read=2573905, temp read=432709 written=425227"
"                                            ->  Hash Join  (cost=5.64..6029.64 rows=18384 width=16) (actual time=0.032..676.147 rows=72057 loops=1247)"
"                                                  Output: mutrlt1.cromutrlt, mutrlt1.croacamutrlt, mutrlt1.croetamutrlt, mutrlt1.cromutdmdmutrlt"
"                                                  Hash Cond: (mutrlt1.cromutmodmutrlt = mutmod1.cromutmod)"
"                                                  Join Filter: (((mutmod1.idemutmod)::text = ANY ('{V,D}'::text[])) OR (((mutmod1.idemutmod)::text = 'E'::text) AND (mutrlt1.ordmutrlt = 1)))"
"                                                  Buffers: shared hit=290456 read=2573905"
"                                                  ->  Seq Scan on public.mutresultats mutrlt1  (cost=0.00..4760.06 rows=246306 width=24) (actual time=0.020..257.395 rows=246306 loops=1247)"
"                                                        Output: mutrlt1.cromutrlt, mutrlt1.datmajmutrlt, mutrlt1.cromutdmdmutrlt, mutrlt1.cromutmodmutrlt, mutrlt1.croacamutrlt, mutrlt1.croetamutrlt, mutrlt1.cromutveumutrlt, mutrlt1.datmutrlt, mutrlt1.totrptmutrlt, mutrlt1.ordmutrlt, mutrlt1.quomutrlt"
"                                                        Buffers: shared hit=290455 read=2573904"
"                                                  ->  Hash  (cost=5.42..5.42 rows=18 width=6) (actual time=0.212..0.212 rows=18 loops=1)"
"                                                        Output: mutmod1.cromutmod, mutmod1.idemutmod"
"                                                        Buckets: 1024  Batches: 1  Memory Usage: 1kB"
"                                                        Buffers: shared hit=1 read=1"
"                                                        ->  Seq Scan on public.mutresultatmodes mutmod1  (cost=0.00..5.42 rows=18 width=6) (actual time=0.021..0.186 rows=18 loops=1)"
"                                                              Output: mutmod1.cromutmod, mutmod1.idemutmod"
"                                                              Filter: (((mutmod1.idemutmod)::text = ANY ('{V,D}'::text[])) OR ((mutmod1.idemutmod)::text = 'E'::text))"
"                                                              Buffers: shared hit=1 read=1"
"                                            ->  Hash  (cost=604.28..604.28 rows=18728 width=118) (actual time=64.064..64.064 rows=18728 loops=1247)"
"                                                  Output: etarlt1.ideeta, etarlt1.nometa, etarlt1.auxadreta, etarlt1.voiadreta, etarlt1.bopadreta, etarlt1.copadreta, etarlt1.locadreta, etarlt1.quaadreta, etarlt1.cotadreta, etarlt1.ctcadreta, etarlt1.croeta"
"                                                  Buckets: 1024  Batches: 4  Memory Usage: 487kB"
"                                                  Buffers: shared hit=519999, temp written=209496"
"                                                  ->  Seq Scan on public.etablissements etarlt1  (cost=0.00..604.28 rows=18728 width=118) (actual time=0.010..28.942 rows=18728 loops=1247)"
"                                                        Output: etarlt1.ideeta, etarlt1.nometa, etarlt1.auxadreta, etarlt1.voiadreta, etarlt1.bopadreta, etarlt1.copadreta, etarlt1.locadreta, etarlt1.quaadreta, etarlt1.cotadreta, etarlt1.ctcadreta, etarlt1.croeta"
"                                                        Buffers: shared hit=519999"
"                                ->  Hash Left Join  (cost=16588.47..27026.54 rows=75 width=200) (actual time=2342.680..3551.010 rows=36147 loops=1247)"
"                                      Output: dmdanc.cromutcdtmutdmd, etaeanc.copadreta, etaeanc.nometa, etaeanc.voiadreta, etaeanc.bopadreta, etaeanc.locadreta, etaeanc.quaadreta, etaeanc.cotadreta, etaeanc.ctcadreta, typeanc.idetyp, topanc.croanntop, etaranc.copadreta, etaranc.nometa, etaranc.voiadreta, etaranc.bopadreta, etaranc.locadreta, etaranc.quaadreta, etaranc.cotadreta, etaranc.ctcadreta, typranc.idetyp"
"                                      Hash Cond: (dmdanc.cromutdmd = rltranc.cromutdmdmutrlt)"
"                                      Buffers: shared hit=2280683 read=10154447, temp read=3704837 written=3654957"
"                                      ->  Hash Left Join  (cost=8593.70..18844.22 rows=75 width=107) (actual time=1235.787..2261.887 rows=35614 loops=1247)"
"                                            Output: dmdanc.cromutdmd, dmdanc.cromutcdtmutdmd, etaeanc.copadreta, etaeanc.nometa, etaeanc.voiadreta, etaeanc.bopadreta, etaeanc.locadreta, etaeanc.quaadreta, etaeanc.cotadreta, etaeanc.ctcadreta, typeanc.idetyp, topanc.croanntop"
"                                            Hash Cond: (dmdanc.cromutdmd = rlteanc.cromutdmdmutrlt)"
"                                            Buffers: shared hit=1470162 read=7580607, temp read=1838078 written=1813138"
"                                            ->  Hash Join  (cost=134.14..10214.05 rows=75 width=10) (actual time=1.732..864.533 rows=35612 loops=1247)"
"                                                  Output: topanc.croanntop, dmdanc.cromutdmd, dmdanc.cromutcdtmutdmd"
"                                                  Hash Cond: (dmdanc.crotopmutdmd = topanc.crotop)"
"                                                  Buffers: shared hit=659673 read=5006735"
"                                                  ->  Seq Scan on public.mutdemandes dmdanc  (cost=0.00..8569.57 rows=402557 width=12) (actual time=0.023..415.419 rows=402557 loops=1247)"
"                                                        Output: dmdanc.cromutdmd, dmdanc.datmajmutdmd, dmdanc.cromutcdtmutdmd, dmdanc.crotopmutdmd, dmdanc.crodismutdmd, dmdanc.crodisrctmutdmd, dmdanc.nbrdismutdmd, dmdanc.crocatmutdmd, dmdanc.croadmmutdmd, dmdanc.cromutsvcmutdmd, dmdanc.croaffmutdmd, dmdanc.croexemutdmd, dmdanc.croacamutdmd, dmdanc.obsmutdmd, dmdanc.obsrltmutdmd, dmdanc.nomcjtmutdmd, dmdanc.prncjtmutdmd, dmdanc.crodiscjtmutdmd, dmdanc.croacacjtmutdmd, dmdanc.extmutdmd, dmdanc.cromutqltmutdmd, dmdanc.cromutlitmutdmd, dmdanc.accmutdmd, dmdanc.prfmutdmd, dmdanc.sspmutdmd, dmdanc.croacaorimutdmd, dmdanc.rarmutdmd"
"                                                        Buffers: shared hit=659671 read=5006697"
"                                                  ->  Hash  (cost=134.13..134.13 rows=1 width=6) (actual time=2.149..2.149 rows=3 loops=1)"
"                                                        Output: topanc.crotop, topanc.croanntop"
"                                                        Buckets: 1024  Batches: 1  Memory Usage: 1kB"
"                                                        Buffers: shared hit=2 read=38"
"                                                        ->  Seq Scan on public.operationtypes topanc  (cost=0.00..134.13 rows=1 width=6) (actual time=1.708..2.139 rows=3 loops=1)"
"                                                              Output: topanc.crotop, topanc.croanntop"
"                                                              Filter: ((topanc.toutop = 3) AND ((topanc.croanntop + 1) = 2011))"
"                                                              Buffers: shared hit=2 read=38"
"                                            ->  Hash  (cost=8175.51..8175.51 rows=10084 width=101) (actual time=1233.710..1233.710 rows=67854 loops=1247)"
"                                                  Output: rlteanc.cromutdmdmutrlt, etaeanc.copadreta, etaeanc.nometa, etaeanc.voiadreta, etaeanc.bopadreta, etaeanc.locadreta, etaeanc.quaadreta, etaeanc.cotadreta, etaeanc.ctcadreta, typeanc.idetyp"
"                                                  Buckets: 1024  Batches: 8 (originally 2)  Memory Usage: 1025kB"
"                                                  Buffers: shared hit=810489 read=2573872, temp read=376594 written=1395393"
"                                                  ->  Hash Join  (cost=1120.62..8175.51 rows=10084 width=101) (actual time=64.086..1072.749 rows=67854 loops=1247)"
"                                                        Output: rlteanc.cromutdmdmutrlt, etaeanc.copadreta, etaeanc.nometa, etaeanc.voiadreta, etaeanc.bopadreta, etaeanc.locadreta, etaeanc.quaadreta, etaeanc.cotadreta, etaeanc.ctcadreta, typeanc.idetyp"
"                                                        Hash Cond: (etaeanc.crotypeta = typeanc.crotyp)"
"                                                        Buffers: shared hit=810489 read=2573872, temp read=376594 written=369112"
"                                                        ->  Hash Join  (cost=1118.38..8034.61 rows=10084 width=96) (actual time=64.081..912.815 rows=67854 loops=1247)"
"                                                              Output: rlteanc.cromutdmdmutrlt, etaeanc.copadreta, etaeanc.nometa, etaeanc.voiadreta, etaeanc.bopadreta, etaeanc.locadreta, etaeanc.quaadreta, etaeanc.cotadreta, etaeanc.ctcadreta, etaeanc.crotypeta"
"                                                              Hash Cond: (rlteanc.croetamutrlt = etaeanc.croeta)"
"                                                              Buffers: shared hit=810488 read=2573872, temp read=376594 written=369112"
"                                                              ->  Hash Join  (cost=5.00..6347.31 rows=11895 width=8) (actual time=0.037..616.600 rows=67854 loops=1247)"
"                                                                    Output: rlteanc.croetamutrlt, rlteanc.cromutdmdmutrlt"
"                                                                    Hash Cond: (rlteanc.cromutmodmutrlt = modeanc.cromutmod)"
"                                                                    Buffers: shared hit=290489 read=2573872"
"                                                                    ->  Seq Scan on public.mutresultats rlteanc  (cost=0.00..5375.82 rows=226010 width=12) (actual time=0.031..317.408 rows=226093 loops=1247)"
"                                                                          Output: rlteanc.cromutrlt, rlteanc.datmajmutrlt, rlteanc.cromutdmdmutrlt, rlteanc.cromutmodmutrlt, rlteanc.croacamutrlt, rlteanc.croetamutrlt, rlteanc.cromutveumutrlt, rlteanc.datmutrlt, rlteanc.totrptmutrlt, rlteanc.ordmutrlt, rlteanc.quomutrlt"
"                                                                          Filter: (rlteanc.ordmutrlt = 1)"
"                                                                          Buffers: shared hit=290487 read=2573872"
"                                                                    ->  Hash  (cost=4.85..4.85 rows=12 width=4) (actual time=0.133..0.133 rows=12 loops=1)"
"                                                                          Output: modeanc.cromutmod"
"                                                                          Buckets: 1024  Batches: 1  Memory Usage: 1kB"
"                                                                          Buffers: shared hit=2"
"                                                                          ->  Seq Scan on public.mutresultatmodes modeanc  (cost=0.00..4.85 rows=12 width=4) (actual time=0.015..0.117 rows=12 loops=1)"
"                                                                                Output: modeanc.cromutmod"
"                                                                                Filter: ((modeanc.cromutmod IS NOT NULL) AND ((modeanc.idemutmod)::text = 'E'::text))"
"                                                                                Buffers: shared hit=2"
"                                                              ->  Hash  (cost=604.28..604.28 rows=18728 width=96) (actual time=63.801..63.801 rows=18728 loops=1247)"
"                                                                    Output: etaeanc.copadreta, etaeanc.nometa, etaeanc.voiadreta, etaeanc.bopadreta, etaeanc.locadreta, etaeanc.quaadreta, etaeanc.cotadreta, etaeanc.ctcadreta, etaeanc.croeta, etaeanc.crotypeta"
"                                                                    Buckets: 1024  Batches: 4  Memory Usage: 459kB"
"                                                                    Buffers: shared hit=519999, temp written=195779"
"                                                                    ->  Seq Scan on public.etablissements etaeanc  (cost=0.00..604.28 rows=18728 width=96) (actual time=0.010..29.445 rows=18728 loops=1247)"
"                                                                          Output: etaeanc.copadreta, etaeanc.nometa, etaeanc.voiadreta, etaeanc.bopadreta, etaeanc.locadreta, etaeanc.quaadreta, etaeanc.cotadreta, etaeanc.ctcadreta, etaeanc.croeta, etaeanc.crotypeta"
"                                                                          Buffers: shared hit=519999"
"                                                        ->  Hash  (cost=1.55..1.55 rows=55 width=13) (actual time=0.138..0.138 rows=55 loops=1)"
"                                                              Output: typeanc.idetyp, typeanc.crotyp"
"                                                              Buckets: 1024  Batches: 1  Memory Usage: 2kB"
"                                                              Buffers: shared hit=1"
"                                                              ->  Seq Scan on public.types typeanc  (cost=0.00..1.55 rows=55 width=13) (actual time=0.007..0.067 rows=55 loops=1)"
"                                                                    Output: typeanc.idetyp, typeanc.crotyp"
"                                                                    Buffers: shared hit=1"
"                                      ->  Hash  (cost=7685.39..7685.39 rows=10990 width=101) (actual time=1106.855..1106.855 rows=56185 loops=1247)"
"                                            Output: rltranc.cromutdmdmutrlt, etaranc.copadreta, etaranc.nometa, etaranc.voiadreta, etaranc.bopadreta, etaranc.locadreta, etaranc.quaadreta, etaranc.cotadreta, etaranc.ctcadreta, typranc.idetyp"
"                                            Buckets: 1024  Batches: 8 (originally 2)  Memory Usage: 1025kB"
"                                            Buffers: shared hit=810521 read=2573840, temp read=349160 written=1193379"
"                                            ->  Hash Join  (cost=1120.62..7685.39 rows=10990 width=101) (actual time=65.017..971.974 rows=56185 loops=1247)"
"                                                  Output: rltranc.cromutdmdmutrlt, etaranc.copadreta, etaranc.nometa, etaranc.voiadreta, etaranc.bopadreta, etaranc.locadreta, etaranc.quaadreta, etaranc.cotadreta, etaranc.ctcadreta, typranc.idetyp"
"                                                  Hash Cond: (etaranc.crotypeta = typranc.crotyp)"
"                                                  Buffers: shared hit=810521 read=2573840, temp read=349160 written=341678"
"                                                  ->  Hash Join  (cost=1118.38..7532.04 rows=10990 width=96) (actual time=65.010..839.886 rows=56185 loops=1247)"
"                                                        Output: rltranc.cromutdmdmutrlt, etaranc.copadreta, etaranc.nometa, etaranc.voiadreta, etaranc.bopadreta, etaranc.locadreta, etaranc.quaadreta, etaranc.cotadreta, etaranc.ctcadreta, etaranc.crotypeta"
"                                                        Hash Cond: (rltranc.croetamutrlt = etaranc.croeta)"
"                                                        Buffers: shared hit=810520 read=2573840, temp read=349160 written=341678"
"                                                        ->  Hash Join  (cost=5.00..5818.34 rows=12963 width=8) (actual time=0.083..580.300 rows=56185 loops=1247)"
"                                                              Output: rltranc.croetamutrlt, rltranc.cromutdmdmutrlt"
"                                                              Hash Cond: (rltranc.cromutmodmutrlt = modranc.cromutmod)"
"                                                              Buffers: shared hit=290521 read=2573840"
"                                                              ->  Seq Scan on public.mutresultats rltranc  (cost=0.00..4760.06 rows=246306 width=12) (actual time=0.027..253.403 rows=246306 loops=1247)"
"                                                                    Output: rltranc.cromutrlt, rltranc.datmajmutrlt, rltranc.cromutdmdmutrlt, rltranc.cromutmodmutrlt, rltranc.croacamutrlt, rltranc.croetamutrlt, rltranc.cromutveumutrlt, rltranc.datmutrlt, rltranc.totrptmutrlt, rltranc.ordmutrlt, rltranc.quomutrlt"
"                                                                    Buffers: shared hit=290519 read=2573840"
"                                                              ->  Hash  (cost=4.85..4.85 rows=12 width=4) (actual time=0.131..0.131 rows=12 loops=1)"
"                                                                    Output: modranc.cromutmod"
"                                                                    Buckets: 1024  Batches: 1  Memory Usage: 1kB"
"                                                                    Buffers: shared hit=2"
"                                                                    ->  Seq Scan on public.mutresultatmodes modranc  (cost=0.00..4.85 rows=12 width=4) (actual time=0.018..0.114 rows=12 loops=1)"
"                                                                          Output: modranc.cromutmod"
"                                                                          Filter: ((modranc.idemutmod)::text = 'R'::text)"
"                                                                          Buffers: shared hit=2"
"                                                        ->  Hash  (cost=604.28..604.28 rows=18728 width=96) (actual time=63.287..63.287 rows=18728 loops=1247)"
"                                                              Output: etaranc.copadreta, etaranc.nometa, etaranc.voiadreta, etaranc.bopadreta, etaranc.locadreta, etaranc.quaadreta, etaranc.cotadreta, etaranc.ctcadreta, etaranc.croeta, etaranc.crotypeta"
"                                                              Buckets: 1024  Batches: 4  Memory Usage: 459kB"
"                                                              Buffers: shared hit=519999, temp written=195779"
"                                                              ->  Seq Scan on public.etablissements etaranc  (cost=0.00..604.28 rows=18728 width=96) (actual time=0.012..29.033 rows=18728 loops=1247)"
"                                                                    Output: etaranc.copadreta, etaranc.nometa, etaranc.voiadreta, etaranc.bopadreta, etaranc.locadreta, etaranc.quaadreta, etaranc.cotadreta, etaranc.ctcadreta, etaranc.croeta, etaranc.crotypeta"
"                                                                    Buffers: shared hit=519999"
"                                                  ->  Hash  (cost=1.55..1.55 rows=55 width=13) (actual time=0.147..0.147 rows=55 loops=1)"
"                                                        Output: typranc.idetyp, typranc.crotyp"
"                                                        Buckets: 1024  Batches: 1  Memory Usage: 2kB"
"                                                        Buffers: shared hit=1"
"                                                        ->  Seq Scan on public.types typranc  (cost=0.00..1.55 rows=55 width=13) (actual time=0.008..0.074 rows=55 loops=1)"
"                                                              Output: typranc.idetyp, typranc.crotyp"
"                                                              Buffers: shared hit=1"
"                          ->  Hash Join  (cost=7.60..7819.48 rows=212817 width=12) (actual time=0.083..693.362 rows=154036 loops=1069)"
"                                Output: mutrlt2.croacamutrlt, mutrlt2.croetamutrlt, mutrlt2.cromutdmdmutrlt"
"                                Hash Cond: (mutrlt2.cromutmodmutrlt = mutmod2.cromutmod)"
"                                Buffers: shared hit=249079 read=2206416"
"                                ->  Seq Scan on public.mutresultats mutrlt2  (cost=0.00..4760.06 rows=246306 width=16) (actual time=0.029..252.505 rows=246306 loops=1069)"
"                                      Output: mutrlt2.cromutrlt, mutrlt2.datmajmutrlt, mutrlt2.cromutdmdmutrlt, mutrlt2.cromutmodmutrlt, mutrlt2.croacamutrlt, mutrlt2.croetamutrlt, mutrlt2.cromutveumutrlt, mutrlt2.datmutrlt, mutrlt2.totrptmutrlt, mutrlt2.ordmutrlt, mutrlt2.quomutrlt"
"                                      Buffers: shared hit=249077 read=2206416"
"                                ->  Hash  (cost=5.13..5.13 rows=197 width=4) (actual time=0.565..0.565 rows=210 loops=1)"
"                                      Output: mutmod2.cromutmod"
"                                      Buckets: 1024  Batches: 1  Memory Usage: 5kB"
"                                      Buffers: shared hit=2"
"                                      ->  Seq Scan on public.mutresultatmodes mutmod2  (cost=0.00..5.13 rows=197 width=4) (actual time=0.015..0.322 rows=210 loops=1)"
"                                            Output: mutmod2.cromutmod"
"                                            Filter: ((mutmod2.idemutmod)::text = ANY ('{N,S,R}'::text[]))"
"                                            Buffers: shared hit=2"
"                    ->  Index Scan using pk_croeta on public.etablissements etarlt2  (cost=0.00..3.14 rows=1 width=118) (actual time=0.004..0.004 rows=0 loops=1069)"
"                          Output: etarlt2.croeta, etarlt2.datmajeta, etarlt2.ideeta, etarlt2.crotypeta, etarlt2.crodepeta, etarlt2.crocometa, etarlt2.nometa, etarlt2.auxadreta, etarlt2.voiadreta, etarlt2.bopadreta, etarlt2.copadreta, etarlt2.locadreta, etarlt2.quaadreta, etarlt2.cotadreta, etarlt2.ctcadreta, etarlt2.teleta, etarlt2.faxeta, etarlt2.maieta, etarlt2.nuseta, etarlt2.coueta, etarlt2.usteta, etarlt2.croroueta, etarlt2.datroueta, etarlt2.deleta, etarlt2.entetieta, etarlt2.descoueta, etarlt2.cormileta, etarlt2.croseceta, etarlt2.rareta, etarlt2.apveta"
"                          Index Cond: (mutrlt2.croetamutrlt = etarlt2.croeta)"
"Total runtime: 6691300.904 ms"