explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Os7S

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 2.692 166,450.910 ↓ 16.0 32 1

GroupAggregate (cost=7,671,985.62..7,671,985.67 rows=2 width=68) (actual time=166,448.244..166,450.910 rows=32 loops=1)

  • Group Key: consumption_computed.delivery_date
2. 0.344 166,448.218 ↓ 767.0 1,534 1

Sort (cost=7,671,985.62..7,671,985.63 rows=2 width=68) (actual time=166,448.115..166,448.218 rows=1,534 loops=1)

  • Sort Key: consumption_computed.delivery_date
  • Sort Method: quicksort Memory: 173kB
3. 13.009 166,447.874 ↓ 767.0 1,534 1

GroupAggregate (cost=7,671,985.55..7,671,985.59 rows=2 width=68) (actual time=166,429.329..166,447.874 rows=1,534 loops=1)

  • Group Key: consumption_computed.horodatage, consumption_computed.delivery_date
4. 440.996 166,434.865 ↓ 23,614.0 47,228 1

Sort (cost=7,671,985.55..7,671,985.55 rows=2 width=68) (actual time=166,429.302..166,434.865 rows=47,228 loops=1)

  • Sort Key: consumption_computed.horodatage, consumption_computed.delivery_date
  • Sort Method: external sort Disk: 2416kB
5. 6.346 165,993.869 ↓ 23,614.0 47,228 1

Subquery Scan on consumption_computed (cost=7,644,464.12..7,671,985.54 rows=2 width=68) (actual time=151,277.350..165,993.869 rows=47,228 loops=1)

6. 10,330.522 165,987.523 ↓ 23,614.0 47,228 1

Nested Loop (cost=7,644,464.12..7,671,985.52 rows=2 width=100) (actual time=151,277.349..165,987.523 rows=47,228 loops=1)

  • Join Filter: (((c.class_code)::text = (uf_aggr.class_code)::text) AND (c.delivery_date = uf_aggr.delivery_date))
  • Rows Removed by Join Filter: 115858692
7. 206.870 2,081.657 ↓ 1.2 111,448 1

GroupAggregate (cost=183,774.99..208,708.85 rows=94,091 width=64) (actual time=1,712.454..2,081.657 rows=111,448 loops=1)

  • Group Key: ((data.value ->> ''horodatage''::text)), c.delivery_date, c.class_code
8. 1,483.737 1,874.787 ↑ 8.4 111,448 1

Sort (cost=183,774.99..186,127.24 rows=940,900 width=64) (actual time=1,712.406..1,874.787 rows=111,448 loops=1)

  • Sort Key: ((data.value ->> ''horodatage''::text)), c.delivery_date, c.class_code
  • Sort Method: external merge Disk: 15960kB
9. 103.961 391.050 ↑ 8.4 111,448 1

Nested Loop (cost=0.01..55,042.39 rows=940,900 width=64) (actual time=0.277..391.050 rows=111,448 loops=1)

10. 191.805 191.805 ↑ 4.0 2,324 1

Seq Scan on coefficients_class c (cost=0.00..33,872.13 rows=9,409 width=1,273) (actual time=0.080..191.805 rows=2,324 loops=1)

  • Filter: (((status)::text = ''ACTIF''::text) AND (delivery_date >= to_date(''01/01/2018''::text, ''DD/MM/YYYY''::text)) AND (delivery_date < to_date(''30/04/2019''::text, ''DD/MM/YYYY''::text)))
  • Rows Removed by Filter: 167420
11. 95.284 95.284 ↑ 2.1 48 2,324

Function Scan on json_array_elements data (cost=0.01..1.01 rows=100 width=32) (actual time=0.037..0.041 rows=48 loops=2,324)

12. 4,010.518 153,575.344 ↓ 1,040.0 1,040 111,448

Materialize (cost=7,460,689.13..7,460,689.16 rows=1 width=64) (actual time=1.342..1.378 rows=1,040 loops=111,448)

13. 0.073 149,564.826 ↓ 1,040.0 1,040 1

Subquery Scan on uf_aggr (cost=7,460,689.13..7,460,689.16 rows=1 width=64) (actual time=149,564.329..149,564.826 rows=1,040 loops=1)

14. 30.868 149,564.753 ↓ 1,040.0 1,040 1

HashAggregate (cost=7,460,689.13..7,460,689.15 rows=1 width=46) (actual time=149,564.327..149,564.753 rows=1,040 loops=1)

  • Group Key: uf_attr.class_code, uf_attr.class_id, c_1.delivery_date
15. 12.953 149,533.885 ↓ 12,714.0 12,714 1

