explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ks5

Settings
# exclusive inclusive rows x rows loops node
1. 1,368,925.979 26,843,661.555 ↓ 1,134,418,246.0 1,134,418,246 1

Gather (cost=6,116.23..151,232.86 rows=1 width=137) (actual time=2,204.037..26,843,661.555 rows=1,134,418,246 loops=1)

  • Output: udl_ann_lplv.iudiref, ins_amont_lplv.iuge, uge_ins_amont_lplv.luge, udl_ann_lplv.iins, udl_ann_lplv.lins, udl_ann_lplv.itin, udl_ann_lplv.ipar, udl_ann_lplv.resultat, udl_ann_lplv.unt, udl_ann_lplv.traduction, ("substring"((udl_ann_lplv.iplv)::text, 4)), udl_ann_lplv.dplv, udl_ann_lplv.utlcalcul, udl_ann_lplv.annee
  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=25364543063 read=106363
2. 10,135,931.662 25,474,735.576 ↓ 378,139,415.0 378,139,415 3

Nested Loop Semi Join (cost=5,116.23..150,232.76 rows=1 width=137) (actual time=2,559.876..25,474,735.576 rows=378,139,415 loops=3)

  • Output: udl_ann_lplv.iudiref, ins_amont_lplv.iuge, uge_ins_amont_lplv.luge, udl_ann_lplv.iins, udl_ann_lplv.lins, udl_ann_lplv.itin, udl_ann_lplv.ipar, udl_ann_lplv.resultat, udl_ann_lplv.unt, udl_ann_lplv.traduction, "substring"((udl_ann_lplv.iplv)::text, 4), udl_ann_lplv.dplv, udl_ann_lplv.utlcalcul, udl_ann_lplv.annee
  • Buffers: shared hit=25364543063 read=106363
  • Worker 0: actual time=3302.740..25160489.359 rows=370449832 loops=1
  • Buffers: shared hit=8394197416 read=18802
  • Worker 1: actual time=2176.245..25061234.270 rows=379203644 loops=1
  • Buffers: shared hit=8356020507 read=39971
3. 3,814,490.649 15,338,803.888 ↓ 378,139,415.0 378,139,415 3

Nested Loop (cost=5,115.39..150,193.96 rows=1 width=147) (actual time=2,559.784..15,338,803.888 rows=378,139,415 loops=3)

  • Output: udl_ann_lplv.iudiref, udl_ann_lplv.iins, udl_ann_lplv.lins, udl_ann_lplv.itin, udl_ann_lplv.ipar, udl_ann_lplv.resultat, udl_ann_lplv.unt, udl_ann_lplv.traduction, udl_ann_lplv.iplv, udl_ann_lplv.dplv, udl_ann_lplv.utlcalcul, udl_ann_lplv.annee, ins_amont_lplv.iuge, uge_ins_amont_lplv.luge, psv.iins, ins.iins, udl_ann_par.iins
  • Buffers: shared hit=14020021393 read=106348
  • Worker 0: actual time=3302.648..15216451.701 rows=370449832 loops=1
  • Buffers: shared hit=4689689597 read=18801
  • Worker 1: actual time=2176.159..14964578.558 rows=379203644 loops=1
  • Buffers: shared hit=4563670885 read=39967
4. 1,416,542.039 11,524,313.230 ↓ 378,139,415.0 378,139,415 3

Nested Loop (cost=5,115.39..150,190.67 rows=1 width=151) (actual time=2,559.743..11,524,313.230 rows=378,139,415 loops=3)

  • Output: udl_ann_lplv.iudiref, udl_ann_lplv.iins, udl_ann_lplv.lins, udl_ann_lplv.itin, udl_ann_lplv.ipar, udl_ann_lplv.resultat, udl_ann_lplv.unt, udl_ann_lplv.traduction, udl_ann_lplv.iplv, udl_ann_lplv.dplv, udl_ann_lplv.utlcalcul, udl_ann_lplv.annee, ins_amont_lplv.iuge, uge_ins_amont_lplv.luge, psv.dptddass, psv.iins, ins.iins, udl_ann_par.iins
  • Inner Unique: true
  • Buffers: shared hit=11751184901 read=106348
  • Worker 0: actual time=3302.579..11474737.607 rows=370449832 loops=1
  • Buffers: shared hit=3948789933 read=18801
  • Worker 1: actual time=2176.132..11158376.629 rows=379203644 loops=1
  • Buffers: shared hit=3805263597 read=39967
