explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hnem

Settings
# exclusive inclusive rows x rows loops node
1. 27.986 12,014.901 ↑ 7.3 820 1

HashAggregate (cost=3,816.42..3,876.68 rows=6,026 width=143) (actual time=12,014.151..12,014.901 rows=820 loops=1)

  • Group Key: defect_families.id, defect_families.name, defect_families.description, defect_families.display, defect_families.created_at, defect_families.updated_at, defect_families.variety_id, defect_families.total, defect_families.accept_issues_total, defect_families.rating_id, defect_families.document, defect_families.company_id, defect_families.archived, defect_families.specification_import_id
2. 11,747.350 11,986.915 ↓ 1.9 13,454 1

Hash Left Join (cost=2,671.87..3,565.89 rows=7,158 width=143) (actual time=318.950..11,986.915 rows=13,454 loops=1)

  • Hash Cond: (defect_family_products.product_id = products.internal_id)
  • Filter: (((users.id = 245) AND programs.active AND (programs.start_date <= '2019-06-07'::date) AND (programs.end_date >= '2019-06-07'::date)) OR (products.internal_id = ANY ('{7963,7705,7706,7707,7768,7767,9038,7610,7769,9106,8885,7754,8895,7792,8985,7793,7797,7973,7883,9092,7934,8991,7937,7976,7935,7939,9070,7980,9078,8947,8936,8917,8999,8937,8927,8955,8939,8929,9001,8945,8887,8951,8943,9037,9005,8944,8884,8873,9121,9120,8928,9006,8907,9003,8894,8880,8946,9058,9059,8940,8938,9028,9026,9025,9027,8950,9043,8893,8872,8905,9088,9017,8015,7978,8055,8059,8054,7979,8058,8056,8057,8053,7764,8853,8857,9080,9083,9021,8994,8875,8897,8857,8853,8060,8062,8061,9042,8063,8995,8075,8876,7981,7960,8067,8071,8072,8069,8070,8073,8074,8100,8101,8102,8103,7690,7691,9053,7607,7716,7717,13960,9040,13940,13942,13936,13941,13938,13937,13939,13935,14000,7968,8930,9772,13953,13988,9033,7766,7770,8981,9109,9107,9108,9030,8903,8926,8867,9116,9032,8920,13947,8860,7995,9016,9064,7983,8107,8108,8104,8914,8877,8878,8879,8909,8969,13948,9055,8997,13976,13971,13980,13977,13972,13978,13974,13975,13964,13969,13970,13965,13966,8922,13967,13968,8923,13973,13979,9011,13981,8941,13984,13994,13993,9100,13928,9063,9066,9060,9067,9061,8957,7926,9015,13989,13932,13946,13933,9051,7964,7708,7714,8065,7711,7710,7712,7713,8975,13985,13949,7709,7611,7858,7857,7865,7851,7852,7859,7860,7862,7827,7843,7816,7826,7814,7824,7840,7834,7838,7839,7841,7842,7831,7829,7825,8866,8888,8890,9072,9073,9074,7869,7867,7868,7954,9056,13992,8014,8066,8855,9110,8855,8022,8021,8020,9045,8869,8023,8024,8098,8099,9068,7969,7798,7799,7692,8948,8908,7900,7899,9062,8935,7970,7800,14737,14738,14003,14004,14005,14007,14008,14742,14744,14009,14746,14752,14012,14015,14016,14759,14017,14018,14019,14761,14764,14765,14767,14768,14776,14777,14778,14779,14783,14791,14031,14032,14033,14798,14799,14800,14801,14802,14803,14037,14038,14805,14806,14040,14041,14807,14042,14808,14043,14044,14045,14046,14047,14048,14049,14050,14051,14052,14053,14054,14055,14810,14057,14058,14059,14060,14061,14816,14062,14820,14064,14065,14066,14822,14068,14069,14070,14071,14074,14080,14839,14081,14082,14841,14084,14085,14086,14087,14088,14089,14845,14090,14091,14092,14093,14095,14849,14097,14099,14100,14101,14102,14104,14851,14106,14108,14853,14854,14110,14113,14114,14115,14116,14117,14119,14125,14126,14864,14868,14871,14873,14874,14875,14878,14881,14883,14888,14889,14890,14891,14892,14893,14894,14896,14897,14898,14900,14901,14904,14905,14906,14129,14131,14133,14909,14910,14911,14912,14134,14135,14914,14136,14915,14917,14137,14138,14920,14921,14922,14923,14924,14926,14927,14930,14932,14139,14934,14936,14937,14939,14940,14941,14942,14943,14944,14142,14145,14148,14149,14150,14151,14152,14153,14956,14957,14958,14169,14170,14171,14959,14960,14177,14183,14186,14188,14189,14190,14195,14196,14197,14972,14198,14199,14973,14201,14203,14205,14208,14980,14982,14987,14211,14212,14216,14217,14218,14990,14992,14993,14228,14229,14230,14231,14232,14995,14999,15000,15002,15003,15005,15006,15007,15008,15011,15017,15018,15022,14241,15023,15027,14244,15032,15040,14250,14252,14253,14254,14255,14256,14257,14258,14260,14261,14262,14263,15045,15046,14264,14265,14266,14267,15047,14268,15048,15050,15053,15061,15062,15076,15077,14273,15079,15080,15095,15101,14284,14285,15106,15119,14301,15120,15121,15133,15134,15139,15140,15141,15142,15156,15157,15158,15160,15163,15164,15165,15167,15168,14329,14330,14331,15171,15172,14332,14333,14334,14335,15173,14336,15174,14337,14338,14339,15175,15177,15178,15179,14340,15181,15183,15184,15185,14341,15186,15190,15191,14344,14348,15193,14350,14351,15195,14353,14354,14357,14359,14361,15201,14363,15203,14365,14366,14369,15207,15208,14372,14373,14374,14375,15216,15219,14377,15221,15222,14379,15224,15225,15226,15228,14380,14381,14382,14384,15231,14385,14386,15239,15240,14388,14389,14390,14394,14395,14396,14397,14398,14399,14401,14402,14403,14404,14406,14407,14412,14414,14416,15253,14417,14418,14419,14421,14422,14423,14424,14425,14426,14427,14428,14429,15259,14432,14433,14434,15261,15262,15263,14435,14436,14437,14438,14440,14442,14443,14444,15267,14445,14446,14447,15270,14452,14453,14454,14456,14457,14458,14459,14460,14461,15272,14465,14467,14468,14470,15276,15277,14481,14482,14483,14484,14488,14492,14493,15281,14494,14495,15282,15284,15286,15288,15290,15292,14499,14500,15294,14501,14502,14503,14504,14505,15296,14506,14507,14508,14509,14510,14511,15301,14514,14515,14516,15302,14519,14520,14521,14531,14532,15314,15317,14540,15318,14541,14544,14545,14546,14547,14552,15326,14554,15327,14555,14556,14560,14561,14562,14563,15330,14565,14567,14569,14570,14571,14572,14575,14586,14587,14588,14589,14594,14595,14596,14597,14598,14599,14600,14602,14604,14605,14606,14607,14608,14609,15335,14610,14611,15338,14616,14618,14619,14620,14626,14627,14628,14629,14630,14634,14635,14640,15344,14644,14647,14653,14654,14657,15346,15347,14659,14661,15350,15351,15352,14662,7796,14035,14270,15137,8068,7943,7942,7944,14788,14846,14214,15138,14660,8942,14328,7940,7941,9091,9079,14780,14840,14112,15135,15136,8033,8032,8034,8031,8052,8046,8026,8045,8048,9036,13983,15182,15213,15230,8042,8027,8038,15024,15025,15321,7977,8049,8050,8047,9105,9034,9041,8039,8037,7955,7956,8028,8036,8043,8952,8904,9057,9115,9089,14782,14795,14809,14056,14814,14818,14821,14836,14850,14858,14903,14961,14204,14215,14991,15055,15056,15162,15205,15212,15214,15235,15247,15248,15310,14542,14543,15342,7999,8002,8005,8004,8010,8013,8001,8006,8011,8012,8003,7992,8008,9095,9024,9023,8993,8921,8968,8967,15459,9044,8000,8007,14827,14902,15153,15154,15155,15237,14405,14411,15256,14431,15265,15266,15268,14490,15287,15320,8076,7776,7777,7774,8077,7967,7775,14781,14817,14857,15187,15245,9031,9019,8954,9111,9029,15448,15392,15765,15536,7894,9018,8986,9164,9775,14246,14613,15790,15550,15641,14222,14534,18671,7949,7946,7947,7950,7948,7945,8910,9007,8913,9008,8886,13921,14790,14876,14224,14376,15241,18666,14111,7787,7791,14094,14879,14935,14950,14963,14550,7889,7879,8856,14745,14866,14867,15293,15328,7701,7700,7962,14574,15299,14593,15411,7670,7669,7959,7672,9104,14756,15227,15285,14513,14614,15538,14763,14642,18797,15405,15289,7743,7966,7746,9102,9101,9112,9119,8899,9085,14200,14213,14994,15274,15304,14522,14622,14623,14624,14643,7609,7965,8949,13919,14863,14466,14471,9046,9096,7801,7953,8901,9098,14769,14771,14497,7803,7805,9097,7982,7957,8882,14063,14880,14925,14971,15127,15206,15236,15297,15312,14603,14615,15339,15340,14631,14632,15343,8079,8091,9082,8902,14855,15209,15210,7756,7757,7755,7758,7759,8963,8960,9118,14030,14831,14832,15037,15042,14279,14321,14553,15784,7987,15004,7724,7726,7727,7725,7984,14882,14966,15028,15029,15030,7985,15033,14247,15038,15258,15349,15616,18944,7760,7762,7761,7763,15036,15348,15615,18943,7984,7985,15617,7733,7765,7951,9035,9093,9039,14796,14877,15280,15323,14548,14549,7702,13958,8973,15073,7697,7704,7698,7703,8972,9084,13959,14819,14073,14856,14872,15071,15246,15300,15309,15395,8864,8892,8900,7972,7872,7873,14862,14300,15671,15669,7897,7898,8976,14083,15049,14360,15305,14001,14006,14010,14013,14797,14034,14036,14039,8883,14072,14833,14834,14076,14096,14098,14852,14107,8906,14122,14123,14124,14859,14895,14899,8919,14913,14918,14929,14931,14938,14140,14141,14945,14147,14154,14155,14156,14157,14158,14159,14160,14161,14162,14163,14164,14165,14951,14952,14953,14954,14955,14166,14962,14178,14179,14180,14181,14182,14194,14977,14981,14983,14984,14985,14988,14989,14226,14996,14997,15001,14233,14234,14235,14236,13926,13927,14239,14240,14242,14243,15031,13929,14251,14259,15067,14271,15166,15233,15234,14392,14393,15250,14400,14408,14409,14410,14439,14462,14463,14464,14476,14477,15278,15279,14491,14517,14524,14525,14526,14529,14530,14533,14537,14538,14539,15329,14576,14577,14579,14580,14581,14582,14583,14584,14585,14591,13930,14617,14621,14636,14637,14638,14639,14646,14656,15682,14658,15401,15408,15415,15416,15425,15427,15442,15437,15438,15441,15445,15446,15452,15453,15460,15461,15469,15470,15473,15474,15475,15477,15478,15479,15480,15481,15482,15483,15484,15485,15490,15492,15493,15494,15502,15503,15514,15526,15528,15542,15544,15545,15549,15556,15557,15558,15559,15569,15572,15578,15579,15583,15584,15585,15586,15588,15589,15591,15590,15592,15593,15594,15595,15596,15597,15599,15604,15613,15614,15618,15622,15623,15625,15627,15628,15632,15633,15634,15638,15639,15656,15657,15659,15658,15664,15665,15666,15667,15668,15670,15673,15674,15675,15676,15680,15681,15683,15685,15692,15694,15696,15697,15698,15699,15700,15701,15702,15704,15711,15715,15724,15726,15728,15729,15731,15732,15733,15734,15741,15747,15742,15746,15748,15743,15749,15750,15744,15751,15757,15758,15762,15771,15794,15795,15802,15805,15807,15815,15816,15817,15818,15819,15820,15826,15831,15830,15828,15832,15829,15833,15827,15834,15835,15837,15838,15836,15841,15842,15848,15849,15852,15855,15856,15857,15858,15862,15869,15872,15873,15874,15875,15903,15908,15909,15912,15914,15926,15928,15929,15930,15935,15947,18622,18624,18631,18633,18641,18642,18646,18647,18648,18650,18651,18653,18662,18663,18669,18679,18699,18704,18703,18705,18711,18720,18727,18729,18730,18734,18735,18736,18763,18766,18768,18769,18773,18774,18784,18788,18791,18799,18801,18802,18804,18811,18812,18817,18818,18819,18820,18824,18826,18827,18850,18877,18880,18881,18882,18883,18884,18888,18891,18894,18898,18897,18902,18914,18916,18917,18918,18919,18920,18921,18922,18927,18930,18931,18933,18948,18950,18952,18953,18955,18956,18954,18957,18958,18959,18961,18962,18963,18967,18974,18987,18991,18992,18990,18994,18993,18996,18995,18997,19000,19001,19002,19008,19007,19009,19010,19012,19014,19013,19015,19016,19033,19030,19031,19032,19036,19035,19037,19038,19041,19040,19039,19042,19043,19044,19051,19050,19052,19053,19054,19055,19056,19057,19058,9065,14299,19059,19061,19062,19064,19065,19066,19067,19069,19068,19070,19073,19077,19078,19079,19080,19081,19082,19084,19083,19085,19086,19088,19089,19091,19092,19094,19093,19095,19096,19098,19099,19100,19097,19101,19102,19104,19105,19106,19108,19114,19115,19119,19118,19117,19116,19123,19124,19126,19125,19127,19128,19129,19130,19131,19132,19135,19134,19136,19138,19139,19140,7961,19144,19148,19147,19150,19156,19152,19157,19158,19153,19154,19155,19160,19159,19161,19168,19167,19171,19172,19174,19186,19185,19187,19188,19189,19190,19191,19192,19194,19195,19196,19198,19197,19199,19200,19201,19202,19203,19205,19204,19207,19208,19212,19213,19214,19216,19215,19226,19237,19238,19236,19239,19240,19253,19254,19255,19256,19257,19258,19262,19261,19263,19264,19265,19266,19270,19267,19269,19268,19271,19273,19279,19284,19285,19287,19288,19290,19291,19289,19292,19293,19294,19304,19305,7920,7914,7917,7913,7907,14025,15126,15152,14786,15176,7975,14785,15123,15244,7924,7923,14865,15220,7922,15128,14928,7916,15170,19333,19334,19336,19337,19338,19343,19351,19366,19367,19369,19378,19379,19377,19374,19373,19376,19375,19383,19385,18968,19389,19390,19391,19394,19396,19397,19403,19406,19409,19416,19423,19430,19431,19434,19435,19436,19437,19439,19440,19441,19443,19445,19455,19457,19458,19459,19460,19461,19462,19476,19483,19488,19500,19505,19507,19510,19511,19515,19521,19524,19525,19535,19536,19543,19554,19559,19573,19574,19572,19571,19570,19582,19587,19589,19590,19591,19592,19596,19597,19600,19603,19607,19609,19610,19612,19615,19627,19626,19633,19636,19638,19639,19641,19644,20605,20606,20608,20611,20613,20616,20618,20633,20639,20640,20652,8961,7715,20676,20753,20764,20762,20763,20766,20765,20778,20777,20779,20787,20793,20799,20801,20802,20804,20808,20809,20810,20811,20812,20813,20814,20816,20817,20826,20828,20842,15104,7808,20852,20882,20888,20889,20895,20896,20931,20934,7815,7836,14168,15019,15093,15094,7853,7819,7830,7835,14766,14837,14885,14219,15096,15308,7861,7821,15124,15125,15238,14167,15016,15107,15108,15145,7822,7823,7832,7837,14220,15143,15144,7850,7813,7812,7811,7833,7828,8889,14815,14884,15009,15074,15075,15311,7864,7845,14773,15015,15109,14528,20940,20945,20946,20949,20951,20950,20952,20954,20953,20972,20981,20978,20980,20979,20984,20986,19368,20990,21003,14916,21038,21039,21073,21076,21077,21095,21102,21129,21132,21131,21138,21135,21139,21137,21136,21134,21140,21141,21142,21143,25420,25573,25712,25715,25718,25720,25926,26035,26048,26097,26106,26385,26457,26458,26460,26461,26490,26493,26498,26559,26590,26615,26619,26620,26624,26625,26626,26650,26651,26652,26655,26653,26654,26657,26659,26660,26661,26663,26664,26866,26883,26904,26908,26906,26905,26907,26909,26953,26978,26979,27007,27026,27087,8009,27441,27440,27593,27595,27681,27682,8086,18690,18828,7747,7742,15087,15088,15397,7744,7988,9117,9099,9103,26656,27535,15298,18636,18644,8083,27838,27839,7818,27857,7844,7719,8064,27958,27959,28047,28050,28061,28062,28241,28290,28315,28317,28353,28376,28378,28381,28380,28388,28386,28387,28389,28410,28481,28483,28485,28505,28506,28507,28508,28525,28524,28531,28532,28552,28551,28604,28606,28623,28624,28633,28644,28666,28667,28617,28672,28693,28724,28750,28772,28789,28790,28795,28796,28798,28797,28799,28800,28801,28815,28816,28817,28818,28819,28820,28821,28857,28858,28859,28861,28872,28873,28874,28879,28880,28881,28882,28883,28884,28885,28910,15457,27118,28626,28467,21107,15410,15491,15505,15506,15507,15510,15512,15710,18806,19446,19478,19594,26312,26658,28643,28725,28952,28953,28955,28964,28965,28966,28986,29009,29043,29047,29046,29069,29070,29071,29072,29073,29075,29098,29099,29113,29114,29115,29116,29117,29118,29130,29131,29132,29156,29157,29343,29384,14291,14287,14289,14292,14294,14297,8990,14315,14316,14317,19395,15811,19456,15443,19593,29464,29465,29525,29543,29561,29601,29626,29634,29656,29657,29674,29681,29729,29733,29752,29753,29754,29755,29756,29770,29792,29799,29833,29905,29935,29968,30013,30014,30046,30047,30061,7887,7888,30082,30107,30124,30138,30147,30186,30191,30091,30190,30222,30246,30247,30254,19605,30284,30285,30336,30337,30343,30371,30382,30418,30422,30442,30478,30479,30480,21058,30544,30559,30560,30561,21060,21061,21037,20912,21094,20971,21048,21126,20898,21050,21072,21124,20970,20938,20962,21049,21014,20996,21001,20908,20961,20995,20988,21127,15390,25703,15412,15398,15402,15400,15413,15409,15406,15414,15417,15430,15420,15421,15422,15432,15407,15434,15436,15435,15455,15513,15467,15517,15468,15472,15516,15464,15515,15548,15531,15530,15570,15552,15547,15532,15535,15551,15529,15539,15555,21093,21091,15426,15404,15433,15581,15497,15571,15580,15450,15582,15603,15540,15553,15611,15619,15672,15642,15631,15630,15640,15677,15693,15391,15679,15645,15607,15612,15636,15712,15714,15713,15602,15707,15600,15760,15774,15775,15779,15786,15781,15782,15796,15769,15770,15766,15788,15767,15787,15804,15809,15813,15810,15814,15610,15845,15803,15876,15906,15918,15863,15939,15940,18626,18645,18649,15708,18635,18685,18698,18722,18765,18767,18677,18795,18831,19393,19034,19469,19372,20792,26885,19286,19451,26266,18792,15938,18892,19075,19181,19242,19306,19272,19347,19477,19401,19498,19417,19583,19646,19645,20609,20800,26386,26936,26977,27659,27738,27704,27954,27927,27930,27928,28292,28340,28291,15772,28445,28621,15525,18777,28812,28814,20771,15721,19335,29467,18893,29813,20881,19277,19332,29945,18960,29997,15605,26532,30389,18928,18712,15608,15606,19345,15706,15609,15864,15919,15924,15932,15911,15943,18623,18660,15931,15942,18659,18940,18945,19145,19146,19410,20885,20886,26047,26867,18923,29360,28541,29394,29726,15458,30481,30493,19122,19241,19339,18665,20634,20636,20772,20773,20831,28264,20745,20933,15429,18682,19581,28860,20785,19556,19634,18654,20659,20834,18655,19487,19560,27859,27801,28028,14413,15936,15941,18638,18664,18964,18972,19120,19163,19407,19349,20607,20750,20755,26045,26976,19588,19631,15921,19137,19480,28464,15922,19307,19348,27483,28615,30492,15910,19121,19165,19381,19301,15861,27705,15860,15927,15937,18630,18637,18681,18717,18725,18724,18680,18822,18829,18700,18941,19087,19179,27085,27144,27802,27978,28010,29602,8097,14861,14227,19481,20754,26623,28080,29147,18808,19494,19485,29934,18825,18901,19551,19468,19225,18951,18803,19111,19169,19555,19601,20619,20631,20637,28791,19380,19491,18640,20612,29524,29600,30108,19537,27059,29592,29595,29593,29594,29596,29946,18778,29330,29359,29690,29700,15923,18796,21103,20774,20776,20806,15851,27058,28739,19492,19063,19392,30294,19637,30224,18985,19133,25924,18949,15451,20775,19479,20819,26560,26783,20791,15913,29390,15905,15904,19608,28096,28097,28098,29342,18731,29008,30157,18981,18915,19482,18632,34324,34325,34326,34334,34655,34718,34719,15013,15112,15113,7847,7866,7849,15059,15060,15105,15012,7854,7820,7817,15058,14933,15010,34805,34806,34807,34808,34809,7846,15014,15110,15111,14886,7856,7855,14173,8891,34813,34852,34854,34869,7677,14919,14986,8881,15643,15644,15687,18627,18691,19103,19499,28523,8690,14747,15678,8898,14128,14751,15064,14829,15254,14755,15065,7958,7688,15180,15223,14838,15322,14812,14870,18639,18798,15925,19415,15868,18890,19149,19173,15637,7699,34915,34937,34938,29258,18674,26267,34608,18741,19175,19438,34617,34663,34664,34879,19422,19454,20822,18621,18896,27005,29964,29962,27027,19504,20835,29963,29965,29967,29773,19604,19613,20653,29772,34958,34983,34990,35018,35019,19209,19512,20748,20749,29523,29466,29556,29557,29559,29558,29810,29809,29811,34485,18789,15768,29531,19370,27683,19278,19371,30477,20788,28954,27874,27955,28027,30494,27858,28029,14887,15129,14415,14448,19611,19364,28773,30419,30484,34651,34995,18770,18794,19109,18793,34307,26220,19112,19151,25986,26621,29731,30475,30476,34486,34871,15839,19344,19412,19413,19484,26497,26622,28616,28625,29278,29906,15554,18684,19251,30790,34566,34893,26662,34870,34868,34867,18676,19444,18732,19475,26307,28011,28026,20786,28622,28683,29916,35022,20820,26309,26310,20746,29918,26308,34994,29727,29725,20907,19493,29728,27796,29751,15907,18643,18686,20615,20614,20620,20780,20798,19250,15759,15761,15763,34725,20942,21130,21125,20977,20982,25231,15424,15527,15621,15626,15684,15624,15691,15690,15705,15703,18728,18764,18787,18726,18889,18929,19388,19450,19497,19414,19585,19599,20635,20647,20651,20642,20752,20827,20829,26350,26353,26496,26492,26491,26489,26780,27002,27737,19426,15727,15620,29074,19331,29393,29447,29530,29562,15428,29662,29757,19640,20646,20645,20644,20948,20944,20955,20830,20943,20956,20947,20983,30682,15695,15722,34991,15725,34992,15686,15789,28316,28379,29758,15709,30722,18656,19243,19245,19249,19248,19252,19464,20770,18672,19400,28209,28210,28230,28273,28277,28274,28276,28275,28279,28278,28280,28281,28730,19170,19244,19502,20836,27837,19463,19246,19382,26617,26618,19247,19503,28046,35037,35060,35062,35068,9075,35078,15345,9077,9076,35095,7615,7915,7910,7911,7912,7918,25991,35113,7908,7921,7909,35126,35128,35164,35165,35219,35288,35289,35290,35291,35300,35317,26456,35335,35346,7741,34552,29732,30589,35354,35367,35368,35369,35370,35372,35373,35401,35402,35403,35404,35405,35406,35407,35408,35409,35410,35411,35413,35412,35414,8831,19011,18721,18634,15337,21065,21101,21066,15511,30692,20654,15718,35455,7745,29771,29446,14739,35464,35465,35482,35489,15242,35546,35547,35548,35613,35614,35615,35621,19074,18932,9175,18895,28684,28826,8925,15773,19420,28526,9012,8912,15601,18667,14245,19028,9771,14518,14651,8870,15439,8987,8988,27881,8989,7893,21010,20932,15252,28670,15388,28671,28740,35445,35646,35656,8051,14002,14760,14813,14811,14826,14793,14842,15243,15217,15044,14964,15249,15319,14848,14828,20648,35712,35713,35714,35715,35734,14758,15068,15069,15070,14028,29969,20751,29970,14318,19522,19523,14319,14146,19516,20973,20974,20975,21009,30439,14120,14370,14371,14486,13996,7895,7896,30671,13923,15132,14023,14286,14288,14290,14293,14295,14296,14298,19235,14527,14026,14067,20649,20650,14075,20930,20897,20985,29954,14306,14307,14308,14309,14310,14118,14650,14469,14523,19398,34717,7938,7936,8040,8029,14741,8041,15041,30441,14843,15200,8030,15218,15215,14770,8035,35777,35837,35839,35842,35913,35914,35930,35935,35969,35970,35987,35988,35989,35990,35991,35993,7614,8958,15034,36023,7750,7751,15090,15091,21040,15251,7752,7753,36044,36045,36046,36060,36068,36069,36070,36103,36104,36111,36115,36116,36117,36118,36130,36203,36246,8830,36136,7748,7749,26782,15089,25711,9050,14472,15403,13987,36431,36432,36436,36437,36497,36545,36546,36548,36547,36549,36550,36551,36552,36553,36554,36555,36556,36557,7718,14274,19076,20610,36569,28605,15264,14564,18743,36739,36741,36740,36742,36743,36744,36927,36928,36929,36930,36931,8084,29955,37058,8096,14343,19003,21030,8090,8078,14578,18847,8974,15394,13956,8932,8934,13957,37256,8933,19060,15189,26803,28694,37257,15078,8092,40065,40073,40074,8081,15131,21029,15257,8082,21046,14847,19419,8094,21092,8093,8088,15273,21047,8087,21031,15054,40162,40163,14998,8080,15169,21032,8089,8095,27819,40260,18887,8085,15850,14127,14601,29679,19346,40299,40300,40301,40338,40339,19562,19552,20658,19534,19506,7613,20657,19520,19616,7612,14276,30197,29987,20747,20630,14278,14277,19474,14209,29999,14475,14474,29998,14021,19614,27990,18707,8862,27086,11411,27929,15843,18620,27143,15840,35472,35456,28341,9054,40349,40348,40350,40351,40434,40457,40458,40459,40460,40524,40525,40526,40527,19508,7927,19598,14355,14078,7929,14356,7928,7925,20832,13990,29901,19509,7931,14311,7932,14312,13950,14314,14027,19496,7933,14479,20833,19501,29873,20638,14794,30391,19584,19418,14804,7996,15150,14324,7997,19566,7998,29872,19565,29902,7930,19557,14792,25421,7993,14326,14325,7994,30388,19586,40728,40729,40853,40922,40923,41051,41092,41282,41447,41610,41690,41817,42008,7802,14774,18687,18823,14975,13944,14559,19178,8911,42107,29953,42175,14193,14558,9114,42309,42338,15859,14772,7806,25816,19408,15103,15866,18810,25719,14557,13934,27057,19513,27534,42381,42447,42449,42455,42551,42573,42571,42572,42574,42575,42576,42577,7882,27006,18785,42639,42648,14979,19143,7720,15295,42678,42679,7608,14342,7783,9090,14280,7780,7781,7782,7778,15097,15806,9081,7779,15324,35481,29676,29724,14824,8106,14345,14347,26426,14346,15192,8105,7789,21036,30342,15541,14283,15099,18846,7788,14823,8984,21028,18942,15100,14248,8959,15035,15867,7790,21064,29675,42722,42723,8979,15086,7737,8978,13963,21045,7739,29678,29677,42799,42855,8863,18809,7732,21034,8980,19006,14020,36368,14275,19274,21035,19166,7731,15092,7735,9094,9022,14079,7734,18832,9000,8859,14024,7738,14304,18830,42956,13955,14536,15313,15315,21013,15316,7740,30255,35129,18673,7736,30581,30582,30583,43008,43031,14535,21018,20862,7886,7885,7884,15307,15306,20860,9002,7881,7880,20861,43051,43070,43080,43081,43082,40688,43120,43125,43126,43139,43140,7728,15081,8977,15082,15083,7729,15084,15085,9071,7730,13951,7721,18776,7722,41448,7723,8822,13924,18821,13925,8823,13931,14207,29579,8824,15199,7693,14269,19630,8828,14185,19602,14352,8825,15198,8826,35198,7695,14449,14391,8829,7694,43201,43202,43261,43271,43276,43303,43322,30568,7807,7804,14496,43342,43346,25990,15635,15523,8865,15462,15780,15520,43948,43958,43967,43978,43979,14109,8915,9773,13448,14748,8827,7696,14480,13943,9766,18834,14121,29045,14441,14184,14105,18934,13991,18854,15821,15431,44054,44057,20621,10459,18970,19180,7809,14358,43283,8044,19402,7919,9086,7874,15283,14978,35127,19342,7878,7875,14210,44170,44171,44172,44176,8858,7663,7664,14754,14753,7668,44183,14860,18971,7876,43345,18965,14011,7877,30196,7870,15463,26616,9087,15537,7671,15444,44194,44195,44196,44197,44198,44199,44202,44203,44204,44205,44206,29386,21104,21106,7689,7683,7687,20989,15456,14830,7676,7678,7682,44222,44234,44235,44236,44242,14784,25927,26591,7891,15122,7890,20929,9113,26041,26041,44253,44254,44259,44262,44263,44277,9069,30540,15629,7901,14302,18657,14175,19421,14625,14176,15486,19282,15846,26326,14303,7903,25589,7902,19022,15115,15194,20853,20849,15114,7906,18678,7905,8896,7904,15116,30545,15117,14367,14825,15118,7771,36992,7772,21008,14103,44315,43061,44322,44401,18986,14652,14649,14648,14512,14641,14743,15518,15399,18625,7974,18689,20622,44413,7848,44433,44434,44435,44436,44437,44438,44439,44440,7773,9163,35395,44448,44464,27062,27063,27061,15920,18879,9162,28478,7661,15822,15051,19234,7662,19452,15396,14749,14750,15063,15393,15534,7667,19642,15823,8970,7665,7666,19217,8918,9010,9009,8953,8931,8956,18900,15871,26311,19411,8861,15066,7674,9520,15824,7675,8962,28530,28550,7684,19219,19218,15797,20641,28538,15764,13712,15418,7685,7686,19107,15825,7681,7679,7680,8971,15419,8854,15043,19350,8965,8964,8924,20617,20796,20632,7952,30260,43937,44482,44483,26376,20850,13961,42693,7971,27481,14368,28045,14645,18688,14762,19486,19473,14174,28377,14172,18723,14223,27102,18924,42724,18805,39962,29578,44489,44490,44493,44494,44495,27291,44500,44509,44510,19635,14489,44517,43905,44549,44552,44553,44554,44555,15524,14225,13997,26999,9052,13999,15646,15870,7810,15854,9049,26928,35515,35657,18790,9014,14485,15476,8916,20625,20821,8025,15232,19176,27060,14327,9048,26049,28533,26499,18878,8868,7871,9122,9020,25992,27439,19365,9013,20623,44583,44584,44585,44586,44587,44588,44589,44590,44591,44592,44593,44594,44595,44596,44597,44598,44599,44600,44601,44602,44603,44604,44605,44606,44607,44608,44609,44610,44611,44612,44613,44614,44615,44616,44617,44618,44619,44620,44621,44622,44623,44624,44625,44626,44627,44628,44629,44630,44631,44632,44633,44634,44635,44636,44637,44638,44639,44640,11460,18668,14735,8871,15148,7989,15303,7990,15146,8992,15147,18670,14322,18718,15159,8016,26034,18816,8017,14305,8874,28390,28509,44323,18697,20807,26354,8998,7986,14349,8996,35151,15916,15917,18786,35152,15915,15423,18783,14320,14029,44551,15454,15471,7795,14869,14378,14612,15102,20769,14655,15717,7794,26796,21002,7784,9004,9047,30789,15211,8966,7785,14740,7786,18807,13954,7991,14022,7892,15188,14281,8018,19164,15865,8019,8982,8983,18652,20941,13962,19624,15336,29088,15161,15723,20784,19182,15776,28095,44655,44656}'::bigint[])) OR (defect_families.id IS NULL))
  • Rows Removed by Filter: 380161
