explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hECl

Settings
# exclusive inclusive rows x rows loops node
1. 0.036 84,525.374 ↑ 1.0 25 1

Limit (cost=9,538,351.75..9,538,351.81 rows=25 width=215) (actual time=84,525.332..84,525.374 rows=25 loops=1)

2.          

CTE user_org_ueids

3. 65.486 65.486 ↑ 1.1 2,965 1

Index Scan using idx_om_user_organization_external_id on om_user_organization ouo_2 (cost=0.43..6,262.18 rows=3,251 width=37) (actual time=0.011..65.486 rows=2,965 loops=1)

  • Index Cond: (external_id = ANY ('{2548233,1230420,2791793,1883831,911984,1033215,2650728,2138149,1849829,2840430,2862144,2857397,194157,1908809,1020850,644910,2505278,702380,1793723,534950,2765463,2770488,1310394,1666586,479045,1254192,1081064,1937261,205762,964171,1848925,1783592,404330,1394486,1736260,1689826,2602994,2747512,1663601,1412107,670212,2222063,1925180,1072287,2418324,1915461,620557,2782380,391105,1249318,2821723,1858062,2771120,283075,832246,493234,784829,964129,832302,2455527,531865,2270037,1646214,184279,832316,2638349,533080,2712579,2397546,2191925,1923182,328966,967374,963210,2469813,2542926,792522,998676,1702307,2136169,520022,832312,160130,NULL,2341767,555446,839791,2398632,2799938,2506806,1027734,2401664,2455358,1302580,2099747,615587,1992868,162300,2633763,2370867,1850776,666089,2808538,2484648,1552645,1075629,1927740,1354902,1552649,2496880,1766777,1078524,1827116,2058617,839765,2770562,2254219,2156673,1907112,1561719,2251889,2663570,1744770,2763227,1993907,957777,2588028,988884,2204474,1630081,964137,1010328,1609604,1941996,1782935,1689469,845779,440581,660190,1484679,1008863,1750792,934349,2770512,2181656,454887,964179,1516964,768834,2737490,2386552,2167847,141168,2129337,713909,2137262,1738731,2261509,955695,1856978,2455529,1909119,1941984,2343813,2770500,2406530,2136556,712342,2617719,193336,1507586,1364781,1429105,895495,1596474,2789116,427038,1033341,671227,672034,1868931,1310366,2827246,1672593,2584960,200215,2759910,702376,2488943,643768,1827120,1622242,2677708,702426,367098,2831454,2108772,713917,2718165,2241293,576232,1856999,2168308,2831443,1766926,2799280,1482661,1316708,2790079,2362782,2781158,1848072,2135379,2158545,1161035,2166197,1905177,2370857,2568478,1939711,1739471,424612,1927011,2197587,1195613,1074097,2038604,827765,410526,2277876,1211060,398415,1144485,2749554,2296055,2751560,1978410,357924,2749558,2642436,1284712,2380771,1987953,1136180,2695008,1922450,219624,2627749,1467434,1001021,666106,613349,1347241,479801,1819197,560751,909955,222674,585755,1922872,1346411,2807945,2591177,139405,1345492,2640281,1426234,1201290,1885641,2835384,2726404,883190,1442500,2455360,2835419,2142397,2820397,1704589,141152,1132217,2089422,1960870,1000594,218381,1628310,2496149,1926995,1953984,2619590,2770544,1033217,2152053,739175,827737,159503,2394639,2095594,1308371,2848854,2019764,2770498,2605498,1277491,196748,205483,1961942,663494,610462,207752,383992,1873002,231923,2480162,702382,599831,2397544,544863,2781146,1303857,391110,184651,386138,2629053,2094544,1921667,621664,697022,361688,222535,2354386,2605064,348472,1721766,352737,529727,1927705,2770510,2845172,1907754,2114055,1996905,194311,1364779,2490924,1719028,2827976,1413216,1682713,1254180,686515,919803,644955,559034,2703866,1401996,2188531,2665026,624716,507359,1053800,2673196,1371597,2833240,1284714,2162363,2822988,1195703,1802325,2333605,881920,2781172,2770484,558217,601872,2425434,630318,1880478,1793851,253898,2845188,686495,2660846,1822956,934281,2182702,194151,1023435,2185857,598339,1271284,585781,1852883,1621442,1617477,1606505,1033205,995577,1870248,2861749,2364986,1529936,2035962,2861444,1331566,410473,948492,2791252,1921197,2400063,2285533,921482,1631072,1562215,2718163,2753067,1502410,1473340,2195488,1225087,1558249,1339927,2339954,2763258,2301477,2707336,1022854,1580713,1736254,1193755,1713532,2027598,2668714,519002,2668734,2249231,1705519,479044,1992870,1887939,1733186,2731903,1676746,644918,240593,1430419,2711969,1632274,576258,1739477,2718185,2386550,2604741,1494136,2802904,980924,614939,588877,1539037,1916166,1203090,2856335,2680880,1310332,523914,2275199,1400594,1881205,883242,129116,1033235,2461721,2661513,1968776,576709,414136,671223,497845,1221236,928365,1008829,2740035,2822286,1866773,2488157,1033317,1081068,1910561,323747,1969925,2418359,1201266,1957178,1640828,1467450,1446004,1349713,898076,1966340,1433103,1188554,2361772,1412097,2001735,2789389,1766924,2232432,1310356,955173,1708068,1750581,2831450,1081074,1484655,2780519,2627737,78629,2718219,1793090,1082533,928409,667647,2350889,2217962,533400,2846019,1584256,222540,1375670,2085778,2540283,2749552,2601829,670205,2770496,727409,2005789,2138110,2164830,612871,2813704,826702,2070355,2383023,1387617,863225,1830169,1581863,1216170,2789387,895539,2770520,1507897,2093493,2333593,2448840,2485283,450991,554262,1954318,1364767,448889,2134140,2221212,2841456,715612,1390524,2662017,2437352,1185264,1689323,951720,655778,644954,1295409,2516135,2366135,1266256,1494150,1606532,1616490,2407039,2718207,1332467,1699314,1818712,2676514,2788761,2433231,1061123,2819940,1941599,1851485,741894,525606,2082010,2282141,895503,1617479,1932811,614535,1918155,1350252,1405694,536911,2454465,1639042,2418322,2565833,505717,644909,225961,2845160,1822659,1945032,2435813,1197216,75608,1649036,1072283,1449930,1446873,290599,2653215,895537,279524,964752,2023316,2596505,2391030,231013,2111577,1502406,1963212,2053937,229230,2173027,2627735,819000,2033178,694760,2118571,2845174,997357,2770550,1836091,1517545,1597795,2564828,2770492,2603771,1620911,2059319,600362,2586194,505791,2553501,655784,411349,648230,2694086,2029688,1511935,1637922,2436534,2658272,454890,1732554,1596020,2558326,1318680,608742,2848459,1766793,2738842,1449432,2804972,2237634,231019,2398633,2786099,257226,2562672,2201732,2781156,1840101,2774697,719300,751791,2044835,1878261,2083555,196743,2673188,2534953,672808,2455362,1954662,1494965,1094362,269392,2236737,2361581,928413,1203082,908168,129922,1432468,1053792,2845166,2792754,1261681,55295,1431454,2636391,2655786,2653111,2768884,2705470,1654569,1087431,2011776,1287907,686503,2288763,2770578,793635,1781522,523889,971359,1586808,567538,1288115,2770542,657079,2447375,2770494,95260,1974026,2281711,1127708,226325,1058377,2698602,1779730,883248,722728,1261751,2671955,2770576,2688633,792735,2354665,1646119,2157929,1708056,109327,2396767,1990805,1838346,1364735,2378469,2718191,405335,1568228,488457,1982593,660185,2196922,2115693,1598934,2341516,2703484,1714100,2045300,946766,2626976,1562225,2556070,2820229,565398,1019154,883200,2203117,253888,909965,591976,2469834,2687619,347286,2682336,1515467,788521,995372,2845152,559884,751823,1601093,2718179,2845833,790194,1523973,2697402,2211356,1356471,1201282,2112462,1965241,2177687,1909535,1450742,2763248,255962,2860072,2709171,1470868,1777849,2710298,1310374,1669488,2510607,2836846,1518507,2838299,946734,2736887,1134117,2080814,1419680,715234,2044421,2654613,2751581,1745623,938971,2746686,2096220,2705950,2712423,2799085,1900350,2492689,2703241,614815,820079,576260,1092991,2410473,1881991,751787,1762663,1911400,1517541,1541331,2006114,2072053,2447377,1786710,2556088,2258042,576239,1586896,1755522,2234244,1770322,1618917,2781176,944886,2770552,2781160,708199,1322880,1628294,626705,2698979,1782933,454896,1026566,1611695,537731,1779764,832326,2469051,2807949,2714443,2638351,1197603,893742,1856980,2512436,2353902,2386988,1478338,686487,2063238,2781154,2482463,1327601,454406,2058619,2711194,1889781,2078228,123569,2461719,634638,562203,2627991,1948243,541579,927279,411358,2301475,681982,2770556,764530,1419293,1755994,2094425,826163,2582720,2705867,427346,2460027,542714,1337583,497843,1850192,2039187,1287905,2119742,2292029,2405720,1067788,72873,2301563,650292,2206411,1583165,2370871,1261729,670202,232353,2801324,446269,2666721,2291296,1301351,1027732,1825856,2848871,1081072,1168789,2639887,1573686,2116398,1762269,379024,1367512,2172347,835569,2299288,2590810,523909,1903180,1089060,893110,2342549,2417824,2841892,1013938,202690,608670,707373,1220182,2249227,2419619,1693898,2569370,1013946,1335227,2783413,545878,601192,2789383,2467625,610441,2032684,1835463,1103138,2377892,2639664,2513245,450436,1519223,1796397,1827118,953920,2364510,1512185,2353908,249766,1222873,1620921,1371881,2838409,141151,393198,479075,2243674,2580156,511621,1310352,2351336,2595093,2374374,152979,958497,2100745,2695344,554528,552867,2236950,2770560,1555048,2425432,2742259,554556,2101272,2035264,2358525,2851297,751809,1221378,177835,372772,2214359,1628308,2210112,784813,2636913,210894,1369656,1903998,2676374,895525,2378293,572479,2859220,1202562,946762,1973011,1628306,283037,2718211,2482873,1777618,1140889,2505280,2767648,2370327,832330,132714,1650688,2241291,598361,1605396,1008841,1412127,621678,2174785,2439747,2671953,1564575,347289,2816720,388681,827161,2789397,2340546,1241246,576236,2772217,1184484,839789,2535178,1245602,593194,1685478,2214021,1008847,2031798,344297,820085,1922524,2825748,644923,2579213,2513427,996766,2159963,1615108,454901,802027,46302,1762659,392913,1352241,713923,1835921,486797,823736,2037207,2341342,2770506,1586882,1921645,2416133,2717839,1633973,2007835,1266250,2599016,2437669,1222955,2214102,1779740,1911680,1966851,2705712,2843856,2548080,2154628,1586812,1762657,2770524,2190312,470865,1938275,1201264,2770580,2586107,1429655,833653,1403268,2454463,1467436,2341757,1203074,2770508,2337074,1892713,441926,2170135,2770546,1730858,995583,2787780,696834,2090939,2073727,471608,391121,2096717,1195619,1953957,2705486,450916,2729903,543639,2718197,2781138,2550014,2394252,1647819,2359419,2541273,124331,2275799,869606,1720742,2406560,1008837,1295411,486176,988882,759861,751811,529737,2171056,1763690,2386533,572469,2339469,997359,449339,454886,395332,2194462,2686872,2591738,1968640,2515762,2781170,2752625,2683467,2801115,403251,2276749,414126,157372,2297157,2861764,2822195,1586890,1173958,995386,545939,516862,1470888,1681571,1945976,463830,827771,1392218,1511793,702412,1511941,2396057,1692638,290600,1322024,1937305,576233,1532043,2556770,802023,1892795,2649700,2617568,548376,1721006,2487820,1402008,2587664,1886662,2783411,1168761,2039851,1992494,2828442,1136550,427924,447442,828192,1190458,938937,2718213,2845170,1904098,2718177,2262338,1586892,2204667,231009,2770568,2518063,1798983,1617483,1947456,831408,2172345,2127606,863355,1451186,576234,600356,927277,1998965,2838084,575879,1414770,2703561,2280475,1528835,2668720,1261683,519095,2852295,1620925,2751579,1720738,614817,2718169,1384312,2560085,1245576,719298,1787863,2435809,2496151,103187,2599635,1723798,2845158,2789385,644907,624830,1041294,2478891,671225,2016234,1527560,2082658,2668736,2668744,1563171,1586894,2668726,2627755,287370,1858613,1361120,2639131,832344,2394637,2838877,2770518,938943,898134,1783683,450969,1592866,2293837,461921,231026,423861,710491,274030,1018033,1143229,883240,2627741,1554342,283029,2192852,2406023,2077302,334517,839797,1412704,1495792,2688772,2789391,644948,1552423,2698984,2621255,432767,2638356,2279922,1158809,1266226,1405958,2214327,706936,2705484,617166,564244,2659346,2861446,1528291,2356236,1464468,2035882,2360976,344305,684464,2220646,2731509,2515205,157363,854561,2787774,2544554,180660,2745530,1193761,2137596,2668738,1989018,1646131,624745,1573674,786864,1525147,2801546,1044695,2709913,645679,2781144,447452,463829,576230,2705466,618419,1628324,1410313,587052,1903008,2271510,2770502,2010574,2654196,1344210,2087231,1677559,2749560,2835902,1957761,483247,2410475,1316718,2260105,624746,2742267,1891780,2172115,1576919,2031554,509454,548955,1224475,1947860,2718175,217384,140269,2182704,2845162,1785387,551443,2757536,620105,2343713,1211080,1086050,183095,1871987,2534402,241222,802902,783059,1663587,1563267,1158085,1456467,500847,162304,824178,1446690,998581,493238,599621,207762,2695180,2766034,2750977,2651736,1562231,1419684,2111533,2751566,1385372,2562694,572483,558215,2705462,2845156,1085573,2150781,354348,1580719,2496870,1261735,2159200,793458,655797,565406,1284479,2785842,852498,2743197,2195994,1804739,2023988,2660262,2705474,1653003,479102,289594,2372578,1620629,1698991,1481530,1429661,142602,2781152,2257000,1671489,1584244,331368,2022041,779894,590169,2196985,883222,2078637,1467438,1277441,931334,2723880,1380088,2831452,1941152,1183613,1933300,1804144,620101,2712425,549999,1762241,249791,210935,2816691,2115709,1913101,2538787,2198181,117153,928431,465104,1147048,2835316,2026224,1658194,511624,1534117,1650710,2031800,2668742,1984789,955425,1569471,2560902,391117,2718217,427341,1833511,1348734,1937719,2781140,2269660,2781905,1423080,1819420,160180,2295104,1118599,2052099,992103,1562219,2150211,1597525,2567741,1091483,955701,1412714,2795855,96118,2111514,1203078,854525,1601095,1679024,2617897,2140617,1261679,581354,1000586,2525699,1996928,751813,2841890,1692640,1637910,228579,2487818,2034542,2712587,1178841,840244,2375332,1907690,784839,1758493,1235904,367102,2770582,1810341,2705460,1828079,1509292,1628296,2781164,1652541,1462199,1053420,548950,2516462,1690396,2777999,1687684,683420,2806115,1613581,2770574,1762661,2509060,565413,2845168,2333023,2751570,2375747,1779736,637376,545885,2161326,1580721,90463,1369658,702410,2749580,686475,2756036,2781166,2802900,2694950,937487,1762275,1870203,1986716,2280796,1541325,2271502,2241062,1990807,1682711,2511452,2382048,1338435,2858764,2035254,2375406,2322710,722710,2227202,1027521,2255857,2846407,2117112,533407,1713062,2789393,1261235,1108647,1023028,726113,483257,664181,2447379,449311,898138,2821848,123065,2754651,1972837,2781148,1867761,1788843,2095764,454877,,1489534,1571912,421101,2263215,888583,1904565,2845176,2786067,950678,539999,545886,1710585,2789395,1115158,1280980,1118591,676947,2666850,2230264,1053790,2705620,2668730,1962103,2816742,1535159,662912,1903182,368256,2103671,1779732,1653494,479056,2457944,1548287,1384324,2830562,1467454,1075855,1965617,2668712,2531074,2038648,2771737,1199369,219349,1437970,2718181,1628302,2618118,1280982,1216166,1630079,2851344,2630063,539997,1266236,1921109,618417,1224479,2627751,2253813,938907,2028818,2745447,1948798,2455531,1203306,2632450,2584535,2129126,2125865,2227051,1109541,1087425,2820988,614541,839795,634682,2680629,1473230,1739465,1685408,2531892,417864,1975682,1963793,273090,2668732,479059,803363,2475351,2858996,585751,1470874,664180,2627753,2152057,2100090,1724094,1797813,2812176,2099245,1316712,1696933,2345127,336167,802057,1108595,2113229,2737468,2635389,530299,2830565,1175202,1611697,1539402,1779738,2560850,2517380,2284913,567622,2770516,1201276,2770536,129925,914031,1941986,1092808,2655909,763623,662717,694756,1333546,576235,1470005,1224481,928399,1562207,708921,2455368,2759430,2812927,2749128,1775581,854549,1261749,2682640,1969083,518132,1691710,2237602,1903178,517682,376156,938987,938989,2700753,2067356,2275075,1697301,2634463,2610396,2149198,1483488,390358,1979620,209698,895475,610471,832332,2584242,2830377,574058,610451,470051,2715134,2009544,1044703,1419480,2333571,1684076,1573688,1949805,1685804,1939032,1562229,2718205,2770566,1277507,2359870,2127880,1823914,2829169,1630071,2512438,1201286,2382834,2792368,1431111,1696357,1745593,2224123,1557281,1560771,1254300,793464,598476,489546,610485,1033339,955717,1818577,1321962,2763260,1467462,500855,1553754,1624161,1975524,2136206,2732688,2674251,1793003,2770548,2770564,1016654,425428,2820381,2016220,1568985,812294,2685192,971339,2822996,1180447,1925203,2751572,621675,2792636,1745591,372777,1431115,2201749,2386296,1197699,2657043,2129308,2194895,938977,971343,1692624,1736262,946758,1108593,1266242,2510161,2645217,146415,2668722,2105628,2174196,1053796,1874778,210933,2060033,1637956,1072289,1419676,1477433,2689139,2728329,2544041,518359,2582142,1896728,434556,2653780,948490,2657299,2858878,721544,2859006,2826822,1013942,708777,2826548,2668724,1613573,2398247,1384328,2685229,110149,1884646,1892664,255891,1959581,2575333,2858630,2811946,707813,1777602,2084381,1108641,893120,1933304,1180457,2820393,400393,2371826,1816017,2022039,449318,2802328,964139,1166875,2660230,1380321,373246,2751872,1147042,1426228,820077,2272963,676969,2770572,621662,2125292,1297096,2560073,1671421,2380520,1134141,1511783,361687,2411088,1902485,2703239,2153417,2717843,884389,1064884,2790426,2718171,2102277,198563,2748065,2668728,576711,2753070,1839763,1733754,1355518,2718161,243632,1885643,359395,226322,655809,1933302,1562221,2804970,1484579,2077160,1628300,2716744,2718203,2215846,456381,2744657,1000582,661769,1310346,2504064,222539,2099224,479074,1620159,2510605,2597120,1731877,1652549,2602589,1762671,849828,547582,2019194,2850187,1868821,644908,2203538,2208332,1600572,1954286,2565831,1864069,2396317,1442472,1000271,1108609,2173291,1969923,2260055,1266252,1844653,450995,1998042,2532657,2357951,702416,1762655,2666863,1658196,2808540,2071622,2770504,2290458,2101967,354354,2719544,2791770,965101,1223575,1026105,1037405,2839959,2164365,576071,361695,1037401,1969929,1307187,1397852,1620169,1013968,1630077,1535366,2277014,1181592,2060909,1795926,621974,2609813,544764,2335600,2264516,1859661,795995,2705492,1322882,1605972,2074018,1979574,1586900,2217958,1910591,2225347,2271156,863911,2689663,1097863,2657303,1960868,1605682,2718215,2712020,2738780,938913,2810316,1628314,46240,2560815,344299,763487,1771799,2824129,2425430,2845180,1980110,1800012,1923917,2020171,1568214,1122899,2845154,1693894,2082994,1794576,717016,576079,1127584,2049291,2289322,1534853,2024332,2013052,1542365,2098688,832294,1819424,550568,2828444,556474,1245612,1823912,1736256,1937462,1422844,290225,1628326,576710,2823261,2614473,1783576,2663572,2198943,1023705,1749138,2257220,2639511,1243488,1944278,624753,2469510,916127,1764157,1819695,676967,1910054,1903964,670203,1577969,2510609,2773865,1333550,2539571,2138638,2835651,2817261,2597118,1595450,2847121,1649367,1900352,883184,938965,1955521,1978330,414123,1346413,174969,1907086,603217,812326,1728589,2778651,832324,458117,2278409,2130483,2627761,1737763,829792,2839622,1465477,1840727,198381,2280023,837126,1502566,807185,2074142,2033182,2691465,1445260,2419621,2293452,152801,909949,416100,594455,2134626,761659,576241,2162498,2851342,196464,1937444,1903188,1600568,114197,644932,2427844,612875,636907,1946372,1791620,284619,1773010,883238,1833509,944888,1948463,883204,2770528,148476,1008871,2751562,1140776,2025616,2485285,601870,334499,1266228,938893,1522943,1544768,1968650,671226,2509879,1663627,1371879,57765,2850637,1915106,1369654,1265120,114185,2003991,142598,1487085,495571,1916168,1708062,2207340,2772284,1908803,2142927,1981591,1367400,1284726,2553507,864142,2087615,2222307,704565,1791550,205760,2838077,2269253,1498791,2189068,1624426,2770514,2241070,2705482,384530,1070626,1507590,1420796,2842236,430980,676965,1955519,2677706,423234,2540541,1746524,1396514,1262714,1338437,2462030,500822,1139308,2821759,500820,1000588,2130615,953938,968640,2569632,1893373,2126571,1076861,147008,129927,557227,518983,117162,507371,660199,1687581,827749,1118593,524223,2092030,2710930,1950312,576237,454895,612005,1623741,2770554,488482,1245610,1662592,190531,2448553,2623894,2644250,283057,784819,2240528,2204499,2832180,2442809,489785,1892270,1310376,1445198,2208354,189038,2825750,1417399,1994816,2668718,2770586,2718183,1659987,2770534,863135,673868,2100768,2527585,561427,2818509,1150460,1659683,1898263,2469835,1333508,974233,1910587,904382,2018888,2861032,2847860,576708,995565,593200,1516954,2360337,1204183,829457,2705468,995569,2770530,1503632,1890539,2007948,1123801,1779734,1346415,644913,2596825,2751575,676963,2271528,2084379,2418951,454442,1613583,610450,2086635,1987426,2401662,1362901,2044069,1586810,1072331,650720,1000584,2293454,635132,1175750,2305281,386132,1324070,1310358,2405770,2076355,2488941,1929430,2751564,612893,2130060,1685806,1979544,154532,1340268,222534,1842101,2515796,802039,2847581,2394643,1408091,898128,735874,2006077,479081,1949823,2705480,2832193,839799,1333524,2596821,1843115,1392060,683424,1310330,2770584,1494152,2554494,2630057,1230398,2717079,1731625,2541275,1997157,2126573,617170,142597,1780012,2556082,1720748,1538128,854533,2717077,372768,1502400,1211056,1620155,2357856,2076381,2770532,742502,1384326,1804136,1576593,2830949,1484843,2765189,2517546,269366,2067786,1838364,465139,993652,1284491,2562696,854555,928387,1685065,2751577,1980844,2184356,2660457,367692,1370707,1003905,1949004,2845164,1701675,2324924,2789399,1230426,2235124,1497472,1111794,2023068,1245580,2601875,964125,1756004,997361,1584248,2854669,2737326,2718221,162252,1586884,827759,2732753,1130308,1204059,258646,1387687,1936840,2151463,531856,290970,964151,1013958,1281465,2861794,893841,2820395,2782386,1292008,2204631,2632473,1206198,2438621,1584246,1401994,1412380,870849,1863437,2718201,2038275,2126183,1663615,1577036,2759434,1708052,1266238,2113006,1440112,2698988,523883,146417,1266258,2770522,480594,259696,1546742,1523975,2718209,660183,928429,1605360,2465312,2455209,2648150,1859711,2652994,2179030,601208,1756002,1562211,854535,2718173,997355,2631898,702374,2770490,1953758,415353,1230438,1748261,1559436,2352055,426964,1207628,1318038,1019536,1211040,2565835,1762669,636919,1628510,1999253,1925241,134389,2152424,1459755,336154,2627733,119179,150764,157368,26398,2719862,344294,1562223,450968,2705490,2826824,1373283,2470095,1601784,2763653,832300,2476747,1806291,2718193,1924403,2341533,1844092,712526,2160597,1793321,2060907,2647029,1213340,210924,825855,1665465,2781162,1962490,413555,2045304,196299,1384310,2022037,1529916,2565837,2790168,2417484,1333552,379050,2789174,666100,2703237,400002,2004099,588266,537470,2772165,2705472,2023161,1911406,2159339,2292656,2705478,2781168,1881902,1260345,955713,270170,2270101,961099,725862,2705476,2781150,2770570,1960461,1316752,2083707,2065382,1153287,2661547,1652553,1791508,1826460,1844035,1795630,1779726,650900,954839,643294,2573792,745767,2383726,2056517,1766922,1254190,259715,2583533,2619592,2770482,2787772,654931,2770526,1732103,2718857,2584416,2563683,1538228,1310763,1668314,2098336,1463465,1230392,2195666,44869,2023736,523920,1333564,2776395,2289655,1151428,2862197,598342,1518123,2202459,2749981,832328,854547,2814838,1740283,2718199,1136548,2657301,1393400,825853,2668740,1053514,1962470,671224,2252164,706932,937085,1284291,2523307,2047663,2751215,1051954,2770538,1579690,2845178,1749268,2033956,2627743,2426658,2139333,2104847,585763,2744681,1168771,605687,2781174,2822981,1587874,2473404,399639,802035,2770540,1942666,2736645,394251,2624041,1872982,2668716,2335602,2536938,427354,1337786,2828507,243624,2179906,160179,395069,715240,953930,1237851,1989524,2827958,2454137,2770486,635031,1318186,1400112,1516956,1525145,1998356,2657284,1833880,1114069,2192854,576231,1762665,2853311,1201260,1013962,1612944,2671297,405915,938917,2718189,2668640,1569817,2592701,537732,1814019,124326,2340571,1559171,727435,2459375,802067,1777128,2472329,1394568,2830375,1786884,336156,542468,621665,1562233,2217960,500587,1310334,2718187,367091,1778087,702370,1647825,2822994,2292610,2718195,1764135,1663623,465106,2418326,554551,2653690,1655294,644920,784831,2148698,239718,2770558,2781142,686559,2035328,1405930,2403647,2411579,1631086,2148570,798042,2705488,2563685,817234,1429659,119183,347280,671228,948484,2705464,1021435,534901,1412710,1319841,1562217,2164929,2278669,2691058,519118,1393402,654930,1790220,1378319,1266230,2066116,2627739,2751568,2178031,804116,2821757,1347173,469225,1628958,2718167,1918583,722722,895489,2455364,812320,1259482,1394835,1960457,2168306,1589645,393193}'::integer[]))
