explain.depesz.com

A tool for finding a real cause for slow queries.

Result: a7Y

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 5.596 6691298.572 ↓ 1069.0 1069 1

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
2. 2.128 6691292.976 ↓ 1069.0 1069 1

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
3. 25.722 6691290.848 ↓ 1069.0 1069 1

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
4. 40.458 6691265.126 ↓ 1069.0 1069 1

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
5. 154165.833 6691220.392 ↓ 1069.0 1069 1

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
6. 43030.120 5795850.581 ↓ 1069.0 1069 1

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
7. 86773.869 1324710.991 ↓ 1247.0 1247 1

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
8. 7.911 279.646 ↓ 1247.0 1247 1

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
9. 9.735 255.524 ↓ 1247.0 1247 1

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
10. 7.016 232.072 ↓ 1247.0 1247 1

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
11. 7.609 222.562 ↓ 1247.0 1247 1

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
12. 7.866 212.459 ↓ 1247.0 1247 1

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
13. 11.031 202.099 ↓ 1247.0 1247 1

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
14. 11.731 191.017 ↓ 919.0 1838 1

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
15. 4.872 160.906 ↓ 919.0 1838 1

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
16. 0.022 0.022 ↑ 1.0 1 1

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
17. 5.107 156.012 ↓ 919.0 1838 1

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
18. 0.078 0.078 ↑ 1.0 1 1

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
19. 10.990 150.827 ↓ 919.0 1838 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
20. 11.348 125.133 ↓ 919.0 1838 1

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
21. 13.616 99.081 ↓ 919.0 1838 1

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
22. 21.548 45.029 ↓ 919.0 1838 1

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
23. 20.990 23.423 ↓ 1.0 11896 1

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
24. 2.433 2.433 ↓ 1.0 11896 1

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
25. 0.007 0.058 ↑ 1.0 1 1

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
26. 0.051 0.051 ↑ 1.0 1 1

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
27. 40.436 40.436 ↑ 1.0 1 1838

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
28. 14.704 14.704 ↑ 1.0 1 1838

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
29. 14.704 14.704 ↑ 1.0 1 1838

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
30. 18.380 18.380 ↓ 0.0 0 1838

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
31. 0.015 0.051 ↑ 1.0 9 1

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
32. 0.036 0.036 ↑ 1.0 9 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
33. 2.494 2.494 ↓ 0.0 0 1247

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
34. 2.494 2.494 ↓ 0.0 0 1247

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
35. 2.494 2.494 ↓ 0.0 0 1247

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
36. 13.717 13.717 ↑ 1.0 1 1247

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
37. 16.211 16.211 ↑ 1.0 1 1247

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
38. 314614.359 1237657.476 ↓ 3.9 72057 1247

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
39. 522183.532 843155.309 ↓ 3.9 72057 1247

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
40. 320971.565 320971.565 ↑ 1.0 246306 1247

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
41. 0.026 0.212 ↑ 1.0 18 1

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
42. 0.186 0.186 ↑ 1.0 18 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
43. 43797.134 79887.808 ↑ 1.0 18728 1247

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
44. 36090.674 36090.674 ↑ 1.0 18728 1247

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
45. 227288.196 4428109.470 ↓ 482.0 36147 1247

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
46. 204064.068 2820573.089 ↓ 474.9 35614 1247

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
47. 560043.009 1078072.651 ↓ 474.8 35612 1247

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
48. 518027.493 518027.493 ↑ 1.0 402557 1247

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
49. 0.010 2.149 ↓ 3.0 3 1

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
50. 2.139 2.139 ↓ 3.0 3 1

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
51. 200718.367 1538436.370 ↓ 6.7 67854 1247

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
52. 199437.560 1337718.003 ↓ 6.7 67854 1247

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
53. 289820.258 1138280.305 ↓ 6.7 67854 1247

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
54. 373092.291 768900.200 ↓ 5.7 67854 1247

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
55. 395807.776 395807.776 ↓ 1.0 226093 1247

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
56. 0.016 0.133 ↑ 1.0 12 1

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
57. 0.117 0.117 ↑ 1.0 12 1

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
58. 42841.932 79559.847 ↑ 1.0 18728 1247

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
59. 36717.915 36717.915 ↑ 1.0 18728 1247

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
60. 0.071 0.138 ↑ 1.0 55 1

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
61. 0.067 0.067 ↑ 1.0 55 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
62. 168196.607 1380248.185 ↓ 5.1 56185 1247

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
63. 164713.589 1212051.578 ↓ 5.1 56185 1247

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
64. 244784.853 1047337.842 ↓ 5.1 56185 1247

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
65. 407640.428 723634.100 ↓ 4.3 56185 1247

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
66. 315993.541 315993.541 ↑ 1.0 246306 1247

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
67. 0.017 0.131 ↑ 1.0 12 1

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
68. 0.114 0.114 ↑ 1.0 12 1

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
69. 42714.738 78918.889 ↑ 1.0 18728 1247

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
70. 36204.151 36204.151 ↑ 1.0 18728 1247

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
71. 0.073 0.147 ↑ 1.0 55 1

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
72. 0.074 0.074 ↑ 1.0 55 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
73. 471275.568 741203.978 ↑ 1.4 154036 1069

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
74. 269927.845 269927.845 ↑ 1.0 246306 1069

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
75. 0.243 0.565 ↓ 1.1 210 1

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
76. 0.322 0.322 ↓ 1.1 210 1

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
77. 4.276 4.276 ↓ 0.0 0 1069

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)