3. 170.507 215.593 ↓ 6.8 393,615 1

Hash Left Join (cost=1,349.65..2,079.88 rows=58,210 width=160) (actual time=23.129..215.593 rows=393,615 loops=1)

  • Hash Cond: (product_groups.program_id = programs.id)
4. 19.830 40.911 ↓ 3.1 24,882 1

Hash Right Join (cost=1,110.35..1,319.70 rows=8,139 width=151) (actual time=18.939..40.911 rows=24,882 loops=1)

  • Hash Cond: (defect_family_products.defect_family_id = defect_families.id)
5. 2.177 2.177 ↑ 1.0 6,033 1

Seq Scan on defect_family_products (cost=0.00..105.33 rows=6,033 width=8) (actual time=0.010..2.177 rows=6,033 loops=1)

6. 4.133 18.904 ↓ 1.3 5,461 1

Hash (cost=1,059.54..1,059.54 rows=4,065 width=147) (actual time=18.904..18.904 rows=5,461 loops=1)

  • Buckets: 8192 (originally 4096) Batches: 1 (originally 1) Memory Usage: 816kB
7. 2.317 14.771 ↓ 1.3 5,461 1

Hash Left Join (cost=216.36..1,059.54 rows=4,065 width=147) (actual time=4.282..14.771 rows=5,461 loops=1)

  • Hash Cond: (defect_family_ratings.product_group_id = product_groups.id)