5. 9,054,023.748 10,107,771.188 ↓ 378,326,744.0 378,326,744 3

Nested Loop (cost=5,115.11..150,186.68 rows=1 width=161) (actual time=2,183.988..10,107,771.188 rows=378,326,744 loops=3)

  • Output: udl_ann_lplv.iudiref, udl_ann_lplv.iins, udl_ann_lplv.lins, udl_ann_lplv.itin, udl_ann_lplv.ipar, udl_ann_lplv.resultat, udl_ann_lplv.unt, udl_ann_lplv.traduction, udl_ann_lplv.iplv, udl_ann_lplv.dplv, udl_ann_lplv.utlcalcul, udl_ann_lplv.annee, ins_amont_lplv.iuge, uge_ins_amont_lplv.luge, plv_anl_par.ipar, psv.dptddass, psv.iins, ins.iins, udl_ann_par.ipar, udl_ann_par.iins
  • Join Filter: ((udl_ann_par.ipar)::text = (plv_anl_par.ipar)::text)
  • Buffers: shared hit=9481224432 read=106348
  • Worker 0: actual time=2175.419..10090013.628 rows=370661428 loops=1
  • Buffers: shared hit=3207467075 read=18801
  • Worker 1: actual time=2176.078..9800727.236 rows=379354713 loops=1
  • Buffers: shared hit=3046554169 read=39967
6. 513,232.867 1,053,747.427 ↓ 685,906,353.0 685,906,353 3

Nested Loop (cost=5,114.53..150,182.21 rows=1 width=168) (actual time=2,157.996..1,053,747.427 rows=685,906,353 loops=3)

  • Output: udl_ann_lplv.iudiref, udl_ann_lplv.iins, udl_ann_lplv.lins, udl_ann_lplv.itin, udl_ann_lplv.ipar, udl_ann_lplv.resultat, udl_ann_lplv.unt, udl_ann_lplv.traduction, udl_ann_lplv.iplv, udl_ann_lplv.dplv, udl_ann_lplv.utlcalcul, udl_ann_lplv.annee, ins_amont_lplv.iuge, uge_ins_amont_lplv.luge, psv.dptddass, psv.iins, plv.iplv, ins.iins, udl_ann_par.ipar, udl_ann_par.iins
  • Buffers: shared hit=1089700278 read=104436
  • Worker 0: actual time=2135.624..870523.408 rows=702208723 loops=1
  • Buffers: shared hit=354280657 read=18714
  • Worker 1: actual time=2145.992..1130590.351 rows=657206397 loops=1
  • Buffers: shared hit=363916516 read=38819
7. 9,548.208 540,514.261 ↓ 1,208,654.0 1,208,654 3

Nested Loop (cost=5,114.10..149,843.59 rows=1 width=170) (actual time=2,156.397..540,514.261 rows=1,208,654 loops=3)

  • Output: udl_ann_lplv.iudiref, udl_ann_lplv.iins, udl_ann_lplv.lins, udl_ann_lplv.itin, udl_ann_lplv.ipar, udl_ann_lplv.resultat, udl_ann_lplv.unt, udl_ann_lplv.traduction, udl_ann_lplv.iplv, udl_ann_lplv.dplv, udl_ann_lplv.utlcalcul, udl_ann_lplv.annee, ins_amont_lplv.iuge, uge_ins_amont_lplv.luge, psv.dptddass, psv.ipsv, psv.iins, ins.iins, udl_ann_par.ipar, udl_ann_par.iins
  • Inner Unique: true
  • Buffers: shared hit=131732344 read=104030
  • Worker 0: actual time=2130.932..361164.582 rows=1089595 loops=1
  • Buffers: shared hit=34546897 read=18664
  • Worker 1: actual time=2145.935..636887.804 rows=1279629 loops=1
  • Buffers: shared hit=53195085 read=38610
8. 12,125.137 530,966.047 ↓ 1,208,654.0 1,208,654 3