4. 5.354 84,525.338 ↑ 130.0 25 1

Sort (cost=9,532,089.56..9,532,097.69 rows=3,251 width=215) (actual time=84,525.329..84,525.338 rows=25 loops=1)

  • Sort Key: ouo.name
  • Sort Method: top-N heapsort Memory: 38kB
5. 11.830 84,519.984 ↑ 15.9 205 1

Hash Right Join (cost=8,916,368.36..9,531,997.82 rows=3,251 width=215) (actual time=84,403.895..84,519.984 rows=205 loops=1)

  • Hash Cond: ((COALESCE(ouo_1.unique_exchange_id, (unnest(u.user_organization_ueids))))::text = (ouo.unique_exchange_id)::text)
  • Filter: (((json_agg(json_build_object('subscriber_ueid', u.subscriber_ueid, 'start_date', op2.start_date, 'end_date', op2.end_date))) IS NOT NULL) OR ((json_agg((json_build_object('tariff_ueid', op_in.tariff_ueid, 'subscription_ueid', op_in.subscription_ueid, 'start_date', op_in.start_date, 'end_date', op_in.end_date))) FILTER (WHERE ((json_build_object('tariff_ueid', op_in.tariff_ueid, 'subscription_ueid', op_in.subscription_ueid, 'start_date', op_in.start_date, 'end_date', op_in.end_date)) IS NOT NULL))) IS NOT NULL))
  • Rows Removed by Filter: 2,760