Nested Loop Semi Join (cost=34,065.82..7,460,689.12 rows=1 width=46) (actual time=207.569..149,533.885 rows=12,714 loops=1)

16. 72.119 113,705.594 ↓ 12,714.0 12,714 1

Hash Join (cost=34,065.54..7,460,426.05 rows=1 width=61) (actual time=203.997..113,705.594 rows=12,714 loops=1)

  • Hash Cond: ((c_1.class_code)::text = (uf_attr.class_code)::text)
  • Join Filter: ((uf_attr.begin_date <= c_1.delivery_date) AND (uf_attr.end_date >= c_1.delivery_date) AND ((SubPlan 1) = uf_attr.creation_date))
  • Rows Removed by Join Filter: 43030
17. 3.918 200.305 ↓ 2.6 2,432 1

HashAggregate (cost=33,919.17..33,928.58 rows=941 width=32) (actual time=197.482..200.305 rows=2,432 loops=1)

  • Group Key: c_1.class_code, c_1.delivery_date
18. 196.387 196.387 ↑ 3.9 2,432 1

Seq Scan on coefficients_class c_1 (cost=0.00..33,872.13 rows=9,409 width=32) (actual time=0.333..196.387 rows=2,432 loops=1)

  • Filter: (((status)::text = ''ACTIF''::text) AND (delivery_date >= to_date(''01/01/2018''::text, ''DD/MM/YYYY''::text)) AND (delivery_date <= to_date(''30/04/2019''::text, ''DD/MM/YYYY''::text)))
  • Rows Removed by Filter: 167312
19. 1.047 1.922 ↑ 1.0 3,661 1