Nested Loop (cost=5,113.81..149,835.84 rows=1 width=146) (actual time=2,156.369..530,966.047 rows=1,208,654 loops=3)

  • Output: udl_ann_lplv.iudiref, udl_ann_lplv.iins, udl_ann_lplv.lins, udl_ann_lplv.itin, udl_ann_lplv.ipar, udl_ann_lplv.resultat, udl_ann_lplv.unt, udl_ann_lplv.traduction, udl_ann_lplv.iplv, udl_ann_lplv.dplv, udl_ann_lplv.utlcalcul, udl_ann_lplv.annee, ins_amont_lplv.iuge, psv.dptddass, psv.ipsv, psv.iins, ins.iins, udl_ann_par.ipar, udl_ann_par.iins
  • Inner Unique: true
  • Buffers: shared hit=120854464 read=104025
  • Worker 0: actual time=2130.901..352496.664 rows=1089595 loops=1
  • Buffers: shared hit=31278112 read=18663
  • Worker 1: actual time=2145.905..626915.683 rows=1279629 loops=1
  • Buffers: shared hit=49356200 read=38607
9. 515,173.359 518,840.902 ↓ 1,208,654.0 1,208,654 3

Nested Loop (cost=5,113.39..149,827.95 rows=1 width=138) (actual time=2,156.305..518,840.902 rows=1,208,654 loops=3)

  • Output: udl_ann_lplv.iudiref, udl_ann_lplv.iins, udl_ann_lplv.lins, udl_ann_lplv.itin, udl_ann_lplv.ipar, udl_ann_lplv.resultat, udl_ann_lplv.unt, udl_ann_lplv.traduction, udl_ann_lplv.iplv, udl_ann_lplv.dplv, udl_ann_lplv.utlcalcul, udl_ann_lplv.annee, psv.dptddass, psv.ipsv, psv.iins, ins.iins, udl_ann_par.ipar, udl_ann_par.iins
  • Buffers: shared hit=106348660 read=104011
  • Worker 0: actual time=2130.823..341538.046 rows=1089595 loops=1
  • Buffers: shared hit=26919626 read=18660
  • Worker 1: actual time=2145.849..614228.700 rows=1279629 loops=1
  • Buffers: shared hit=44235882 read=38600
10. 174.699 3,666.282 ↓ 882.5 407,725 3

Merge Join (cost=5,112.82..13,978.04 rows=462 width=61) (actual time=1,753.691..3,666.282 rows=407,725 loops=3)

  • Output: psv.dptddass, psv.ipsv, psv.iins, ins.iins, udl_ann_par.idcalcul, udl_ann_par.ipar, udl_ann_par.iins
  • Inner Unique: true
  • Merge Cond: (udl_ann_par.iins = ins.iins)
  • Buffers: shared hit=42541 read=970
  • Worker 0: actual time=1745.187..2689.396 rows=235521 loops=1
  • Buffers: shared hit=10076 read=186
  • Worker 1: actual time=1745.818..4310.783 rows=617506 loops=1
  • Buffers: shared hit=18969 read=456
11. 204.412 2,461.800 ↓ 250.4 407,725 3

Merge Join (cost=5,083.18..8,111.85 rows=1,628 width=51) (actual time=754.469..2,461.800 rows=407,725 loops=3)

  • Output: psv.dptddass, psv.ipsv, psv.iins, udl_ann_par.idcalcul, udl_ann_par.ipar, udl_ann_par.iins
  • Merge Cond: (udl_ann_par.iins = psv.iins)
  • Buffers: shared hit=40996 read=965
  • Worker 0: actual time=745.533..1598.509 rows=235521 loops=1
  • Buffers: shared hit=9559 read=186
  • Worker 1: actual time=746.771..2965.282 rows=617506 loops=1
  • Buffers: shared hit=18453 read=455
12. 1,537.021 1,537.021 ↓ 1.8 59,380 3

Parallel Index Only Scan using kb_idx_udl_ann_par_dptddass_iins_ipar_idcalcul on public.udl_ann_par (cost=0.56..2,930.40 rows=33,923 width=23) (actual time=104.325..1,537.021 rows=59,380 loops=3)

  • Output: udl_ann_par.dptddass, udl_ann_par.iins, udl_ann_par.ipar, udl_ann_par.idcalcul
  • Index Cond: (udl_ann_par.dptddass = '069'::bpchar)
  • Heap Fetches: 0
  • Buffers: shared hit=40706 read=965
  • Worker 0: actual time=95.888..773.826 rows=37043 loops=1
  • Buffers: shared hit=9462 read=186
  • Worker 1: actual time=96.355..1916.771 rows=81731 loops=1
  • Buffers: shared hit=18356 read=455
