explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sbpt

Settings
# exclusive inclusive rows x rows loops node
1. 167,900.089 167,900.089 ↑ 29.7 7,260 1

Index Scan using cowbody_subissions_assignment_id on submissions (cost=0.57..1,034,901.53 rows=215,475 width=16) (actual time=2,914.388..167,900.089 rows=7,260 loops=1)

  • Index Cond: (assignment_id = ANY ('{11546996,11546997,11546998,11546999,11547000,11547001,11547002,11547003,11547004,11547005,11547008,11547009,11547010,11547011,11547012,11547013,11547014,11547015,11547016,11547017,11547018,11547019,11547020,11547021,11547022,11547023,11547024,11547025,11547026,11547027,11547028,11547029,11547030,11547031,11547032,11547033,11547034,11547035,11547036,11547037,11547038,11547039,11547040,11547041,11547042,11547043,11547045,11547046,11547047,11547048,11547049,11547050,11547051,11547052,11547053,11547054,11547055,11547056,11547057,11547058,11547059,11547060,11547061,11547062,11547063,11547064,11547065,11547066,11547067,11547068,11547069,11547070,11547071,11547072,11547073,11547074,11547075,11547076,11547077,11547078,11547079,11547080,11547081,11547082,11547083,11547084,11547085,11547086,11547087,11547088,11547089,11547090,11547091,11547093,11547094,11547095,11547096,11547097,11547098,11547099,11547100,11547101,11547102,11547103,11547104,11547105,11547106,11547107,11547109,11547110,11547111,11547112,11547113,11547114,11547115,11547116,11547117,11547118,11547119,11547120,11547121,11547122,11547124,11547125,11547126,11547127,11547128,11547129,11547130,11547131,11547132,11547133,11547134,11547135,11547136,11547138,11547139,11547140,11547141,11547142,11547143,11547144,11547145,11547146,11547147,11547148,11547149,11547150,11547151,11547152,11547153,11547154,11547155,11547156,11547157,11547158,11547159,11547160,11547161,11547162,11547163,11547164,11547165,11547166,11547167,11547168,11547169,11547170,11547171,11547172,11547173,11547174,11547175,11547176,11547177,11547178,11547179,11547180,11547181,11547182,11547183,11547184,11547185,11547186,11547187,11547188,11547189,11547190,11547192,11547193,11547194,11547195,11547196,11547197,11547198,11547199,11547200,11547201,11547202,11547203,11547204,11547205,11547206,11547207,11547208,11547209,11547210,11547211,11547212,11547213,11547214,11547215,11547216,11547217,11547218,11547219,11547220,11547221,11547222,11547223,11547224,11547225,11547226,11547227,11547228,11547229,11547230,11547231,11547232,11547233,11547234,11547235,11547236,11547237,11547238,11547239,11547240,11547241,11547242,11547243,11547244,11547245,11547246,11547247,11547248,11547249,11547250,11547251,11547252,11547253,11547254,11547255,11547256,11547257,11547258,11547259,11547260,11547261,11547262,11547263,11547264,11547265,11547266,11547267,11547268,11547269,11547270,11547271,11547272,11547273,11547274,11547275,11547276,11547277,11547278,11547279,11547280,11547281,11547282,11547283,11547284,11547285,11547286,11547287,11547288,11547289,11547290,11547291,11547292,11547293,11547294,11547295,11547296,11547297,11547298,11547299,11547300,11547301,11547302,11547303,11547304,11547305,11547306,11547307,11547308,11547309,11547310,11547311,11547312,11547313,11547314,11547315,11547316,11547317,11547319,11547320,11547321,11547322,11547323,11547324,11547325,11547326,11547327,11547328,11547329,11547330,11547331,11547332,11547333,11547334,11547335,11547336,11547337,11547338,11547339,11547340,11547341,11547342,11547343,11547344,11547345,11547346,11547347,11547348,11547349,11547350,11547351,11547352,11547353,11547354,11547355,11547356,11547357,11547358,11547359,11547360,11547361,11547362,11547363,11547364,11547365,11547366,11547367,11547368,11547369,11547370,11547371,11547372,11547373,11547374,11547375,11547376,11547377,11547379,11547380,11547381,11547382,11547383,11547384,11547385,11547387,11547388,11547389,11547391,11547392,11547393,11547395,11547396,11547397,11547399,11547400,11547401,11547403,11547405,11547407,11547408,11547410,11547412,11547414,11547416,11547418,11547419,11547421,11547423,11547424,11547425,11547426,11547427,11547428,11547429,11547430,11547431,11547432,11547433,11547434,11547435,11547436,11547437,11547438,11547439,11547440,11547441,11547442,11547443,11547444,11547445,11547446,11547447,11547448,11547449,11547450,11547451,11547452,11547453,11547454,11547455,11547456,11547457,11547458,11547459,11547460,11547461,11547462,11547463,11547464,11547465,11547466,11547467,11547468,11547469,11547470,11547471,11547472,11547473,11547474,11547475,11547476,11547477,11547478,11547479,11547480,11547481,11547482,11547483,11547484,11547485,11547486,11547487,11547488,11547489,11547490,11547491,11547492,11547493,11547494,11547495,11547496,11547497,11547498,11547499,11547500,11547501,11547502,11547503,11547504,11547505,11547506,11547507,11547508,11547509,11547510,11547511,11547512,11547513,11547514,11547515,11547516,11547517,11547518,11547519,11547521,11547522,11547523,11547524,11547525,11547526,11547527,11547528,11547530,11547531,11547532,11547533,11547534,11547535,11547536,11547537,11547538,11547539,11547540,11547541,11547542,11547543,11547544,11547545,11547546,11547547,11547548,11547549,11547550,11547551,11547552,11547553,11547554,11547555,11547556,11547557,11547558,11547559,11547560,11547561,11547562,11547563,11547564,11547565,11547566,11547567,11547568,11547569,11547570,11547571,11547572,11547573,11547574,11547575,11547576,11547577,11547578,11547579,11547580,11547581,11547583,11547584,11547585,11547587,11547588,11547589,11547590,11547591,11547592,11547593,11547594,11547595,11547596,11547597,11547598,11547599,11547600,11547601,11547602,11547603,11547604,11547605,11547606,11547607,11547608,11547610,11547611,11547612,11547613,11547614,11547615,11547616,11547617,11547618,11547619,11547620,11547621,11547622,11547623,11547625,11547626,11547627,11547628,11547630,11547631,11547632,11547633,11547634,11547635,11547636,11547637,11547638,11547640,11547641,11547642,11547643,11547644,11547645,11557402,11581324,11597323}'::bigint[]))
  • Filter: ((grading_period_id = ANY ('{348,349}'::bigint[])) OR ((grading_period_id IS NULL) AND (now() > '2019-10-03 16:50:20+00'::timestamp with time zone)))
  • Rows Removed by Filter: 29940
Planning time : 6.114 ms
Execution time : 167,901.870 ms