explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JZG

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 4,639.666 ↑ 1.0 20 1

Limit (cost=1,144,296.99..1,144,297.04 rows=20 width=290) (actual time=4,639.664..4,639.666 rows=20 loops=1)

  • Buffers: shared hit=61017 read=33830, temp read=24955 written=24701
2. 58.050 4,639.663 ↑ 11,334.8 20 1

Sort (cost=1,144,296.99..1,144,863.72 rows=226,695 width=290) (actual time=4,639.662..4,639.663 rows=20 loops=1)

  • Sort Key: public.katello_rpms.name, public.katello_rpms.epoch, public.katello_rpms.version_sortable, public.katello_rpms.release_sortable, public.katello_rpms.id
  • Sort Method: top-N heapsort Memory: 35kB
  • Buffers: shared hit=61017 read=33830, temp read=24955 written=24701
3. 109.086 4,581.613 ↑ 1.5 148,260 1

Hash Join (cost=1,004,961.67..1,138,264.71 rows=226,695 width=290) (actual time=3,385.928..4,581.613 rows=148,260 loops=1)

  • Hash Cond: (public.katello_rpms.id = public.katello_rpms.id)
  • Buffers: shared hit=61012 read=33830, temp read=24955 written=24701
4. 139.299 4,360.507 ↑ 1.5 148,260 1

Unique (cost=981,602.03..1,098,609.70 rows=226,695 width=4) (actual time=3,273.429..4,360.507 rows=148,260 loops=1)

  • Buffers: shared hit=51609 read=33830, temp read=15298 written=15298
5. 325.503 4,221.208 ↑ 1.7 2,759,714 1

Merge Join (cost=981,602.03..1,086,550.58 rows=4,823,648 width=4) (actual time=3,273.428..4,221.208 rows=2,759,714 loops=1)

  • Merge Cond: (public.katello_rpms.id = katello_repository_rpms.rpm_id)
  • Buffers: shared hit=51609 read=33830, temp read=15298 written=15298
6. 50.549 50.549 ↑ 1.0 226,695 1

Index Only Scan using katello_rpms_pkey on katello_rpms (cost=0.00..19,997.82 rows=226,695 width=4) (actual time=0.030..50.549 rows=226,695 loops=1)

  • Heap Fetches: 226695
  • Buffers: shared hit=49677
7. 218.123 3,845.156 ↑ 1.7 2,759,714 1

Materialize (cost=981,600.85..1,005,719.09 rows=4,823,648 width=4) (actual time=3,273.390..3,845.156 rows=2,759,714 loops=1)

  • Buffers: shared hit=1932 read=33830, temp read=15298 written=15298
8. 1,929.093 3,627.033 ↑ 1.7 2,759,714 1

Sort (cost=981,600.85..993,659.97 rows=4,823,648 width=4) (actual time=3,273.384..3,627.033 rows=2,759,714 loops=1)

  • Sort Key: katello_repository_rpms.rpm_id
  • Sort Method: external merge Disk: 37792kB
  • Buffers: shared hit=1932 read=33830, temp read=15298 written=15298
9. 546.024 1,697.940 ↑ 1.7 2,759,714 1

Hash Join (cost=33,034.68..248,283.59 rows=4,823,648 width=4) (actual time=28.551..1,697.940 rows=2,759,714 loops=1)

  • Hash Cond: (katello_repository_rpms.repository_id = public.katello_repositories.id)
  • Buffers: shared hit=1932 read=33830
10. 797.517 1,140.783 ↑ 1.0 4,823,648 1

Hash Semi Join (cost=20,546.11..182,634.87 rows=4,823,648 width=12) (actual time=17.406..1,140.783 rows=4,823,648 loops=1)

  • Hash Cond: (katello_repository_rpms.repository_id = public.katello_repositories.id)
  • Buffers: shared hit=1773 read=33830
11. 325.872 325.872 ↑ 1.0 4,823,648 1

Seq Scan on katello_repository_rpms (cost=0.00..83,704.48 rows=4,823,648 width=8) (actual time=0.004..325.872 rows=4,823,648 loops=1)

  • Buffers: shared hit=1638 read=33830
12. 0.370 17.394 ↑ 1.0 2,797 1