13. 76.511 720.367 ↓ 169.7 409,086 3

Sort (cost=5,068.31..5,074.33 rows=2,411 width=28) (actual time=650.135..720.367 rows=409,086 loops=3)

  • Output: psv.dptddass, psv.ipsv, psv.iins
  • Sort Key: psv.iins
  • Sort Method: quicksort Memory: 187kB
  • Buffers: shared hit=290
  • Worker 0: actual time=649.637..696.049 rows=236957 loops=1
  • Buffers: shared hit=97
  • Worker 1: actual time=650.408..750.558 rows=618756 loops=1
  • Buffers: shared hit=97
14. 365.630 643.856 ↑ 1.4 1,772 3

Bitmap Heap Scan on public.psv (cost=47.11..4,932.86 rows=2,411 width=28) (actual time=278.248..643.856 rows=1,772 loops=3)

  • Output: psv.dptddass, psv.ipsv, psv.iins
  • Recheck Cond: (psv.dptddass = '069'::bpchar)
  • Heap Blocks: exact=84
  • Buffers: shared hit=278
  • Worker 0: actual time=278.075..643.367 rows=1772 loops=1
  • Buffers: shared hit=93
  • Worker 1: actual time=278.329..644.111 rows=1772 loops=1
  • Buffers: shared hit=93
15. 278.226 278.226 ↑ 1.4 1,772 3

Bitmap Index Scan on fki_psv (cost=0.00..46.50 rows=2,411 width=0) (actual time=278.226..278.226 rows=1,772 loops=3)

  • Index Cond: (psv.dptddass = '069'::bpchar)
  • Buffers: shared hit=26
  • Worker 0: actual time=278.048..278.048 rows=1772 loops=1
  • Buffers: shared hit=9
  • Worker 1: actual time=278.312..278.312 rows=1772 loops=1
  • Buffers: shared hit=9
16. 1,029.783 1,029.783 ↑ 1.3 133,668 3

Index Only Scan using pk_ins on public.ins (cost=0.42..5,402.78 rows=177,224 width=10) (actual time=18.404..1,029.783 rows=133,668 loops=3)

  • Output: ins.iins
  • Heap Fetches: 0
  • Buffers: shared hit=1545 read=5
  • Worker 0: actual time=18.786..972.182 rows=133652 loops=1
  • Buffers: shared hit=517
  • Worker 1: actual time=18.138..1098.654 rows=133653 loops=1
  • Buffers: shared hit=516 read=1
17. 1.261 1.261 ↓ 3.0 3 1,223,175

Index Scan using pk_udl_ann_lplv on public.udl_ann_lplv (cost=0.57..294.04 rows=1 width=93) (actual time=1.166..1.261 rows=3 loops=1,223,175)

  • Output: udl_ann_lplv.dptddass, udl_ann_lplv.idcalcul, udl_ann_lplv.annee, udl_ann_lplv.debut_periode, udl_ann_lplv.fin_periode, udl_ann_lplv.iins, udl_ann_lplv.type_rapport, udl_ann_lplv.iplv, udl_ann_lplv.utlcalcul, udl_ann_lplv.ipar, udl_ann_lplv.dplv, udl_ann_lplv.itin, udl_ann_lplv.lins, udl_ann_lplv.resultat, udl_ann_lplv.unt, udl_ann_lplv.itye, udl_ann_lplv.iudiref, udl_ann_lplv.traduction, udl_ann_lplv.norme_min, udl_ann_lplv.norme_max
  • Index Cond: ((udl_ann_lplv.idcalcul = udl_ann_par.idcalcul) AND ((udl_ann_lplv.ipar)::text = (udl_ann_par.ipar)::text))
  • Filter: ((udl_ann_lplv.annee = '2018'::numeric) AND ((udl_ann_lplv.type_rapport)::text = 'LOCAL'::text) AND (udl_ann_lplv.utlcalcul = 'O'::bpchar) AND (udl_ann_lplv.dptddass = '069'::bpchar) AND (udl_ann_par.iins = udl_ann_lplv.iudiref))
  • Rows Removed by Filter: 36
  • Buffers: shared hit=106306119 read=103041
  • Worker 0: actual time=1.308..1.435 rows=5 loops=235521
  • Buffers: shared hit=26909550 read=18474
  • Worker 1: actual time=0.915..0.986 rows=2 loops=617506
  • Buffers: shared hit=44216913 read=38144
