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 6,691,298.572 ↓ 1,069.0 1,069 1

HashAggregate (cost=50,810.98..50,810.99 rows=1 width=1,528) (actual time=6,691,296.912..6,691,298.572 rows=1,069 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 6,691,292.976 ↓ 1,069.0 1,069 1

Subquery Scan on vue_mutphp4test (cost=50,810.80..50,810.91 rows=1 width=1,528) (actual time=6,691,288.043..6,691,292.976 rows=1,069 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 6,691,290.848 ↓ 1,069.0 1,069 1

HashAggregate (cost=50,810.80..50,810.90 rows=1 width=936) (actual time=6,691,288.039..6,691,290.848 rows=1,069 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 6,691,265.126 ↓ 1,069.0 1,069 1

Nested Loop Left Join (cost=18,007.86..50,810.64 rows=1 width=936) (actual time=5,245.329..6,691,265.126 rows=1,069 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. 154,165.833 6,691,220.392 ↓ 1,069.0 1,069 1

Nested Loop Left Join (cost=18,007.86..50,807.39 rows=1 width=822) (actual time=5,245.275..6,691,220.392 rows=1,069 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. 43,030.120 5,795,850.581 ↓ 1,069.0 1,069 1

Nested Loop Left Join (cost=18,000.26..40,327.70 rows=1 width=814) (actual time=4,419.177..5,795,850.581 rows=1,069 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. 86,773.869 1,324,710.991 ↓ 1,247.0 1,247 1

Nested Loop Left Join (cost=1,411.79..13,298.63 rows=1 width=620) (actual time=907.293..1,324,710.991 rows=1,247 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 ↓ 1,247.0 1,247 1

Nested Loop Left Join (cost=237.76..5,044.10 rows=1 width=494) (actual time=29.739..279.646 rows=1,247 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 ↓ 1,247.0 1,247 1

Nested Loop Left Join (cost=237.76..5,043.82 rows=1 width=489) (actual time=29.727..255.524 rows=1,247 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 ↓ 1,247.0 1,247 1

Nested Loop Left Join (cost=237.76..5,035.53 rows=1 width=371) (actual time=29.709..232.072 rows=1,247 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 ↓ 1,247.0 1,247 1

Nested Loop Left Join (cost=237.76..5,027.25 rows=1 width=287) (actual time=29.702..222.562 rows=1,247 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 ↓ 1,247.0 1,247 1

Nested Loop Left Join (cost=237.76..5,018.97 rows=1 width=197) (actual time=29.695..212.459 rows=1,247 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 ↓ 1,247.0 1,247 1

Hash Left Join (cost=237.76..5,010.69 rows=1 width=197) (actual time=29.688..202.099 rows=1,247 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 1,838 1

Nested Loop Left Join (cost=236.56..5,009.46 rows=2 width=189) (actual time=29.606..191.017 rows=1,838 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 1,838 1

Nested Loop (cost=236.56..5,002.84 rows=2 width=71) (actual time=29.598..160.906 rows=1,838 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 1,838 1

Nested Loop (cost=236.56..4,994.55 rows=2 width=71) (actual time=29.572..156.012 rows=1,838 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 1,838 1

Nested Loop (cost=236.56..4,990.87 rows=2 width=58) (actual time=29.545..150.827 rows=1,838 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 1,838 1

Nested Loop (cost=236.56..4,988.31 rows=2 width=58) (actual time=29.532..125.133 rows=1,838 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 1,838 1

Nested Loop (cost=236.56..4,987.75 rows=2 width=58) (actual time=29.519..99.081 rows=1,838 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 1,838 1

Hash Join (cost=236.56..4,971.16 rows=2 width=38) (actual time=29.489..45.029 rows=1,838 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 11,896 1

Bitmap Heap Scan on public.mutdemandes (cost=227.19..4,917.79 rows=11,728 width=28) (actual time=2.574..23.423 rows=11,896 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 11,896 1

Bitmap Index Scan on ix_acamutdmd (cost=0.00..224.26 rows=11,728 width=0) (actual time=2.433..2.433 rows=11,896 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 1,838

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=1,838)

  • 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 1,838

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=1,838)

  • 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 1,838

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=1,838)

  • 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 1,838

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=1,838)

  • 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 1,247

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=1,247)

  • 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 1,247

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=1,247)

  • 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 1,247

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=1,247)

  • 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 1,247

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=1,247)

  • 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 1,247

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=1,247)

  • Output: typaffmutdmd.crotyp, typaffmutdmd.datmajtyp, typaffmutdmd.idetyp, typaffmutdmd.libtyp, typaffmutdmd.crogtytyp
  • Index Cond: (etaaffmutdmd.crotypeta = typaffmutdmd.crotyp)
  • Buffers: shared hit=2248
38. 314,614.359 1,237,657.476 ↓ 3.9 72,057 1,247

Hash Left Join (cost=1,174.03..8,024.73 rows=18,384 width=130) (actual time=64.360..992.508 rows=72,057 loops=1,247)

  • 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. 522,183.532 843,155.309 ↓ 3.9 72,057 1,247

Hash Join (cost=5.64..6,029.64 rows=18,384 width=16) (actual time=0.032..676.147 rows=72,057 loops=1,247)

  • 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. 320,971.565 320,971.565 ↑ 1.0 246,306 1,247

Seq Scan on public.mutresultats mutrlt1 (cost=0.00..4,760.06 rows=246,306 width=24) (actual time=0.020..257.395 rows=246,306 loops=1,247)

  • 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. 43,797.134 79,887.808 ↑ 1.0 18,728 1,247

Hash (cost=604.28..604.28 rows=18,728 width=118) (actual time=64.064..64.064 rows=18,728 loops=1,247)

  • 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. 36,090.674 36,090.674 ↑ 1.0 18,728 1,247

Seq Scan on public.etablissements etarlt1 (cost=0.00..604.28 rows=18,728 width=118) (actual time=0.010..28.942 rows=18,728 loops=1,247)

  • 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. 227,288.196 4,428,109.470 ↓ 482.0 36,147 1,247

Hash Left Join (cost=16,588.47..27,026.54 rows=75 width=200) (actual time=2,342.680..3,551.010 rows=36,147 loops=1,247)

  • 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. 204,064.068 2,820,573.089 ↓ 474.9 35,614 1,247

Hash Left Join (cost=8,593.70..18,844.22 rows=75 width=107) (actual time=1,235.787..2,261.887 rows=35,614 loops=1,247)

  • 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. 560,043.009 1,078,072.651 ↓ 474.8 35,612 1,247

Hash Join (cost=134.14..10,214.05 rows=75 width=10) (actual time=1.732..864.533 rows=35,612 loops=1,247)

  • Output: topanc.croanntop, dmdanc.cromutdmd, dmdanc.cromutcdtmutdmd
  • Hash Cond: (dmdanc.crotopmutdmd = topanc.crotop)
  • Buffers: shared hit=659673 read=5006735
48. 518,027.493 518,027.493 ↑ 1.0 402,557 1,247

Seq Scan on public.mutdemandes dmdanc (cost=0.00..8,569.57 rows=402,557 width=12) (actual time=0.023..415.419 rows=402,557 loops=1,247)

  • 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. 200,718.367 1,538,436.370 ↓ 6.7 67,854 1,247

Hash (cost=8,175.51..8,175.51 rows=10,084 width=101) (actual time=1,233.710..1,233.710 rows=67,854 loops=1,247)

  • 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. 199,437.560 1,337,718.003 ↓ 6.7 67,854 1,247

Hash Join (cost=1,120.62..8,175.51 rows=10,084 width=101) (actual time=64.086..1,072.749 rows=67,854 loops=1,247)

  • 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. 289,820.258 1,138,280.305 ↓ 6.7 67,854 1,247

Hash Join (cost=1,118.38..8,034.61 rows=10,084 width=96) (actual time=64.081..912.815 rows=67,854 loops=1,247)

  • 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. 373,092.291 768,900.200 ↓ 5.7 67,854 1,247

Hash Join (cost=5.00..6,347.31 rows=11,895 width=8) (actual time=0.037..616.600 rows=67,854 loops=1,247)

  • Output: rlteanc.croetamutrlt, rlteanc.cromutdmdmutrlt
  • Hash Cond: (rlteanc.cromutmodmutrlt = modeanc.cromutmod)
  • Buffers: shared hit=290489 read=2573872
55. 395,807.776 395,807.776 ↓ 1.0 226,093 1,247

Seq Scan on public.mutresultats rlteanc (cost=0.00..5,375.82 rows=226,010 width=12) (actual time=0.031..317.408 rows=226,093 loops=1,247)

  • 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. 42,841.932 79,559.847 ↑ 1.0 18,728 1,247

Hash (cost=604.28..604.28 rows=18,728 width=96) (actual time=63.801..63.801 rows=18,728 loops=1,247)

  • 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. 36,717.915 36,717.915 ↑ 1.0 18,728 1,247

Seq Scan on public.etablissements etaeanc (cost=0.00..604.28 rows=18,728 width=96) (actual time=0.010..29.445 rows=18,728 loops=1,247)

  • 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. 168,196.607 1,380,248.185 ↓ 5.1 56,185 1,247

Hash (cost=7,685.39..7,685.39 rows=10,990 width=101) (actual time=1,106.855..1,106.855 rows=56,185 loops=1,247)

  • 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. 164,713.589 1,212,051.578 ↓ 5.1 56,185 1,247

Hash Join (cost=1,120.62..7,685.39 rows=10,990 width=101) (actual time=65.017..971.974 rows=56,185 loops=1,247)

  • 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. 244,784.853 1,047,337.842 ↓ 5.1 56,185 1,247

Hash Join (cost=1,118.38..7,532.04 rows=10,990 width=96) (actual time=65.010..839.886 rows=56,185 loops=1,247)

  • 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. 407,640.428 723,634.100 ↓ 4.3 56,185 1,247

Hash Join (cost=5.00..5,818.34 rows=12,963 width=8) (actual time=0.083..580.300 rows=56,185 loops=1,247)

  • Output: rltranc.croetamutrlt, rltranc.cromutdmdmutrlt
  • Hash Cond: (rltranc.cromutmodmutrlt = modranc.cromutmod)
  • Buffers: shared hit=290521 read=2573840
66. 315,993.541 315,993.541 ↑ 1.0 246,306 1,247

Seq Scan on public.mutresultats rltranc (cost=0.00..4,760.06 rows=246,306 width=12) (actual time=0.027..253.403 rows=246,306 loops=1,247)

  • 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. 42,714.738 78,918.889 ↑ 1.0 18,728 1,247

Hash (cost=604.28..604.28 rows=18,728 width=96) (actual time=63.287..63.287 rows=18,728 loops=1,247)

  • 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. 36,204.151 36,204.151 ↑ 1.0 18,728 1,247

Seq Scan on public.etablissements etaranc (cost=0.00..604.28 rows=18,728 width=96) (actual time=0.012..29.033 rows=18,728 loops=1,247)

  • 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. 471,275.568 741,203.978 ↑ 1.4 154,036 1,069

Hash Join (cost=7.60..7,819.48 rows=212,817 width=12) (actual time=0.083..693.362 rows=154,036 loops=1,069)

  • Output: mutrlt2.croacamutrlt, mutrlt2.croetamutrlt, mutrlt2.cromutdmdmutrlt
  • Hash Cond: (mutrlt2.cromutmodmutrlt = mutmod2.cromutmod)
  • Buffers: shared hit=249079 read=2206416
74. 269,927.845 269,927.845 ↑ 1.0 246,306 1,069

Seq Scan on public.mutresultats mutrlt2 (cost=0.00..4,760.06 rows=246,306 width=16) (actual time=0.029..252.505 rows=246,306 loops=1,069)

  • 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 1,069

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=1,069)

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