explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1gP8

Settings
# exclusive inclusive rows x rows loops node
1. 1.214 48.073 ↑ 1.0 1 1

Aggregate (cost=5,832.85..5,832.86 rows=1 width=8) (actual time=48.073..48.073 rows=1 loops=1)

2. 1.120 46.859 ↓ 4,622.5 9,245 1

Nested Loop (cost=2.15..5,832.84 rows=2 width=4) (actual time=0.168..46.859 rows=9,245 loops=1)

3. 0.436 12.507 ↓ 6.1 67 1

Merge Join (cost=1.72..4,946.60 rows=11 width=8) (actual time=0.128..12.507 rows=67 loops=1)

  • Merge Cond: (u.id = s.user_id)
4. 11.760 11.760 ↑ 1.1 4,458 1

Index Scan using users_pkey on users u (cost=0.42..4,906.81 rows=4,796 width=4) (actual time=0.010..11.760 rows=4,458 loops=1)

  • Index Cond: (id = ANY ('{5,24,27,58,94,98,120,184523,160,164,207,208,238,246,258,282,284,286,310,358,374,414,438,454,490,617,618,622,631,675,681,747,780,801,802,803,822,828,873,940,965,977,1003,1062,1066,1083,1113,1164,1165,1189,1236,1366,1383,1458,1479,1510,1536,1622,1628,1680,1691,1814,1856,1874,1931,1987,2103,2145,2154,2188,2191,2211,2217,2274,2282,2423,2425,2573,2606,2672,2695,2803,2883,2931,2968,2973,2975,3150,3184,3188,3230,3329,3367,3399,3448,3473,3520,3527,3556,3559,3614,3619,3621,3655,3656,3661,3668,3679,3705,3732,3744,3748,3793,3847,3861,3916,3968,3980,4057,4090,4112,4114,4136,4156,4159,4165,4167,4176,4194,4197,4205,4214,4216,4220,4222,4243,4350,4380,4383,4400,4405,4441,4449,4450,4479,4516,4527,4529,4531,4541,4549,4560,4568,4663,4691,4726,4735,4757,4759,4901,4927,4930,4936,4948,4958,4966,4973,4988,4991,5079,5101,5122,5140,5149,5165,5167,5169,5203,5219,5244,5250,5256,5263,5286,5323,184309,5358,5454,5458,5482,5551,5557,5621,5640,5659,5718,5729,5786,5840,5869,5913,5920,5929,5949,5958,6001,6014,6034,6037,6044,6057,6064,6103,6124,6184,6193,6218,6237,6261,6314,6327,6379,6412,6482,6531,6561,6575,6577,6598,6600,6604,6631,6642,6643,6644,6689,6696,6704,6726,6727,6748,6763,6772,6775,6813,6817,6830,6863,6889,6898,6906,6927,6949,6974,6978,6982,6997,7000,7001,7010,7018,7027,7035,7047,7060,7063,7066,7088,7146,7190,7206,7216,7229,7244,7245,7263,7266,7289,7301,7302,7307,7308,7322,7331,7349,7355,7363,7364,7369,7383,7385,7418,7475,7540,7542,7557,7564,7577,7578,7596,7599,7602,7607,7609,7639,7653,7657,7687,7733,7752,7771,7805,167546,7823,7826,7831,7862,7863,7880,7904,7926,7944,7960,7998,8005,8036,8043,8090,8096,8118,8123,8185,8201,8207,8210,8217,8241,8249,8251,8324,8327,8364,8367,8372,8424,8483,8500,8525,8544,8570,8593,8596,8601,8607,8634,8688,8710,8722,8759,8765,8788,8814,8815,8837,8846,8854,8874,8926,8934,8952,8960,8973,8974,8978,8990,9003,9010,9020,9036,9060,9117,9119,9154,9161,9169,9179,9206,9217,9222,9233,9242,9253,9278,9288,9290,9293,9310,9316,9325,9334,9336,9346,9363,9372,9390,9399,9404,9406,9456,9468,9480,9485,9486,9502,9506,9510,9543,9547,9550,9552,9556,9573,9575,9579,9580,9606,9613,9615,9631,9650,9686,9689,9696,9697,9714,9730,9747,9756,9758,9759,9763,9786,9787,9793,184304,9807,9812,9814,9818,9823,9828,9840,9847,9857,9880,9917,9936,9964,9977,9986,9991,9997,10001,10002,10010,10018,10021,10023,10049,10074,10077,10089,10097,10101,10108,10109,10125,10130,10134,10136,10145,10150,10157,10167,10171,10192,10193,10202,10209,10227,10229,10233,10237,10242,10256,10257,10287,10292,10297,10304,10306,10350,10354,10365,10374,10424,10441,10472,10475,10479,10502,10514,10550,10551,10554,10560,10563,10569,10590,10594,10610,10615,10636,10669,10755,10784,10792,10802,10806,10812,10818,10822,10854,10856,10858,10871,10907,10916,10932,10943,10983,11017,11080,11093,11103,11153,11185,11210,11223,11230,11278,11340,11342,11346,11364,11384,11386,11399,11405,11414,11439,11441,11473,11476,11492,11523,11525,11537,11550,11569,11592,11625,11648,11654,11669,11693,11719,11757,11760,11828,11843,11852,11925,11959,12021,12115,12123,12129,12138,12165,12232,12244,12260,12302,12320,12322,12343,12384,12473,12475,12489,12512,12556,12568,12605,12678,12681,12697,12726,12731,12745,12770,12805,12847,12864,12931,12936,12945,12960,12996,13011,13045,13078,13082,13086,13087,13181,13193,13235,13302,13316,13336,13351,13429,13432,13463,13475,13482,13509,13523,13529,13532,13536,13564,13579,13581,13598,13633,13668,13673,13679,13691,13732,13742,13743,13756,13772,13816,13834,13837,13856,13861,13867,13879,13886,13923,13933,13934,13943,13993,14008,14010,14024,14025,14035,14040,14043,14063,14064,14073,14099,14101,14120,14128,14174,14206,14236,14246,14260,14278,14282,14300,14310,14319,14351,14356,14366,14386,14388,14450,14457,14470,14473,14483,14501,14506,14520,14542,14544,14606,14621,14625,14707,14718,14736,14756,14763,14783,14819,14835,14853,14882,14883,14888,14900,14935,14960,14966,14973,14979,14989,14995,15001,15029,15037,15048,15056,15068,15107,15119,15125,15126,15128,15138,15156,15168,15172,15178,15193,15209,15263,15282,15301,15353,15362,15379,15385,15386,15391,15414,15423,15457,15504,15514,15829,15880,15981,15983,16037,16095,16104,16111,16130,16132,16149,16159,16161,16185,16197,170159,16207,16209,16244,16256,16258,16259,16301,16315,16339,16350,16387,16388,16405,16426,16428,16436,16463,16473,16491,16497,16502,16544,16545,16562,16567,16583,16599,16606,16607,16612,16613,16624,16659,16662,16696,16701,16715,16749,16800,16819,16840,16853,16918,16945,16973,16982,16987,17026,17079,17125,17163,17167,17192,17231,17300,17302,17312,17318,17348,17364,17466,17568,17570,17571,17613,17620,17631,17660,17709,17725,17731,17787,17802,17847,17850,17853,17871,17873,17940,170377,17981,18002,18003,18034,18052,18059,18093,18112,18149,18164,18183,18208,18218,18254,18329,18352,18403,18434,18439,18451,18455,18494,18518,18520,18533,18548,18572,18599,18600,18617,18618,18623,18626,18635,18649,18650,18654,18665,18678,18683,18689,18698,18701,18708,18727,18733,18742,18784,18796,18797,18803,18810,18826,18828,18848,18858,18868,18874,18905,18916,18940,18947,18955,18972,18985,18994,19000,19010,19027,19029,19030,19031,19034,19037,19039,19044,19052,19058,19072,19080,19094,19097,19098,19104,19129,19160,19161,19164,19167,19209,19233,19236,19237,19243,19269,19284,19285,19301,19305,19311,19314,19315,19324,19337,19353,19355,19365,19380,19390,19402,19438,19460,19461,19464,19466,19468,19470,19485,19492,19500,19504,19513,19517,19522,19575,19587,19633,19637,19668,19669,19670,19682,19699,19700,19751,19755,19782,19786,19789,19796,19822,19829,19840,19848,19855,19861,19868,19878,19919,19943,19977,19979,19980,19983,19996,20011,20012,20013,20028,20034,20036,20040,20044,20052,20056,20059,20067,20129,20157,20235,20240,20243,20256,20257,20266,20270,20284,20295,20314,20343,20364,20370,20374,20441,20463,20466,20472,20484,20492,20504,20520,20536,20539,20558,20574,20583,20617,20642,20680,20684,20727,20729,20734,20740,20756,20793,20815,20821,20843,20855,20874,20880,20903,20917,20920,20936,20960,20963,20970,20979,20980,20982,20986,20991,20992,20999,21005,21022,21028,21057,21073,21110,21112,21137,21176,21204,21239,21267,21299,21323,21336,21353,21361,21373,21375,21379,21408,21445,21459,21473,21481,21483,21514,21546,21566,21584,21603,21605,21621,21622,21678,21702,21719,21754,21772,21795,21799,21808,21821,21826,21861,21866,21867,21928,21964,21976,21985,22024,22031,22051,22057,22083,22223,22270,22275,22288,22341,22344,22383,22520,22523,164163,22581,22582,22680,22692,22714,22718,22740,22744,22750,22751,22778,22780,22787,22840,22876,22923,22946,22959,22988,23014,23064,23079,23143,23156,23166,23189,23222,23288,23289,23323,23372,23388,23443,23488,23493,23605,23612,23618,23666,23686,23689,23725,23739,23776,23789,23796,23823,23833,23882,23892,23908,23911,23934,23951,24009,24010,24018,24046,24088,24100,24169,24196,24234,24260,24289,24329,24392,24415,24425,24475,24507,24512,24530,24534,24556,24563,24565,24584,24585,24588,24592,24602,24603,24609,24618,24637,24643,24650,24651,24658,24677,24701,24735,24737,24770,24788,24824,24825,24832,24842,24844,24850,24860,24867,24869,24870,24925,24948,24982,24992,24996,25003,25062,25063,25088,25121,25123,25148,25372,25399,25400,25545,25556,25791,25797,25829,25836,25850,25936,25947,25961,25963,25967,25991,26071,26073,26088,26106,26113,26149,26150,26220,26294,26331,26376,26396,26487,26492,26510,26566,26648,26681,26740,26790,26868,26981,26986,27031,27077,27129,27199,27210,27280,27296,27315,27414,27422,27479,27590,27625,27645,27749,27985,28029,28141,28180,28237,28296,28298,28320,28343,28364,28379,28415,28529,28594,28629,28661,28805,28827,28896,28967,29038,29064,29077,29083,29127,29143,29242,29277,29281,29374,29499,29500,29571,29685,29709,29722,29797,29801,29812,29821,29866,29867,29953,29968,29998,30014,30031,30109,30253,30297,30468,30530,30554,30582,30669,30677,30725,30845,30870,30880,30966,31078,31081,31291,31313,31329,31333,31339,31422,31424,31435,31454,31606,31681,31938,31952,32018,32137,32263,32314,32350,32448,32457,32522,32601,32652,32700,32771,32777,32834,8321,33034,32995,2996,33165,184314,33324,33326,33337,33336,33405,33456,33406,33489,33440,33537,33564,33582,33597,33643,33761,33777,33900,33803,33930,33952,33951,33995,34110,34173,34176,34207,34225,34301,34342,34376,34466,34492,34574,34681,34695,34699,34706,34724,34725,34783,34789,34807,34836,34498,34886,34894,34893,34949,34956,35019,35020,35051,35090,35093,35147,35146,30368,35216,35266,35321,35335,35400,35461,35497,25925,35545,35547,35577,35586,34183,32981,35681,35683,35670,35719,35729,34642,35744,35756,35757,35809,35818,35825,35849,35869,35873,35892,35891,35047,35911,35923,25705,12601,35955,35979,35776,36012,36033,36056,36066,36070,36151,35111,36168,1217,32739,36240,36239,36255,36274,36283,36309,36318,36340,4256,36357,36346,25238,36375,27763,36398,36404,14389,36432,36452,36441,36469,36470,36480,36483,36487,36492,36396,36494,36521,36512,36563,36565,36624,36661,36667,36678,36679,36734,36743,36749,36754,36762,36759,36769,36780,36796,36800,9858,36847,36868,36845,36915,36922,36959,36969,36974,36992,37031,37041,37053,37081,37121,37123,37127,37140,37145,37148,37146,37164,37166,37172,37170,37162,37189,37192,37194,37200,37202,37210,37173,37238,37254,37273,37299,37316,37322,37334,37323,37356,37357,37360,37370,184346,37398,37415,37441,37458,37496,37207,37506,37513,27358,37543,16386,37579,37584,37603,37625,37119,37650,37639,27736,37661,37717,37718,37780,37473,37830,13486,37814,37817,37879,37892,37924,37927,37934,37964,38003,38017,38021,38024,38027,38028,38030,5355,38035,38037,38044,38063,38064,38069,38074,38091,38094,38126,38136,38148,38169,38182,38181,38154,38205,38202,38219,38248,38245,38272,38285,37386,38322,38343,38369,38385,38394,38395,38446,38457,38500,38515,38524,38523,38545,38552,38575,38605,38617,38631,38640,38644,38693,38719,36865,38730,38746,38818,38872,38874,38878,35656,38915,38814,38925,38930,38891,38983,39000,39011,38869,39016,39004,39040,39123,37895,39165,39179,39267,39295,39307,39310,39324,39328,39329,39338,39345,162255,39367,167588,38506,39389,39425,39429,39440,39454,39482,37703,39351,39560,39342,39678,39736,38770,39768,21564,39771,39813,39826,39831,39379,39837,39808,39936,39941,39963,40000,40002,40043,22274,40133,40115,14243,23864,40170,40258,40259,40280,40298,40309,40325,40350,40375,40379,40398,40476,40389,40725,40406,40761,40788,40825,40880,40914,40942,40937,41039,41044,41075,41121,41146,41213,41218,41245,41281,39754,41329,39499,41354,41361,40995,41418,41397,41474,41476,41507,41528,41548,41623,7719,41677,41688,41773,23584,41363,41845,42001,42083,42166,42238,42243,42260,42290,42313,42323,42326,42343,42364,42374,42423,42433,42461,42467,40230,42595,42612,42642,42644,42635,42753,42812,8581,40307,42775,42894,42976,43009,43097,43123,43180,43182,43106,34401,43268,37679,43403,43450,43471,43491,43493,43505,43524,43408,40717,43772,43808,43811,43849,43869,43968,43969,43976,43989,43992,44198,44247,44274,44280,44318,44339,44389,44488,44510,43893,44549,44545,44635,44580,38622,44742,44745,44834,44925,44429,45090,45225,45276,45336,45421,45579,28238,45583,45729,45799,45801,45806,45873,45943,45969,45982,12689,46036,46078,22747,46181,46187,46222,46223,46200,46028,46257,45516,46283,46341,46360,46406,46417,46322,46093,46436,46507,46518,46557,46569,46275,46604,46627,46688,46706,46735,46741,14981,46760,46811,46829,46840,46818,46863,46914,46919,41435,20766,46967,46966,46991,37342,47041,47049,47110,47128,7191,46087,47163,47171,47222,47247,47255,47284,47294,47309,47237,47332,46653,47371,47404,47502,47533,47526,47544,47564,47465,47604,47608,47650,47349,47648,47673,2522,47717,47753,46615,47920,47934,47973,48007,47888,48038,48073,48055,48080,48114,48145,48211,47929,48241,48228,48288,48327,48360,48358,47182,48402,48433,48518,48653,48644,48693,48787,48810,48942,48936,48971,48998,48909,49021,49068,49087,49100,49138,49185,49188,49210,49101,49225,49255,49260,49304,49326,48716,49367,49370,49352,46356,9178,49583,49590,49593,49609,49627,49638,49707,49735,49779,49788,49820,49825,49835,49837,49883,49906,49939,50001,50059,50078,50093,50104,50116,50166,50207,50220,50242,50254,50276,50274,50291,50305,50321,49885,50351,50054,50367,50372,50379,50391,48928,50469,50480,50497,50505,50528,50556,50560,50664,50525,50623,48777,50711,50715,50716,50718,50721,50735,50741,49999,50714,50750,50760,50771,50781,50791,50796,50795,50823,50831,50854,50875,50896,50899,50901,50937,50794,50976,51000,51029,51067,51085,51098,51071,51127,48305,51157,51162,51166,51186,51221,51227,51245,51270,51028,51334,51362,51385,51395,51386,51399,51405,51411,51446,51465,51470,51480,39519,51492,51534,51567,51477,51618,51622,51726,51728,51735,51759,11535,51850,51799,51925,51940,51976,51984,51991,52050,52112,52129,52146,52162,52170,52177,52215,52241,52299,52329,52382,50506,52410,44950,52433,52482,11838,52514,52486,52584,52624,52718,52782,47375,52804,52852,52887,52911,52919,52924,52946,53133,22070,53182,53305,53308,53294,53323,53388,53398,53528,53576,53626,53591,53619,53754,53767,53631,53839,30689,54074,54079,54047,54164,54183,54194,54208,54253,54265,54304,54340,54394,54514,54538,53951,19651,54708,54743,54835,54846,162263,54775,164195,54917,54962,54995,54902,51151,55208,55231,55244,55283,55333,55450,55470,55487,55572,55638,55574,55706,55702,55819,54762,55933,55631,51252,55990,55949,56177,56189,56196,56264,56328,56388,56565,41187,56818,56840,56854,56868,56742,57076,57097,57290,57015,57415,57424,14614,57684,57685,57692,57695,57697,57574,57678,57805,57840,57870,57876,57734,33146,58030,58041,58108,58123,58146,58290,58529,32409,58553,58576,58766,58852,58872,58880,58909,59040,59080,59103,59169,57046,37738,43010,59431,5711,59710,60093,60138,60180,60190,60204,60267,60293,60321,60299,55576,60770,60731,60872,61096,38954,60160,61522,59371,61722,61859,61746,61924,62033,26009,59124,62450,62479,62668,62708,62736,62802,62288,52535,62911,62947,62950,62967,61670,62984,63004,63059,55902,38787,63223,63360,63461,63473,63510,63520,63603,63630,63725,63757,41030,63845,63857,37155,63897,63735,63935,63903,64060,64210,64217,64225,64228,64383,64410,64424,64451,64624,64625,64704,64741,64761,64792,64808,64880,64897,64943,65018,65028,65183,65213,65217,54424,65281,65339,41058,65448,65379,65457,65458,65473,65509,65527,65534,65566,65571,65607,65635,65634,57995,65663,65668,65671,65680,65693,65702,65723,65728,65754,65762,65765,65794,65803,65814,27171,65834,65874,65951,65963,66050,66117,66136,66140,65970,66180,66189,57249,66247,66260,66272,65988,66284,66302,66308,65182,66327,66357,66366,66382,66384,66385,66399,66410,66412,66424,66429,66488,66499,66509,66530,66538,66540,66526,66565,66579,66594,66618,66631,66632,66637,66638,66642,66646,66378,66669,66670,66674,66699,66704,66714,66718,66724,66726,66727,66728,66776,66802,66809,66813,66832,66830,59717,66804,65788,66844,66863,56972,66910,66928,66937,66961,67001,67006,67029,66964,67105,67116,67120,67121,67122,67124,67130,67154,67166,67180,67191,67201,67208,67220,67210,67258,67307,66934,67322,67324,67330,67356,67357,67194,66138,67376,67379,54638,67383,38070,67421,67422,67443,67457,67468,67487,52175,11604,67576,64062,67588,67602,67666,67716,67719,30857,67787,67802,67782,67840,67895,67902,67903,67912,67926,2054,67982,14092,68027,68039,68062,68078,68091,68093,68029,67662,68167,68181,68184,68205,68222,68240,68285,68363,68401,68481,68507,68500,68651,68674,68698,68705,68712,68704,68719,68721,68734,68751,68675,68720,68798,68834,68849,68852,68856,68859,68714,68740,68891,68919,68876,68929,68980,68981,68983,68986,68984,68991,68810,69017,69022,69039,69044,68562,69091,69097,69110,69123,58171,69192,69196,69234,69243,69244,69289,69295,69314,69308,69328,69395,40138,69416,69439,69479,69490,69511,69540,69606,66480,69688,68844,69713,69733,32017,67438,69747,69762,69837,69890,69591,69727,69912,69896,69924,69925,69932,38022,69964,69975,69786,35686,70062,70063,70090,39271,70163,70201,70279,70282,70324,70358,70045,70393,70154,70508,70519,70528,70536,70538,70598,70620,70635,70634,70658,70684,70662,70708,70826,70857,70914,70915,71052,71130,71131,71179,71285,71320,9995,71403,71425,64945,71329,71462,71477,71482,71491,71489,71578,71490,71634,69264,71807,71877,71897,71906,71918,71952,71985,72000,72009,72141,55350,72247,72237,50568,72290,70551,2657,3337,72397,72427,72428,72435,72463,72534,72623,72643,72655,16550,72945,73030,73158,73162,73184,73188,73219,61100,73261,73330,73335,73338,61348,63323,73435,73528,73547,73535,73656,73658,73164,66322,9770,73883,73821,74067,74188,74226,74235,74241,74255,74258,74356,74391,74408,74435,74498,70246,74641,74675,74759,74365,72394,74987,74999,75122,75125,75150,165102,6847,75388,75486,75589,75620,75645,75863,75758,76082,76102,76211,56295,76302,76351,23810,41601,76610,76224,76517,76681,76763,76772,76813,76970,76833,76853,2974,72496,77472,77554,66525,77782,77888,47805,77931,77952,223,78141,78033,78280,78250,78402,78404,78443,53466,78518,78519,78576,78735,78727,78784,78202,78889,78921,75557,78938,79169,79181,79184,43127,79279,79285,79441,79483,79594,79652,79755,79795,79819,79842,79846,79958,79954,80178,80194,80222,80227,80258,80282,80300,56284,80330,80348,80361,80401,80433,80448,80477,145937,80459,80510,78120,80540,80578,80587,48022,75183,80640,80681,80703,80740,80782,80785,80795,63565,80875,80886,80907,80952,80963,81011,85143,166835,81069,80714,66650,80574,81174,81189,81244,81257,81268,81286,81334,76319,81413,163060,81463,81474,81589,81443,81607,81638,81654,81705,81746,81838,81067,81891,81895,81843,81949,81958,75545,81981,82050,82065,79732,82121,82336,82366,82401,82459,82467,82470,82515,82551,82640,82729,82772,82779,82797,81909,82862,82712,82904,82908,82912,82943,83000,83003,83016,83019,83082,83214,83388,83425,20507,83733,83763,83769,83773,83823,83872,83857,83892,83916,83951,83964,84047,84052,83990,84057,84108,84115,84153,68321,84152,83303,62395,84210,84221,84290,84322,233,84376,84379,84380,84408,84443,84464,84468,84476,84486,83992,84515,84519,84518,84552,84559,84563,84586,83189,84654,84485,82517,84660,84663,84681,84690,83949,84716,84755,84666,84785,84891,84912,84927,84993,85041,85047,84998,85130,84905,85180,77390,85227,85259,85323,85337,85349,85351,85386,85440,85455,85460,166867,163649,85502,85540,85541,85548,84816,85593,85594,85608,85615,85614,85632,31607,85525,162338,85704,85744,85753,81460,85895,86032,86031,84489,86158,86185,68541,86265,85928,86293,86296,86360,86363,86447,86590,86656,12991,62561,86705,86779,86802,75023,86830,86777,68268,86894,166212,86919,84414,87077,87090,87140,87191,87218,87248,87292,87293,87326,87332,87342,50408,86108,87406,87448,87480,87574,87651,87667,87671,87566,87800,87812,52684,87839,87864,87836,87948,87970,87975,87915,87985,88015,88060,88109,88170,88205,88224,88239,88275,88320,88327,88445,88523,88541,88611,88627,88639,88712,88829,88877,88905,88931,88945,88974,89054,89082,89088,89094,89100,89124,89187,89179,89221,89226,89326,89340,89381,89392,89486,89567,89545,89666,45412,89791,87832,89854,89898,89931,89960,89992,90068,89964,51556,90169,90182,90267,90270,90285,90292,90357,185129,90590,90623,40874,90459,90687,90707,90779,50643,90866,90882,90917,91184,91330,91369,91373,91359,91461,91489,91574,91584,91601,91647,91670,91688,91691,91778,91882,91922,91830,91999,92035,91976,92115,92110,92227,92347,92425,92792,92817,92914,93073,93110,93169,93178,93197,93250,93277,93445,93458,93471,93538,93569,93737,93763,93767,93960,93970,90246,94074,94115,94175,94313,94398,94394,94432,94645,94671,94690,94780,79293,94909,94993,95036,18212,95322,95343,95386,95492,94258,95667,95683,95691,95710,62966,77116,45133,95957,96065,96099,96115,96212,91389,96345,96520,96579,96604,96675,96715,94864,96758,96709,96782,84874,93690,97086,97186,97192,97250,97440,97101,97604,95498,67552,97703,97781,97694,97811,94388,98046,98090,98212,98235,82851,98276,98377,98446,98401,45805,98689,98696,98755,98761,96886,98814,98845,98871,53999,99054,99231,98557,99409,99411,99507,99597,99626,99741,100048,100075,99979,100080,100226,69652,100272,100304,100011,99678,100782,100846,100857,101024,101369,101436,101465,101496,101497,101753,101874,102148,102262,102338,23242,102388,102279,23005,102467,81423,102538,102579,30953,102868,102955,103008,103153,103157,103156,103291,103368,103366,103461,103430,103558,103589,103623,103813,103849,103899,103941,104056,104170,104159,104198,104165,104323,104371,104387,104407,104417,104484,104521,104567,100815,3332,104860,104936,105024,105143,105145,105209,104229,105260,104369,105309,105410,105425,105540,105624,105690,105988,106032,106069,106093,106379,106387,106395,106394,106401,106407,106084,114311,106549,106608,106638,102564,106704,106782,106780,106793,106870,106901,106918,57852,106954,106965,107223,107257,107287,107324,107376,107428,107556,107567,107630,85837,107695,107700,107727,107759,107784,107884,107924,107943,108015,107819,108094,108174,98003,108391,108441,108447,108468,108501,108514,108516,108520,108541,108545,107475,99480,42588,108607,108640,18515,108631,166934,108713,108814,108825,108477,108740,103591,108885,108895,108903,108949,108958,108971,108888,108995,98473,109000,108968,108780,109040,109076,65797,109141,109161,108805,109165,109171,109186,109195,109240,89664,109267,109273,109281,109301,109399,109423,109438,109458,49296,108926,100503,109578,109592,109607,163674,109615,109618,109619,109689,165364,167309,109769,167299,185141,109826,65829,109854,109078,109899,109907,109914,109915,109634,109942,109966,109960,109980,109985,110029,92112,110056,110069,110088,110092,110104,110129,110134,110172,110183,110230,110249,110281,110329,110378,110458,110463,110465,110202,110515,110529,110532,110551,110570,110611,110612,110619,110684,110622,110725,110728,110744,110767,110804,110818,110849,110863,110877,110885,110893,110934,110939,110989,110995,110996,111002,29028,165142,111051,100669,61693,111062,162440,111067,111092,111102,111128,111129,111136,110947,111162,59352,111211,111244,111261,111267,111268,111221,111326,111332,110985,111404,111414,111419,111429,111023,111478,111509,108965,166803,41708,111576,111605,111634,8098,100523,111708,13518,111751,111788,111827,111881,111900,111982,112034,112039,112041,112045,112068,112069,111898,111487,67395,112147,112202,78726,112328,112345,112348,112349,112382,112427,112503,112538,112564,104938,112613,15565,36866,66395,112655,112494,112679,112506,162483,112740,112745,22333,112773,112778,112002,112785,112790,93005,112839,112837,109457,112857,91052,112917,112933,113007,113009,113045,113119,83094,113283,113314,113347,113357,113373,113383,113393,113554,110646,113708,113758,113773,113793,113795,113910,113964,109061,113986,114027,114033,114075,114113,114112,114128,112559,114305,114372,19105,111782,114459,114461,114445,114495,114498,114527,114650,114669,114725,165838,114824,114834,114954,115049,115118,115145,115327,115362,115406,115427,115456,46380,115575,115713,115875,115943,115955,116014,116071,116079,116167,116246,116135,116371,116452,116421,116496,116530,116567,116705,116752,116613,117008,117014,117022,117027,117048,117190,117150,117267,117264,117298,117338,105150,117378,117628,117644,117688,165166,113481,117823,117728,117360,118057,118053,118190,118219,118249,118256,162262,118336,170465,118370,118380,118452,117309,117151,118513,118529,165557,118599,118611,118619,118642,118668,118749,118868,117455,118959,114487,119008,119081,20922,119365,119402,119403,119412,119422,119512,119473,119522,119524,169955,170512,119605,119663,119668,119677,119738,119808,119813,119828,7824,119956,119967,119979,120033,120038,119330,120111,120197,164238,120218,170166,120342,120374,120376,120385,120421,120471,120413,120531,120583,15878,120765,120622,36782,120859,84772,45718,33423,121023,102622,121200,120645,121337,121363,121368,121399,121504,121587,121603,121661,114902,114868,121779,169654,100057,121858,121870,121989,122112,122160,163022,122203,122222,100922,98511,122435,122719,122723,122750,122814,122950,123009,123052,123116,123113,118233,123179,123191,123195,123296,123397,123481,163088,42481,123555,123639,123534,123704,123773,123814,124001,124318,124457,84313,124458,115469,124500,124511,95948,68638,169658,124923,125015,162599,125395,124820,125378,125608,166282,125712,125797,125813,165584,49805,126002,126032,126134,124024,126544,126835,118432,126808,126885,126902,126942,126952,127000,127159,127265,126245,127143,127474,127838,127841,128402,128459,101733,96648,128737,101695,128882,128948,85142,23315,129146,129183,164252,129244,129178,129395,129361,123533,129403,129472,165615,129499,59648,129434,129627,129612,129762,126439,184671,129611,129930,130042,130068,130137,130049,130179,130229,126928,130435,130439,130546,130581,130823,128665,130370,131034,120099,130907,131304,131279,131310,131321,130804,77688,131501,131527,131592,131740,130552,131858,128342,131768,108852,132018,131631,132026,132079,132159,125361,132354,132397,152907,82447,114716,132600,126786,132810,184825,132855,132982,102885,133053,184453,133036,170187,133247,87205,133357,133304,96994,133564,133599,133625,133782,133886,114271,134007,134061,134129,36614,134207,41049,134439,164269,1925,134723,97358,134917,134906,116402,68527,135074,135248,135301,109248,135317,135435,135347,135590,135742,115733,135850,135856,135910,169113,83268,135848,114237,50023,169229,136527,136357,80943,137153,137201,137316,137491,137516,137534,106453,137572,137633,137795,137781,137916,137937,137953,138082,138223,138231,138358,138390,184145,120598,138613,138503,112796,138653,138655,138745,138668,138827,592,138935,137426,128259,16422,139292,139357,134383,139422,139409,139467,139706,139583,139646,12910,139851,139729,139662,140119,140160,140252,116868,140298,140464,140786,140886,140893,140917,140923,141126,107365,141905,141992,142014,142040,142056,142162,142313,142458,142530,142574,100852,142723,166310,166314,184150,142929,143122,163507,143315,143385,85152,143234,143546,143554,143643,143645,143410,143866,76327,143906,144115,144206,144374,144486,118803,144534,143653,144642,67996,144645,144169,144766,144820,144971,144982,144957,145071,40481,68359,145148,165892,145156,145412,139676,145623,145565,145745,145748,131068,145875,145996,74580,146038,143861,146454,146680,146671,146841,146941,74815,147047,147062,147078,147082,147064,147172,23309,136362,147465,147524,142160,147702,147786,86424,148000,148043,148080,148250,39,123591,139342,148832,148971,149040,148913,3697,149077,149314,141740,150024,6873,149877,85650,150593,150649,150679,150765,150642,150890,151017,151272,96776,151360,184481,166498,113065,151736,152072,152103,152164,151826,122685,153130,153274,152997,153740,167302,154497,154498,153858,155130,155017,155416,155666,156157,156180,163142,156750,156840,150790,156917,157056,157080,157179,119635,136249,157350,157362,157499,157541,157834,163808,158080,158162,169020,166345,164396,164131,163832,164353,165637,165675,164428,164437,143787,163272,163228,163291,163284,164430,164443,136494,166512,158508,162626,164403,164410,157408,162700,165682,165760,162663,165728,163338,163440,103709,163527,158800,166346,165897,163613,162808,132775,136131,163899,117122,170526,162818,162840,168120,162899,163931,163941,170583,163990,92975,158935,120299,164082,163973,145166,114789,168134,167968,168623,170581,166449,170504,170248,164689,165299,165277,164959,170006,164665,163932,164654,164548,164737,164745,163407,94440,168964,184851,129120,101678,164868,165284,165422,165814,165382,165870,147549,166138,166152,164897,165866,166001,166147,168020,164084,166018,164845,170552,170556,164962,46049,164958,158960,158884,166181,165059,170655,170781,166415,149592,158806,167156,55866,168644,157708,169399,83544,159168,168949,168867,169368,168939,168853,167259,170780,169488,169620,166031,169616,117503,166686,169802,166815,170331,169746,105282,167388,170334,166792,169013,169475,169172,170771,80455,169876,164647,170757,169593,170365,170849,170739,170481,169922,170634,144465,170790,23595,159280,170628,159332,59834,159523,157178,159703,159929,160021,160142,159765,139609,160323,160321,91156,160595,160623,169035,160848,160876,161310,169927,161466,161492,161425,161431,161771,161853,161779,161933,158008,162004,162187,169930,170644,149188,162217,170856,184220,170904,170929,170677,171114,171120,171125,14290,171134,171159,171187,171205,171237,140815,171352,171254,137963,171399,171419,171470,184985,171485,169407,171566,171578,171612,171636,171703,171722,171765,171807,171733,171769,171856,171858,142630,172013,172015,172032,172114,93966,172165,172169,162595,172184,162929,172246,100187,157196,172443,172488,172526,172603,172616,172630,172655,172716,184544,172814,172845,163806,172853,172857,137814,172876,172972,172982,172723,173009,173044,173089,173090,173100,133881,173214,118954,173324,173331,184467,173140,173388,173386,173417,173435,173451,184243,185000,173466,173470,173473,173575,173595,173614,173621,173632,173648,173665,173679,173711,173719,173725,173749,173734,96169,173876,173928,174022,174039,174055,174086,174130,174155,173968,174244,174239,160948,174345,174368,169490,174417,86075,173389,174530,174537,174547,174583,174558,174664,174671,174749,174777,167176,174815,174868,174906,174365,174989,174993,175029,175047,175130,148654,174912,175422,175637,175641,175904,175806,154423,175990,176010,176018,176029,176062,184545,175220,176167,176263,176296,176334,176427,176490,176551,176563,106064,176660,176678,176688,176696,176749,176753,14230,176922,176995,153220,177114,177142,177145,185027,177265,91143,177299,177315,177332,172429,177540,177410,177647,177763,91967,53472,177905,178018,177671,178176,178213,178252,178269,178448,178464,3174,178525,184736,178531,178535,178255,178557,178649,178658,178673,178686,178701,178712,178728,178755,178765,178794,165965,178825,178831,178887,178890,178974,179033,179071,179134,23926,179224,179295,179329,48265,179147,179369,179351,179415,179438,179484,179492,179519,179738,123601,179829,5016,179912,179965,179984,179937,180042,180130,180147,180161,180200,180208,180218,180228,126282,180282,180291,180303,180328,180463,175054,141718,180498,164255,78273,180558,180607,180610,180556,180640,180689,180764,147854,180776,180793,180818,180821,180853,180866,180870,180904,183077,180979,181018,181074,181085,181108,181177,181181,181157,181208,181233,181285,181305,184565,178026,181410,181419,181465,178643,181715,181658,181762,119799,181648,181778,181626,181599,181806,181810,181736,181840,181855,181883,178651,181930,181942,133718,181963,181973,181978,182018,182024,66548,182133,182171,105659,182233,35865,182235,182268,182282,182272,50608,182329,182363,182377,182379,182383,182425,182474,182490,182507,182513,109582,182565,93417,182678,106738,182710,182749,182842,147666,18856,182904,182924,183056,183192,183194,183225,183343,183244,183362,183366,183387,183402,183428,183444,182534,42666,183614,183670,183665,183727,6773,183805,183830,183908,183942,183952}'::integer[]))
  • Filter: (active AND allow_invites AND (id <> 19831))
  • Rows Removed by Filter: 461
5. 0.311 0.311 ↑ 1.0 431 1

Index Scan using users_status_assign_user_id_idx on users_status_assign s (cost=0.27..36.87 rows=431 width=4) (actual time=0.006..0.311 rows=431 loops=1)

  • Filter: (status_id = ANY ('{1,2,5,6}'::integer[]))
6. 33.232 33.232 ↓ 34.5 138 67

Index Scan using orders_executor_id_idx on orders o (cost=0.43..80.53 rows=4 width=4) (actual time=0.055..0.496 rows=138 loops=67)

  • Index Cond: (executor_id = u.id)
  • Filter: ((discipline_id = 104) AND (status = 4))
  • Rows Removed by Filter: 476