18. 0.008 0.008 ↑ 1.0 1 3,625,961

Index Scan using kb_idx_ins_iins_dptddass_mpopp_iusd_ieti_lins_mpopd on public.ins ins_amont_lplv (cost=0.42..7.89 rows=1 width=18) (actual time=0.008..0.008 rows=1 loops=3,625,961)

  • Output: ins_amont_lplv.dptddass, ins_amont_lplv.iins, ins_amont_lplv.itin, ins_amont_lplv.iqlc, ins_amont_lplv.iqlbo, ins_amont_lplv.iqlbr, ins_amont_lplv.ipsv, ins_amont_lplv.inae, ins_amont_lplv.ityr, ins_amont_lplv.ivul, ins_amont_lplv.ityc, ins_amont_lplv.iusd, ins_amont_lplv.mpkm, ins_amont_lplv.ncaptant, ins_amont_lplv.brgm, ins_amont_lplv.dauto, ins_amont_lplv.daviscdh, ins_amont_lplv.davisgeo, ins_amont_lplv.ddup, ins_amont_lplv.mdbpt, ins_amont_lplv.mdbmjr, ins_amont_lplv.mdbmrg, ins_amont_lplv.ienv, ins_amont_lplv.mfrcontr, ins_amont_lplv.mfrdecret, ins_amont_lplv.mfrreal, ins_amont_lplv.jtemlib1, ins_amont_lplv.jtemlib2, ins_amont_lplv.nemerg, ins_amont_lplv.lins, ins_amont_lplv.nperim, ins_amont_lplv.nprofond, ins_amont_lplv.respsuivi, ins_amont_lplv.znhydro, ins_amont_lplv.esuhy, ins_amont_lplv.esudbet, ins_amont_lplv.esudbmoy, ins_amont_lplv.esulpuis, ins_amont_lplv.esuptkm, ins_amont_lplv.esurhy, ins_amont_lplv.inap, ins_amont_lplv.iesu, ins_amont_lplv.iuge, ins_amont_lplv.ncap, ins_amont_lplv.icap, ins_amont_lplv.ityt, ins_amont_lplv.dttp, ins_amont_lplv.dyalises, ins_amont_lplv.meau, ins_amont_lplv.sensible, ins_amont_lplv.mpopp, ins_amont_lplv.mpopd, ins_amont_lplv.mpope, ins_amont_lplv.mpoph, ins_amont_lplv.dmodif, ins_amont_lplv.bss, ins_amont_lplv.nappe_un, ins_amont_lplv.dtrecomp, ins_amont_lplv.dtdebusage, ins_amont_lplv.imoa, ins_amont_lplv.dtddepep, ins_amont_lplv.dthypopep, ins_amont_lplv.ipep, ins_amont_lplv.image, ins_amont_lplv.image2, ins_amont_lplv.image3, ins_amont_lplv.ietp, ins_amont_lplv.capprincpep, ins_amont_lplv.ddelibpp, ins_amont_lplv.imass, ins_amont_lplv.dmaj, ins_amont_lplv.esohy, ins_amont_lplv.ieti, ins_amont_lplv.deeti, ins_amont_lplv.popalim, ins_amont_lplv.deuge, ins_amont_lplv.dateqrgeol, ins_amont_lplv.dateabdup, ins_amont_lplv.datfinautaep, ins_amont_lplv.iinsref, ins_amont_lplv.nbtbct, ins_amont_lplv.nbtbctplb, ins_amont_lplv.debct, ins_amont_lplv.sdage, ins_amont_lplv.progmise, ins_amont_lplv.darzonage, ins_amont_lplv.darpav, ins_amont_lplv.darpao, ins_amont_lplv.milfissure, ins_amont_lplv.itya, ins_amont_lplv.iproc, ins_amont_lplv.ipos, ins_amont_lplv.isec, ins_amont_lplv.ihyg, ins_amont_lplv.capprio
  • Index Cond: (ins_amont_lplv.iins = udl_ann_lplv.iins)
  • Buffers: shared hit=14505804 read=14
  • Worker 0: actual time=0.008..0.008 rows=1 loops=1089595
  • Buffers: shared hit=4358486 read=3
  • Worker 1: actual time=0.008..0.008 rows=1 loops=1279629
  • Buffers: shared hit=5120318 read=7