6. 22.769 82,763.716 ↓ 2.1 16,844 1

Merge Full Join (cost=8,910,065.54..9,525,664.54 rows=8,083 width=197) (actual time=82,657.676..82,763.716 rows=16,844 loops=1)

  • Merge Cond: (((unnest(u.user_organization_ueids)))::text = (ouo_1.unique_exchange_id)::text)
7. 1.249 74,065.918 ↑ 1.4 138 1

GroupAggregate (cost=8,180,541.63..8,795,693.56 rows=200 width=64) (actual time=74,064.413..74,065.918 rows=138 loops=1)

  • Group Key: (unnest(u.user_organization_ueids))
8. 0.189 74,064.669 ↑ 3,491.5 139 1

Unique (cost=8,180,541.63..8,787,197.88 rows=485,325 width=96) (actual time=74,064.374..74,064.669 rows=139 loops=1)

9. 0.622 74,064.480 ↑ 334,706.9 145 1

Sort (cost=8,180,541.63..8,301,872.88 rows=48,532,500 width=96) (actual time=74,064.372..74,064.480 rows=145 loops=1)

  • Sort Key: (unnest(u.user_organization_ueids)), u.subscriber_ueid, op2.start_date, op2.end_date
  • Sort Method: quicksort Memory: 45kB
