QUERY PLAN --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Finalize Aggregate (cost=8855923.53..8855923.54 rows=1 width=4) -> Gather (cost=8855922.80..8855923.51 rows=7 width=4) Workers Planned: 7 -> Partial Aggregate (cost=8854922.80..8854922.81 rows=1 width=4) -> Nested Loop Semi Join (cost=1.02..8854905.17 rows=7052 width=4) -> Parallel Index Scan using standard_buildroot_pkey on standard_buildroot (cost=0.44..606990.47 rows=3282972 width=8) -> Index Only Scan using buildroot_listing_buildroot_id_key on buildroot_listing (cost=0.58..4394.93 rows=2282 width=4) Index Cond: ((buildroot_id = standard_buildroot.buildroot_id) AND (rpm_id = ANY ('{10859025,10859026,10859027,10859028,10859029,10859030,10859031,10859032,10859033,10859034,10859035,10859036,10859037,10859038,10859039,10859040,10859041,10859042,10859043,10859044,10859045,10859046,10859047,10859048,10859049,10859050,10859051,10859052,10859053,10859054,10859055,10859056,10859057,10859058,10859059,10859060,10859061,10859062,10859063,10859064,10859065,10859066,10859067,10859068,10859069,10859070,10859071,10859072,10859073,10859074,10859075,10859076,10859077,10859078,10859079,10859080,10859081,10859082,10859083,10859084,10859085,10859086,10859087,10859088,10859089,10859090,10859091,10859092,10859093,10859094,10859095,10859096,10859097,10859098,10859099,10859100,10859101,10859102,10859103,10859104,10859105,10859106,10859107,10859108,10859109,10859110,10859111,10859112,10859113,10859114,10859115,10859116,10859117,10859118,10859119,10859120,10859121,10859122,10859123,10859124,10859125,10859126,10859127,10859128,10859129,10859130,10859131,10859132,10859133,10859134,10859135,10859136,10859137,10859138,10859139,10859140,10859141,10859142,10859143,10859144,10859145,10859146,10859147,10859148,10859149,10859150,10859151,10859152,10859153,10859154,10859155,10859156,10859157,10859158,10859159,10859160,10859161,10859162,10859163,10859164,10859165,10859166,10859167,10859168,10859169,10859170,10859171,10859172,10859173,10859174,10859175,10859176,10859177,10859178,10859179,10859180,10859181,10859182,10859183,10859184,10859185,10859186,10859187,10859188,10859189,10859190,10859191,10859192,10859193,10859194,10859195,10859196,10859197,10859198,10859199,10859200,10859201,10859202,10859203,10859204,10859205,10859206,10859207,10859208,10859209,10859210,10859211,10859212,10859213,10859214,10859215,10859216,10859217,10859218,10859219,10859220,10859221,10859222,10859223,10859224,10859225,10859226,10859227,10859228,10859229,10859230,10859231,10859232,10859233,10859234,10859235,10859236,10859237,10859238,10859239,10859240,10859241,10859242,10859243,10859244,10859245,10859246,10859247,10859248,10859249,10859250,10859251,10859252,10859253,10859254,10859255,10859256,10859257,10859258,10859259,10859260,10859261,10859262,10859263,10859264,10859265,10859266,10859267,10859268,10859269,10859270,10859271,10859272,10859273,10859274,10859275,10859276,10859277,10859278,10859279,10859280,10859281,10859282,10859283,10859284,10859285,10859286,10859287,10859288,10859289,10859290,10859291,10859292,10859293,10859294,10859295,10859296,10859297,10859298,10859299,10859300,10859301,10859302,10859303,10859304,10859305,10859306,10859307,10859308,10859309,10859310,10859311,10859312,10859313,10859314,10859315,10859316,10859317,10859318,10859319,10859320,10859321,10859322,10859323,10859324,10859325,10859326,10859327,10859328,10859329,10859330,10859331,10859332,10859333,10859334,10859335,10859336,10859337,10859338,10859339,10859340,10859341,10859342,10859343,10859344,10859345,10859346,10859347,10859348,10859349,10859350,10859351,10859352,10859353,10859354,10859355,10859356,10859357,10859358,10859359,10859360,10859361,10859362,10859363,10859364,10859365,10859366,10859367,10859368,10859369,10859370,10859371,10859372,10859373,10859374,10859375,10859376,10859377,10859378,10859379,10859380,10859381,10859382,10859383,10859384,10859385,10859386,10859387,10859388,10859389,10859390,10859391,10859392,10859393,10859394,10859395,10859396,10859397,10859398,10859399,10859400,10859401,10859402,10859403,10859404,10859405,10859406,10859407,10859408,10859409,10859410,10859411,10859412,10859413,10859414,10859415,10859416,10859417,10859418,10859419,10859420,10859421,10859422,10859423,10859424,10859425,10859426,10859427,10859428,10859429,10859430,10859431,10859432,10859433,10859434,10859435,10859436,10859437,10859438,10859439,10859440,10859441,10859442,10859443,10859444,10859445,10859446,10859447,10859448,10859449,10859450,10859451,10859452,10859453,10859454,10859455,10859456,10859457,10859458,10859459,10859460,10859461,10859462,10859463,10859464,10859465,10859466,10859467,10859468,10859469,10859470,10859471,10859472,10859473,10859474,10859475,10859476,10859477,10859478,10859479,10859480,10859481,10859482,10859483,10859484,10859485,10859486,10859487,10859488,10859489,10859490,10859491,10859492,10859493,10859494,10859495,10859496,10859497,10859498,10859499,10859500,10859501,10859502,10859503,10859504,10859505,10859506,10859507,10859508,10859509,10859510,10859511,10859512,10859513,10859514,10859515,10859516,10859517,10859518,10859519,10859520,10859521,10859522,10859523,10859524,10859525,10859526,10859527,10859528,10859529,10859530,10859531,10859532,10859533,10859534,10859535,10859536,10859537,10859538,10859539,10859540,10859541,10859542,10859543,10859544,10859545,10859546,10859547,10859548,10859549,10859550,10859551,10859552,10859553,10859554,10859555,10859556,10859557,10859558,10859559,10859560,10859561,10859562,10859563,10859564,10859565,10859566,10859567,10859568,10859569,10859570,10859571,10859572,10859573,10859574,10859575,10859576,10859577,10859578,10859579,10859580,10859581,10859582,10859583,10859584,10859585,10859586,10859587,10859588,10859589,10859590,10859591,10859592,10859593,10859594,10859595,10859596,10859597,10859598,10859599,10859600,10859601,10859602,10859603,10859604,10859605,10859606,10859607,10859608,10859609,10859610,10859611,10859612,10859613,10859614,10859615,10859616,10859617,10859618,10859619,10859620,10859621,10859622,10859623,10859624,10859625,10859626,10859627,10859628,10859629,10859630,10859631,10859632,10859633,10859634,10859635,10859636,10859637,10859638,10859639,10859640,10859641,10859642,10859643,10859644,10859645,10859646,10859647,10859648,10859649,10859650,10859651,10859652,10859653,10859654,10859655,10859656,10859657,10859658,10859659,10859660,10859661,10859662,10859663,10859664,10859665,10859666,10859667,10859668,10859669,10859670,10859671,10859672,10859673,10859674,10859675,10859676,10859677,10859678,10859679,10859680,10859681,10859682,10859683,10859684,10859685,10859686,10859687,10859688,10859689,10859690,10859691,10859692,10859693,10859694,10859695,10859696,10859697,10859698,10859699,10859700,10859701,10859702,10859703,10859704,10859705,10859706,10859707,10859708,10859709,10859710,10859711,10859712,10859713,10859714,10859715,10859716,10859717,10859718,10859719,10859720,10859721,10859722,10859723,10859724,10859725,10859726,10859727,10859728,10859729,10859730,10859731,10859732,10859733,10859734,10859735,10859736,10859737,10859738,10859739,10859740,10859741,10859742,10859743,10859744,10859745,10859746,10859747,10859748,10859749,10859750,10859751,10859752,10859753,10859754,10859755,10859756,10859757,10859758,10859759,10859760,10859761,10859762,10859763,10859764,10859765,10859766,10859767,10859768,10859769,10859770,10859771,10859772,10859773,10859774,10859775,10859776,10859777,10859778,10859779,10859780,10859781,10859782,10859783,10859784,10859785,10859786,10859787,10859788,10859789,10859790,10859791,10859792,10859793,10859794,10859795,10859796,10859797,10859798,10859799,10859800,10859801,10859802,10859803,10859804,10859805,10859806,10859807,10859808,10859809,10859810,10859811,10859812,10859813,10859814,10859815,10859816,10859817,10859818,10859819,10859820,10859821,10859822,10859823,10859824,10859825,10859826,10859827,10859828,10859829,10859830,10859831,10859832,10859833,10859834,10859835,10859836,10859837,10859838,10859839,10859840,10859841,10859842,10859843,10859844,10859845,10859846,10859847,10859848,10859849,10859850,10859851,10859852,10859853,10859854,10859855,10859856,10859857,10859858,10859859,10859860,10859861,10859862,10859863,10859864,10859865,10859866,10859867,10859868,10859869,10859870,10859871,10859872,10859873,10859874,10859875,10859876,10859877,10859878,10859879,10859880,10859881,10859882,10859883,10859884,10859885,10859886,10859887,10859888,10859889,10859890,10859891,10859892,10859893,10859894,10859895,10859896,10859897,10859898,10859899,10859900,10859901,10859902,10859903,10859904,10859905,10859906,10859907,10859908,10859909,10859910,10859911,10859912,10859913,10859914,10859915,10859916,10859917,10859918,10859919,10859920,10859921,10859922,10859923,10859924,10859925,10859926,10859927,10859928,10859929,10859930,10859931,10859932,10859933,10859934,10859935,10859936,10859937,10859938,10859939,10859940,10859941,10859942,10859943,10859944,10859945,10859946,10859947,10859948,10859949,10859950,10859951,10859952,10859953,10859954,10859955,10859956,10859957,10859958,10859959,10859960,10859961,10859962,10859963,10859964,10859965,10859966,10859967,10859968,10859969,10859970,10859971,10859972,10859973,10859974,10859975,10859976,10859977,10859978,10859979,10859980,10859981,10859982,10859983,10859984,10859985,10859986,10859987,10859988,10859989,10859990,10859991,10859992,10859993,10859994,10859995,10859996,10859997,10859998,10859999,10860000,10860001,10860002,10860003,10860004,10860005,10860006,10860007,10860008,10860009,10860010,10860011,10860012,10860013,10860014,10860015,10860016,10860017,10860018,10860019,10860020,10860021,10860022,10860023,10860024,10860025,10860026,10860027,10860028,10860029,10860030,10860031,10860032,10860033,10860034,10860035,10860036,10860037,10860038,10860039,10860040,10860041,10860042,10860043,10860044,10860045,10860046,10860047,10860048,10860049,10860050,10860051,10860052,10860053,10860054,10860055,10860056,10860057,10860058,10860059,10860060,10860061,10860062,10860063,10860064,10860065,10860066,10860067,10860068,10860069,10860070,10860071,10860072,10860073,10860074,10860075,10860076,10860077,10860078,10860079,10860080,10860081,10860082,10860083,10860084,10860085,10860086,10860087,10860088,10860089,10860090,10860091,10860092,10860093,10860094,10860095,10860096,10860097,10860098,10860099,10860100,10860101,10860102,10860103,10860104,10860105,10860106,10860107,10860108,10860109,10860110,10860111,10860112,10860113,10860114,10860115,10860116,10860117,10860118,10860119,10860120,10860121,10860122,10860123,10860124,10860125,10860126,10860127,10860128,10860129,10860130,10860131,10860132,10860133,10860134,10860135,10860136,10860137,10860138,10860139,10860140,10860141,10860142,10860143,10860144,10860145,10860146,10860147,10860148,10860149,10860150,10860151,10860152,10860153,10860154,10860155,10860156,10860157,10860158,10860159,10860160,10860161,10860162,10860163,10860164,10860165,10860166,10860167,10860168,10860169,10860170,10860171,10860172,10860173,10860174,10860175,10860176,10860177,10860178,10860179,10860180,10860181,10860182,10860183,10860184,10860185,10860186,10860187,10860188,10860189,10860190,10860191,10860192,10860193,10860194,10860195,10860196,10860197,10860198,10860199,10860200,10860201,10860202,10860203,10860204,10860205,10860206,10860207,10860208,10860209,10860210,10860211,10860212,10860213,10860214,10860215,10860216,10860217,10860218,10860219,10860220,10860221,10860222,10860223,10860224,10860225,10860226,10860227,10860228,10860229,10860230,10860231,10860232,10860233,10860234,10860235,10860236,10860237}'::integer[]))) (8 rows)