explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5djY

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Limit (cost=0.85..269.90 rows=20 width=1,695) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.85..1,448,445.24 rows=107,675 width=1,695) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Index Scan Backward using index_appeal_pkey on index_appeal indexappea0_ (cost=0.42..43,393.55 rows=692,625 width=30) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Index Scan using appeal_pkey on appeal indexappea0_1_ (cost=0.43..2.03 rows=1 width=1,673) (actual rows= loops=)

  • Index Cond: (appeal_id = indexappea0_.appeal_id)
  • Filter: ((((appeal_status)::text = ''IN_PROCESS''::text) OR ((appeal_status)::text = ''NEW''::text)) AND ((appointed_post_index)::text = ANY (''{901084,188226,998545,998546,990043,990048,990050,990014,990053,921116,921117,921130,921145,921149,921151,921159,921162,921166,921172,921177,921183,998547,998551,998552,998553,998560,998561,990025,990047,921189,190702,990042,990052,921109,921110,921111,921121,921124,921131,921133,921134,921136,921137,921142,921155,921156,921157,921164,921173,921174,921176,190701,998550,998555,998557,990049,921184,921106,921123,921125,921129,921141,921171,921178,921179,921180,921160,990012,990018,921107,921108,921119,921120,921122,921138,921140,921146,921147,921148,921150,921153,921154,921161,921165,990056,998548,998549,998558,998559,990037,923912,921185,921186,921187,921112,921114,921115,921118,921128,921139,921144,921158,921113,921132,921163,921170,921175,998554,990323,998575,998579,998562,200933,200957,200948,200951,998589,998581,998585,998591,200949,998583,921126,921127,921135,921143,921152,921167,921169,921181,921182,921188,998571,998582,200945,998587,998590,998594,200918,998580,200950,190960,998595,998556,923913,998574,200939,200910,998588,990324,998578,200937,200917,998592,200919,998577,200940,200932,998586,998593,998596,998597,200954,998584,190967,901136,901173,190974,901199,187346,187348,196631,196641,197720,188401,188431,188415,188417,188653,188658,188663,188656,188667,188683,188664,188676,188827,188840,196632,196642,188402,188445,188672,188695,188686,188671,188650,188652,188846,190999,197000,196643,188341,188456,188668,188682,188360,188380,188378,188320,187125,187353,188345,188330,188333,188475,188458,188469,188468,188490,188520,187133,194361,188665,196644,196620,197730,197733,197739,188430,188414,188422,188699,188674,188657,188654,188838,188855,188828,188852,188850,188842,188359,188347,196627,188365,196626,188685,188843,188460,188472,188839,188830,188399,187120,188377,188336,188324,188357,187130,188467,188505,188531,188532,187340,187310,187330,187315,188524,188525,197755,198510,196645,197729,188447,188425,188421,188413,188696,188832,188823,188826,188822,188371,188355,188375,188361,188337,188348,198504,196634,188327,197758,188423,188400,188446,188477,188459,188680,188679,188689,188470,188465,188335,188354,188370,188356,188366,188340,187351,188376,188479,188471,187123,187122,188517,187134,187128,187323,187316,187322,187320,188515,188534,188506,188501,188507,188513,188516,188299,188221,198411,196650,188444,188420,188442,188684,188661,188670,188659,188338,188349,188362,188499,188453,187105,187100,187121,187352,187300,187326,187307,188508,188502,188523,188528,188277,188577,188551,188556,188553,187099,187031,187070,187033,187037,187460,187468,187720,187729,187735,187760,187750,187765,187758,187741,188932,187402,187432,187414,187440,187413,187516,187600,187612,187637,187636,188246,188291,188245,188259,188225,188751,188733,188731,187023,187024,187739,187726,187713,187762,188903,187504,187683,187634,187640,187661,188514,188535,188540,188280,194362,196625,188258,197738,188449,188416,188440,188820,188358,188351,188455,188462,187135,188527,188530,188518,188275,188282,188289,188279,188270,188292,188278,188287,188750,188769,188752,188572,188571,188578,187010,187461,187742,187757,187434,187450,187520,187611,187681,187665,187671,188286,188271,188223,188222,188264,188272,188296,188210,188743,187045,187050,187029,187717,187716,187773,187774,188909,188917,188901,188910,187522,187517,188250,188293,188224,188744,188574,187032,187021,187025,187463,187462,187715,187754,188980,188861,188970,188990,188931,187406,187442,187515,187513,187512,187631,187667,197760,188660,188675,188662,188681,188651,188824,188845,188851,188325,188352,188353,188457,188451,188478,187126,187327,187355,187350,188288,188266,188267,188284,188767,188734,188754,188763,188765,188753,188732,188741,188554,188550,187015,187751,188899,188870,188911,187430,187542,187613,187617,187638,188274,188268,188276,188283,188290,188265,188297,188273,188764,188742,187026,187090,187736,187770,187507,187620,187660,187625,187632,188220,188281,188730,188579,188576,187047,187040,187022,187469,187465,187714,187733,188960,188918,187509,187501,187643,187644,188261,187060,187464,187725,187711,187727,187439,187426,187420,187550,187540,187510,187511,187662,188285,188255,188200,188740,188736,187041,187030,187719,187775,188950,188908,188965,188919,187423,187514,187650,187642,187663,187429,187724,187771,188902,188930,188836,188966,188914,187422,187412,187435,187503,187530,187646,187630,187633,187635,188474,990000,187098,188439,190891,200973,200974,197001,200972,200994,901126,198998,901094,901001,187096,901085,901093,901002,187139,200920,188831,188819,188398,187761,191002,194044,197045,191086,193091,192102,190103,191104,190107,197110,192236,196240,195252,198255,198259,195275,192282,194291,195298,190005,190013,191015,194017,192019,195043,191055,199058,190068,191069,197082,196084,199106,195112,191119,190121,191141,192177,195197,198217,192239,188641,188642,188643,188644,197046,199048,199053,191060,196105}''::text[])))