10. 40,814.463 74,063.858 ↑ 334,706.9 145 1

Nested Loop (cost=1.87..527,375.70 rows=48,532,500 width=96) (actual time=1,180.093..74,063.858 rows=145 loops=1)

  • Join Filter: ((uou.unique_exchange_id)::text = ANY ((u.user_organization_ueids)::text[]))
  • Rows Removed by Join Filter: 66,647,143
11. 76.975 76.975 ↑ 1.1 2,965 1

CTE Scan on user_org_ueids uou (cost=0.00..65.02 rows=3,251 width=90) (actual time=0.014..76.975 rows=2,965 loops=1)

12. 31,285.169 33,172.420 ↓ 7.4 22,478 2,965

Materialize (cost=1.87..37,736.55 rows=3,053 width=96) (actual time=0.001..11.188 rows=22,478 loops=2,965)

13. 92.299 1,887.251 ↓ 7.4 22,478 1

Nested Loop (cost=1.87..37,721.29 rows=3,053 width=96) (actual time=0.404..1,887.251 rows=22,478 loops=1)

14. 67.064 843.262 ↓ 4.4 31,723 1

Nested Loop (cost=0.98..23,235.93 rows=7,131 width=68) (actual time=0.042..843.262 rows=31,723 loops=1)

15. 332.076 332.076 ↓ 4.4 31,723 1

Index Scan using ix_om_options_package_options_package_tariff_ueid on om_options_package op2 (cost=0.56..7,784.63 rows=7,131 width=20) (actual time=0.026..332.076 rows=31,723 loops=1)

  • Index Cond: ((tariff_ueid)::text = '5734cd43-de6e-4e23-9fe7-bb86398c27a3'::text)
16. 444.122 444.122 ↑ 1.0 1 31,723

Index Scan using om_options_package_owner_pkey on om_options_package_owner opo2 (cost=0.43..2.16 rows=1 width=56) (actual time=0.013..0.014 rows=1 loops=31,723)

  • Index Cond: (id = op2.options_package_owner_id)
17. 222.061 951.690 ↑ 2.0 1 31,723

Bitmap Heap Scan on om_user u (cost=0.88..2.01 rows=2 width=116) (actual time=0.029..0.030 rows=1 loops=31,723)

  • Recheck Cond: ((opo2.subscriber_ueid = subscriber_ueid) OR ((opo2.user_ueid)::text = (ueid)::text))
  • Heap Blocks: exact=22,478
18. 63.446 729.629 ↓ 0.0 0 31,723

BitmapOr (cost=0.88..0.88 rows=2 width=0) (actual time=0.023..0.023 rows=0 loops=31,723)

19. 666.183 666.183 ↑ 1.0 1 31,723

Bitmap Index Scan on ix_om_user_subscriber_ueid (cost=0.00..0.44 rows=1 width=0) (actual time=0.021..0.021 rows=1 loops=31,723)

  • Index Cond: (opo2.subscriber_ueid = subscriber_ueid)