19. 0.006 0.006 ↑ 1.0 1 3,625,961

Index Scan using pk_uge on public.uge uge_ins_amont_lplv (cost=0.29..7.75 rows=1 width=32) (actual time=0.006..0.006 rows=1 loops=3,625,961)

  • Output: uge_ins_amont_lplv.dptddass, uge_ins_amont_lplv.iuge, uge_ins_amont_lplv.imex, uge_ins_amont_lplv.luge, uge_ins_amont_lplv.nabn, uge_ins_amont_lplv.ndist, uge_ins_amont_lplv.nprod, uge_ins_amont_lplv.iorg_mouvr, uge_ins_amont_lplv.iorg_exploit, uge_ins_amont_lplv.isec, uge_ins_amont_lplv.dmodif, uge_ins_amont_lplv.iagence, uge_ins_amont_lplv.deorg_exploit, uge_ins_amont_lplv.deorg_mouvr, uge_ins_amont_lplv.aff_piscine
  • Index Cond: (uge_ins_amont_lplv.iuge = ins_amont_lplv.iuge)
  • Buffers: shared hit=10877880 read=5
  • Worker 0: actual time=0.006..0.006 rows=1 loops=1089595
  • Buffers: shared hit=3268785 read=1
  • Worker 1: actual time=0.006..0.006 rows=1 loops=1279629
  • Buffers: shared hit=3838885 read=3
20. 0.299 0.299 ↓ 4.6 567 3,625,961

Index Scan using ifk_plv_r_psv on public.plv (cost=0.43..337.37 rows=124 width=26) (actual time=0.015..0.299 rows=567 loops=3,625,961)

  • Output: plv.dptddass, plv.iplv, plv.iplr, plv.ityv, plv.imop, plv.itye, plv.mcout, plv.dplv, plv.hplv, plv.icplv, plv.dmaj, plv.localx, plv.rep, plv.stab, plv.stat, plv.trfct, plv.cplt, plv.cnfbact, plv.cnfchim, plv.icty, plv.iorg, plv.edite, plv.ipsv, plv.dmodif, plv.sandre, plv.sandreprod, plv.dttranslabo, plv.anlext, plv.cnfbactref, plv.cnfchimref, plv.refdistrib, plv.information, plv.mxlamb, plv.mylamb, plv.mzlamb, plv.annee
  • Index Cond: (plv.ipsv = psv.ipsv)
  • Buffers: shared hit=957967934 read=406
  • Worker 0: actual time=0.015..0.331 rows=644 loops=1089595
  • Buffers: shared hit=319733760 read=50
  • Worker 1: actual time=0.015..0.274 rows=514 loops=1279629
  • Buffers: shared hit=310721431 read=209
21. 0.013 0.013 ↑ 3.0 1 2,057,719,059

Index Only Scan using ifk_plv_anl_par_r_1 on public.plv_anl_par (cost=0.57..4.44 rows=3 width=17) (actual time=0.013..0.013 rows=1 loops=2,057,719,059)

  • Output: plv_anl_par.iplv, plv_anl_par.ipar
  • Index Cond: ((plv_anl_par.iplv = plv.iplv) AND (plv_anl_par.ipar = (udl_ann_lplv.ipar)::text))
  • Heap Fetches: 0
  • Buffers: shared hit=8391524154 read=1912
  • Worker 0: actual time=0.013..0.013 rows=1 loops=702208723
  • Buffers: shared hit=2853186418 read=87
  • Worker 1: actual time=0.013..0.013 rows=1 loops=657206397
  • Buffers: shared hit=2682637653 read=1148
22. 0.003 0.003 ↑ 1.0 1 1,134,980,232