8. 4.902 11.614 ↓ 1.3 5,461 1

Hash Right Join (cost=132.79..965.28 rows=4,065 width=147) (actual time=3.435..11.614 rows=5,461 loops=1)

  • Hash Cond: (defect_family_ratings.defect_family_id = defect_families.id)
9. 3.310 3.310 ↑ 1.0 18,889 1

Seq Scan on defect_family_ratings (cost=0.00..782.89 rows=18,889 width=8) (actual time=0.008..3.310 rows=18,889 loops=1)

10. 2.029 3.402 ↑ 1.0 3,013 1

Hash (cost=95.13..95.13 rows=3,013 width=143) (actual time=3.401..3.402 rows=3,013 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 460kB
11. 1.373 1.373 ↑ 1.0 3,013 1

Seq Scan on defect_families (cost=0.00..95.13 rows=3,013 width=143) (actual time=0.011..1.373 rows=3,013 loops=1)

12. 0.374 0.840 ↑ 1.0 1,492 1

Hash (cost=64.92..64.92 rows=1,492 width=8) (actual time=0.840..0.840 rows=1,492 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 75kB
13. 0.466 0.466 ↑ 1.0 1,492 1

Seq Scan on product_groups (cost=0.00..64.92 rows=1,492 width=8) (actual time=0.006..0.466 rows=1,492 loops=1)

14. 0.326 4.175 ↓ 1.2 875 1

Hash (cost=230.53..230.53 rows=701 width=17) (actual time=4.175..4.175 rows=875 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 53kB
15. 0.386 3.849 ↓ 1.2 875 1

Hash Left Join (cost=203.70..230.53 rows=701 width=17) (actual time=2.916..3.849 rows=875 loops=1)

  • Hash Cond: (programs_users.user_id = users.id)
16. 0.451 0.680 ↓ 1.2 875 1

Hash Right Join (cost=4.54..29.54 rows=701 width=17) (actual time=0.110..0.680 rows=875 loops=1)

  • Hash Cond: (programs_users.program_id = programs.id)
17. 0.139 0.139 ↑ 1.0 944 1

Seq Scan on programs_users (cost=0.00..14.44 rows=944 width=8) (actual time=0.009..0.139 rows=944 loops=1)

18. 0.040 0.090 ↑ 1.0 98 1

Hash (cost=3.32..3.32 rows=98 width=13) (actual time=0.090..0.090 rows=98 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 13kB
19. 0.050 0.050 ↑ 1.0 98 1

Seq Scan on programs (cost=0.00..3.32 rows=98 width=13) (actual time=0.009..0.050 rows=98 loops=1)

  • Filter: active
  • Rows Removed by Filter: 34
20. 0.742 2.783 ↑ 1.0 2,848 1

Hash (cost=162.73..162.73 rows=2,914 width=4) (actual time=2.782..2.783 rows=2,848 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 133kB
21. 2.041 2.041 ↑ 1.0 2,848 1

Seq Scan on users (cost=0.00..162.73 rows=2,914 width=4) (actual time=0.007..2.041 rows=2,848 loops=1)

  • Filter: (NOT archived)
  • Rows Removed by Filter: 58
22. 10.522 23.972 ↑ 1.0 35,555 1

Hash (cost=877.10..877.10 rows=35,610 width=8) (actual time=23.972..23.972 rows=35,555 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 1901kB
23. 13.450 13.450 ↑ 1.0 35,555 1

Seq Scan on products (cost=0.00..877.10 rows=35,610 width=8) (actual time=0.008..13.450 rows=35,555 loops=1)