Hash (cost=20,511.15..20,511.15 rows=2,797 width=4) (actual time=17.394..17.394 rows=2,797 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 99kB
  • Buffers: shared hit=135
13. 17.024 17.024 ↑ 1.0 2,797 1

Seq Scan on katello_repositories (cost=0.00..20,511.15 rows=2,797 width=4) (actual time=0.002..17.024 rows=2,797 loops=1)

  • Filter: ((id = ANY ('{3291,3292,2430,1184,1181,1183,14,7,1,5,3,6,4,115,2,15,186,10,21,1077,9,117,1182,11,2431,1180,22,2448,188,2154,1076,190,19,23,192,1240,846,1238,124,1243,1242,1241,126,119,128,121,120,114,116,123,847,3461,2432,2433,2434,2435,2436,130,3462,132,66,1662,2437,65,74,56,55,848,58,59,57,62,63,60,61,1247,1246,1245,2442,2443,2444,2441,2445,2446,2447,135,68,1244,3463,3464,3465,3466,3467,2440,1127,2958,1071,3468,134,2449,136,2450,2469,2470,2471,2472,1929,2207,52,54,53,2473,2474,2475,2476,2477,1037,1036,1035,1034,1033,1032,1031,2451,3469,3470,2454,2455,2456,2457,2458,2459,2460,2461,2462,2463,2464,2465,194,3471,196,198,200,2466,2467,2468,2452,2453,2478,2479,154,156,158,1030,160,1029,162,1028,164,1027,166,3330,168,103,170,2480,172,72,174,78,2481,111,2482,2483,2484,2485,3472,202,2486,2487,204,176,2491,178,2492,180,2493,182,110,184,104,2488,2489,2490,206,2494,208,2495,210,2496,212,2497,214,2959,216,218,220,222,224,226,2960,3473,3474,3475,3476,3477,3478,228,3479,230,232,2501,234,2502,236,2503,238,2504,240,2505,242,2506,244,2507,246,2508,2509,2510,2511,2500,248,2512,250,2513,252,2514,274,3480,276,3481,278,3482,280,282,284,286,2515,2516,2517,254,3146,256,3483,258,3148,260,1930,3484,262,3150,264,3485,266,3152,268,302,3486,3487,3488,270,3154,272,3489,288,3490,835,290,3491,292,3492,294,3493,296,298,300,3153,3155,3494,304,3495,306,3496,308,3497,310,3498,312,3499,314,3500,316,3501,318,3502,320,3503,3504,322,3505,324,3506,326,3507,328,3508,330,3509,332,3510,334,3511,336,3160,338,3512,340,342,341,343,344,3513,346,3514,348,3515,350,352,354,356,358,3400,360,3167,362,3166,364,3516,366,3517,368,3518,370,3171,372,281,374,3172,376,275,2518,2519,2520,2521,2522,3519,2523,3170,378,379,380,393,382,383,384,3520,386,388,392,385,387,389,2524,2203,704,2961,706,479,2962,708,2963,710,2964,712,390,2302,394,2525,396,2204,3521,395,397,2528,2529,2530,2531,2532,2533,3430,2534,2535,2536,2537,2542,3522,414,416,2538,418,2539,420,2540,422,2541,424,2543,426,2546,960,428,2526,429,2527,430,487,2544,431,2545,432,3523,3524,3525,2547,3526,2548,449,451,453,455,3175,457,459,461,463,465,485,3173,2227,2228,2229,2230,2231,467,469,471,277,473,3174,475,279,477,481,483,287,3176,283,3177,285,2233,2234,2232,489,2236,491,2549,493,495,497,499,501,503,2965,505,714,507,2966,509,716,511,2304,2550,2551,2237,513,2238,515,2235,517,3178,519,3179,521,3180,523,525,720,527,529,3181,531,3182,2552,2553,2554,533,2555,535,2556,537,2557,539,2558,541,2559,543,2560,545,2561,2562,2563,2564,2565,2566,2567,2568,2569,2570,2571,2572,2573,2574,2575,2576,2577,2967,718,2968,2969,722,2970,574,577,3183,579,3184,581,598,583,600,585,1208,587,1215,589,2118,591,1214,593,1213,595,3419,1212,597,1211,599,601,603,2279,605,3185,607,289,609,3186,611,291,613,3187,615,293,617,921,381,619,920,621,2583,623,2584,625,2585,627,2586,629,2587,631,3188,633,295,635,3189,637,297,919,3190,1746,299,2588,2589,2590,2591,2592,2593,327,2594,329,2595,3411,331,2596,333,2597,335,2401,2598,337,2599,2300,3191,301,3192,2308,303,2309,3193,683,2303,685,2301,687,684,689,686,688,305,691,3194,693,307,695,3195,697,309,699,3196,701,2305,2314,2322,703,311,705,3197,707,313,709,3198,711,315,713,3199,715,717,719,721,339,723,2310,725,724,317,727,3200,729,319,731,3201,733,321,735,3202,737,323,739,3203,741,325,743,745,2213,747,2214,749,2215,751,2216,753,2217,755,757,759,761,763,2341,2344,2346,2342,746,748,765,2218,767,769,2600,771,2601,773,2602,775,2603,777,2604,779,1126,781,1125,783,810,809,2219,2220,2221,2222,2223,2224,2225,2226,802,801,800,799,798,797,796,795,807,806,805,804,803,3204,3205,3206,3207,3208,3209,3210,3211,3212,3213,3214,3215,3216,3217,3218,3219,1210,1763,813,814,815,3220,3221,3222,3223,2311,2312,2313,2318,2320,2317,2316,2315,2321,2319,871,870,869,868,867,866,865,3224,3225,3226,3227,3228,3229,3230,3231,872,3410,3418,2605,2606,391,2350,2349,3421,3422,3423,2498,2607,2608,2609,2610,2611,2612,2613,2614,2615,2616,2617,2618,2619,129,2620,125,2621,137,2622,2623,133,3232,3233,3234,3235,3236,3237,3238,3239,3429,2352,2353,2624,127,2625,131,2626,2627,2628,2629,2630,2631,2632,2633,3240,3241,3242,197,3243,195,3244,201,3245,199,3246,189,932,931,930,929,928,927,926,925,923,3247,187,3248,193,3249,191,1209,1207,1198,1197,1196,942,952,951,950,949,948,947,946,945,944,943,2208,2205,2206,2211,2212,2209,2210,3250,3251,970,969,968,967,966,965,964,963,981,982,983,984,985,3252,3253,3254,3255,3256,3257,3258,3259,3260,3261,3262,3263,3264,3265,3266,1025,548,1024,1023,1022,1021,1020,1019,1018,1017,1011,1016,1013,1015,1014,1046,2634,2635,2636,2637,2638,2639,2640,2641,2642,2643,2644,3267,3268,3269,3270,1047,2645,2646,2647,2649,2650,2652,2655,2657,2659,2661,1195,1091,1090,791,790,789,788,787,786,785,3271,3272,3273,3274,3275,3331,1111,2306,836,837,834,2354,2648,2651,2653,1138,1137,1136,1135,1134,1133,1132,1131,1130,1178,1684,70,71,8,1900,1148,1147,1146,1145,1144,1143,1142,1141,1140,1139,1149,1150,1151,3280,3281,3282,3283,3279,1172,1171,1173,1170,1239,2654,2656,2658,2660,2663,2665,2667,2669,2671,2673,1485,961,3042,812,811,3284,3285,3286,3287,3288,118,1683,3378,3379,3380,1262,1261,1260,1259,1258,3381,576,2031,1206,1205,1204,1203,1202,1201,1200,1199,2662,2664,2666,2668,2670,2672,2676,2678,2679,2680,2681,2683,2684,1010,3289,3290,1012,2674,2708,2709,2710,2711,2712,1288,1287,1286,1285,1284,3293,578,3294,580,3295,582,3296,584,2675,2677,2682,345,1179,2685,347,2688,349,2693,959,351,2695,353,2696,355,2697,357,2698,359,2699,361,2700,363,2701,365,2686,2687,2689,2690,2691,2692,2694,1323,1324,1325,1326,1327,1328,1329,1330,1331,1332,1333,1334,1335,1336,1337,1338,1339,1340,1341,1342,1343,1344,1345,1346,1347,1348,1349,1350,1351,1352,1353,1354,1355,1356,1399,1400,1401,1402,1357,1358,1359,1360,1361,1362,1363,1364,1365,1366,1367,1368,1369,1370,1371,1372,1373,1374,1375,1376,1377,1378,1379,1380,1381,1382,1383,1384,1385,1386,1387,1388,1389,1390,1391,1392,1393,1394,1395,1396,1397,1398,3297,586,3298,588,3299,590,3300,592,2702,367,2703,369,2704,371,2705,373,2706,375,2707,1403,1404,1405,1406,1407,1408,1409,1410,1411,1412,1413,1414,1415,1416,1417,1418,1419,1420,1421,1422,1423,1424,1425,958,1426,1427,1428,1429,1430,1431,1432,1433,1434,1435,1436,1437,1438,377,918,917,916,915,914,913,912,2971,957,956,955,954,953,2974,2713,3301,2714,594,2715,3302,2716,596,2717,3303,2718,2719,2720,2721,1129,2767,2768,2769,2770,2771,2045,858,857,1486,1487,1488,1489,1490,1491,1492,1493,1494,1495,1496,1497,1498,1499,1500,1501,1502,1503,1504,1505,1506,1507,1508,1509,1510,1511,1512,1513,1514,1515,1516,1517,1518,1519,1520,1521,1522,1523,1524,1525,1526,1527,1528,1529,1530,1531,1532,1533,1534,1535,1536,1537,1538,1539,1540,1541,1542,1543,1544,1545,1546,1547,1548,1549,1550,1551,1552,1553,1554,1555,1556,1557,1558,1559,1560,1561,1562,1563,1564,1565,1566,1567,1568,1569,1570,1571,1572,1573,1574,1575,1576,1577,1578,1579,1580,1581,1582,1583,1584,1585,1586,1587,1644,1588,1589,1590,1591,1592,1593,1594,1595,1596,1597,1598,1599,1600,1601,1602,1603,1604,1605,1606,1607,1608,1609,1610,1611,1612,1613,1614,1615,1616,1617,1618,1619,1620,2323,2324,2325,2419,2420,2418,2422,2423,2424,2421,3431,558,3432,3433,556,3434,562,3435,1621,1623,1625,1627,1629,1631,1632,1633,1634,1635,1636,1637,1638,1639,1640,1641,2326,1643,2327,1645,2328,1647,2329,1649,2330,1651,2331,2335,1653,2332,1655,1657,1661,1659,1660,1671,1664,1663,1665,1667,1669,1666,1673,1668,1670,2333,2334,1675,2336,1677,2337,1679,2338,1681,2339,2340,2722,2723,2724,2725,2726,2727,2728,1764,1765,2729,2730,2731,2732,2733,2734,2735,2736,2737,2738,2739,2740,2741,2742,2743,2744,2745,2746,2747,2748,2749,2750,2815,2751,2752,2753,2754,2755,2756,2757,2758,2759,113,67,105,560,2299,1719,1720,2760,2761,2762,2763,2764,2765,2766,1257,1256,1255,1254,1253,1252,1251,1250,1249,107,106,27,28,2772,2773,2774,2775,2776,2777,2778,2779,2780,2781,2782,2783,2784,2785,1248,2973,108,25,26,73,2786,2787,2788,2789,2790,2791,2816,2792,2793,2794,2795,2796,2797,2798,2799,75,76,77,2402,2800,2801,2802,2803,2804,2813,2814,1723,79,2817,2818,2819,80,81,82,83,1724,2805,169,1715,1717,1721,1718,1725,2806,1727,155,1729,2807,1731,163,1743,2808,1745,159,1716,1722,1733,2809,1735,157,1737,2810,1739,167,1741,2811,161,2812,856,1742,3277,1004,1003,1005,1002,1008,3460,165,1747,2348,1749,2347,1751,2345,1753,1755,2343,1757,2921,1759,2922,1761,2923,1762,2924,2925,2820,1766,2821,1767,2822,1768,2823,1769,2824,1771,1642,1772,1773,1646,1774,1648,1775,1650,2975,1776,1652,1777,1654,1778,1656,1779,1780,1781,1782,1783,1784,1785,1672,1786,1674,1787,2825,1676,1788,1678,1789,1680,1790,1682,1791,1792,2826,2827,1927,2828,2829,2830,2831,2832,2833,2834,1803,1804,1805,1806,1807,1808,2835,1809,2836,1810,2837,1811,2838,1813,1814,2839,1815,1758,1816,1817,1818,1819,1820,1821,1822,2840,1824,2841,2842,2843,2844,2845,2846,1844,1802,1837,1838,2847,1839,1840,1841,1842,1843,1845,1846,1812,1847,1848,1849,1850,1851,1852,1853,1854,1855,1856,1857,1858,1859,1860,1939,1940,2848,1861,1862,1863,1864,1865,2849,1866,1867,2850,1868,1869,1870,1871,1872,1873,1874,1128,1875,1876,1877,1878,1879,1880,1881,1882,1883,1884,1885,1886,1887,1888,1889,1890,1941,1891,1892,1893,1894,1895,1896,1897,1898,2851,2852,2853,2854,1901,1904,1905,2855,1907,1908,1909,1910,1911,1912,1913,1928,1914,1915,1916,1942,1906,1903,1917,1918,1919,1920,1921,1922,1923,1924,1925,1926,1931,1932,1933,1934,1935,1936,1937,1938,2856,2857,2858,2859,2860,2861,2862,2863,2864,2865,2866,2867,2868,1943,1944,1945,1946,1947,1948,1949,1950,1951,1952,1953,1954,2869,2870,2871,2872,2873,2874,2875,2876,2877,2878,2879,2880,2881,2882,2883,2884,2885,1966,1967,1968,1969,1970,1971,1972,1973,2886,2887,2888,1974,855,1975,854,1976,853,1978,852,1979,851,1980,850,1981,849,1982,3304,1983,1026,1984,3305,1985,1194,1986,1987,1988,2889,2890,2891,2892,2893,2894,2895,2896,2897,2898,2899,2900,2901,2902,2903,2904,2905,2906,2907,2908,2909,1990,1991,1992,1993,2910,1994,2911,1995,2912,1996,1997,2913,1998,2914,1999,2915,2000,2916,2001,2917,2918,2002,2919,2003,2004,2005,2920,2006,2976,2007,2977,2008,726,2009,2010,2978,2011,2979,730,2034,2046,2047,2048,2049,2050,2051,2052,2053,2054,2055,612,602,2033,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2926,2927,2928,2056,2057,2058,2059,2060,2061,2062,2063,2064,2065,2066,2067,2929,2930,2931,2932,2933,2934,2935,2936,2937,904,903,911,2938,2939,2941,2942,2943,2944,2945,2946,2947,2948,2949,2950,2951,2952,2953,2954,2955,2956,2957,2107,1193,2108,1192,2109,1191,2110,1190,2111,1189,2112,1188,2113,1187,2114,1186,2115,1185,2116,3306,2117,3390,2142,2095,2096,2097,2098,2099,2100,2101,2102,2103,2104,2105,3307,2119,2120,3308,2121,3309,2122,3310,2123,3311,2124,728,2125,604,2126,3312,2127,606,2128,3313,2129,608,2130,2131,2132,3314,2133,610,2134,3315,2135,614,3316,2136,616,2137,3317,2138,618,2139,3318,2140,1089,1088,1087,1086,1085,1084,1083,1082,1081,1080,2972,620,2143,3319,2144,622,2145,3320,2146,624,2147,3321,626,2148,3322,2149,3327,628,2150,2151,2152,2980,732,2981,734,2982,736,2983,738,2984,740,2985,742,2986,744,2987,2988,2989,750,2990,752,2991,754,2992,756,2993,758,2994,760,2995,762,2996,764,2997,2141,3323,630,3324,632,3325,634,3326,636,1124,1123,1122,1121,941,2998,2999,940,939,938,937,936,935,934,933,924,922,3000,1110,792,1109,1108,1107,1106,1105,1104,1103,1102,1101,1100,1099,1098,1097,1096,1095,1094,1093,1092,3001,1278,1277,1276,1275,1274,1273,1272,1271,1270,1269,1268,1267,1266,1265,1264,1263,3002,3003,766,3004,768,3005,770,3006,772,3007,774,3008,776,3009,778,3010,780,3011,782,3012,784,3013,2153,638,3328,2068,112,3014,3015,3016,1120,1119,1118,1117,1116,1115,1114,1113,1112,3017,1283,1282,1281,1280,1279,3018,3019,3020,879,3021,3022,3023,3024,3025,3026,3027,3028,3029,3030,3031,3032,3033,3034,3035,3036,3037,3038,3039,3040,794,793,3041,962,3043,3044,3045,3046,3047,3048,3049,3050,3051,3052,3053,3054,3055,3056,3057,3058,3059,3060,3061,3062,3063,3064,3065,878,808,3066,980,979,978,977,976,975,974,973,972,971,3067,3068,3069,3070,3071,3072,3073,3074,3075,3076,3077,3078,3079,3080,3081,3082,3083,3084,3085,3086,3087,3088,3089,3090,3091,3092,3093,3094,3095,3096,3097,3098,3099,3100,3101,3102,3103,3104,3105,3106,3107,3108,3109,3110,3111,3112,3113,816,817,818,819,820,877,821,822,823,824,825,826,827,828,829,830,831,832,833,3114,986,987,988,989,990,991,992,993,994,995,996,997,998,999,1000,1001,3115,1152,1153,1154,1155,1156,1157,1158,1159,1160,1161,1162,1163,1164,1165,1166,1167,1168,1169,3116,3118,3120,3122,3124,861,3130,3135,3134,3133,3132,3131,3139,3138,3137,3136,876,875,874,873,864,863,862,860,859,3329,1040,1045,1044,1043,1042,1041,1039,1038,69,1902,1714,3391,1740,3392,1728,3393,1726,1760,3394,3395,1736,3396,1730,3397,1734,3398,1732,3364,3372,1630,3373,3370,3369,3377,3371,1628,3374,1622,3375,1626,3376,1624,3382,3383,3384,3385,3386,3387,3388,3389,1738,3399,1823,3401,1748,3402,1750,3403,1752,3404,1754,3405,1756,3406,3407,3408,1744,3409,3412,3420,3117,3413,3119,3414,3121,3415,3123,3416,3417,1658,3125,842,2250,2439,2438,3129,3128,3127,3126,2351,2499,3140,3424,3147,3425,3149,3426,3151,3427,843,3428,3440,3441,3442,3443,3444,564,3445,570,3446,2249,3159,3158,3157,3156,3169,3168,2156,2155,845,844,550,3436,554,3437,552,3438,1834,3439,3165,3164,3163,3162,3161,840,838,839,2307,841,566,3447,568,3448,572,3449,2278,1176,1174,692,1175,3278,1177,1006,1007,3276,1009,3450,698,3451,700,3452,702,3453,3454,3455,3456,690,3457,3458,694,3459,696,2106,2940,902,910,909,908,907,906,905,1072,1070,1079,1078,1075,1074,1073}'::integer[])) OR (id = ANY ('{14,14,7,7,1,1,1,5,5,3,3,3,6,6,4,4,4,115,115,115,115,2,2,2,15,15,15,10,21,21,21,21,9,117,117,117,117,11,22,22,22,22,19,23,23,23,23,119,119,119,119,121,121,121,121,120,120,120,120,114,114,114,114,116,116,116,116,123,123,123,66,66,66,66,1662,65,65,65,65,74,74,74,74,74,56,55,58,59,57,62,62,63,60,61,68,68,68,68,52,54,53,72,72,72,72,72,78,78,78,78,78,111,111,110,110,110,104,104,104,70,70,70,70,70,71,71,71,71,71,8,8,1900,1900,118,118,118,118,1661,113,67,67,67,67,105,105,105,107,107,107,106,106,106,27,27,27,27,28,28,28,28,108,108,108,25,25,25,25,26,26,26,26,73,73,73,73,73,75,75,75,75,75,76,76,76,76,76,77,77,77,77,77,79,79,79,79,79,80,80,80,80,80,81,81,81,81,81,82,82,82,82,83,83,83,83,1901,1904,1905,1906,1903,112,69,69,69,69,1902,1714}'::integer[])) OR (id = ANY ('{3291,3292,2430,1184,1181,1183,14,7,1,5,3,6,4,115,2,15,186,10,21,1077,9,117,1182,11,2431,1180,22,2448,188,2154,1076,190,19,23,192,1240,846,1238,124,1243,1242,1241,126,119,128,121,120,114,116,123,847,3461,2432,2433,2434,2435,2436,130,3462,132,66,1662,2437,65,74,56,55,848,58,59,57,62,63,60,61,1247,1246,1245,2442,2443,2444,2441,2445,2446,2447,135,68,1244,3463,3464,3465,3466,3467,2440,1127,2958,1071,3468,134,2449,136,2450,2469,2470,2471,2472,1929,2207,52,54,53,2473,2474,2475,2476,2477,1037,1036,1035,1034,1033,1032,1031,2451,3469,3470,2454,2455,2456,2457,2458,2459,2460,2461,2462,2463,2464,2465,194,3471,196,198,200,2466,2467,2468,2452,2453,2478,2479,154,156,158,1030,160,1029,162,1028,164,1027,166,3330,168,103,170,2480,172,72,174,78,2481,111,2482,2483,2484,2485,3472,202,2486,2487,204,176,2491,178,2492,180,2493,182,110,184,104,2488,2489,2490,206,2494,208,2495,210,2496,212,2497,214,2959,216,218,220,222,224,226,2960,3473,3474,3475,3476,3477,3478,228,3479,230,232,2501,234,2502,236,2503,238,2504,240,2505,242,2506,244,2507,246,2508,2509,2510,2511,2500,248,2512,250,2513,252,2514,274,3480,276,3481,278,3482,280,282,284,286,2515,2516,2517,254,3146,256,3483,258,3148,260,1930,3484,262,3150,264,3485,266,3152,268,302,3486,3487,3488,270,3154,272,3489,288,3490,835,290,3491,292,3492,294,3493,296,298,300,3153,3155,3494,304,3495,306,3496,308,3497,310,3498,312,3499,314,3500,316,3501,318,3502,320,3503,3504,322,3505,324,3506,326,3507,328,3508,330,3509,332,3510,334,3511,336,3160,338,3512,340,342,341,343,344,3513,346,3514,348,3515,350,352,354,356,358,3400,360,3167,362,3166,364,3516,366,3517,368,3518,370,3171,372,281,374,3172,376,275,2518,2519,2520,2521,2522,3519,2523,3170,378,379,380,393,382,383,384,3520,386,388,392,385,387,389,2524,2203,704,2961,706,479,2962,708,2963,710,2964,712,390,2302,394,2525,396,2204,3521,395,397,2528,2529,2530,2531,2532,2533,3430,2534,2535,2536,2537,2542,3522,414,416,2538,418,2539,420,2540,422,2541,424,2543,426,2546,960,428,2526,429,2527,430,487,2544,431,2545,432,3523,3524,3525,2547,3526,2548,449,451,453,455,3175,457,459,461,463,465,485,3173,2227,2228,2229,2230,2231,467,469,471,277,473,3174,475,279,477,481,483,287,3176,283,3177,285,2233,2234,2232,489,2236,491,2549,493,495,497,499,501,503,2965,505,714,507,2966,509,716,511,2304,2550,2551,2237,513,2238,515,2235,517,3178,519,3179,521,3180,523,525,720,527,529,3181,531,3182,2552,2553,2554,533,2555,535,2556,537,2557,539,2558,541,2559,543,2560,545,2561,2562,2563,2564,2565,2566,2567,2568,2569,2570,2571,2572,2573,2574,2575,2576,2577,2967,718,2968,2969,722,2970,574,577,3183,579,3184,581,598,583,600,585,1208,587,1215,589,2118,591,1214,593,1213,595,3419,1212,597,1211,599,601,603,2279,605,3185,607,289,609,3186,611,291,613,3187,615,293,617,921,381,619,920,621,2583,623,2584,625,2585,627,2586,629,2587,631,3188,633,295,635,3189,637,297,919,3190,1746,299,2588,2589,2590,2591,2592,2593,327,2594,329,2595,3411,331,2596,333,2597,335,2401,2598,337,2599,2300,3191,301,3192,2308,303,2309,3193,683,2303,685,2301,687,684,689,686,688,305,691,3194,693,307,695,3195,697,309,699,3196,701,2305,2314,2322,703,311,705,3197,707,313,709,3198,711,315,713,3199,715,717,719,721,339,723,2310,725,724,317,727,3200,729,319,731,3201,733,321,735,3202,737,323,739,3203,741,325,743,745,2213,747,2214,749,2215,751,2216,753,2217,755,757,759,761,763,2341,2344,2346,2342,746,748,765,2218,767,769,2600,771,2601,773,2602,775,2603,777,2604,779,1126,781,1125,783,810,809,2219,2220,2221,2222,2223,2224,2225,2226,802,801,800,799,798,797,796,795,807,806,805,804,803,3204,3205,3206,3207,3208,3209,3210,3211,3212,3213,3214,3215,3216,3217,3218,3219,1210,1763,813,814,815,3220,3221,3222,3223,2311,2312,2313,2318,2320,2317,2316,2315,2321,2319,871,870,869,868,867,866,865,3224,3225,3226,3227,3228,3229,3230,3231,872,3410,3418,2605,2606,391,2350,2349,3421,3422,3423,2498,2607,2608,2609,2610,2611,2612,2613,2614,2615,2616,2617,2618,2619,129,2620,125,2621,137,2622,2623,133,3232,3233,3234,3235,3236,3237,3238,3239,3429,2352,2353,2624,127,2625,131,2626,2627,2628,2629,2630,2631,2632,2633,3240,3241,3242,197,3243,195,3244,201,3245,199,3246,189,932,931,930,929,928,927,926,925,923,3247,187,3248,193,3249,191,1209,1207,1198,1197,1196,942,952,951,950,949,948,947,946,945,944,943,2208,2205,2206,2211,2212,2209,2210,3250,3251,970,969,968,967,966,965,964,963,981,982,983,984,985,3252,3253,3254,3255,3256,3257,3258,3259,3260,3261,3262,3263,3264,3265,3266,1025,548,1024,1023,1022,1021,1020,1019,1018,1017,1011,1016,1013,1015,1014,1046,2634,2635,2636,2637,2638,2639,2640,2641,2642,2643,2644,3267,3268,3269,3270,1047,2645,2646,2647,2649,2650,2652,2655,2657,2659,2661,1195,1091,1090,791,790,789,788,787,786,785,3271,3272,3273,3274,3275,3331,1111,2306,836,837,834,2354,2648,2651,2653,1138,1137,1136,1135,1134,1133,1132,1131,1130,1178,1684,70,71,8,1900,1148,1147,1146,1145,1144,1143,1142,1141,1140,1139,1149,1150,1151,3280,3281,3282,3283,3279,1172,1171,1173,1170,1239,2654,2656,2658,2660,2663,2665,2667,2669,2671,2673,1485,961,3042,812,811,3284,3285,3286,3287,3288,118,1683,3378,3379,3380,1262,1261,1260,1259,1258,3381,576,2031,1206,1205,1204,1203,1202,1201,1200,1199,2662,2664,2666,2668,2670,2672,2676,2678,2679,2680,2681,2683,2684,1010,3289,3290,1012,2674,2708,2709,2710,2711,2712,1288,1287,1286,1285,1284,3293,578,3294,580,3295,582,3296,584,2675,2677,2682,345,1179,2685,347,2688,349,2693,959,351,2695,353,2696,355,2697,357,2698,359,2699,361,2700,363,2701,365,2686,2687,2689,2690,2691,2692,2694,1323,1324,1325,1326,1327,1328,1329,1330,1331,1332,1333,1334,1335,1336,1337,1338,1339,1340,1341,1342,1343,1344,1345,1346,1347,1348,1349,1350,1351,1352,1353,1354,1355,1356,1399,1400,1401,1402,1357,1358,1359,1360,1361,1362,1363,1364,1365,1366,1367,1368,1369,1370,1371,1372,1373,1374,1375,1376,1377,1378,1379,1380,1381,1382,1383,1384,1385,1386,1387,1388,1389,1390,1391,1392,1393,1394,1395,1396,1397,1398,3297,586,3298,588,3299,590,3300,592,2702,367,2703,369,2704,371,2705,373,2706,375,2707,1403,1404,1405,1406,1407,1408,1409,1410,1411,1412,1413,1414,1415,1416,1417,1418,1419,1420,1421,1422,1423,1424,1425,958,1426,1427,1428,1429,1430,1431,1432,1433,1434,1435,1436,1437,1438,377,918,917,916,915,914,913,912,2971,957,956,955,954,953,2974,2713,3301,2714,594,2715,3302,2716,596,2717,3303,2718,2719,2720,2721,1129,2767,2768,2769,2770,2771,2045,858,857,1486,1487,1488,1489,1490,1491,1492,1493,1494,1495,1496,1497,1498,1499,1500,1501,1502,1503,1504,1505,1506,1507,1508,1509,1510,1511,1512,1513,1514,1515,1516,1517,1518,1519,1520,1521,1522,1523,1524,1525,1526,1527,1528,1529,1530,1531,1532,1533,1534,1535,1536,1537,1538,1539,1540,1541,1542,1543,1544,1545,1546,1547,1548,1549,1550,1551,1552,1553,1554,1555,1556,1557,1558,1559,1560,1561,1562,1563,1564,1565,1566,1567,1568,1569,1570,1571,1572,1573,1574,1575,1576,1577,1578,1579,1580,1581,1582,1583,1584,1585,1586,1587,1644,1588,1589,1590,1591,1592,1593,1594,1595,1596,1597,1598,1599,1600,1601,1602,1603,1604,1605,1606,1607,1608,1609,1610,1611,1612,1613,1614,1615,1616,1617,1618,1619,1620,2323,2324,2325,2419,2420,2418,2422,2423,2424,2421,3431,558,3432,3433,556,3434,562,3435,1621,1623,1625,1627,1629,1631,1632,1633,1634,1635,1636,1637,1638,1639,1640,1641,2326,1643,2327,1645,2328,1647,2329,1649,2330,1651,2331,2335,1653,2332,1655,1657,1661,1659,1660,1671,1664,1663,1665,1667,1669,1666,1673,1668,1670,2333,2334,1675,2336,1677,2337,1679,2338,1681,2339,2340,2722,2723,2724,2725,2726,2727,2728,1764,1765,2729,2730,2731,2732,2733,2734,2735,2736,2737,2738,2739,2740,2741,2742,2743,2744,2745,2746,2747,2748,2749,2750,2815,2751,2752,2753,2754,2755,2756,2757,2758,2759,113,67,105,560,2299,1719,1720,2760,2761,2762,2763,2764,2765,2766,1257,1256,1255,1254,1253,1252,1251,1250,1249,107,106,27,28,2772,2773,2774,2775,2776,2777,2778,2779,2780,2781,2782,2783,2784,2785,1248,2973,108,25,26,73,2786,2787,2788,2789,2790,2791,2816,2792,2793,2794,2795,2796,2797,2798,2799,75,76,77,2402,2800,2801,2802,2803,2804,2813,2814,1723,79,2817,2818,2819,80,81,82,83,1724,2805,169,1715,1717,1721,1718,1725,2806,1727,155,1729,2807,1731,163,1743,2808,1745,159,1716,1722,1733,2809,1735,157,1737,2810,1739,167,1741,2811,161,2812,856,1742,3277,1004,1003,1005,1002,1008,3460,165,1747,2348,1749,2347,1751,2345,1753,1755,2343,1757,2921,1759,2922,1761,2923,1762,2924,2925,2820,1766,2821,1767,2822,1768,2823,1769,2824,1771,1642,1772,1773,1646,1774,1648,1775,1650,2975,1776,1652,1777,1654,1778,1656,1779,1780,1781,1782,1783,1784,1785,1672,1786,1674,1787,2825,1676,1788,1678,1789,1680,1790,1682,1791,1792,2826,2827,1927,2828,2829,2830,2831,2832,2833,2834,1803,1804,1805,1806,1807,1808,2835,1809,2836,1810,2837,1811,2838,1813,1814,2839,1815,1758,1816,1817,1818,1819,1820,1821,1822,2840,1824,2841,2842,2843,2844,2845,2846,1844,1802,1837,1838,2847,1839,1840,1841,1842,1843,1845,1846,1812,1847,1848,1849,1850,1851,1852,1853,1854,1855,1856,1857,1858,1859,1860,1939,1940,2848,1861,1862,1863,1864,1865,2849,1866,1867,2850,1868,1869,1870,1871,1872,1873,1874,1128,1875,1876,1877,1878,1879,1880,1881,1882,1883,1884,1885,1886,1887,1888,1889,1890,1941,1891,1892,1893,1894,1895,1896,1897,1898,2851,2852,2853,2854,1901,1904,1905,2855,1907,1908,1909,1910,1911,1912,1913,1928,1914,1915,1916,1942,1906,1903,1917,1918,1919,1920,1921,1922,1923,1924,1925,1926,1931,1932,1933,1934,1935,1936,1937,1938,2856,2857,2858,2859,2860,2861,2862,2863,2864,2865,2866,2867,2868,1943,1944,1945,1946,1947,1948,1949,1950,1951,1952,1953,1954,2869,2870,2871,2872,2873,2874,2875,2876,2877,2878,2879,2880,2881,2882,2883,2884,2885,1966,1967,1968,1969,1970,1971,1972,1973,2886,2887,2888,1974,855,1975,854,1976,853,1978,852,1979,851,1980,850,1981,849,1982,3304,1983,1026,1984,3305,1985,1194,1986,1987,1988,2889,2890,2891,2892,2893,2894,2895,2896,2897,2898,2899,2900,2901,2902,2903,2904,2905,2906,2907,2908,2909,1990,1991,1992,1993,2910,1994,2911,1995,2912,1996,1997,2913,1998,2914,1999,2915,2000,2916,2001,2917,2918,2002,2919,2003,2004,2005,2920,2006,2976,2007,2977,2008,726,2009,2010,2978,2011,2979,730,2034,2046,2047,2048,2049,2050,2051,2052,2053,2054,2055,612,602,2033,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2926,2927,2928,2056,2057,2058,2059,2060,2061,2062,2063,2064,2065,2066,2067,2929,2930,2931,2932,2933,2934,2935,2936,2937,904,903,911,2938,2939,2941,2942,2943,2944,2945,2946,2947,2948,2949,2950,2951,2952,2953,2954,2955,2956,2957,2107,1193,2108,1192,2109,1191,2110,1190,2111,1189,2112,1188,2113,1187,2114,1186,2115,1185,2116,3306,2117,3390,2142,2095,2096,2097,2098,2099,2100,2101,2102,2103,2104,2105,3307,2119,2120,3308,2121,3309,2122,3310,2123,3311,2124,728,2125,604,2126,3312,2127,606,2128,3313,2129,608,2130,2131,2132,3314,2133,610,2134,3315,2135,614,3316,2136,616,2137,3317,2138,618,2139,3318,2140,1089,1088,1087,1086,1085,1084,1083,1082,1081,1080,2972,620,2143,3319,2144,622,2145,3320,2146,624,2147,3321,626,2148,3322,2149,3327,628,2150,2151,2152,2980,732,2981,734,2982,736,2983,738,2984,740,2985,742,2986,744,2987,2988,2989,750,2990,752,2991,754,2992,756,2993,758,2994,760,2995,762,2996,764,2997,2141,3323,630,3324,632,3325,634,3326,636,1124,1123,1122,1121,941,2998,2999,940,939,938,937,936,935,934,933,924,922,3000,1110,792,1109,1108,1107,1106,1105,1104,1103,1102,1101,1100,1099,1098,1097,1096,1095,1094,1093,1092,3001,1278,1277,1276,1275,1274,1273,1272,1271,1270,1269,1268,1267,1266,1265,1264,1263,3002,3003,766,3004,768,3005,770,3006,772,3007,774,3008,776,3009,778,3010,780,3011,782,3012,784,3013,2153,638,3328,2068,112,3014,3015,3016,1120,1119,1118,1117,1116,1115,1114,1113,1112,3017,1283,1282,1281,1280,1279,3018,3019,3020,879,3021,3022,3023,3024,3025,3026,3027,3028,3029,3030,3031,3032,3033,3034,3035,3036,3037,3038,3039,3040,794,793,3041,962,3043,3044,3045,3046,3047,3048,3049,3050,3051,3052,3053,3054,3055,3056,3057,3058,3059,3060,3061,3062,3063,3064,3065,878,808,3066,980,979,978,977,976,975,974,973,972,971,3067,3068,3069,3070,3071,3072,3073,3074,3075,3076,3077,3078,3079,3080,3081,3082,3083,3084,3085,3086,3087,3088,3089,3090,3091,3092,3093,3094,3095,3096,3097,3098,3099,3100,3101,3102,3103,3104,3105,3106,3107,3108,3109,3110,3111,3112,3113,816,817,818,819,820,877,821,822,823,824,825,826,827,828,829,830,831,832,833,3114,986,987,988,989,990,991,992,993,994,995,996,997,998,999,1000,1001,3115,1152,1153,1154,1155,1156,1157,1158,1159,1160,1161,1162,1163,1164,1165,1166,1167,1168,1169,3116,3118,3120,3122,3124,861,3130,3135,3134,3133,3132,3131,3139,3138,3137,3136,876,875,874,873,864,863,862,860,859,3329,1040,1045,1044,1043,1042,1041,1039,1038,69,1902,1714,3391,1740,3392,1728,3393,1726,1760,3394,3395,1736,3396,1730,3397,1734,3398,1732,3364,3372,1630,3373,3370,3369,3377,3371,1628,3374,1622,3375,1626,3376,1624,3382,3383,3384,3385,3386,3387,3388,3389,1738,3399,1823,3401,1748,3402,1750,3403,1752,3404,1754,3405,1756,3406,3407,3408,1744,3409,3412,3420,3117,3413,3119,3414,3121,3415,3123,3416,3417,1658,3125,842,2250,2439,2438,3129,3128,3127,3126,2351,2499,3140,3424,3147,3425,3149,3426,3151,3427,843,3428,3440,3441,3442,3443,3444,564,3445,570,3446,2249,3159,3158,3157,3156,3169,3168,2156,2155,845,844,550,3436,554,3437,552,3438,1834,3439,3165,3164,3163,3162,3161,840,838,839,2307,841,566,3447,568,3448,572,3449,2278,1176,1174,692,1175,3278,1177,1006,1007,3276,1009,3450,698,3451,700,3452,702,3453,3454,3455,3456,690,3457,3458,694,3459,696,2106,2940,902,910,909,908,907,906,905,1072,1070,1079,1078,1075,1074,1073}'::integer[])))
  • Buffers: shared hit=135
14. 0.509 11.133 ↑ 1.0 1,684 1

Hash (cost=12,467.52..12,467.52 rows=1,684 width=4) (actual time=11.133..11.133 rows=1,684 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 635kB
  • Buffers: shared hit=159
15. 10.519 10.624 ↑ 1.0 1,684 1

Bitmap Heap Scan on katello_repositories (cost=43.53..12,467.52 rows=1,684 width=4) (actual time=0.124..10.624 rows=1,684 loops=1)

  • Recheck Cond: (environment_id = ANY ('{1,7,8,9,10,11,12,13,14,15}'::integer[]))
  • Filter: ((id = ANY ('{3291,3292,2430,1184,1181,1183,14,7,1,5,3,6,4,115,2,15,186,10,21,1077,9,117,1182,11,2431,1180,22,2448,188,2154,1076,190,19,23,192,1240,846,1238,124,1243,1242,1241,126,119,128,121,120,114,116,123,847,3461,2432,2433,2434,2435,2436,130,3462,132,66,1662,2437,65,74,56,55,848,58,59,57,62,63,60,61,1247,1246,1245,2442,2443,2444,2441,2445,2446,2447,135,68,1244,3463,3464,3465,3466,3467,2440,1127,2958,1071,3468,134,2449,136,2450,2469,2470,2471,2472,1929,2207,52,54,53,2473,2474,2475,2476,2477,1037,1036,1035,1034,1033,1032,1031,2451,3469,3470,2454,2455,2456,2457,2458,2459,2460,2461,2462,2463,2464,2465,194,3471,196,198,200,2466,2467,2468,2452,2453,2478,2479,154,156,158,1030,160,1029,162,1028,164,1027,166,3330,168,103,170,2480,172,72,174,78,2481,111,2482,2483,2484,2485,3472,202,2486,2487,204,176,2491,178,2492,180,2493,182,110,184,104,2488,2489,2490,206,2494,208,2495,210,2496,212,2497,214,2959,216,218,220,222,224,226,2960,3473,3474,3475,3476,3477,3478,228,3479,230,232,2501,234,2502,236,2503,238,2504,240,2505,242,2506,244,2507,246,2508,2509,2510,2511,2500,248,2512,250,2513,252,2514,274,3480,276,3481,278,3482,280,282,284,286,2515,2516,2517,254,3146,256,3483,258,3148,260,1930,3484,262,3150,264,3485,266,3152,268,302,3486,3487,3488,270,3154,272,3489,288,3490,835,290,3491,292,3492,294,3493,296,298,300,3153,3155,3494,304,3495,306,3496,308,3497,310,3498,312,3499,314,3500,316,3501,318,3502,320,3503,3504,322,3505,324,3506,326,3507,328,3508,330,3509,332,3510,334,3511,336,3160,338,3512,340,342,341,343,344,3513,346,3514,348,3515,350,352,354,356,358,3400,360,3167,362,3166,364,3516,366,3517,368,3518,370,3171,372,281,374,3172,376,275,2518,2519,2520,2521,2522,3519,2523,3170,378,379,380,393,382,383,384,3520,386,388,392,385,387,389,2524,2203,704,2961,706,479,2962,708,2963,710,2964,712,390,2302,394,2525,396,2204,3521,395,397,2528,2529,2530,2531,2532,2533,3430,2534,2535,2536,2537,2542,3522,414,416,2538,418,2539,420,2540,422,2541,424,2543,426,2546,960,428,2526,429,2527,430,487,2544,431,2545,432,3523,3524,3525,2547,3526,2548,449,451,453,455,3175,457,459,461,463,465,485,3173,2227,2228,2229,2230,2231,467,469,471,277,473,3174,475,279,477,481,483,287,3176,283,3177,285,2233,2234,2232,489,2236,491,2549,493,495,497,499,501,503,2965,505,714,507,2966,509,716,511,2304,2550,2551,2237,513,2238,515,2235,517,3178,519,3179,521,3180,523,525,720,527,529,3181,531,3182,2552,2553,2554,533,2555,535,2556,537,2557,539,2558,541,2559,543,2560,545,2561,2562,2563,2564,2565,2566,2567,2568,2569,2570,2571,2572,2573,2574,2575,2576,2577,2967,718,2968,2969,722,2970,574,577,3183,579,3184,581,598,583,600,585,1208,587,1215,589,2118,591,1214,593,1213,595,3419,1212,597,1211,599,601,603,2279,605,3185,607,289,609,3186,611,291,613,3187,615,293,617,921,381,619,920,621,2583,623,2584,625,2585,627,2586,629,2587,631,3188,633,295,635,3189,637,297,919,3190,1746,299,2588,2589,2590,2591,2592,2593,327,2594,329,2595,3411,331,2596,333,2597,335,2401,2598,337,2599,2300,3191,301,3192,2308,303,2309,3193,683,2303,685,2301,687,684,689,686,688,305,691,3194,693,307,695,3195,697,309,699,3196,701,2305,2314,2322,703,311,705,3197,707,313,709,3198,711,315,713,3199,715,717,719,721,339,723,2310,725,724,317,727,3200,729,319,731,3201,733,321,735,3202,737,323,739,3203,741,325,743,745,2213,747,2214,749,2215,751,2216,753,2217,755,757,759,761,763,2341,2344,2346,2342,746,748,765,2218,767,769,2600,771,2601,773,2602,775,2603,777,2604,779,1126,781,1125,783,810,809,2219,2220,2221,2222,2223,2224,2225,2226,802,801,800,799,798,797,796,795,807,806,805,804,803,3204,3205,3206,3207,3208,3209,3210,3211,3212,3213,3214,3215,3216,3217,3218,3219,1210,1763,813,814,815,3220,3221,3222,3223,2311,2312,2313,2318,2320,2317,2316,2315,2321,2319,871,870,869,868,867,866,865,3224,3225,3226,3227,3228,3229,3230,3231,872,3410,3418,2605,2606,391,2350,2349,3421,3422,3423,2498,2607,2608,2609,2610,2611,2612,2613,2614,2615,2616,2617,2618,2619,129,2620,125,2621,137,2622,2623,133,3232,3233,3234,3235,3236,3237,3238,3239,3429,2352,2353,2624,127,2625,131,2626,2627,2628,2629,2630,2631,2632,2633,3240,3241,3242,197,3243,195,3244,201,3245,199,3246,189,932,931,930,929,928,927,926,925,923,3247,187,3248,193,3249,191,1209,1207,1198,1197,1196,942,952,951,950,949,948,947,946,945,944,943,2208,2205,2206,2211,2212,2209,2210,3250,3251,970,969,968,967,966,965,964,963,981,982,983,984,985,3252,3253,3254,3255,3256,3257,3258,3259,3260,3261,3262,3263,3264,3265,3266,1025,548,1024,1023,1022,1021,1020,1019,1018,1017,1011,1016,1013,1015,1014,1046,2634,2635,2636,2637,2638,2639,2640,2641,2642,2643,2644,3267,3268,3269,3270,1047,2645,2646,2647,2649,2650,2652,2655,2657,2659,2661,1195,1091,1090,791,790,789,788,787,786,785,3271,3272,3273,3274,3275,3331,1111,2306,836,837,834,2354,2648,2651,2653,1138,1137,1136,1135,1134,1133,1132,1131,1130,1178,1684,70,71,8,1900,1148,1147,1146,1145,1144,1143,1142,1141,1140,1139,1149,1150,1151,3280,3281,3282,3283,3279,1172,1171,1173,1170,1239,2654,2656,2658,2660,2663,2665,2667,2669,2671,2673,1485,961,3042,812,811,3284,3285,3286,3287,3288,118,1683,3378,3379,3380,1262,1261,1260,1259,1258,3381,576,2031,1206,1205,1204,1203,1202,1201,1200,1199,2662,2664,2666,2668,2670,2672,2676,2678,2679,2680,2681,2683,2684,1010,3289,3290,1012,2674,2708,2709,2710,2711,2712,1288,1287,1286,1285,1284,3293,578,3294,580,3295,582,3296,584,2675,2677,2682,345,1179,2685,347,2688,349,2693,959,351,2695,353,2696,355,2697,357,2698,359,2699,361,2700,363,2701,365,2686,2687,2689,2690,2691,2692,2694,1323,1324,1325,1326,1327,1328,1329,1330,1331,1332,1333,1334,1335,1336,1337,1338,1339,1340,1341,1342,1343,1344,1345,1346,1347,1348,1349,1350,1351,1352,1353,1354,1355,1356,1399,1400,1401,1402,1357,1358,1359,1360,1361,1362,1363,1364,1365,1366,1367,1368,1369,1370,1371,1372,1373,1374,1375,1376,1377,1378,1379,1380,1381,1382,1383,1384,1385,1386,1387,1388,1389,1390,1391,1392,1393,1394,1395,1396,1397,1398,3297,586,3298,588,3299,590,3300,592,2702,367,2703,369,2704,371,2705,373,2706,375,2707,1403,1404,1405,1406,1407,1408,1409,1410,1411,1412,1413,1414,1415,1416,1417,1418,1419,1420,1421,1422,1423,1424,1425,958,1426,1427,1428,1429,1430,1431,1432,1433,1434,1435,1436,1437,1438,377,918,917,916,915,914,913,912,2971,957,956,955,954,953,2974,2713,3301,2714,594,2715,3302,2716,596,2717,3303,2718,2719,2720,2721,1129,2767,2768,2769,2770,2771,2045,858,857,1486,1487,1488,1489,1490,1491,1492,1493,1494,1495,1496,1497,1498,1499,1500,1501,1502,1503,1504,1505,1506,1507,1508,1509,1510,1511,1512,1513,1514,1515,1516,1517,1518,1519,1520,1521,1522,1523,1524,1525,1526,1527,1528,1529,1530,1531,1532,1533,1534,1535,1536,1537,1538,1539,1540,1541,1542,1543,1544,1545,1546,1547,1548,1549,1550,1551,1552,1553,1554,1555,1556,1557,1558,1559,1560,1561,1562,1563,1564,1565,1566,1567,1568,1569,1570,1571,1572,1573,1574,1575,1576,1577,1578,1579,1580,1581,1582,1583,1584,1585,1586,1587,1644,1588,1589,1590,1591,1592,1593,1594,1595,1596,1597,1598,1599,1600,1601,1602,1603,1604,1605,1606,1607,1608,1609,1610,1611,1612,1613,1614,1615,1616,1617,1618,1619,1620,2323,2324,2325,2419,2420,2418,2422,2423,2424,2421,3431,558,3432,3433,556,3434,562,3435,1621,1623,1625,1627,1629,1631,1632,1633,1634,1635,1636,1637,1638,1639,1640,1641,2326,1643,2327,1645,2328,1647,2329,1649,2330,1651,2331,2335,1653,2332,1655,1657,1661,1659,1660,1671,1664,1663,1665,1667,1669,1666,1673,1668,1670,2333,2334,1675,2336,1677,2337,1679,2338,1681,2339,2340,2722,2723,2724,2725,2726,2727,2728,1764,1765,2729,2730,2731,2732,2733,2734,2735,2736,2737,2738,2739,2740,2741,2742,2743,2744,2745,2746,2747,2748,2749,2750,2815,2751,2752,2753,2754,2755,2756,2757,2758,2759,113,67,105,560,2299,1719,1720,2760,2761,2762,2763,2764,2765,2766,1257,1256,1255,1254,1253,1252,1251,1250,1249,107,106,27,28,2772,2773,2774,2775,2776,2777,2778,2779,2780,2781,2782,2783,2784,2785,1248,2973,108,25,26,73,2786,2787,2788,2789,2790,2791,2816,2792,2793,2794,2795,2796,2797,2798,2799,75,76,77,2402,2800,2801,2802,2803,2804,2813,2814,1723,79,2817,2818,2819,80,81,82,83,1724,2805,169,1715,1717,1721,1718,1725,2806,1727,155,1729,2807,1731,163,1743,2808,1745,159,1716,1722,1733,2809,1735,157,1737,2810,1739,167,1741,2811,161,2812,856,1742,3277,1004,1003,1005,1002,1008,3460,165,1747,2348,1749,2347,1751,2345,1753,1755,2343,1757,2921,1759,2922,1761,2923,1762,2924,2925,2820,1766,2821,1767,2822,1768,2823,1769,2824,1771,1642,1772,1773,1646,1774,1648,1775,1650,2975,1776,1652,1777,1654,1778,1656,1779,1780,1781,1782,1783,1784,1785,1672,1786,1674,1787,2825,1676,1788,1678,1789,1680,1790,1682,1791,1792,2826,2827,1927,2828,2829,2830,2831,2832,2833,2834,1803,1804,1805,1806,1807,1808,2835,1809,2836,1810,2837,1811,2838,1813,1814,2839,1815,1758,1816,1817,1818,1819,1820,1821,1822,2840,1824,2841,2842,2843,2844,2845,2846,1844,1802,1837,1838,2847,1839,1840,1841,1842,1843,1845,1846,1812,1847,1848,1849,1850,1851,1852,1853,1854,1855,1856,1857,1858,1859,1860,1939,1940,2848,1861,1862,1863,1864,1865,2849,1866,1867,2850,1868,1869,1870,1871,1872,1873,1874,1128,1875,1876,1877,1878,1879,1880,1881,1882,1883,1884,1885,1886,1887,1888,1889,1890,1941,1891,1892,1893,1894,1895,1896,1897,1898,2851,2852,2853,2854,1901,1904,1905,2855,1907,1908,1909,1910,1911,1912,1913,1928,1914,1915,1916,1942,1906,1903,1917,1918,1919,1920,1921,1922,1923,1924,1925,1926,1931,1932,1933,1934,1935,1936,1937,1938,2856,2857,2858,2859,2860,2861,2862,2863,2864,2865,2866,2867,2868,1943,1944,1945,1946,1947,1948,1949,1950,1951,1952,1953,1954,2869,2870,2871,2872,2873,2874,2875,2876,2877,2878,2879,2880,2881,2882,2883,2884,2885,1966,1967,1968,1969,1970,1971,1972,1973,2886,2887,2888,1974,855,1975,854,1976,853,1978,852,1979,851,1980,850,1981,849,1982,3304,1983,1026,1984,3305,1985,1194,1986,1987,1988,2889,2890,2891,2892,2893,2894,2895,2896,2897,2898,2899,2900,2901,2902,2903,2904,2905,2906,2907,2908,2909,1990,1991,1992,1993,2910,1994,2911,1995,2912,1996,1997,2913,1998,2914,1999,2915,2000,2916,2001,2917,2918,2002,2919,2003,2004,2005,2920,2006,2976,2007,2977,2008,726,2009,2010,2978,2011,2979,730,2034,2046,2047,2048,2049,2050,2051,2052,2053,2054,2055,612,602,2033,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2926,2927,2928,2056,2057,2058,2059,2060,2061,2062,2063,2064,2065,2066,2067,2929,2930,2931,2932,2933,2934,2935,2936,2937,904,903,911,2938,2939,2941,2942,2943,2944,2945,2946,2947,2948,2949,2950,2951,2952,2953,2954,2955,2956,2957,2107,1193,2108,1192,2109,1191,2110,1190,2111,1189,2112,1188,2113,1187,2114,1186,2115,1185,2116,3306,2117,3390,2142,2095,2096,2097,2098,2099,2100,2101,2102,2103,2104,2105,3307,2119,2120,3308,2121,3309,2122,3310,2123,3311,2124,728,2125,604,2126,3312,2127,606,2128,3313,2129,608,2130,2131,2132,3314,2133,610,2134,3315,2135,614,3316,2136,616,2137,3317,2138,618,2139,3318,2140,1089,1088,1087,1086,1085,1084,1083,1082,1081,1080,2972,620,2143,3319,2144,622,2145,3320,2146,624,2147,3321,626,2148,3322,2149,3327,628,2150,2151,2152,2980,732,2981,734,2982,736,2983,738,2984,740,2985,742,2986,744,2987,2988,2989,750,2990,752,2991,754,2992,756,2993,758,2994,760,2995,762,2996,764,2997,2141,3323,630,3324,632,3325,634,3326,636,1124,1123,1122,1121,941,2998,2999,940,939,938,937,936,935,934,933,924,922,3000,1110,792,1109,1108,1107,1106,1105,1104,1103,1102,1101,1100,1099,1098,1097,1096,1095,1094,1093,1092,3001,1278,1277,1276,1275,1274,1273,1272,1271,1270,1269,1268,1267,1266,1265,1264,1263,3002,3003,766,3004,768,3005,770,3006,772,3007,774,3008,776,3009,778,3010,780,3011,782,3012,784,3013,2153,638,3328,2068,112,3014,3015,3016,1120,1119,1118,1117,1116,1115,1114,1113,1112,3017,1283,1282,1281,1280,1279,3018,3019,3020,879,3021,3022,3023,3024,3025,3026,3027,3028,3029,3030,3031,3032,3033,3034,3035,3036,3037,3038,3039,3040,794,793,3041,962,3043,3044,3045,3046,3047,3048,3049,3050,3051,3052,3053,3054,3055,3056,3057,3058,3059,3060,3061,3062,3063,3064,3065,878,808,3066,980,979,978,977,976,975,974,973,972,971,3067,3068,3069,3070,3071,3072,3073,3074,3075,3076,3077,3078,3079,3080,3081,3082,3083,3084,3085,3086,3087,3088,3089,3090,3091,3092,3093,3094,3095,3096,3097,3098,3099,3100,3101,3102,3103,3104,3105,3106,3107,3108,3109,3110,3111,3112,3113,816,817,818,819,820,877,821,822,823,824,825,826,827,828,829,830,831,832,833,3114,986,987,988,989,990,991,992,993,994,995,996,997,998,999,1000,1001,3115,1152,1153,1154,1155,1156,1157,1158,1159,1160,1161,1162,1163,1164,1165,1166,1167,1168,1169,3116,3118,3120,3122,3124,861,3130,3135,3134,3133,3132,3131,3139,3138,3137,3136,876,875,874,873,864,863,862,860,859,3329,1040,1045,1044,1043,1042,1041,1039,1038,69,1902,1714,3391,1740,3392,1728,3393,1726,1760,3394,3395,1736,3396,1730,3397,1734,3398,1732,3364,3372,1630,3373,3370,3369,3377,3371,1628,3374,1622,3375,1626,3376,1624,3382,3383,3384,3385,3386,3387,3388,3389,1738,3399,1823,3401,1748,3402,1750,3403,1752,3404,1754,3405,1756,3406,3407,3408,1744,3409,3412,3420,3117,3413,3119,3414,3121,3415,3123,3416,3417,1658,3125,842,2250,2439,2438,3129,3128,3127,3126,2351,2499,3140,3424,3147,3425,3149,3426,3151,3427,843,3428,3440,3441,3442,3443,3444,564,3445,570,3446,2249,3159,3158,3157,3156,3169,3168,2156,2155,845,844,550,3436,554,3437,552,3438,1834,3439,3165,3164,3163,3162,3161,840,838,839,2307,841,566,3447,568,3448,572,3449,2278,1176,1174,692,1175,3278,1177,1006,1007,3276,1009,3450,698,3451,700,3452,702,3453,3454,3455,3456,690,3457,3458,694,3459,696,2106,2940,902,910,909,908,907,906,905,1072,1070,1079,1078,1075,1074,1073}'::integer[])) OR (id = ANY ('{14,14,7,7,1,1,1,5,5,3,3,3,6,6,4,4,4,115,115,115,115,2,2,2,15,15,15,10,21,21,21,21,9,117,117,117,117,11,22,22,22,22,19,23,23,23,23,119,119,119,119,121,121,121,121,120,120,120,120,114,114,114,114,116,116,116,116,123,123,123,66,66,66,66,1662,65,65,65,65,74,74,74,74,74,56,55,58,59,57,62,62,63,60,61,68,68,68,68,52,54,53,72,72,72,72,72,78,78,78,78,78,111,111,110,110,110,104,104,104,70,70,70,70,70,71,71,71,71,71,8,8,1900,1900,118,118,118,118,1661,113,67,67,67,67,105,105,105,107,107,107,106,106,106,27,27,27,27,28,28,28,28,108,108,108,25,25,25,25,26,26,26,26,73,73,73,73,73,75,75,75,75,75,76,76,76,76,76,77,77,77,77,77,79,79,79,79,79,80,80,80,80,80,81,81,81,81,81,82,82,82,82,83,83,83,83,1901,1904,1905,1906,1903,112,69,69,69,69,1902,1714}'::integer[])) OR (id = ANY ('{3291,3292,2430,1184,1181,1183,14,7,1,5,3,6,4,115,2,15,186,10,21,1077,9,117,1182,11,2431,1180,22,2448,188,2154,1076,190,19,23,192,1240,846,1238,124,1243,1242,1241,126,119,128,121,120,114,116,123,847,3461,2432,2433,2434,2435,2436,130,3462,132,66,1662,2437,65,74,56,55,848,58,59,57,62,63,60,61,1247,1246,1245,2442,2443,2444,2441,2445,2446,2447,135,68,1244,3463,3464,3465,3466,3467,2440,1127,2958,1071,3468,134,2449,136,2450,2469,2470,2471,2472,1929,2207,52,54,53,2473,2474,2475,2476,2477,1037,1036,1035,1034,1033,1032,1031,2451,3469,3470,2454,2455,2456,2457,2458,2459,2460,2461,2462,2463,2464,2465,194,3471,196,198,200,2466,2467,2468,2452,2453,2478,2479,154,156,158,1030,160,1029,162,1028,164,1027,166,3330,168,103,170,2480,172,72,174,78,2481,111,2482,2483,2484,2485,3472,202,2486,2487,204,176,2491,178,2492,180,2493,182,110,184,104,2488,2489,2490,206,2494,208,2495,210,2496,212,2497,214,2959,216,218,220,222,224,226,2960,3473,3474,3475,3476,3477,3478,228,3479,230,232,2501,234,2502,236,2503,238,2504,240,2505,242,2506,244,2507,246,2508,2509,2510,2511,2500,248,2512,250,2513,252,2514,274,3480,276,3481,278,3482,280,282,284,286,2515,2516,2517,254,3146,256,3483,258,3148,260,1930,3484,262,3150,264,3485,266,3152,268,302,3486,3487,3488,270,3154,272,3489,288,3490,835,290,3491,292,3492,294,3493,296,298,300,3153,3155,3494,304,3495,306,3496,308,3497,310,3498,312,3499,314,3500,316,3501,318,3502,320,3503,3504,322,3505,324,3506,326,3507,328,3508,330,3509,332,3510,334,3511,336,3160,338,3512,340,342,341,343,344,3513,346,3514,348,3515,350,352,354,356,358,3400,360,3167,362,3166,364,3516,366,3517,368,3518,370,3171,372,281,374,3172,376,275,2518,2519,2520,2521,2522,3519,2523,3170,378,379,380,393,382,383,384,3520,386,388,392,385,387,389,2524,2203,704,2961,706,479,2962,708,2963,710,2964,712,390,2302,394,2525,396,2204,3521,395,397,2528,2529,2530,2531,2532,2533,3430,2534,2535,2536,2537,2542,3522,414,416,2538,418,2539,420,2540,422,2541,424,2543,426,2546,960,428,2526,429,2527,430,487,2544,431,2545,432,3523,3524,3525,2547,3526,2548,449,451,453,455,3175,457,459,461,463,465,485,3173,2227,2228,2229,2230,2231,467,469,471,277,473,3174,475,279,477,481,483,287,3176,283,3177,285,2233,2234,2232,489,2236,491,2549,493,495,497,499,501,503,2965,505,714,507,2966,509,716,511,2304,2550,2551,2237,513,2238,515,2235,517,3178,519,3179,521,3180,523,525,720,527,529,3181,531,3182,2552,2553,2554,533,2555,535,2556,537,2557,539,2558,541,2559,543,2560,545,2561,2562,2563,2564,2565,2566,2567,2568,2569,2570,2571,2572,2573,2574,2575,2576,2577,2967,718,2968,2969,722,2970,574,577,3183,579,3184,581,598,583,600,585,1208,587,1215,589,2118,591,1214,593,1213,595,3419,1212,597,1211,599,601,603,2279,605,3185,607,289,609,3186,611,291,613,3187,615,293,617,921,381,619,920,621,2583,623,2584,625,2585,627,2586,629,2587,631,3188,633,295,635,3189,637,297,919,3190,1746,299,2588,2589,2590,2591,2592,2593,327,2594,329,2595,3411,331,2596,333,2597,335,2401,2598,337,2599,2300,3191,301,3192,2308,303,2309,3193,683,2303,685,2301,687,684,689,686,688,305,691,3194,693,307,695,3195,697,309,699,3196,701,2305,2314,2322,703,311,705,3197,707,313,709,3198,711,315,713,3199,715,717,719,721,339,723,2310,725,724,317,727,3200,729,319,731,3201,733,321,735,3202,737,323,739,3203,741,325,743,745,2213,747,2214,749,2215,751,2216,753,2217,755,757,759,761,763,2341,2344,2346,2342,746,748,765,2218,767,769,2600,771,2601,773,2602,775,2603,777,2604,779,1126,781,1125,783,810,809,2219,2220,2221,2222,2223,2224,2225,2226,802,801,800,799,798,797,796,795,807,806,805,804,803,3204,3205,3206,3207,3208,3209,3210,3211,3212,3213,3214,3215,3216,3217,3218,3219,1210,1763,813,814,815,3220,3221,3222,3223,2311,2312,2313,2318,2320,2317,2316,2315,2321,2319,871,870,869,868,867,866,865,3224,3225,3226,3227,3228,3229,3230,3231,872,3410,3418,2605,2606,391,2350,2349,3421,3422,3423,2498,2607,2608,2609,2610,2611,2612,2613,2614,2615,2616,2617,2618,2619,129,2620,125,2621,137,2622,2623,133,3232,3233,3234,3235,3236,3237,3238,3239,3429,2352,2353,2624,127,2625,131,2626,2627,2628,2629,2630,2631,2632,2633,3240,3241,3242,197,3243,195,3244,201,3245,199,3246,189,932,931,930,929,928,927,926,925,923,3247,187,3248,193,3249,191,1209,1207,1198,1197,1196,942,952,951,950,949,948,947,946,945,944,943,2208,2205,2206,2211,2212,2209,2210,3250,3251,970,969,968,967,966,965,964,963,981,982,983,984,985,3252,3253,3254,3255,3256,3257,3258,3259,3260,3261,3262,3263,3264,3265,3266,1025,548,1024,1023,1022,1021,1020,1019,1018,1017,1011,1016,1013,1015,1014,1046,2634,2635,2636,2637,2638,2639,2640,2641,2642,2643,2644,3267,3268,3269,3270,1047,2645,2646,2647,2649,2650,2652,2655,2657,2659,2661,1195,1091,1090,791,790,789,788,787,786,785,3271,3272,3273,3274,3275,3331,1111,2306,836,837,834,2354,2648,2651,2653,1138,1137,1136,1135,1134,1133,1132,1131,1130,1178,1684,70,71,8,1900,1148,1147,1146,1145,1144,1143,1142,1141,1140,1139,1149,1150,1151,3280,3281,3282,3283,3279,1172,1171,1173,1170,1239,2654,2656,2658,2660,2663,2665,2667,2669,2671,2673,1485,961,3042,812,811,3284,3285,3286,3287,3288,118,1683,3378,3379,3380,1262,1261,1260,1259,1258,3381,576,2031,1206,1205,1204,1203,1202,1201,1200,1199,2662,2664,2666,2668,2670,2672,2676,2678,2679,2680,2681,2683,2684,1010,3289,3290,1012,2674,2708,2709,2710,2711,2712,1288,1287,1286,1285,1284,3293,578,3294,580,3295,582,3296,584,2675,2677,2682,345,1179,2685,347,2688,349,2693,959,351,2695,353,2696,355,2697,357,2698,359,2699,361,2700,363,2701,365,2686,2687,2689,2690,2691,2692,2694,1323,1324,1325,1326,1327,1328,1329,1330,1331,1332,1333,1334,1335,1336,1337,1338,1339,1340,1341,1342,1343,1344,1345,1346,1347,1348,1349,1350,1351,1352,1353,1354,1355,1356,1399,1400,1401,1402,1357,1358,1359,1360,1361,1362,1363,1364,1365,1366,1367,1368,1369,1370,1371,1372,1373,1374,1375,1376,1377,1378,1379,1380,1381,1382,1383,1384,1385,1386,1387,1388,1389,1390,1391,1392,1393,1394,1395,1396,1397,1398,3297,586,3298,588,3299,590,3300,592,2702,367,2703,369,2704,371,2705,373,2706,375,2707,1403,1404,1405,1406,1407,1408,1409,1410,1411,1412,1413,1414,1415,1416,1417,1418,1419,1420,1421,1422,1423,1424,1425,958,1426,1427,1428,1429,1430,1431,1432,1433,1434,1435,1436,1437,1438,377,918,917,916,915,914,913,912,2971,957,956,955,954,953,2974,2713,3301,2714,594,2715,3302,2716,596,2717,3303,2718,2719,2720,2721,1129,2767,2768,2769,2770,2771,2045,858,857,1486,1487,1488,1489,1490,1491,1492,1493,1494,1495,1496,1497,1498,1499,1500,1501,1502,1503,1504,1505,1506,1507,1508,1509,1510,1511,1512,1513,1514,1515,1516,1517,1518,1519,1520,1521,1522,1523,1524,1525,1526,1527,1528,1529,1530,1531,1532,1533,1534,1535,1536,1537,1538,1539,1540,1541,1542,1543,1544,1545,1546,1547,1548,1549,1550,1551,1552,1553,1554,1555,1556,1557,1558,1559,1560,1561,1562,1563,1564,1565,1566,1567,1568,1569,1570,1571,1572,1573,1574,1575,1576,1577,1578,1579,1580,1581,1582,1583,1584,1585,1586,1587,1644,1588,1589,1590,1591,1592,1593,1594,1595,1596,1597,1598,1599,1600,1601,1602,1603,1604,1605,1606,1607,1608,1609,1610,1611,1612,1613,1614,1615,1616,1617,1618,1619,1620,2323,2324,2325,2419,2420,2418,2422,2423,2424,2421,3431,558,3432,3433,556,3434,562,3435,1621,1623,1625,1627,1629,1631,1632,1633,1634,1635,1636,1637,1638,1639,1640,1641,2326,1643,2327,1645,2328,1647,2329,1649,2330,1651,2331,2335,1653,2332,1655,1657,1661,1659,1660,1671,1664,1663,1665,1667,1669,1666,1673,1668,1670,2333,2334,1675,2336,1677,2337,1679,2338,1681,2339,2340,2722,2723,2724,2725,2726,2727,2728,1764,1765,2729,2730,2731,2732,2733,2734,2735,2736,2737,2738,2739,2740,2741,2742,2743,2744,2745,2746,2747,2748,2749,2750,2815,2751,2752,2753,2754,2755,2756,2757,2758,2759,113,67,105,560,2299,1719,1720,2760,2761,2762,2763,2764,2765,2766,1257,1256,1255,1254,1253,1252,1251,1250,1249,107,106,27,28,2772,2773,2774,2775,2776,2777,2778,2779,2780,2781,2782,2783,2784,2785,1248,2973,108,25,26,73,2786,2787,2788,2789,2790,2791,2816,2792,2793,2794,2795,2796,2797,2798,2799,75,76,77,2402,2800,2801,2802,2803,2804,2813,2814,1723,79,2817,2818,2819,80,81,82,83,1724,2805,169,1715,1717,1721,1718,1725,2806,1727,155,1729,2807,1731,163,1743,2808,1745,159,1716,1722,1733,2809,1735,157,1737,2810,1739,167,1741,2811,161,2812,856,1742,3277,1004,1003,1005,1002,1008,3460,165,1747,2348,1749,2347,1751,2345,1753,1755,2343,1757,2921,1759,2922,1761,2923,1762,2924,2925,2820,1766,2821,1767,2822,1768,2823,1769,2824,1771,1642,1772,1773,1646,1774,1648,1775,1650,2975,1776,1652,1777,1654,1778,1656,1779,1780,1781,1782,1783,1784,1785,1672,1786,1674,1787,2825,1676,1788,1678,1789,1680,1790,1682,1791,1792,2826,2827,1927,2828,2829,2830,2831,2832,2833,2834,1803,1804,1805,1806,1807,1808,2835,1809,2836,1810,2837,1811,2838,1813,1814,2839,1815,1758,1816,1817,1818,1819,1820,1821,1822,2840,1824,2841,2842,2843,2844,2845,2846,1844,1802,1837,1838,2847,1839,1840,1841,1842,1843,1845,1846,1812,1847,1848,1849,1850,1851,1852,1853,1854,1855,1856,1857,1858,1859,1860,1939,1940,2848,1861,1862,1863,1864,1865,2849,1866,1867,2850,1868,1869,1870,1871,1872,1873,1874,1128,1875,1876,1877,1878,1879,1880,1881,1882,1883,1884,1885,1886,1887,1888,1889,1890,1941,1891,1892,1893,1894,1895,1896,1897,1898,2851,2852,2853,2854,1901,1904,1905,2855,1907,1908,1909,1910,1911,1912,1913,1928,1914,1915,1916,1942,1906,1903,1917,1918,1919,1920,1921,1922,1923,1924,1925,1926,1931,1932,1933,1934,1935,1936,1937,1938,2856,2857,2858,2859,2860,2861,2862,2863,2864,2865,2866,2867,2868,1943,1944,1945,1946,1947,1948,1949,1950,1951,1952,1953,1954,2869,2870,2871,2872,2873,2874,2875,2876,2877,2878,2879,2880,2881,2882,2883,2884,2885,1966,1967,1968,1969,1970,1971,1972,1973,2886,2887,2888,1974,855,1975,854,1976,853,1978,852,1979,851,1980,850,1981,849,1982,3304,1983,1026,1984,3305,1985,1194,1986,1987,1988,2889,2890,2891,2892,2893,2894,2895,2896,2897,2898,2899,2900,2901,2902,2903,2904,2905,2906,2907,2908,2909,1990,1991,1992,1993,2910,1994,2911,1995,2912,1996,1997,2913,1998,2914,1999,2915,2000,2916,2001,2917,2918,2002,2919,2003,2004,2005,2920,2006,2976,2007,2977,2008,726,2009,2010,2978,2011,2979,730,2034,2046,2047,2048,2049,2050,2051,2052,2053,2054,2055,612,602,2033,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2926,2927,2928,2056,2057,2058,2059,2060,2061,2062,2063,2064,2065,2066,2067,2929,2930,2931,2932,2933,2934,2935,2936,2937,904,903,911,2938,2939,2941,2942,2943,2944,2945,2946,2947,2948,2949,2950,2951,2952,2953,2954,2955,2956,2957,2107,1193,2108,1192,2109,1191,2110,1190,2111,1189,2112,1188,2113,1187,2114,1186,2115,1185,2116,3306,2117,3390,2142,2095,2096,2097,2098,2099,2100,2101,2102,2103,2104,2105,3307,2119,2120,3308,2121,3309,2122,3310,2123,3311,2124,728,2125,604,2126,3312,2127,606,2128,3313,2129,608,2130,2131,2132,3314,2133,610,2134,3315,2135,614,3316,2136,616,2137,3317,2138,618,2139,3318,2140,1089,1088,1087,1086,1085,1084,1083,1082,1081,1080,2972,620,2143,3319,2144,622,2145,3320,2146,624,2147,3321,626,2148,3322,2149,3327,628,2150,2151,2152,2980,732,2981,734,2982,736,2983,738,2984,740,2985,742,2986,744,2987,2988,2989,750,2990,752,2991,754,2992,756,2993,758,2994,760,2995,762,2996,764,2997,2141,3323,630,3324,632,3325,634,3326,636,1124,1123,1122,1121,941,2998,2999,940,939,938,937,936,935,934,933,924,922,3000,1110,792,1109,1108,1107,1106,1105,1104,1103,1102,1101,1100,1099,1098,1097,1096,1095,1094,1093,1092,3001,1278,1277,1276,1275,1274,1273,1272,1271,1270,1269,1268,1267,1266,1265,1264,1263,3002,3003,766,3004,768,3005,770,3006,772,3007,774,3008,776,3009,778,3010,780,3011,782,3012,784,3013,2153,638,3328,2068,112,3014,3015,3016,1120,1119,1118,1117,1116,1115,1114,1113,1112,3017,1283,1282,1281,1280,1279,3018,3019,3020,879,3021,3022,3023,3024,3025,3026,3027,3028,3029,3030,3031,3032,3033,3034,3035,3036,3037,3038,3039,3040,794,793,3041,962,3043,3044,3045,3046,3047,3048,3049,3050,3051,3052,3053,3054,3055,3056,3057,3058,3059,3060,3061,3062,3063,3064,3065,878,808,3066,980,979,978,977,976,975,974,973,972,971,3067,3068,3069,3070,3071,3072,3073,3074,3075,3076,3077,3078,3079,3080,3081,3082,3083,3084,3085,3086,3087,3088,3089,3090,3091,3092,3093,3094,3095,3096,3097,3098,3099,3100,3101,3102,3103,3104,3105,3106,3107,3108,3109,3110,3111,3112,3113,816,817,818,819,820,877,821,822,823,824,825,826,827,828,829,830,831,832,833,3114,986,987,988,989,990,991,992,993,994,995,996,997,998,999,1000,1001,3115,1152,1153,1154,1155,1156,1157,1158,1159,1160,1161,1162,1163,1164,1165,1166,1167,1168,1169,3116,3118,3120,3122,3124,861,3130,3135,3134,3133,3132,3131,3139,3138,3137,3136,876,875,874,873,864,863,862,860,859,3329,1040,1045,1044,1043,1042,1041,1039,1038,69,1902,1714,3391,1740,3392,1728,3393,1726,1760,3394,3395,1736,3396,1730,3397,1734,3398,1732,3364,3372,1630,3373,3370,3369,3377,3371,1628,3374,1622,3375,1626,3376,1624,3382,3383,3384,3385,3386,3387,3388,3389,1738,3399,1823,3401,1748,3402,1750,3403,1752,3404,1754,3405,1756,3406,3407,3408,1744,3409,3412,3420,3117,3413,3119,3414,3121,3415,3123,3416,3417,1658,3125,842,2250,2439,2438,3129,3128,3127,3126,2351,2499,3140,3424,3147,3425,3149,3426,3151,3427,843,3428,3440,3441,3442,3443,3444,564,3445,570,3446,2249,3159,3158,3157,3156,3169,3168,2156,2155,845,844,550,3436,554,3437,552,3438,1834,3439,3165,3164,3163,3162,3161,840,838,839,2307,841,566,3447,568,3448,572,3449,2278,1176,1174,692,1175,3278,1177,1006,1007,3276,1009,3450,698,3451,700,3452,702,3453,3454,3455,3456,690,3457,3458,694,3459,696,2106,2940,902,910,909,908,907,906,905,1072,1070,1079,1078,1075,1074,1073}'::integer[])))
  • Buffers: shared hit=159
16. 0.105 0.105 ↑ 1.0 1,684 1

Bitmap Index Scan on index_repositories_on_environment_id (cost=0.00..43.11 rows=1,684 width=0) (actual time=0.105..0.105 rows=1,684 loops=1)

  • Index Cond: (environment_id = ANY ('{1,7,8,9,10,11,12,13,14,15}'::integer[]))
  • Buffers: shared hit=25
17. 74.858 112.020 ↑ 1.0 226,695 1

Hash (cost=11,669.95..11,669.95 rows=226,695 width=290) (actual time=112.020..112.020 rows=226,695 loops=1)

  • Buckets: 1024 Batches: 128 Memory Usage: 618kB
  • Buffers: shared hit=9403, temp written=8768
18. 37.162 37.162 ↑ 1.0 226,695 1

Seq Scan on katello_rpms (cost=0.00..11,669.95 rows=226,695 width=290) (actual time=0.003..37.162 rows=226,695 loops=1)

  • Buffers: shared hit=9403