20. 0.000 0.000 ↓ 0.0 0 31,723

Bitmap Index Scan on om_user_pkey (cost=0.00..0.44 rows=1 width=0) (actual time=0.000..0.000 rows=0 loops=31,723)

  • Index Cond: ((opo2.user_ueid)::text = (ueid)::text)
21. 17.510 8,675.029 ↓ 2.1 16,714 1

Materialize (cost=729,523.91..729,867.44 rows=8,083 width=133) (actual time=8,593.256..8,675.029 rows=16,714 loops=1)

22. 43.569 8,657.519 ↓ 2.1 16,714 1

GroupAggregate (cost=729,523.91..729,766.40 rows=8,083 width=129) (actual time=8,593.251..8,657.519 rows=16,714 loops=1)

  • Group Key: ouo_1.unique_exchange_id
23. 127.993 8,613.950 ↓ 3.3 26,969 1

Sort (cost=729,523.91..729,544.12 rows=8,083 width=129) (actual time=8,593.221..8,613.950 rows=26,969 loops=1)

  • Sort Key: ouo_1.unique_exchange_id
  • Sort Method: quicksort Memory: 9,271kB
24. 68.355 8,485.957 ↓ 3.3 26,969 1

Nested Loop (cost=704,833.53..728,999.30 rows=8,083 width=129) (actual time=572.160..8,485.957 rows=26,969 loops=1)

25. 82.948 2,349.577 ↓ 1.9 26,969 1

Nested Loop (cost=704,832.98..720,145.31 rows=14,263 width=129) (actual time=570.768..2,349.577 rows=26,969 loops=1)

26. 357.372 844.315 ↓ 2.1 30,262 1

HashAggregate (cost=704,832.55..705,153.47 rows=14,263 width=131) (actual time=569.819..844.315 rows=30,262 loops=1)

  • Group Key: op_in.id
27. 77.114 486.943 ↑ 3.8 66,485 1

Hash Join (cost=290.52..701,030.47 rows=253,472 width=131) (actual time=9.692..486.943 rows=66,485 loops=1)

  • Hash Cond: (o.option_type_id = ot.id)
28. 119.145 409.297 ↑ 3.8 66,485 1

Nested Loop (cost=259.61..697,514.33 rows=253,472 width=107) (actual time=9.143..409.297 rows=66,485 loops=1)

29. 73.052 78.318 ↓ 2.1 30,262 1

Bitmap Heap Scan on om_options_package op_in (cost=259.05..14,996.68 rows=14,262 width=98) (actual time=9.123..78.318 rows=30,262 loops=1)

  • Recheck Cond: ((tariff_ueid)::text = ANY ('{b55d396d-e963-4ea9-adb2-04a89de46acf,1d3eb6e0-0b35-40fc-a6d2-b2a2af2dffd8}'::text[]))
  • Heap Blocks: exact=21,808
30. 5.266 5.266 ↓ 2.1 30,272 1

Bitmap Index Scan on ix_om_options_package_options_package_tariff_ueid (cost=0.00..255.48 rows=14,262 width=0) (actual time=5.266..5.266 rows=30,272 loops=1)

  • Index Cond: ((tariff_ueid)::text = ANY ('{b55d396d-e963-4ea9-adb2-04a89de46acf,1d3eb6e0-0b35-40fc-a6d2-b2a2af2dffd8}'::text[]))
31. 211.834 211.834 ↑ 240.0 2 30,262

Index Scan using ix_option_fk_option_options_package_id on om_option o (cost=0.57..43.06 rows=480 width=13) (actual time=0.006..0.007 rows=2 loops=30,262)

  • Index Cond: (options_package_id = op_in.id)
32. 0.079 0.532 ↑ 1.0 103 1

