explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6Ui

Settings
# exclusive inclusive rows x rows loops node
1. 4.928 4.928 ↑ 1.0 1,000 1

Index Scan using product_template_attribute_line_pkey on product_template_attribute_line (cost=0.42..1,368.73 rows=1,000 width=4) (actual time=0.337..4.928 rows=1,000 loops=1)

  • Index Cond: (id = ANY ('{673980,674011,674042,674073,674102,674143,674184,674225,674266,674307,674348,674389,674430,674471,674512,674553,674595,674637,674678,674719,674760,674801,674842,674883,674925,674967,675008,675049,675090,675131,675172,675213,675255,675297,675339,662324,662345,662366,662387,662408,662429,662450,662471,662492,662513,662534,662555,662576,662597,662618,662639,662661,662682,662703,662724,662745,662766,662787,662808,662829,662850,662871,662892,662913,662934,662955,662976,662997,663018,667769,667829,667889,667946,668009,668060,668129,668189,668249,668309,668369,668429,668489,668549,668609,668669,668728,668789,668849,668909,668959,669020,669081,669142,669203,669264,669325,669386,669447,669508,669569,669630,669691,669752,669813,669874,669929,670006,670066,670128,670189,670250,670311,670372,673981,674012,674043,674074,674103,674144,674185,674226,674267,674308,674349,674390,674431,674472,674513,674554,674596,674638,674679,674720,674761,674802,674843,674884,674926,674968,675009,675050,675091,675132,675173,675214,675256,675298,675340,662327,662348,662369,662390,662411,662432,662453,662474,662495,662516,662537,662558,662579,662600,662621,662642,671557,671594,671631,671668,671705,671742,671779,671816,671853,671890,671927,671964,672001,672038,672075,672112,672149,672186,672223,672260,672297,672334,672371,672408,672445,672482,672519,672556,672593,672630,672667,672704,672741,672778,672815,672852,672889,672926,672963,673000,673037,673074,673111,673148,673185,663042,663066,663090,663114,663138,663162,663186,663210,663234,663258,663282,663306,663330,663359,663388,663417,663446,663475,663504,663535,663562,663589,663616,663643,663670,663697,663724,663751,663783,663815,663847,663879,663911,663943,663975,664007,664034,664061,664088,664115,664142,664169,664196,664223,664255,664287,664319,664351,664383,664425,664496,664559,664616,664663,664720,664777,664825,664881,664937,664985,665057,665119,665181,665243,665295,665367,665429,665491,665548,665595,665652,665709,665764,665813,665875,665944,666009,666071,666133,707869,707882,707895,707910,707925,707940,707964,707977,707990,708003,708016,663043,663067,663091,663115,663139,663163,663187,663211,663235,663259,663283,663307,663331,663360,663389,663418,663447,663476,663505,663536,663563,663590,663617,663644,663671,663698,663725,663752,663784,663816,663848,663880,663912,663944,663976,664008,664035,664062,664089,664116,664143,664170,664197,664224,664256,664288,664320,664352,664384,664436,664498,664560,664617,664664,664721,664778,664827,664882,664939,664993,665058,665120,665182,665244,665306,665368,665430,665492,665549,665605,665653,665710,665766,665814,665883,665946,666010,666072,666134,707896,707911,707926,663045,663069,663093,663117,663141,663165,663189,663213,663237,663261,663285,663309,663333,663362,663391,663420,663449,663478,663507,663538,663565,663592,663619,663646,663673,663700,663727,663754,663786,663818,663850,663882,663914,663946,663978,664010,664037,664064,664091,664118,664145,664172,664199,664226,664258,664290,664322,664354,664386,664438,664500,664562,664619,664675,664723,664780,664837,664884,664941,664998,665060,665122,665184,665246,665308,665370,665432,665494,665551,665608,665655,665712,665769,665824,665886,665950,666012,666074,666144,663337,663366,663395,663424,663453,663482,663511,663758,663790,663822,663854,663886,663918,663950,663982,664230,664262,664294,664326,664358,664390,664442,664504,665002,665064,665135,665198,665254,665312,665374,665446,665830,665892,665954,666026,666088,666150,663338,663367,663396,663425,663454,663483,663512,663759,663791,663823,663855,663887,663919,663951,663983,664231,664263,664295,664327,664359,664391,664443,664505,665003,665065,665137,665199,665256,665313,665375,665447,665831,665893,665955,666027,666089,666151,663530,663557,663584,663611,663638,663665,663692,663719,663746,663778,663810,663842,663874,663906,663938,663970,664002,664029,664056,664083,664110,664137,664164,664191,664218,664250,664282,664314,664346,664378,664420,664482,664544,664601,664658,664705,664762,664819,664876,664923,664980,665042,665104,665175,665238,665290,665352,665414,665486,665533,665590,665647,665694,665751,665808,665870,665932,665993,666066,666128,708097,708107,708117,708127,708137,708147,708157,708167,708177,708187,708197,708207,708217,708227,663531,663558,663585,663612,663639,663666,663693,663720,663747,663779,663811,663843,663875,663907,663939,663971,664003,664030,664057,664084,664111,664138,664165,664192,664219,664251,664283,664315,664347,664379,664421,664483,664545,664602,664659,664715,664763,664820,664877,664924,664981,665043,665105,665177,665239,665291,665353,665415,665487,665534,665591,665648,665695,665752,665809,665871,665933,665995,666067,666129,664467,664531,664595,664669,664734,664807,664871,664938,665009,665073,665147,665211,665285,665359,665423,665497,665561,665626,665699,665763,665837,665901,665975,666039,666102,666154,666176,666240,666250,666305,666346,666378,666432,666442,666516,666528,666580,666614,666643,666707,666720,666771,666815,666835,666902,666908,666972,666998,667046,667084,667109,667173,667180,667247,667276,667311,667362,667375,667448,667458,667512,667544,667586,667640,667650,667735,667822,667919,668005,668100,668196,668282,668378,668464,668560,668656,668743,668838,668926,669030,669126,669212,669308,669404,669500,669596,669682,669778,669864,669960,670056,670142,670238,670324,670418,670464,670510,670556,670602,670648,670694,670740,670786,670832,670878,670924,670970,671016,671062,671108,671154,671200,671246,671292,671338,671384,671430,671476,671522,671559,671596,671633,671670,671707,671744,671781,671818,671855,671892,671929,671966,672003,672040,672077,672114,672151,672188,672225,672262,672299,672336,672373,672410,672447,672484,672521,672558,672595,672632,672669,672706,672743,672780,672817,672854,672891,672928,672965,673002,673039,673076,673113,673150,673187,673221,673255,673289,673323,673357,673391,673425,673459,673493,673527,673561,673595,673629,673663,673697,673731,673765,673799,673833,673867,673901,673935,673969,666173,666269,666355,666451,666544,666633,666739,666825,666922,667017,667103,667199,667285,667381,667476,667563,667659,667745,667841,667937,668023,668119,668205,668301,668397,668483,668579,668666,668761,668857,668953,669049,669136,669231,669327,669423,669519,669605,669701,669797,669883,669979,670067,670161,670257,670343,670427,670473,670519,670565,670611,670657,670703,670749,670795,670841,670887,670933,670979,671025,671071,671117,671163,671209,671255,671301,671347,671393,671439,671485,675370,675422,675474,675526,675578,675630,675682,675734,675786,675838,675890,675942,675994,676046,676098,676150,676202,676254,676306,676359,676412,676465,676518,676571,676624,676677,676730,676782,676834,676886,676938,676990,677042,677094,677146,677198,677250,677302,677354,677406,677458,677510,677562,677614,677666,677718,677771,677824,677877,677930,677983,678036,678089,678142,678194,678246,678298,678350,678402,678454,678506,678558,678610,678662,678714,678766,678818,678870,678922,678974,679026,679078,679130,679183,679236}'::integer[]))
Planning time : 3.604 ms
Execution time : 5.068 ms