Index Only Scan using kb_idx_par_ipar_ifap on public.par (cost=0.28..3.98 rows=1 width=6) (actual time=0.003..0.003 rows=1 loops=1,134,980,232)

  • Output: par.ipar, par.ifap
  • Index Cond: (par.ipar = (plv_anl_par.ipar)::text)
  • Filter: (par.ifap <> ALL ('{MT,AM,AR,CR,PD,NA,OC,OP,PT,ST,PS,TR,TZ,TC,US}'::bpchar[]))
  • Rows Removed by Filter: 0
  • Heap Fetches: 0
  • Buffers: shared hit=2269960469
  • Worker 0: actual time=0.003..0.003 rows=1 loops=370661428
  • Buffers: shared hit=741322858
  • Worker 1: actual time=0.003..0.003 rows=1 loops=379354713
  • Buffers: shared hit=758709428
23. 0.009 0.009 ↑ 1.0 1 1,134,418,246

Seq Scan on public.dpt dpt_adm (cost=0.00..3.29 rows=1 width=4) (actual time=0.009..0.009 rows=1 loops=1,134,418,246)

  • Output: dpt_adm.dptddass, dpt_adm.idpt, dpt_adm.ldpt, dpt_adm.ireg, dpt_adm.dmodif, dpt_adm.siret, dpt_adm.san_idpt, dpt_adm.cdnuts, dpt_adm.statut
  • Filter: (dpt_adm.idpt = '069'::bpchar)
  • Rows Removed by Filter: 102
  • Buffers: shared hit=2268836492
  • Worker 0: actual time=0.009..0.009 rows=1 loops=370449832
  • Buffers: shared hit=740899664
  • Worker 1: actual time=0.009..0.009 rows=1 loops=379203644
  • Buffers: shared hit=758407288
24. 0.001 0.026 ↑ 1.0 1 1,134,418,246

Nested Loop (cost=0.84..38.78 rows=1 width=20) (actual time=0.026..0.026 rows=1 loops=1,134,418,246)

  • Output: ins_1.iins, psv_1.iins
  • Buffers: shared hit=11344521670 read=15
  • Worker 0: actual time=0.026..0.026 rows=1 loops=370449832
  • Buffers: shared hit=3704507819 read=1
  • Worker 1: actual time=0.026..0.026 rows=1 loops=379203644
  • Buffers: shared hit=3792349622 read=4
25. 0.000 0.016 ↑ 1.0 1 1,134,418,246

Nested Loop (cost=0.84..35.48 rows=1 width=24) (actual time=0.016..0.016 rows=1 loops=1,134,418,246)

  • Output: ins_1.iins, psv_1.dptddass, psv_1.iins
  • Buffers: shared hit=9075685178 read=15
  • Worker 0: actual time=0.016..0.016 rows=1 loops=370449832
  • Buffers: shared hit=2963608155 read=1
  • Worker 1: actual time=0.016..0.016 rows=1 loops=379203644
  • Buffers: shared hit=3033942334 read=4
26. 0.008 0.008 ↑ 1.0 1 1,134,418,246