Hash (cost=29.62..29.62 rows=103 width=32) (actual time=0.532..0.532 rows=103 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 15kB
33. 0.155 0.453 ↑ 1.0 103 1

Merge Join (cost=6.13..29.62 rows=103 width=32) (actual time=0.126..0.453 rows=103 loops=1)

  • Merge Cond: (ot.option_type_nick_id = otn.id)
34. 0.131 0.131 ↑ 1.0 103 1

Index Scan using ix_om_option_type_fk_option_type_option_type_nick_id on om_option_type ot (cost=0.14..30.02 rows=103 width=14) (actual time=0.011..0.131 rows=103 loops=1)

35. 0.112 0.167 ↓ 1.4 100 1

Sort (cost=5.99..6.17 rows=73 width=26) (actual time=0.111..0.167 rows=100 loops=1)

  • Sort Key: otn.id
  • Sort Method: quicksort Memory: 30kB
36. 0.055 0.055 ↓ 1.0 75 1

Seq Scan on om_option_type_nick otn (cost=0.00..3.73 rows=73 width=26) (actual time=0.003..0.055 rows=75 loops=1)

37. 1,422.314 1,422.314 ↑ 1.0 1 30,262

Index Only Scan using _ix_spark_report_speed_up on om_options_package_owner opo (cost=0.42..1.03 rows=1 width=41) (actual time=0.047..0.047 rows=1 loops=30,262)

  • Index Cond: (id = op_in.options_package_owner_id)
  • Heap Fetches: 1,164
38. 6,068.025 6,068.025 ↑ 1.0 1 26,969

Index Only Scan using om_user_organization_unique_exchange_id_key on om_user_organization ouo_1 (cost=0.55..0.61 rows=1 width=37) (actual time=0.224..0.225 rows=1 loops=26,969)

  • Index Cond: (unique_exchange_id = (opo.user_organization_ueid)::text)
  • Heap Fetches: 26,969
39. 6.119 1,744.438 ↑ 1.1 2,965 1

Hash (cost=6,262.18..6,262.18 rows=3,251 width=87) (actual time=1,744.438..1,744.438 rows=2,965 loops=1)

  • Buckets: 4,096 Batches: 1 Memory Usage: 424kB
40. 1,738.319 1,738.319 ↑ 1.1 2,965 1

Index Scan using idx_om_user_organization_external_id on om_user_organization ouo (cost=0.43..6,262.18 rows=3,251 width=87) (actual time=3.240..1,738.319 rows=2,965 loops=1)

  • Index Cond: (external_id = ANY ('{2548233,1230420,2791793,1883831,911984,1033215,2650728,2138149,1849829,2840430,2862144,2857397,194157,1908809,1020850,644910,2505278,702380,1793723,534950,2765463,2770488,1310394,1666586,479045,1254192,1081064,1937261,205762,964171,1848925,1783592,404330,1394486,1736260,1689826,2602994,2747512,1663601,1412107,670212,2222063,1925180,1072287,2418324,1915461,620557,2782380,391105,1249318,2821723,1858062,2771120,283075,832246,493234,784829,964129,832302,2455527,531865,2270037,1646214,184279,832316,2638349,533080,2712579,2397546,2191925,1923182,328966,967374,963210,2469813,2542926,792522,998676,1702307,2136169,520022,832312,160130,NULL,2341767,555446,839791,2398632,2799938,2506806,1027734,2401664,2455358,1302580,2099747,615587,1992868,162300,2633763,2370867,1850776,666089,2808538,2484648,1552645,1075629,1927740,1354902,1552649,2496880,1766777,1078524,1827116,2058617,839765,2770562,2254219,2156673,1907112,1561719,2251889,2663570,1744770,2763227,1993907,957777,2588028,988884,2204474,1630081,964137,1010328,1609604,1941996,1782935,1689469,845779,440581,660190,1484679,1008863,1750792,934349,2770512,2181656,454887,964179,1516964,768834,2737490,2386552,2167847,141168,2129337,713909,2137262,1738731,2261509,955695,1856978,2455529,1909119,1941984,2343813,2770500,2406530,2136556,712342,2617719,193336,1507586,1364781,1429105,895495,1596474,2789116,427038,1033341,671227,672034,1868931,1310366,2827246,1672593,2584960,200215,2759910,702376,2488943,643768,1827120,1622242,2677708,702426,367098,2831454,2108772,713917,2718165,2241293,576232,1856999,2168308,2831443,1766926,2799280,1482661,1316708,2790079,2362782,2781158,1848072,2135379,2158545,1161035,2166197,1905177,2370857,2568478,1939711,1739471,424612,1927011,2197587,1195613,1074097,2038604,827765,410526,2277876,1211060,398415,1144485,2749554,2296055,2751560,1978410,357924,2749558,2642436,1284712,2380771,1987953,1136180,2695008,1922450,219624,2627749,1467434,1001021,666106,613349,1347241,479801,1819197,560751,909955,222674,585755,1922872,1346411,2807945,2591177,139405,1345492,2640281,1426234,1201290,1885641,2835384,2726404,883190,1442500,2455360,2835419,2142397,2820397,1704589,141152,1132217,2089422,1960870,1000594,218381,1628310,2496149,1926995,1953984,2619590,2770544,1033217,2152053,739175,827737,159503,2394639,2095594,1308371,2848854,2019764,2770498,2605498,1277491,196748,205483,1961942,663494,610462,207752,383992,1873002,231923,2480162,702382,599831,2397544,544863,2781146,1303857,391110,184651,386138,2629053,2094544,1921667,621664,697022,361688,222535,2354386,2605064,348472,1721766,352737,529727,1927705,2770510,2845172,1907754,2114055,1996905,194311,1364779,2490924,1719028,2827976,1413216,1682713,1254180,686515,919803,644955,559034,2703866,1401996,2188531,2665026,624716,507359,1053800,2673196,1371597,2833240,1284714,2162363,2822988,1195703,1802325,2333605,881920,2781172,2770484,558217,601872,2425434,630318,1880478,1793851,253898,2845188,686495,2660846,1822956,934281,2182702,194151,1023435,2185857,598339,1271284,585781,1852883,1621442,1617477,1606505,1033205,995577,1870248,2861749,2364986,1529936,2035962,2861444,1331566,410473,948492,2791252,1921197,2400063,2285533,921482,1631072,1562215,2718163,2753067,1502410,1473340,2195488,1225087,1558249,1339927,2339954,2763258,2301477,2707336,1022854,1580713,1736254,1193755,1713532,2027598,2668714,519002,2668734,2249231,1705519,479044,1992870,1887939,1733186,2731903,1676746,644918,240593,1430419,2711969,1632274,576258,1739477,2718185,2386550,2604741,1494136,2802904,980924,614939,588877,1539037,1916166,1203090,2856335,2680880,1310332,523914,2275199,1400594,1881205,883242,129116,1033235,2461721,2661513,1968776,576709,414136,671223,497845,1221236,928365,1008829,2740035,2822286,1866773,2488157,1033317,1081068,1910561,323747,1969925,2418359,1201266,1957178,1640828,1467450,1446004,1349713,898076,1966340,1433103,1188554,2361772,1412097,2001735,2789389,1766924,2232432,1310356,955173,1708068,1750581,2831450,1081074,1484655,2780519,2627737,78629,2718219,1793090,1082533,928409,667647,2350889,2217962,533400,2846019,1584256,222540,1375670,2085778,2540283,2749552,2601829,670205,2770496,727409,2005789,2138110,2164830,612871,2813704,826702,2070355,2383023,1387617,863225,1830169,1581863,1216170,2789387,895539,2770520,1507897,2093493,2333593,2448840,2485283,450991,554262,1954318,1364767,448889,2134140,2221212,2841456,715612,1390524,2662017,2437352,1185264,1689323,951720,655778,644954,1295409,2516135,2366135,1266256,1494150,1606532,1616490,2407039,2718207,1332467,1699314,1818712,2676514,2788761,2433231,1061123,2819940,1941599,1851485,741894,525606,2082010,2282141,895503,1617479,1932811,614535,1918155,1350252,1405694,536911,2454465,1639042,2418322,2565833,505717,644909,225961,2845160,1822659,1945032,2435813,1197216,75608,1649036,1072283,1449930,1446873,290599,2653215,895537,279524,964752,2023316,2596505,2391030,231013,2111577,1502406,1963212,2053937,229230,2173027,2627735,819000,2033178,694760,2118571,2845174,997357,2770550,1836091,1517545,1597795,2564828,2770492,2603771,1620911,2059319,600362,2586194,505791,2553501,655784,411349,648230,2694086,2029688,1511935,1637922,2436534,2658272,454890,1732554,1596020,2558326,1318680,608742,2848459,1766793,2738842,1449432,2804972,2237634,231019,2398633,2786099,257226,2562672,2201732,2781156,1840101,2774697,719300,751791,2044835,1878261,2083555,196743,2673188,2534953,672808,2455362,1954662,1494965,1094362,269392,2236737,2361581,928413,1203082,908168,129922,1432468,1053792,2845166,2792754,1261681,55295,1431454,2636391,2655786,2653111,2768884,2705470,1654569,1087431,2011776,1287907,686503,2288763,2770578,793635,1781522,523889,971359,1586808,567538,1288115,2770542,657079,2447375,2770494,95260,1974026,2281711,1127708,226325,1058377,2698602,1779730,883248,722728,1261751,2671955,2770576,2688633,792735,2354665,1646119,2157929,1708056,109327,2396767,1990805,1838346,1364735,2378469,2718191,405335,1568228,488457,1982593,660185,2196922,2115693,1598934,2341516,2703484,1714100,2045300,946766,2626976,1562225,2556070,2820229,565398,1019154,883200,2203117,253888,909965,591976,2469834,2687619,347286,2682336,1515467,788521,995372,2845152,559884,751823,1601093,2718179,2845833,790194,1523973,2697402,2211356,1356471,1201282,2112462,1965241,2177687,1909535,1450742,2763248,255962,2860072,2709171,1470868,1777849,2710298,1310374,1669488,2510607,2836846,1518507,2838299,946734,2736887,1134117,2080814,1419680,715234,2044421,2654613,2751581,1745623,938971,2746686,2096220,2705950,2712423,2799085,1900350,2492689,2703241,614815,820079,576260,1092991,2410473,1881991,751787,1762663,1911400,1517541,1541331,2006114,2072053,2447377,1786710,2556088,2258042,576239,1586896,1755522,2234244,1770322,1618917,2781176,944886,2770552,2781160,708199,1322880,1628294,626705,2698979,1782933,454896,1026566,1611695,537731,1779764,832326,2469051,2807949,2714443,2638351,1197603,893742,1856980,2512436,2353902,2386988,1478338,686487,2063238,2781154,2482463,1327601,454406,2058619,2711194,1889781,2078228,123569,2461719,634638,562203,2627991,1948243,541579,927279,411358,2301475,681982,2770556,764530,1419293,1755994,2094425,826163,2582720,2705867,427346,2460027,542714,1337583,497843,1850192,2039187,1287905,2119742,2292029,2405720,1067788,72873,2301563,650292,2206411,1583165,2370871,1261729,670202,232353,2801324,446269,2666721,2291296,1301351,1027732,1825856,2848871,1081072,1168789,2639887,1573686,2116398,1762269,379024,1367512,2172347,835569,2299288,2590810,523909,1903180,1089060,893110,2342549,2417824,2841892,1013938,202690,608670,707373,1220182,2249227,2419619,1693898,2569370,1013946,1335227,2783413,545878,601192,2789383,2467625,610441,2032684,1835463,1103138,2377892,2639664,2513245,450436,1519223,1796397,1827118,953920,2364510,1512185,2353908,249766,1222873,1620921,1371881,2838409,141151,393198,479075,2243674,2580156,511621,1310352,2351336,2595093,2374374,152979,958497,2100745,2695344,554528,552867,2236950,2770560,1555048,2425432,2742259,554556,2101272,2035264,2358525,2851297,751809,1221378,177835,372772,2214359,1628308,2210112,784813,2636913,210894,1369656,1903998,2676374,895525,2378293,572479,2859220,1202562,946762,1973011,1628306,283037,2718211,2482873,1777618,1140889,2505280,2767648,2370327,832330,132714,1650688,2241291,598361,1605396,1008841,1412127,621678,2174785,2439747,2671953,1564575,347289,2816720,388681,827161,2789397,2340546,1241246,576236,2772217,1184484,839789,2535178,1245602,593194,1685478,2214021,1008847,2031798,344297,820085,1922524,2825748,644923,2579213,2513427,996766,2159963,1615108,454901,802027,46302,1762659,392913,1352241,713923,1835921,486797,823736,2037207,2341342,2770506,1586882,1921645,2416133,2717839,1633973,2007835,1266250,2599016,2437669,1222955,2214102,1779740,1911680,1966851,2705712,2843856,2548080,2154628,1586812,1762657,2770524,2190312,470865,1938275,1201264,2770580,2586107,1429655,833653,1403268,2454463,1467436,2341757,1203074,2770508,2337074,1892713,441926,2170135,2770546,1730858,995583,2787780,696834,2090939,2073727,471608,391121,2096717,1195619,1953957,2705486,450916,2729903,543639,2718197,2781138,2550014,2394252,1647819,2359419,2541273,124331,2275799,869606,1720742,2406560,1008837,1295411,486176,988882,759861,751811,529737,2171056,1763690,2386533,572469,2339469,997359,449339,454886,395332,2194462,2686872,2591738,1968640,2515762,2781170,2752625,2683467,2801115,403251,2276749,414126,157372,2297157,2861764,2822195,1586890,1173958,995386,545939,516862,1470888,1681571,1945976,463830,827771,1392218,1511793,702412,1511941,2396057,1692638,290600,1322024,1937305,576233,1532043,2556770,802023,1892795,2649700,2617568,548376,1721006,2487820,1402008,2587664,1886662,2783411,1168761,2039851,1992494,2828442,1136550,427924,447442,828192,1190458,938937,2718213,2845170,1904098,2718177,2262338,1586892,2204667,231009,2770568,2518063,1798983,1617483,1947456,831408,2172345,2127606,863355,1451186,576234,600356,927277,1998965,2838084,575879,1414770,2703561,2280475,1528835,2668720,1261683,519095,2852295,1620925,2751579,1720738,614817,2718169,1384312,2560085,1245576,719298,1787863,2435809,2496151,103187,2599635,1723798,2845158,2789385,644907,624830,1041294,2478891,671225,2016234,1527560,2082658,2668736,2668744,1563171,1586894,2668726,2627755,287370,1858613,1361120,2639131,832344,2394637,2838877,2770518,938943,898134,1783683,450969,1592866,2293837,461921,231026,423861,710491,274030,1018033,1143229,883240,2627741,1554342,283029,2192852,2406023,2077302,334517,839797,1412704,1495792,2688772,2789391,644948,1552423,2698984,2621255,432767,2638356,2279922,1158809,1266226,1405958,2214327,706936,2705484,617166,564244,2659346,2861446,1528291,2356236,1464468,2035882,2360976,344305,684464,2220646,2731509,2515205,157363,854561,2787774,2544554,180660,2745530,1193761,2137596,2668738,1989018,1646131,624745,1573674,786864,1525147,2801546,1044695,2709913,645679,2781144,447452,463829,576230,2705466,618419,1628324,1410313,587052,1903008,2271510,2770502,2010574,2654196,1344210,2087231,1677559,2749560,2835902,1957761,483247,2410475,1316718,2260105,624746,2742267,1891780,2172115,1576919,2031554,509454,548955,1224475,1947860,2718175,217384,140269,2182704,2845162,1785387,551443,2757536,620105,2343713,1211080,1086050,183095,1871987,2534402,241222,802902,783059,1663587,1563267,1158085,1456467,500847,162304,824178,1446690,998581,493238,599621,207762,2695180,2766034,2750977,2651736,1562231,1419684,2111533,2751566,1385372,2562694,572483,558215,2705462,2845156,1085573,2150781,354348,1580719,2496870,1261735,2159200,793458,655797,565406,1284479,2785842,852498,2743197,2195994,1804739,2023988,2660262,2705474,1653003,479102,289594,2372578,1620629,1698991,1481530,1429661,142602,2781152,2257000,1671489,1584244,331368,2022041,779894,590169,2196985,883222,2078637,1467438,1277441,931334,2723880,1380088,2831452,1941152,1183613,1933300,1804144,620101,2712425,549999,1762241,249791,210935,2816691,2115709,1913101,2538787,2198181,117153,928431,465104,1147048,2835316,2026224,1658194,511624,1534117,1650710,2031800,2668742,1984789,955425,1569471,2560902,391117,2718217,427341,1833511,1348734,1937719,2781140,2269660,2781905,1423080,1819420,160180,2295104,1118599,2052099,992103,1562219,2150211,1597525,2567741,1091483,955701,1412714,2795855,96118,2111514,1203078,854525,1601095,1679024,2617897,2140617,1261679,581354,1000586,2525699,1996928,751813,2841890,1692640,1637910,228579,2487818,2034542,2712587,1178841,840244,2375332,1907690,784839,1758493,1235904,367102,2770582,1810341,2705460,1828079,1509292,1628296,2781164,1652541,1462199,1053420,548950,2516462,1690396,2777999,1687684,683420,2806115,1613581,2770574,1762661,2509060,565413,2845168,2333023,2751570,2375747,1779736,637376,545885,2161326,1580721,90463,1369658,702410,2749580,686475,2756036,2781166,2802900,2694950,937487,1762275,1870203,1986716,2280796,1541325,2271502,2241062,1990807,1682711,2511452,2382048,1338435,2858764,2035254,2375406,2322710,722710,2227202,1027521,2255857,2846407,2117112,533407,1713062,2789393,1261235,1108647,1023028,726113,483257,664181,2447379,449311,898138,2821848,123065,2754651,1972837,2781148,1867761,1788843,2095764,454877,1489534,1571912,421101,2263215,888583,1904565,2845176,2786067,950678,539999,545886,1710585,2789395,1115158,1280980,1118591,676947,2666850,2230264,1053790,2705620,2668730,1962103,2816742,1535159,662912,1903182,368256,2103671,1779732,1653494,479056,2457944,1548287,1384324,2830562,1467454,1075855,1965617,2668712,2531074,2038648,2771737,1199369,219349,1437970,2718181,1628302,2618118,1280982,1216166,1630079,2851344,2630063,539997,1266236,1921109,618417,1224479,2627751,2253813,938907,2028818,2745447,1948798,2455531,1203306,2632450,2584535,2129126,2125865,2227051,1109541,1087425,2820988,614541,839795,634682,2680629,1473230,1739465,1685408,2531892,417864,1975682,1963793,273090,2668732,479059,803363,2475351,2858996,585751,1470874,664180,2627753,2152057,2100090,1724094,1797813,2812176,2099245,1316712,1696933,2345127,336167,802057,1108595,2113229,2737468,2635389,530299,2830565,1175202,1611697,1539402,1779738,2560850,2517380,2284913,567622,2770516,1201276,2770536,129925,914031,1941986,1092808,2655909,763623,662717,694756,1333546,576235,1470005,1224481,928399,1562207,708921,2455368,2759430,2812927,2749128,1775581,854549,1261749,2682640,1969083,518132,1691710,2237602,1903178,517682,376156,938987,938989,2700753,2067356,2275075,1697301,2634463,2610396,2149198,1483488,390358,1979620,209698,895475,610471,832332,2584242,2830377,574058,610451,470051,2715134,2009544,1044703,1419480,2333571,1684076,1573688,1949805,1685804,1939032,1562229,2718205,2770566,1277507,2359870,2127880,1823914,2829169,1630071,2512438,1201286,2382834,2792368,1431111,1696357,1745593,2224123,1557281,1560771,1254300,793464,598476,489546,610485,1033339,955717,1818577,1321962,2763260,1467462,500855,1553754,1624161,1975524,2136206,2732688,2674251,1793003,2770548,2770564,1016654,425428,2820381,2016220,1568985,812294,2685192,971339,2822996,1180447,1925203,2751572,621675,2792636,1745591,372777,1431115,2201749,2386296,1197699,2657043,2129308,2194895,938977,971343,1692624,1736262,946758,1108593,1266242,2510161,2645217,146415,2668722,2105628,2174196,1053796,1874778,210933,2060033,1637956,1072289,1419676,1477433,2689139,2728329,2544041,518359,2582142,1896728,434556,2653780,948490,2657299,2858878,721544,2859006,2826822,1013942,708777,2826548,2668724,1613573,2398247,1384328,2685229,110149,1884646,1892664,255891,1959581,2575333,2858630,2811946,707813,1777602,2084381,1108641,893120,1933304,1180457,2820393,400393,2371826,1816017,2022039,449318,2802328,964139,1166875,2660230,1380321,373246,2751872,1147042,1426228,820077,2272963,676969,2770572,621662,2125292,1297096,2560073,1671421,2380520,1134141,1511783,361687,2411088,1902485,2703239,2153417,2717843,884389,1064884,2790426,2718171,2102277,198563,2748065,2668728,576711,2753070,1839763,1733754,1355518,2718161,243632,1885643,359395,226322,655809,1933302,1562221,2804970,1484579,2077160,1628300,2716744,2718203,2215846,456381,2744657,1000582,661769,1310346,2504064,222539,2099224,479074,1620159,2510605,2597120,1731877,1652549,2602589,1762671,849828,547582,2019194,2850187,1868821,644908,2203538,2208332,1600572,1954286,2565831,1864069,2396317,1442472,1000271,1108609,2173291,1969923,2260055,1266252,1844653,450995,1998042,2532657,2357951,702416,1762655,2666863,1658196,2808540,2071622,2770504,2290458,2101967,354354,2719544,2791770,965101,1223575,1026105,1037405,2839959,2164365,576071,361695,1037401,1969929,1307187,1397852,1620169,1013968,1630077,1535366,2277014,1181592,2060909,1795926,621974,2609813,544764,2335600,2264516,1859661,795995,2705492,1322882,1605972,2074018,1979574,1586900,2217958,1910591,2225347,2271156,863911,2689663,1097863,2657303,1960868,1605682,2718215,2712020,2738780,938913,2810316,1628314,46240,2560815,344299,763487,1771799,2824129,2425430,2845180,1980110,1800012,1923917,2020171,1568214,1122899,2845154,1693894,2082994,1794576,717016,576079,1127584,2049291,2289322,1534853,2024332,2013052,1542365,2098688,832294,1819424,550568,2828444,556474,1245612,1823912,1736256,1937462,1422844,290225,1628326,576710,2823261,2614473,1783576,2663572,2198943,1023705,1749138,2257220,2639511,1243488,1944278,624753,2469510,916127,1764157,1819695,676967,1910054,1903964,670203,1577969,2510609,2773865,1333550,2539571,2138638,2835651,2817261,2597118,1595450,2847121,1649367,1900352,883184,938965,1955521,1978330,414123,1346413,174969,1907086,603217,812326,1728589,2778651,832324,458117,2278409,2130483,2627761,1737763,829792,2839622,1465477,1840727,198381,2280023,837126,1502566,807185,2074142,2033182,2691465,1445260,2419621,2293452,152801,909949,416100,594455,2134626,761659,576241,2162498,2851342,196464,1937444,1903188,1600568,114197,644932,2427844,612875,636907,1946372,1791620,284619,1773010,883238,1833509,944888,1948463,883204,2770528,148476,1008871,2751562,1140776,2025616,2485285,601870,334499,1266228,938893,1522943,1544768,1968650,671226,2509879,1663627,1371879,57765,2850637,1915106,1369654,1265120,114185,2003991,142598,1487085,495571,1916168,1708062,2207340,2772284,1908803,2142927,1981591,1367400,1284726,2553507,864142,2087615,2222307,704565,1791550,205760,2838077,2269253,1498791,2189068,1624426,2770514,2241070,2705482,384530,1070626,1507590,1420796,2842236,430980,676965,1955519,2677706,423234,2540541,1746524,1396514,1262714,1338437,2462030,500822,1139308,2821759,500820,1000588,2130615,953938,968640,2569632,1893373,2126571,1076861,147008,129927,557227,518983,117162,507371,660199,1687581,827749,1118593,524223,2092030,2710930,1950312,576237,454895,612005,1623741,2770554,488482,1245610,1662592,190531,2448553,2623894,2644250,283057,784819,2240528,2204499,2832180,2442809,489785,1892270,1310376,1445198,2208354,189038,2825750,1417399,1994816,2668718,2770586,2718183,1659987,2770534,863135,673868,2100768,2527585,561427,2818509,1150460,1659683,1898263,2469835,1333508,974233,1910587,904382,2018888,2861032,2847860,576708,995565,593200,1516954,2360337,1204183,829457,2705468,995569,2770530,1503632,1890539,2007948,1123801,1779734,1346415,644913,2596825,2751575,676963,2271528,2084379,2418951,454442,1613583,610450,2086635,1987426,2401662,1362901,2044069,1586810,1072331,650720,1000584,2293454,635132,1175750,2305281,386132,1324070,1310358,2405770,2076355,2488941,1929430,2751564,612893,2130060,1685806,1979544,154532,1340268,222534,1842101,2515796,802039,2847581,2394643,1408091,898128,735874,2006077,479081,1949823,2705480,2832193,839799,1333524,2596821,1843115,1392060,683424,1310330,2770584,1494152,2554494,2630057,1230398,2717079,1731625,2541275,1997157,2126573,617170,142597,1780012,2556082,1720748,1538128,854533,2717077,372768,1502400,1211056,1620155,2357856,2076381,2770532,742502,1384326,1804136,1576593,2830949,1484843,2765189,2517546,269366,2067786,1838364,465139,993652,1284491,2562696,854555,928387,1685065,2751577,1980844,2184356,2660457,367692,1370707,1003905,1949004,2845164,1701675,2324924,2789399,1230426,2235124,1497472,1111794,2023068,1245580,2601875,964125,1756004,997361,1584248,2854669,2737326,2718221,162252,1586884,827759,2732753,1130308,1204059,258646,1387687,1936840,2151463,531856,290970,964151,1013958,1281465,2861794,893841,2820395,2782386,1292008,2204631,2632473,1206198,2438621,1584246,1401994,1412380,870849,1863437,2718201,2038275,2126183,1663615,1577036,2759434,1708052,1266238,2113006,1440112,2698988,523883,146417,1266258,2770522,480594,259696,1546742,1523975,2718209,660183,928429,1605360,2465312,2455209,2648150,1859711,2652994,2179030,601208,1756002,1562211,854535,2718173,997355,2631898,702374,2770490,1953758,415353,1230438,1748261,1559436,2352055,426964,1207628,1318038,1019536,1211040,2565835,1762669,636919,1628510,1999253,1925241,134389,2152424,1459755,336154,2627733,119179,150764,157368,26398,2719862,344294,1562223,450968,2705490,2826824,1373283,2470095,1601784,2763653,832300,2476747,1806291,2718193,1924403,2341533,1844092,712526,2160597,1793321,2060907,2647029,1213340,210924,825855,1665465,2781162,1962490,413555,2045304,196299,1384310,2022037,1529916,2565837,2790168,2417484,1333552,379050,2789174,666100,2703237,400002,2004099,588266,537470,2772165,2705472,2023161,1911406,2159339,2292656,2705478,2781168,1881902,1260345,955713,270170,2270101,961099,725862,2705476,2781150,2770570,1960461,1316752,2083707,2065382,1153287,2661547,1652553,1791508,1826460,1844035,1795630,1779726,650900,954839,643294,2573792,745767,2383726,2056517,1766922,1254190,259715,2583533,2619592,2770482,2787772,654931,2770526,1732103,2718857,2584416,2563683,1538228,1310763,1668314,2098336,1463465,1230392,2195666,44869,2023736,523920,1333564,2776395,2289655,1151428,2862197,598342,1518123,2202459,2749981,832328,854547,2814838,1740283,2718199,1136548,2657301,1393400,825853,2668740,1053514,1962470,671224,2252164,706932,937085,1284291,2523307,2047663,2751215,1051954,2770538,1579690,2845178,1749268,2033956,2627743,2426658,2139333,2104847,585763,2744681,1168771,605687,2781174,2822981,1587874,2473404,399639,802035,2770540,1942666,2736645,394251,2624041,1872982,2668716,2335602,2536938,427354,1337786,2828507,243624,2179906,160179,395069,715240,953930,1237851,1989524,2827958,2454137,2770486,635031,1318186,1400112,1516956,1525145,1998356,2657284,1833880,1114069,2192854,576231,1762665,2853311,1201260,1013962,1612944,2671297,405915,938917,2718189,2668640,1569817,2592701,537732,1814019,124326,2340571,1559171,727435,2459375,802067,1777128,2472329,1394568,2830375,1786884,336156,542468,621665,1562233,2217960,500587,1310334,2718187,367091,1778087,702370,1647825,2822994,2292610,2718195,1764135,1663623,465106,2418326,554551,2653690,1655294,644920,784831,2148698,239718,2770558,2781142,686559,2035328,1405930,2403647,2411579,1631086,2148570,798042,2705488,2563685,817234,1429659,119183,347280,671228,948484,2705464,1021435,534901,1412710,1319841,1562217,2164929,2278669,2691058,519118,1393402,654930,1790220,1378319,1266230,2066116,2627739,2751568,2178031,804116,2821757,1347173,469225,1628958,2718167,1918583,722722,895489,2455364,812320,1259482,1394835,1960457,2168306,1589645,393193}'::integer[]))
Planning time : 18.321 ms
Execution time : 84,527.525 ms