explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kHYj

Settings
# exclusive inclusive rows x rows loops node
1. 2,401.722 68,801.755 ↓ 2,111,917.0 2,111,917 1

Gather (cost=304,270.57..327,109.56 rows=1 width=137) (actual time=11,863.017..68,801.755 rows=2,111,917 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=46359233 read=14119, temp read=15322 written=4182
2. 16,005.041 66,400.033 ↓ 703,972.0 703,972 3

Nested Loop Semi Join (cost=303,270.57..326,109.46 rows=1 width=137) (actual time=10,332.803..66,400.033 rows=703,972 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=46359233 read=14119, temp read=15322 written=4182
  • Worker 0: actual time=9965.617..66516.368 rows=708963 loops=1
  • Buffers: shared hit=15638604 read=4883, temp read=4893 written=1394
  • Worker 1: actual time=9171.472..64678.598 rows=716659 loops=1
  • Buffers: shared hit=15587345 read=4418, temp read=4655 written=1394
3. 5,603.588 50,394.970 ↓ 706,367.0 706,367 3

Nested Loop (cost=303,269.72..326,094.08 rows=1 width=147) (actual time=10,332.637..50,394.970 rows=706,367 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
  • Inner Unique: true
  • Buffers: shared hit=29415688 read=14119, temp read=15322 written=4182
  • Worker 0: actual time=9965.549..50557.403 rows=711841 loops=1
  • Buffers: shared hit=9949664 read=4883, temp read=4893 written=1394
  • Worker 1: actual time=9171.393..48407.923 rows=718988 loops=1
  • Buffers: shared hit=9836308 read=4418, temp read=4655 written=1394
4. 26,712.779 44,791.375 ↓ 706,367.0 706,367 3

Nested Loop (cost=303,269.30..326,089.92 rows=1 width=137) (actual time=10,332.618..44,791.375 rows=706,367 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, udl_ann_par.iins
  • Join Filter: ((par.ipar)::text = (plv_anl_par.ipar)::text)
  • Buffers: shared hit=23049044 read=14118, temp read=15322 written=4182
  • Worker 0: actual time=9965.530..44973.792 rows=711841 loops=1
  • Buffers: shared hit=7811339 read=4882, temp read=4893 written=1394
  • Worker 1: actual time=9171.370..42711.473 rows=718988 loops=1
  • Buffers: shared hit=7676051 read=4418, temp read=4655 written=1394
5. 4,710.656 18,078.574 ↓ 1,195,683.0 1,195,683 3

Nested Loop (cost=303,268.73..326,085.52 rows=1 width=160) (actual time=8,736.786..18,078.574 rows=1,195,683 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, par.ipar, psv.iins, plv.iplv, udl_ann_par.ipar, udl_ann_par.iins
  • Buffers: shared hit=8397908 read=8301, temp read=15322 written=4182
  • Worker 0: actual time=8728.753..18146.657 rows=1214927 loops=1
  • Buffers: shared hit=2848653 read=3124, temp read=4893 written=1394
  • Worker 1: actual time=8728.421..17755.640 rows=1193920 loops=1
  • Buffers: shared hit=2797983 read=2578, temp read=4655 written=1394
6. 1,522.597 13,367.888 ↓ 146,542.0 146,542 3

Nested Loop (cost=303,268.30..325,747.59 rows=1 width=162) (actual time=8,717.096..13,367.888 rows=146,542 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, par.ipar, psv.ipsv, psv.iins, udl_ann_par.ipar, udl_ann_par.iins
  • Buffers: shared hit=3801855 read=6324, temp read=15322 written=4182
  • Worker 0: actual time=8709.069..13426.960 rows=149148 loops=1
  • Buffers: shared hit=1291173 read=2544, temp read=4893 written=1394
  • Worker 1: actual time=8708.732..13278.288 rows=146626 loops=1
  • Buffers: shared hit=1267177 read=1981, temp read=4655 written=1394
7. 1,016.117 11,845.282 ↓ 146,542.0 146,542 3

Nested Loop (cost=303,268.30..325,744.29 rows=1 width=166) (actual time=8,717.071..11,845.282 rows=146,542 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, par.ipar, psv.dptddass, psv.ipsv, psv.iins, udl_ann_par.ipar, udl_ann_par.iins
  • Inner Unique: true
  • Buffers: shared hit=2922605 read=6324, temp read=15322 written=4182
  • Worker 0: actual time=8709.048..11887.681 rows=149148 loops=1
  • Buffers: shared hit=992877 read=2544, temp read=4893 written=1394
  • Worker 1: actual time=8708.709..11756.815 rows=146626 loops=1
  • Buffers: shared hit=973925 read=1981, temp read=4655 written=1394
8. 1,233.204 10,829.159 ↓ 146,542.0 146,542 3

Nested Loop (cost=303,267.88..325,740.14 rows=1 width=142) (actual time=8,686.517..10,829.159 rows=146,542 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, par.ipar, psv.dptddass, psv.ipsv, psv.iins, udl_ann_par.ipar, udl_ann_par.iins
  • Inner Unique: true
  • Buffers: shared hit=1597330 read=6320, temp read=15322 written=4182
  • Worker 0: actual time=8678.479..10851.820 rows=149148 loops=1
  • Buffers: shared hit=543371 read=2543, temp read=4893 written=1394
  • Worker 1: actual time=8678.149..10742.064 rows=146626 loops=1
  • Buffers: shared hit=531817 read=1980, temp read=4655 written=1394
9. 315.785 9,595.947 ↓ 146,542.0 146,542 3

Merge Join (cost=303,267.46..325,735.98 rows=1 width=134) (actual time=8,654.076..9,595.947 rows=146,542 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, par.ipar, psv.dptddass, psv.ipsv, psv.iins, udl_ann_par.ipar, udl_ann_par.iins
  • Merge Cond: ((udl_ann_par.iins = udl_ann_lplv.iudiref) AND ((udl_ann_par.ipar)::text = (par.ipar)::text) AND (udl_ann_par.idcalcul = udl_ann_lplv.idcalcul))
  • Buffers: shared hit=277962 read=6302, temp read=15322 written=4182
  • Worker 0: actual time=8646.225..9614.493 rows=149148 loops=1
  • Buffers: shared hit=95738 read=2535, temp read=4893 written=1394
  • Worker 1: actual time=8645.689..9515.341 rows=146626 loops=1
  • Buffers: shared hit=91801 read=1978, temp read=4655 written=1394
10. 345.485 641.130 ↓ 51.1 1,854,313 3

Merge Join (cost=102.17..22,165.06 rows=36,299 width=51) (actual time=57.553..641.130 rows=1,854,313 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=272700 read=3800
  • Worker 0: actual time=51.767..659.214 rows=1909180 loops=1
  • Buffers: shared hit=94375 read=1295
  • Worker 1: actual time=53.308..575.128 rows=1760775 loops=1
  • Buffers: shared hit=89923 read=1253
11. 200.552 200.552 ↑ 1.2 207,110 3

Parallel Index Only Scan using kb_idx_udl_ann_par_dptddass_iins_ipar_idcalcul on public.udl_ann_par (cost=0.56..20,699.30 rows=239,955 width=23) (actual time=50.279..200.552 rows=207,110 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 = '048'::bpchar)
  • Heap Fetches: 0
  • Buffers: shared hit=272598 read=3753
  • Worker 0: actual time=51.685..222.469 rows=212352 loops=1
  • Buffers: shared hit=94338 read=1282
  • Worker 1: actual time=53.198..167.095 rows=205971 loops=1
  • Buffers: shared hit=89885 read=1241
12. 85.734 95.093 ↓ 244.5 1,858,046 3

Materialize (cost=0.42..340.38 rows=7,598 width=28) (actual time=6.694..95.093 rows=1,858,046 loops=3)

  • Output: psv.dptddass, psv.iins, psv.ipsv
  • Buffers: shared hit=102 read=47
  • Worker 0: actual time=0.060..89.126 rows=1912965 loops=1
  • Buffers: shared hit=37 read=13
  • Worker 1: actual time=0.089..83.001 rows=1764490 loops=1
  • Buffers: shared hit=38 read=12
13. 9.359 9.359 ↑ 1.0 7,402 3

Index Only Scan using kb_idx_psv_dptddass_iins_ipsv on public.psv (cost=0.42..321.39 rows=7,598 width=28) (actual time=6.688..9.359 rows=7,402 loops=3)

  • Output: psv.dptddass, psv.iins, psv.ipsv
  • Index Cond: (psv.dptddass = '048'::bpchar)
  • Heap Fetches: 0
  • Buffers: shared hit=102 read=47
  • Worker 0: actual time=0.055..1.987 rows=7422 loops=1
  • Buffers: shared hit=37 read=13
  • Worker 1: actual time=0.083..2.133 rows=7403 loops=1
  • Buffers: shared hit=38 read=12
14. 430.443 8,639.032 ↓ 7.5 179,483 3

Sort (cost=303,059.46..303,119.36 rows=23,960 width=99) (actual time=8,589.583..8,639.032 rows=179,483 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, udl_ann_lplv.idcalcul, par.ipar
  • Sort Key: udl_ann_lplv.iudiref, udl_ann_lplv.ipar, udl_ann_lplv.idcalcul
  • Sort Method: external sort Disk: 5576kB
  • Buffers: shared hit=5262 read=2502, temp read=9750 written=4182
  • Worker 0: actual time=8586.504..8634.518 rows=181865 loops=1
  • Buffers: shared hit=1363 read=1240, temp read=3143 written=1394
  • Worker 1: actual time=8586.538..8636.965 rows=179532 loops=1
  • Buffers: shared hit=1878 read=725, temp read=3024 written=1394
15. 23.518 8,208.589 ↓ 2.1 49,485 3

Hash Join (cost=2,424.42..301,316.56 rows=23,960 width=99) (actual time=135.605..8,208.589 rows=49,485 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, udl_ann_lplv.idcalcul, par.ipar
  • Inner Unique: true
  • Hash Cond: ((udl_ann_lplv.ipar)::text = (par.ipar)::text)
  • Buffers: shared hit=5223 read=2502
  • Worker 0: actual time=131.408..8210.142 rows=49485 loops=1
  • Buffers: shared hit=1350 read=1240
  • Worker 1: actual time=131.278..8217.736 rows=49485 loops=1
  • Buffers: shared hit=1865 read=725
16. 8,049.847 8,179.656 ↓ 1.9 64,969 3

Bitmap Heap Scan on public.udl_ann_lplv (cost=2,278.46..301,080.24 rows=34,373 width=93) (actual time=130.079..8,179.656 rows=64,969 loops=3)

  • 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
  • Recheck Cond: ((udl_ann_lplv.dptddass = '048'::bpchar) AND (udl_ann_lplv.annee = '2018'::numeric))
  • Filter: (((udl_ann_lplv.type_rapport)::text = 'LOCAL'::text) AND (udl_ann_lplv.utlcalcul = 'O'::bpchar))
  • Rows Removed by Filter: 9450
  • Heap Blocks: exact=2204
  • Buffers: shared hit=5026 read=2455
  • Worker 0: actual time=129.340..8184.958 rows=64969 loops=1
  • Buffers: shared hit=1267 read=1227
  • Worker 1: actual time=129.434..8193.174 rows=64969 loops=1
  • Buffers: shared hit=1769 read=725
17. 129.809 129.809 ↑ 1.2 74,419 3

Bitmap Index Scan on kb_idx_udl_ann_lplv_dptddass_annee (cost=0.00..2,269.87 rows=89,330 width=0) (actual time=129.808..129.809 rows=74,419 loops=3)

  • Index Cond: ((udl_ann_lplv.dptddass = '048'::bpchar) AND (udl_ann_lplv.annee = '2018'::numeric))
  • Buffers: shared hit=581 read=288
  • Worker 0: actual time=129.066..129.066 rows=74419 loops=1
  • Buffers: shared hit=2 read=288
  • Worker 1: actual time=129.166..129.166 rows=74419 loops=1
  • Buffers: shared hit=290
18. 0.357 5.415 ↑ 1.0 1,804 3

Hash (cost=123.41..123.41 rows=1,804 width=6) (actual time=5.415..5.415 rows=1,804 loops=3)

  • Output: par.ipar
  • Buckets: 2048 Batches: 1 Memory Usage: 86kB
  • Buffers: shared hit=100 read=47
  • Worker 0: actual time=1.915..1.915 rows=1804 loops=1
  • Buffers: shared hit=36 read=13
  • Worker 1: actual time=1.705..1.705 rows=1804 loops=1
  • Buffers: shared hit=49
19. 5.058 5.058 ↑ 1.0 1,804 3

Seq Scan on public.par (cost=0.00..123.41 rows=1,804 width=6) (actual time=1.093..5.058 rows=1,804 loops=3)

  • Output: par.ipar
  • Filter: (par.ifap <> ALL ('{MT,AM,AR,CR,PD,NA,OC,OP,PT,ST,PS,TR,TZ,TC,US}'::bpchar[]))
  • Rows Removed by Filter: 784
  • Buffers: shared hit=100 read=47
  • Worker 0: actual time=0.024..1.567 rows=1804 loops=1
  • Buffers: shared hit=36 read=13
  • Worker 1: actual time=0.023..1.343 rows=1804 loops=1
  • Buffers: shared hit=49
20. 0.008 0.008 ↑ 1.0 1 439,625

Index Only Scan using kb_idx_ins_iins_iuge on public.ins ins_amont_lplv (cost=0.42..4.16 rows=1 width=18) (actual time=0.008..0.008 rows=1 loops=439,625)

  • Output: ins_amont_lplv.iins, ins_amont_lplv.iuge
  • Index Cond: (ins_amont_lplv.iins = udl_ann_lplv.iins)
  • Heap Fetches: 0
  • Buffers: shared hit=1319368 read=18
  • Worker 0: actual time=0.008..0.008 rows=1 loops=149148
  • Buffers: shared hit=447633 read=8
  • Worker 1: actual time=0.008..0.008 rows=1 loops=146626
  • Buffers: shared hit=440016 read=2
21. 0.006 0.006 ↑ 1.0 1 439,625

Index Only Scan using kb_idx_uge_iuge_luge on public.uge uge_ins_amont_lplv (cost=0.41..4.15 rows=1 width=32) (actual time=0.006..0.006 rows=1 loops=439,625)

  • Output: uge_ins_amont_lplv.iuge, uge_ins_amont_lplv.luge
  • Index Cond: (uge_ins_amont_lplv.iuge = ins_amont_lplv.iuge)
  • Heap Fetches: 0
  • Buffers: shared hit=1325275 read=4
  • Worker 0: actual time=0.006..0.006 rows=1 loops=149148
  • Buffers: shared hit=449506 read=1
  • Worker 1: actual time=0.006..0.006 rows=1 loops=146626
  • Buffers: shared hit=442108 read=1
22. 0.009 0.009 ↑ 1.0 1 439,625

Seq Scan on public.dpt dpt_adm (cost=0.00..3.29 rows=1 width=4) (actual time=0.004..0.009 rows=1 loops=439,625)

  • 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 = '048'::bpchar)
  • Rows Removed by Filter: 102
  • Buffers: shared hit=879250
  • Worker 0: actual time=0.004..0.009 rows=1 loops=149148
  • Buffers: shared hit=298296
  • Worker 1: actual time=0.004..0.009 rows=1 loops=146626
  • Buffers: shared hit=293252
23. 0.030 0.030 ↑ 15.5 8 439,625

Index Scan using ifk_plv_r_psv on public.plv (cost=0.43..336.69 rows=124 width=26) (actual time=0.013..0.030 rows=8 loops=439,625)

  • 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=4596053 read=1977
  • Worker 0: actual time=0.013..0.029 rows=8 loops=149148
  • Buffers: shared hit=1557480 read=580
  • Worker 1: actual time=0.013..0.028 rows=8 loops=146626
  • Buffers: shared hit=1530806 read=597
24. 0.022 0.022 ↑ 1.0 1 3,587,049

Index Only Scan using kb_idx_plv_anl_par_dptddass_iplv_ipar on public.plv_anl_par (cost=0.57..4.38 rows=1 width=17) (actual time=0.021..0.022 rows=1 loops=3,587,049)

  • Output: plv_anl_par.dptddass, plv_anl_par.iplv, plv_anl_par.ipar
  • Index Cond: ((plv_anl_par.dptddass = '048'::bpchar) AND (plv_anl_par.iplv = plv.iplv) AND (plv_anl_par.ipar = (udl_ann_par.ipar)::text))
  • Heap Fetches: 0
  • Buffers: shared hit=14651136 read=5817
  • Worker 0: actual time=0.021..0.022 rows=1 loops=1214927
  • Buffers: shared hit=4962686 read=1758
  • Worker 1: actual time=0.020..0.020 rows=1 loops=1193920
  • Buffers: shared hit=4878068 read=1840
25. 0.007 0.007 ↑ 1.0 1 2,119,100

Index Only Scan using kb_idx_ins_iins_iuge on public.ins (cost=0.42..4.16 rows=1 width=10) (actual time=0.007..0.007 rows=1 loops=2,119,100)

  • Output: ins.iins, ins.iuge
  • Index Cond: (ins.iins = udl_ann_par.iins)
  • Heap Fetches: 0
  • Buffers: shared hit=6366644 read=1
  • Worker 0: actual time=0.007..0.007 rows=1 loops=711841
  • Buffers: shared hit=2138325 read=1
  • Worker 1: actual time=0.007..0.007 rows=1 loops=718988
  • Buffers: shared hit=2160257
26. 0.001 0.022 ↑ 1.0 1 2,119,100

Nested Loop (cost=0.84..15.37 rows=1 width=20) (actual time=0.022..0.022 rows=1 loops=2,119,100)

  • Output: ins_1.iins, psv_1.iins
  • Buffers: shared hit=16943545
  • Worker 0: actual time=0.022..0.022 rows=1 loops=711841
  • Buffers: shared hit=5688940
  • Worker 1: actual time=0.022..0.022 rows=1 loops=718988
  • Buffers: shared hit=5751037
27. 0.000 0.017 ↑ 1.0 1 2,119,100

Nested Loop (cost=0.84..12.07 rows=1 width=24) (actual time=0.017..0.017 rows=1 loops=2,119,100)

  • Output: ins_1.iins, psv_1.dptddass, psv_1.iins
  • Buffers: shared hit=14831628
  • Worker 0: actual time=0.017..0.017 rows=1 loops=711841
  • Buffers: shared hit=4979977
  • Worker 1: actual time=0.017..0.017 rows=1 loops=718988
  • Buffers: shared hit=5034378
28. 0.008 0.008 ↑ 1.0 1 2,119,100

Index Scan using kb_idx_ins_iins_iuge on public.ins ins_1 (cost=0.42..7.89 rows=1 width=10) (actual time=0.008..0.008 rows=1 loops=2,119,100)

  • 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)
  • Filter: ((ins_1.iusd = ANY ('{AEP,PRV}'::bpchar[])) AND (ins_1.itin = 'UDI'::bpchar) AND (ins_1.ieti = 'ACT'::bpchar))
  • Rows Removed by Filter: 0
  • Buffers: shared hit=8485742
  • Worker 0: actual time=0.008..0.008 rows=1 loops=711841
  • Buffers: shared hit=2850166
  • Worker 1: actual time=0.008..0.008 rows=1 loops=718988
  • Buffers: shared hit=2879244
29. 0.009 0.009 ↑ 1.0 1 2,111,917

Index Only Scan using kb_idx_psv_dptddass_iins_ipsv on public.psv psv_1 (cost=0.42..4.17 rows=1 width=14) (actual time=0.009..0.009 rows=1 loops=2,111,917)

  • Output: psv_1.dptddass, psv_1.iins, psv_1.ipsv
  • Index Cond: ((psv_1.dptddass = '048'::bpchar) AND (psv_1.iins = ins_1.iins))
  • Heap Fetches: 0
  • Buffers: shared hit=6345886
  • Worker 0: actual time=0.008..0.008 rows=1 loops=708963
  • Buffers: shared hit=2129811
  • Worker 1: actual time=0.009..0.009 rows=1 loops=716659
  • Buffers: shared hit=2155134
30. 0.004 0.004 ↑ 1.0 1 2,111,917

Seq Scan on public.dpt dpt_adm_1 (cost=0.00..3.29 rows=1 width=4) (actual time=0.004..0.004 rows=1 loops=2,111,917)

  • 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 = '048'::bpchar)
  • Rows Removed by Filter: 40
  • Buffers: shared hit=2111917
  • Worker 0: actual time=0.004..0.004 rows=1 loops=708963
  • Buffers: shared hit=708963
  • Worker 1: actual time=0.004..0.004 rows=1 loops=716659
  • Buffers: shared hit=716659
Planning time : 250.294 ms
Execution time : 68,913.799 ms