Hash (cost=100.61..100.61 rows=3,661 width=73) (actual time=1.922..1.922 rows=3,661 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 430kB
20. 0.875 0.875 ↑ 1.0 3,661 1

Seq Scan on uf_attr (cost=0.00..100.61 rows=3,661 width=73) (actual time=0.008..0.875 rows=3,661 loops=1)

21.          

SubPlan (forHash Join)

22. 43.344 113,431.248 ↑ 1.0 1 21,672

Aggregate (cost=431.09..431.10 rows=1 width=8) (actual time=5.234..5.234 rows=1 loops=21,672)

23. 42,208.800 113,387.904 ↓ 2.0 2 21,672

Nested Loop Semi Join (cost=0.28..431.08 rows=1 width=8) (actual time=2.944..5.232 rows=2 loops=21,672)

24. 9,492.336 9,492.336 ↓ 2.0 2 21,672

Seq Scan on uf_attr uf (cost=0.00..128.07 rows=1 width=23) (actual time=0.109..0.438 rows=2 loops=21,672)

  • Filter: ((begin_date <= c_1.delivery_date) AND (end_date >= c_1.delivery_date) AND ((pod)::text = (uf_attr.pod)::text))
  • Rows Removed by Filter: 3659
25. 60,656.816 61,686.768 ↑ 1.0 1 36,784

Nested Loop Left Join (cost=0.28..303.01 rows=1 width=15) (actual time=1.677..1.677 rows=1 loops=36,784)

  • Join Filter: (((perimeter_1.customer_siret IS NOT NULL) AND ((perimeter_1.customer_siret)::text = (customer_1.siret)::text)) OR ((perimeter_1.customer_siren IS NOT NULL) AND (perimeter_1.customer_siret IS NULL) AND (customer_1.siret IS NULL) AND ((perimeter_1.customer_siren)::text = (customer_1.siren)::text)))
26. 1,029.952 1,029.952 ↑ 1.0 1 36,784

Index Scan using const_fonct on perimeter perimeter_1 (cost=0.28..289.68 rows=1 width=97) (actual time=0.028..0.028 rows=1 loops=36,784)

  • Index Cond: (((ref_pod)::text = ANY (''{30001940446520,30001420302704,30000651092031,30002141507009,30000710886540,30001970334952,30002321150275,30002321227980,50082164389870,30001630213737,30001730109569,30000940236040,30001520174550,30001630619282,30002321145429,50059298984231,50040334018801,30002431726058,30002140534108,50037337140209,30001550188859,30000940260340,30000910337802,30000950021966,30000950025346,30000950195204,30000951192303,30000420036409,30001422091761,30001991107745,30002131715447,30000970090492,30000750311961,30000970607975,30002144161541,30000751472395,30002251197404,30002220321690,30002111406949,30000211046712,50041099810898,30000230494689,30002231491682,30000910661473,30002250085790,30000130462401,30000131031882,30000220689408,30000230147389,30001960704290,30001961136183,30001961281192,30001961345866,30001970010869,30001981173098,30002220663674,30002251589566,30002320634002,50073336845741,50076230926818,50096925463352,30001910523895,30000950070564,30000951192180,30002220418650,30000950165946,30001940305029,30001790495379,30001910519498,50015340032972,30000410144160,30000420303800,50009696083983,50066238553489,30001420729493,30000420335308,50054082475702,30001450626591,50048726876394,50049782914020,50083212682562,30001424012053,30002581543526,50073762637760,30002140739508,50007634841904,50005894829701,30002220334409,30000950410001,50048769888936,30001612246133,30002122111671,50007631718350,30002530113723,50049457161611,50064072819509,30002210231460,30000711478631,30002210248432,30002430541322,30002221178808,50028900951257,50000683527002,50009223036933,30001950799536,50058430992102,30000110448204,50096780964955,30000410268907,30000160832997,50035854577467,30000560195281,50000833366974,50022540810578,30002211713741,30001910191807,50041929021208,50068122118756,30002530156796,30001960335184,30001960334946,30000141018403,30000121027593,30002122004907,30002110482310,30002330393360,30002330665052,30002330262759,30002311264879,30001450687332,30001420152172,30002530109776,50006367530766,50014327055292,30002520747736,30000164074575,30001210986405,30001210998871,30001440264454,30002120625109,30000450178492,30000630223070,30000940585558,30000210350574,30000510752000,30000731438610,30000950038715,30000740497110,30000751446070,30000751469239,30000220588930,30000210005210,30000160480544,30000160982063,30000210071794,30000210148399,30000111606616,50063241669947,30001912694998,30000220293539,50095224303749,30002140359812,30002131488070,30002111452305,30001250146541,30002140616009,30002254000260,50008792777716,30002220923338,30001240116504,30000410054710,30000430171624,30000140171934,30000112087981,30002251549410,30000430551757,30002251408132,30001990903887,30002151604215,30001430049018,30000220201978,30000211313797,30002151522426,30001240645575,30002121819699,30000520158016,30002212100320,30001430970045,30002140630956,30002210100859,30002212560107,50064109931132,50063820495506,30002142170410,30002131462769,30002154135456,30002311278049,50054812981079,30000410226408,30002210048850,50001122849730,30000167567782,30001480414359,30002330300572,30001440382135,30001991267701,30002151413746,30002110541603,30002121062051,30002142230827,30002212112024,30002210322912,30002240255111,30002120850868,30002121078908,30002131934910,30002212551106,30002314749762,30002240255559,30002235104085,30000510613737,30000520050702,30002231296719,30002241497208,30001720114400,30002241497310,30002221065109,30000560047020,30001911367633,50097105636835,30000960050665,50051085336005,30002311270077,30002142311164,30002530138133,30001611352430,50009261930210,30000410267221,30000920080650,30002211194227,30002212346554,30000711453894,50010998544860,30000430414848,30000430405296,30001970122353,30002142344225,30002210003547,30001460103060,30000510745574,30002151400928,30002111511801,30002212100981,30000731235908,30001430214501,50062769197822,50056729333296,30002212112573,30001991259498,30000410729143,30000520138324,30002122295708,30001651198550,30001540476072,30001440254339,30002510978457,30001422408898,30001430124724,50049747553575,30000410879757,30002151979707,30002210878960,30002142368722,30001431051402,30000730898592,30002212100219,30000220005440,50010853827366,30001441714464,50056692211787,30001430240052,30002140533532,30001430189943,30002212112350,30002220418437,30000410726440,30000410225609,30002510271538,30002241496968,30002131916479,30001460686997,30002150315528,50009696049344,30000110280146,30000430693059,30002521079614,30002130173960,30002212100432,30002210887960,30000210235260,50026296564427,30001520342410,30002151376935,30000720319028,30000430713208,30000510281198,50065232265119,30000210647553,30002451202305,30000410326840,50030066166746,30000160128754,30002580326399,30001441096600,30001430249474,30001991488974,50041492821224,30001440551222,30000131055729,30001441088836,30000131507850,30000110391065,30001441195387,30001441518374,30001440221491,30001444926103,30001440192231,50063531064850,30001960239100,50040915267140,50077674435128,30000120081146,30000751177966,50014616490882,30002340042942,30002340042830,30000720077366,30000544036135,30002150554020,30001760408509,50070008423706,30002251836737,30000650680503,30000740241422,30000741816957,30002231393368,30001760346950,30000560427265,30002140947290,30000234058465,50005065113340,30000710585728,30000560437718,30000730807495,30002110548908,30000120406811,30001912699720,50000828190635,50072033999779,50016023520986,50021812901150,30000110840494,30001911605039,50059295143405,30000430158452,30000110389572,30002580266105,50041207355402,30002110533940,30002310290190,30000750545505,50072034222462,30000430818591,30001240264216,50010960262061,30002121266998,50066097775501,30001620574932,30001620498101,30001620612532,30002120168332,50017619216576,50092002876253,30002121337872,50076226392404,30000750489801,50029049375081,30000910970835,50092437353169,30002230177469,50060890722037,30002122054406,50059299260990,30002120130441,50065557117409,30001990289952,50074203196562,30001460457400,30001424199657,30002215013384,30000120547100,30001930250887,50062048617470,50046853345403,30002312063303,30002151303390,30002231586840,30001450813680,30000110291050,30000140214252,50025723572249,30002240872168,30002120696177,30002221168131,30002142201360,30002224014501,30000130088772,30000750371586,30000210366534,30001931230651,30000710350510,30000210354830,30001940026025,30001940025124,30000140265539,30000214095459,30000210748469,30002241545889,30000210141991,30002110525188,30000934118508,30000210891901,30001952302689,30000930215552,30001952512825,50050325308830,30001611897573,50045260358351,50049203997890,50051774075164,50002569677004,30000940233123,50062192648959,30001970279698,50065521040801,50034117918580,30002320370206,30002221190528,50078836002801,30001991405641,30002141616998,30002241860581,50060456568648,50085927075011,30002430396293,30002320807242,30001430082644,30001970313607,30002310089030,50004016621550,50004450889952,30000711620630,30002240229894,50053944575881,30001220502585,30001210311337,50097649182701,30001422349719,30001930320423,50078581756386,50042511777916,30002110398264,30000750613248,30002410186248,30001914136505,30002122053729,50052786556240,30000430164313,30001240180074,30002214618481,30000430070719,30000740922929,30001641282374,30001470551251,30000630774073,30002134627601,50054812777765,30000430595171,30001424217789,30000160400687,30000160780130,30000911026003,30002141331727,50014581298182,50041932786101,30000120157737,30000520567931,30000454035457,30002580769839,30000140776935,50032416732410,30001210577588,30000540459514,50021562904759,50011831647227,50063351183989,30001970308299,30001210844552,30000951298588,50058720161321,50084080993763,30002151983317,30002254638210,30002121932113,30000970146730,30002110538333,50075073339943,50072902645044,30002230509894,50030245966371,30000751532365,30000751086952,30001912240658,30001420536785,30001420146974,30000631173568,30001421508897,30000430020445,30000111965802,30001250133611,30002434068735,30002434064704,30002142032160,30001914084737,30001990888895,30000430066873,30001910462699,30001960269131,30002251854952,30001630707370,30001990615333,30001944060157,30000510067870,50007235881915,50072902520843,30000510257550,30000124069244,30001434115989,30000214012126,30001940064819,50002424959260,30000710001887,30001220125480,30002230009302,30001750906855,30000540182990,50003727456806,30002111713409,30001444926215,30001974043300,30002521824048,30002140647266,30001970743229,30000910760798,30000112138513,30002210747889,30002110468573,30001650346386,30000711741340,30001650327046,50016642500592,30000124074977,30001940039506,30000730181009,30002330277592,50050182108053,30001961595272,30001650348188,30001990321933,30001991037650,30000750267626,30001514579780,30001711299986,30002410695629,30001510766940,30001990351190,30002111114139,30000510840759,30000140766045,30000220513920,30001460647630,30000750381703,30001970343189,30000550413865,30002110485450,30001420911427,30001450813804,30000711241307,30001210627432,30000750388335,30002110401440,30002111343176,30001441640338,30002580232357,30002130248448,50016642538046,30000741569125,30001990299305,30001940790006,30001750075715,30002151837305,30002141970818,30002121921095,50091316923365,30000731345253,50007345499650,30002250545912,30001611206744,30001610731321,30002120641624,30002111905877,30002110393434,30002232018863,30001650326694,30001790332384,30001914133790,30001750730585,30001913018809,30002212464672,30000931392401,30000150310019,30002321116848,30002220767945,30002150492910,50077858168961,30002431228132,30002431750571,30002230008615,30001940826652,30002330106172,30001750722261,30002110491423,30000114124601,30000160053401,30002131822101,30002231963394,30000210354403,30002132165006,30002131292008,30000110993038,30002142343650,30002534086520,30001750081025,30002111111873,30002132066441,30001960239436,50054957643453,30001654037832,50013169271189,30000720044419,30001651132653,30000141145512,30001610828066,50096202179053,30002211897329,30000950612709,30002210204680,30000950082370,30002220366904,30002131588635,30000940547976,50017221409503,30001910411740,30002142154545,30000250620498,50055102225790,30001964520290,30001620130591,30001240689327,30002560082475,30001441125972,30002310551418,30002141943264,30002221604305,30000160271085,30000431164878,30001540540213,30002140767074,30000910964862,30001540308018,30000450204838,30002142119778,30000550670257,30001990299854,30000970374765,30001440265467,30001430886102,50033285049585,30002321462330,30001430929419,30002210122903,30001540050723,30002211725445,50004595916199,30002231443650,50015774195192,30002320265221,30000750611771,30000711651349,30001941161036,30002132102138,30000110910030,30001910441557,30002110593016,30002210148204,30000751336163,30001540076034,30002140730635,30000450145006,30000741569013,30001650385194,30000930229934,30000650269410,30002111932219,30001440554149,30000131374767,30000140178678,30000131469374,30000210352601,30000731278208,30001420423403,30001421749853,30000960674121,30000971165098,30001440264017,30001220339993,30002521625479,30000731063221,30000731278084,30002224804574,30001421253105,30000240893722,30002321695745,30001420913229,30000950028049,30000940252240,30000734345830,50077713414030,30001420997239,30002230410360,30001220968969,30002151193791,30000430158340,30002580713283,30002114071959,30000741699160,30002511181217,30001220337754,30002521039680,30002520367052,30002540640673,50012301005915,30002231730977,30002140507980,30001612648412,30001981680029,30002510226970,30001441416670,30000431129338,30001931415371,30002251867557,30002250003145,30001980589644,30000110642053,30001990659309,30001941096769,30001611524770,30001610385923,30001620048999,50050905728598,30001931297908,30002231641653,30002430841132,30002431756089,30002251923159,30002132030688,30001970283760,30000730212835,30002122557599,30000950211646,30002221137096,30000110433470,30002510284020,30002252290028,30002310465234,30002450141205,30002212530615,30000120760403,30002150872820,30000740166704,30002250547938,30000131226067,30000910201158,30001912917007,30002241847411,30001912075490,30000750262133,30002310940002,30002310398830,30000740028231,50046888516706,30002530029341,30000140228522,30001441126324,30001550136671,30001710297731,30001710765951,50072214173309,30002212129322,30002154142218,30000211324703,50010239987083,30000111440136,30002132164766,30001981556040,30002132076343,30000150997330,30000630219909,30001220176543,30002580087980,30000430414400,30000260068354,30001510175556,30000450182775,30000630396954,30000410564664,30002524143342,30001610983528,30001611526571,30002564042584,30000410410569,30001450292701,30000930106760,30000110575872,50067727921760,30000450382469,30000450173774,30002210002107,30001610900856,30001240029867,30001420775498,30002310236195,30001931724845,30000130201753,30002211976201,30002121477260,30002430400810,30002235075925,30000931403110,50024856148628,30002534106678,30002531462889,50008503211992,50046020210498,30000240153726,30000640946756,30002221055195,50030500204505,30001611173990,30002431175250,30002311505416,30002430251087,30001991026308,30001964536473,50051953643824,30001960486140}''::text[])) AND ((ref_pod)::text = (uf_attr.pod)::text))
  • Filter: (((segment)::text = ''C2''::text) AND (entry_date <= to_date(''30/04/2019''::text, ''DD/MM/YYYY''::text)) AND ((exit_date IS NULL) OR (exit_date >= to_date(''01/01/2018''::text, ''DD/MM/YYYY''::text))))
27. 0.000 0.000 ↓ 0.0 0 36,682

Seq Scan on customer customer_1 (cost=0.00..11.90 rows=95 width=82) (actual time=0.000..0.000 rows=0 loops=36,682)

  • Filter: (actif IS TRUE)
28. 35,472.060 35,815.338 ↑ 1.0 1 12,714

Nested Loop Left Join (cost=0.28..263.06 rows=1 width=15) (actual time=2.817..2.817 rows=1 loops=12,714)

  • Join Filter: (((perimeter.customer_siret IS NOT NULL) AND ((perimeter.customer_siret)::text = (customer.siret)::text)) OR ((perimeter.customer_siren IS NOT NULL) AND (perimeter.customer_siret IS NULL) AND (customer.siret IS NULL) AND ((perimeter.customer_siren)::text = (customer.siren)::text)))
29. 343.278 343.278 ↑ 1.0 1 12,714

Index Scan using const_fonct on perimeter (cost=0.28..249.74 rows=1 width=97) (actual time=0.027..0.027 rows=1 loops=12,714)

  • Index Cond: (((ref_pod)::text = (uf_attr.pod)::text) AND ((ref_pod)::text = ANY (''{30001940446520,30001420302704,30000651092031,30002141507009,30000710886540,30001970334952,30002321150275,30002321227980,50082164389870,30001630213737,30001730109569,30000940236040,30001520174550,30001630619282,30002321145429,50059298984231,50040334018801,30002431726058,30002140534108,50037337140209,30001550188859,30000940260340,30000910337802,30000950021966,30000950025346,30000950195204,30000951192303,30000420036409,30001422091761,30001991107745,30002131715447,30000970090492,30000750311961,30000970607975,30002144161541,30000751472395,30002251197404,30002220321690,30002111406949,30000211046712,50041099810898,30000230494689,30002231491682,30000910661473,30002250085790,30000130462401,30000131031882,30000220689408,30000230147389,30001960704290,30001961136183,30001961281192,30001961345866,30001970010869,30001981173098,30002220663674,30002251589566,30002320634002,50073336845741,50076230926818,50096925463352,30001910523895,30000950070564,30000951192180,30002220418650,30000950165946,30001940305029,30001790495379,30001910519498,50015340032972,30000410144160,30000420303800,50009696083983,50066238553489,30001420729493,30000420335308,50054082475702,30001450626591,50048726876394,50049782914020,50083212682562,30001424012053,30002581543526,50073762637760,30002140739508,50007634841904,50005894829701,30002220334409,30000950410001,50048769888936,30001612246133,30002122111671,50007631718350,30002530113723,50049457161611,50064072819509,30002210231460,30000711478631,30002210248432,30002430541322,30002221178808,50028900951257,50000683527002,50009223036933,30001950799536,50058430992102,30000110448204,50096780964955,30000410268907,30000160832997,50035854577467,30000560195281,50000833366974,50022540810578,30002211713741,30001910191807,50041929021208,50068122118756,30002530156796,30001960335184,30001960334946,30000141018403,30000121027593,30002122004907,30002110482310,30002330393360,30002330665052,30002330262759,30002311264879,30001450687332,30001420152172,30002530109776,50006367530766,50014327055292,30002520747736,30000164074575,30001210986405,30001210998871,30001440264454,30002120625109,30000450178492,30000630223070,30000940585558,30000210350574,30000510752000,30000731438610,30000950038715,30000740497110,30000751446070,30000751469239,30000220588930,30000210005210,30000160480544,30000160982063,30000210071794,30000210148399,30000111606616,50063241669947,30001912694998,30000220293539,50095224303749,30002140359812,30002131488070,30002111452305,30001250146541,30002140616009,30002254000260,50008792777716,30002220923338,30001240116504,30000410054710,30000430171624,30000140171934,30000112087981,30002251549410,30000430551757,30002251408132,30001990903887,30002151604215,30001430049018,30000220201978,30000211313797,30002151522426,30001240645575,30002121819699,30000520158016,30002212100320,30001430970045,30002140630956,30002210100859,30002212560107,50064109931132,50063820495506,30002142170410,30002131462769,30002154135456,30002311278049,50054812981079,30000410226408,30002210048850,50001122849730,30000167567782,30001480414359,30002330300572,30001440382135,30001991267701,30002151413746,30002110541603,30002121062051,30002142230827,30002212112024,30002210322912,30002240255111,30002120850868,30002121078908,30002131934910,30002212551106,30002314749762,30002240255559,30002235104085,30000510613737,30000520050702,30002231296719,30002241497208,30001720114400,30002241497310,30002221065109,30000560047020,30001911367633,50097105636835,30000960050665,50051085336005,30002311270077,30002142311164,30002530138133,30001611352430,50009261930210,30000410267221,30000920080650,30002211194227,30002212346554,30000711453894,50010998544860,30000430414848,30000430405296,30001970122353,30002142344225,30002210003547,30001460103060,30000510745574,30002151400928,30002111511801,30002212100981,30000731235908,30001430214501,50062769197822,50056729333296,30002212112573,30001991259498,30000410729143,30000520138324,30002122295708,30001651198550,30001540476072,30001440254339,30002510978457,30001422408898,30001430124724,50049747553575,30000410879757,30002151979707,30002210878960,30002142368722,30001431051402,30000730898592,30002212100219,30000220005440,50010853827366,30001441714464,50056692211787,30001430240052,30002140533532,30001430189943,30002212112350,30002220418437,30000410726440,30000410225609,30002510271538,30002241496968,30002131916479,30001460686997,30002150315528,50009696049344,30000110280146,30000430693059,30002521079614,30002130173960,30002212100432,30002210887960,30000210235260,50026296564427,30001520342410,30002151376935,30000720319028,30000430713208,30000510281198,50065232265119,30000210647553,30002451202305,30000410326840,50030066166746,30000160128754,30002580326399,30001441096600,30001430249474,30001991488974,50041492821224,30001440551222,30000131055729,30001441088836,30000131507850,30000110391065,30001441195387,30001441518374,30001440221491,30001444926103,30001440192231,50063531064850,30001960239100,50040915267140,50077674435128,30000120081146,30000751177966,50014616490882,30002340042942,30002340042830,30000720077366,30000544036135,30002150554020,30001760408509,50070008423706,30002251836737,30000650680503,30000740241422,30000741816957,30002231393368,30001760346950,30000560427265,30002140947290,30000234058465,50005065113340,30000710585728,30000560437718,30000730807495,30002110548908,30000120406811,30001912699720,50000828190635,50072033999779,50016023520986,50021812901150,30000110840494,30001911605039,50059295143405,30000430158452,30000110389572,30002580266105,50041207355402,30002110533940,30002310290190,30000750545505,50072034222462,30000430818591,30001240264216,50010960262061,30002121266998,50066097775501,30001620574932,30001620498101,30001620612532,30002120168332,50017619216576,50092002876253,30002121337872,50076226392404,30000750489801,50029049375081,30000910970835,50092437353169,30002230177469,50060890722037,30002122054406,50059299260990,30002120130441,50065557117409,30001990289952,50074203196562,30001460457400,30001424199657,30002215013384,30000120547100,30001930250887,50062048617470,50046853345403,30002312063303,30002151303390,30002231586840,30001450813680,30000110291050,30000140214252,50025723572249,30002240872168,30002120696177,30002221168131,30002142201360,30002224014501,30000130088772,30000750371586,30000210366534,30001931230651,30000710350510,30000210354830,30001940026025,30001940025124,30000140265539,30000214095459,30000210748469,30002241545889,30000210141991,30002110525188,30000934118508,30000210891901,30001952302689,30000930215552,30001952512825,50050325308830,30001611897573,50045260358351,50049203997890,50051774075164,50002569677004,30000940233123,50062192648959,30001970279698,50065521040801,50034117918580,30002320370206,30002221190528,50078836002801,30001991405641,30002141616998,30002241860581,50060456568648,50085927075011,30002430396293,30002320807242,30001430082644,30001970313607,30002310089030,50004016621550,50004450889952,30000711620630,30002240229894,50053944575881,30001220502585,30001210311337,50097649182701,30001422349719,30001930320423,50078581756386,50042511777916,30002110398264,30000750613248,30002410186248,30001914136505,30002122053729,50052786556240,30000430164313,30001240180074,30002214618481,30000430070719,30000740922929,30001641282374,30001470551251,30000630774073,30002134627601,50054812777765,30000430595171,30001424217789,30000160400687,30000160780130,30000911026003,30002141331727,50014581298182,50041932786101,30000120157737,30000520567931,30000454035457,30002580769839,30000140776935,50032416732410,30001210577588,30000540459514,50021562904759,50011831647227,50063351183989,30001970308299,30001210844552,30000951298588,50058720161321,50084080993763,30002151983317,30002254638210,30002121932113,30000970146730,30002110538333,50075073339943,50072902645044,30002230509894,50030245966371,30000751532365,30000751086952,30001912240658,30001420536785,30001420146974,30000631173568,30001421508897,30000430020445,30000111965802,30001250133611,30002434068735,30002434064704,30002142032160,30001914084737,30001990888895,30000430066873,30001910462699,30001960269131,30002251854952,30001630707370,30001990615333,30001944060157,30000510067870,50007235881915,50072902520843,30000510257550,30000124069244,30001434115989,30000214012126,30001940064819,50002424959260,30000710001887,30001220125480,30002230009302,30001750906855,30000540182990,50003727456806,30002111713409,30001444926215,30001974043300,30002521824048,30002140647266,30001970743229,30000910760798,30000112138513,30002210747889,30002110468573,30001650346386,30000711741340,30001650327046,50016642500592,30000124074977,30001940039506,30000730181009,30002330277592,50050182108053,30001961595272,30001650348188,30001990321933,30001991037650,30000750267626,30001514579780,30001711299986,30002410695629,30001510766940,30001990351190,30002111114139,30000510840759,30000140766045,30000220513920,30001460647630,30000750381703,30001970343189,30000550413865,30002110485450,30001420911427,30001450813804,30000711241307,30001210627432,30000750388335,30002110401440,30002111343176,30001441640338,30002580232357,30002130248448,50016642538046,30000741569125,30001990299305,30001940790006,30001750075715,30002151837305,30002141970818,30002121921095,50091316923365,30000731345253,50007345499650,30002250545912,30001611206744,30001610731321,30002120641624,30002111905877,30002110393434,30002232018863,30001650326694,30001790332384,30001914133790,30001750730585,30001913018809,30002212464672,30000931392401,30000150310019,30002321116848,30002220767945,30002150492910,50077858168961,30002431228132,30002431750571,30002230008615,30001940826652,30002330106172,30001750722261,30002110491423,30000114124601,30000160053401,30002131822101,30002231963394,30000210354403,30002132165006,30002131292008,30000110993038,30002142343650,30002534086520,30001750081025,30002111111873,30002132066441,30001960239436,50054957643453,30001654037832,50013169271189,30000720044419,30001651132653,30000141145512,30001610828066,50096202179053,30002211897329,30000950612709,30002210204680,30000950082370,30002220366904,30002131588635,30000940547976,50017221409503,30001910411740,30002142154545,30000250620498,50055102225790,30001964520290,30001620130591,30001240689327,30002560082475,30001441125972,30002310551418,30002141943264,30002221604305,30000160271085,30000431164878,30001540540213,30002140767074,30000910964862,30001540308018,30000450204838,30002142119778,30000550670257,30001990299854,30000970374765,30001440265467,30001430886102,50033285049585,30002321462330,30001430929419,30002210122903,30001540050723,30002211725445,50004595916199,30002231443650,50015774195192,30002320265221,30000750611771,30000711651349,30001941161036,30002132102138,30000110910030,30001910441557,30002110593016,30002210148204,30000751336163,30001540076034,30002140730635,30000450145006,30000741569013,30001650385194,30000930229934,30000650269410,30002111932219,30001440554149,30000131374767,30000140178678,30000131469374,30000210352601,30000731278208,30001420423403,30001421749853,30000960674121,30000971165098,30001440264017,30001220339993,30002521625479,30000731063221,30000731278084,30002224804574,30001421253105,30000240893722,30002321695745,30001420913229,30000950028049,30000940252240,30000734345830,50077713414030,30001420997239,30002230410360,30001220968969,30002151193791,30000430158340,30002580713283,30002114071959,30000741699160,30002511181217,30001220337754,30002521039680,30002520367052,30002540640673,50012301005915,30002231730977,30002140507980,30001612648412,30001981680029,30002510226970,30001441416670,30000431129338,30001931415371,30002251867557,30002250003145,30001980589644,30000110642053,30001990659309,30001941096769,30001611524770,30001610385923,30001620048999,50050905728598,30001931297908,30002231641653,30002430841132,30002431756089,30002251923159,30002132030688,30001970283760,30000730212835,30002122557599,30000950211646,30002221137096,30000110433470,30002510284020,30002252290028,30002310465234,30002450141205,30002212530615,30000120760403,30002150872820,30000740166704,30002250547938,30000131226067,30000910201158,30001912917007,30002241847411,30001912075490,30000750262133,30002310940002,30002310398830,30000740028231,50046888516706,30002530029341,30000140228522,30001441126324,30001550136671,30001710297731,30001710765951,50072214173309,30002212129322,30002154142218,30000211324703,50010239987083,30000111440136,30002132164766,30001981556040,30002132076343,30000150997330,30000630219909,30001220176543,30002580087980,30000430414400,30000260068354,30001510175556,30000450182775,30000630396954,30000410564664,30002524143342,30001610983528,30001611526571,30002564042584,30000410410569,30001450292701,30000930106760,30000110575872,50067727921760,30000450382469,30000450173774,30002210002107,30001610900856,30001240029867,30001420775498,30002310236195,30001931724845,30000130201753,30002211976201,30002121477260,30002430400810,30002235075925,30000931403110,50024856148628,30002534106678,30002531462889,50008503211992,50046020210498,30000240153726,30000640946756,30002221055195,50030500204505,30001611173990,30002431175250,30002311505416,30002430251087,30001991026308,30001964536473,50051953643824,30001960486140}''::text[])))
  • Filter: (((segment)::text = ''C2''::text) AND (entry_date <= to_date(''30/04/2019''::text, ''DD/MM/YYYY''::text)) AND ((exit_date IS NULL) OR (exit_date >= to_date(''01/01/2018''::text, ''DD/MM/YYYY''::text))))
30. 0.000 0.000 ↓ 0.0 0 12,714

Seq Scan on customer (cost=0.00..11.90 rows=95 width=82) (actual time=0.000..0.000 rows=0 loops=12,714)

  • Filter: (actif IS TRUE)