Index Scan using kb_idx_ins_iins_dptddass_mpopp_iusd_ieti_lins_mpopd on public.ins ins_1 (cost=0.42..7.90 rows=1 width=10) (actual time=0.008..0.008 rows=1 loops=1,134,418,246)

  • Output: ins_1.dptddass, ins_1.iins, ins_1.itin, ins_1.iqlc, ins_1.iqlbo, ins_1.iqlbr, ins_1.ipsv, ins_1.inae, ins_1.ityr, ins_1.ivul, ins_1.ityc, ins_1.iusd, ins_1.mpkm, ins_1.ncaptant, ins_1.brgm, ins_1.dauto, ins_1.daviscdh, ins_1.davisgeo, ins_1.ddup, ins_1.mdbpt, ins_1.mdbmjr, ins_1.mdbmrg, ins_1.ienv, ins_1.mfrcontr, ins_1.mfrdecret, ins_1.mfrreal, ins_1.jtemlib1, ins_1.jtemlib2, ins_1.nemerg, ins_1.lins, ins_1.nperim, ins_1.nprofond, ins_1.respsuivi, ins_1.znhydro, ins_1.esuhy, ins_1.esudbet, ins_1.esudbmoy, ins_1.esulpuis, ins_1.esuptkm, ins_1.esurhy, ins_1.inap, ins_1.iesu, ins_1.iuge, ins_1.ncap, ins_1.icap, ins_1.ityt, ins_1.dttp, ins_1.dyalises, ins_1.meau, ins_1.sensible, ins_1.mpopp, ins_1.mpopd, ins_1.mpope, ins_1.mpoph, ins_1.dmodif, ins_1.bss, ins_1.nappe_un, ins_1.dtrecomp, ins_1.dtdebusage, ins_1.imoa, ins_1.dtddepep, ins_1.dthypopep, ins_1.ipep, ins_1.image, ins_1.image2, ins_1.image3, ins_1.ietp, ins_1.capprincpep, ins_1.ddelibpp, ins_1.imass, ins_1.dmaj, ins_1.esohy, ins_1.ieti, ins_1.deeti, ins_1.popalim, ins_1.deuge, ins_1.dateqrgeol, ins_1.dateabdup, ins_1.datfinautaep, ins_1.iinsref, ins_1.nbtbct, ins_1.nbtbctplb, ins_1.debct, ins_1.sdage, ins_1.progmise, ins_1.darzonage, ins_1.darpav, ins_1.darpao, ins_1.milfissure, ins_1.itya, ins_1.iproc, ins_1.ipos, ins_1.isec, ins_1.ihyg, ins_1.capprio
  • Index Cond: ((ins_1.iins = udl_ann_par.iins) AND (ins_1.ieti = 'ACT'::bpchar))
  • Filter: ((ins_1.iusd = ANY ('{AEP,PRV}'::bpchar[])) AND (ins_1.itin = 'UDI'::bpchar))
  • Buffers: shared hit=4537991134 read=10
  • Worker 0: actual time=0.008..0.008 rows=1 loops=370449832
  • Buffers: shared hit=1481808826 read=1
  • Worker 1: actual time=0.008..0.008 rows=1 loops=379203644
  • Buffers: shared hit=1517118116 read=2
27. 0.008 0.008 ↑ 1.0 1 1,134,418,246

Index Scan using ifk_psv_r_ins on public.psv psv_1 (cost=0.42..27.58 rows=1 width=14) (actual time=0.008..0.008 rows=1 loops=1,134,418,246)

  • Output: psv_1.dptddass, psv_1.ipsv, psv_1.itye, psv_1.local, psv_1.lpsv, psv_1.mxlamb, psv_1.mylamb, psv_1.mzlamb, psv_1.icom, psv_1.idpt, psv_1.primsec, psv_1.iins, psv_1.itin, psv_1.psvnat, psv_1.dmodif, psv_1.sandregest, psv_1.irq_stk, psv_1.gendis, psv_1.touv, psv_1.ipos, psv_1.rep, psv_1.descriptif
  • Index Cond: (psv_1.iins = ins_1.iins)
  • Filter: (psv_1.dptddass = '069'::bpchar)
  • Buffers: shared hit=4537694044 read=5
  • Worker 0: actual time=0.008..0.008 rows=1 loops=370449832
  • Buffers: shared hit=1481799329
  • Worker 1: actual time=0.008..0.008 rows=1 loops=379203644
  • Buffers: shared hit=1516824218 read=2
28. 0.009 0.009 ↑ 1.0 1 1,134,418,246

Seq Scan on public.dpt dpt_adm_1 (cost=0.00..3.29 rows=1 width=4) (actual time=0.009..0.009 rows=1 loops=1,134,418,246)

  • Output: dpt_adm_1.dptddass, dpt_adm_1.idpt, dpt_adm_1.ldpt, dpt_adm_1.ireg, dpt_adm_1.dmodif, dpt_adm_1.siret, dpt_adm_1.san_idpt, dpt_adm_1.cdnuts, dpt_adm_1.statut
  • Filter: (dpt_adm_1.idpt = '069'::bpchar)
  • Rows Removed by Filter: 100
  • Buffers: shared hit=2268836492
  • Worker 0: actual time=0.009..0.009 rows=1 loops=370449832
  • Buffers: shared hit=740899664
  • Worker 1: actual time=0.009..0.009 rows=1 loops=379203644
  • Buffers: shared hit=758407288
Planning time : 1,286.881 ms
Execution time : 26,905,304.204 ms