explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lb9w

Settings
# exclusive inclusive rows x rows loops node
1. 0.035 7,455.175 ↑ 1.0 200 1

Limit (cost=1,000.64..4,060.45 rows=200 width=79) (actual time=6,888.471..7,455.175 rows=200 loops=1)

  • Output: oid, capacity, creation_date, uuid, subscription_id, version, workspace_oid, iteration_oid, user_oid, project_oid
  • Buffers: shared hit=2,736,611
2. 106.909 7,455.140 ↑ 614.1 200 1

Gather Merge (cost=1,000.64..1,880,016.28 rows=122,819 width=79) (actual time=6,888.464..7,455.140 rows=200 loops=1)

  • Output: oid, capacity, creation_date, uuid, subscription_id, version, workspace_oid, iteration_oid, user_oid, project_oid
  • Workers Planned: 5
  • Workers Launched: 5
  • Buffers: shared hit=2,736,611
3. 7,348.231 7,348.231 ↑ 614.1 40 6 / 6

Parallel Index Scan using pk_user_iter_capacity_oid on sandbox.user_iter_capacity (cost=0.56..1,864,225.75 rows=24,564 width=79) (actual time=6,790.456..7,348.231 rows=40 loops=6)

  • Output: oid, capacity, creation_date, uuid, subscription_id, version, workspace_oid, iteration_oid, user_oid, project_oid
  • Filter: (user_iter_capacity.project_oid = ANY ('{30186602309,35041776303,102328171820,75489210772,45693326724,42162777366,35453681461,44459699713,38439940913,31616274545,53267526397,75491256764,40309166745,97396493136,80103410836,28907680541,43027613372,40309165185,30187544910,31413997684,32293807811,32293861569,41928759604,45708565095,30187851598,31225405237,45407715498,110899548700,30187662194,48486418985,31538713082,157601362380,30186599796,30187797857,26799926617,31538908128,27085047842,33483514243,32293943964,75427208600,56813560863,30187851032,30187947801,42162649429,49253231097,30187306758,31538404254,32293810839,30187536152,56185386155,26799927599,45410000639,33146160124,53978019593,81016678072,97918161956,30188374285,38899598023,39353322491,48804677806,30186597662,34199832611,35280355976,38899596018,146604660240,40463239073,26799931141,36712524882,184801633604,31538865596,30188324658,31282554107,56769845208,42288325366,40309170937,40309318392,30187944737,31538536354,35041871058,35865634232,31282367201,32293665960,30188228394,39617750296,75488375580,44395423837,52882366079,117765507896,45692659979,110516938036,30188329946,54015038720,76719976524,33146026797,43883897639,71876399292,35615608411,44538325552,93453939920,35041374757,51419603550,35041769505,75426084128,39617560063,31281964573,57154956326,145235435532,30187536842,30188228034,31538405196,92112841936,97396019656,30187948530,42162645942,48401779295,97395660672,41928756609,53091653182,290867073012,31225407896,31538708325,35041772567,45409992215,56813802216,44395155611,308032612048,30187665386,30187481495,112239435556,120123859752,33606434778,30188093337,45414742048,30188444048,54015046472,30187951488,39065960538,108272410432,49605561441,101228287336,49312409063,75428414752,39065962591,40309314124,37940238265,157988463648,30188472709,35041865341,30187952560,38908796364,49250591611,57157285435,57005322528,30187852215,142919408224,33287533818,34957598016,30187802041,35614830635,78737182180,93442394464,58199254033,40309310585,30186416055,31538716973,40309312103,38439802826,63349614354,54015242103,77888922732,97666100152,40309168737,42162643434,32293940783,76719219764,30187661740,51419539494,28906200584,31282420331,35041625512,48401801207,36713819486,85870587228,30187109450,39065962893,31538303707,45693623950,54014809231,71095531676,32464026642,45693234841,164680059520,61478743923,30187662915,46203299069,140105910732,30188099653,257015644276,30187952205,34413564960,117748678488,44538196868,33146904720,98343909108,53770502610,31282413491,30187668092,30187948154,27343100141,33287462716,30187947134,56362397270,31282481059,56296873651,41569970424,32679484651,57004806904,30188373601,38233456597,32679480548,49253285518,95130891028,31282476974,75487182924,31538588896,27093697967,77986437384,31225402476,93455238912,45407559619,33146151655,33146033380,49431553305,30188232720,30187406854,78939982444,35461687542,34957674744,42162776130,48634220939,29173740464,31225521790,32293858700,27342962325,30188094471,54618528466,43254786942,31225329782,101226545880,39617672204,32675306748,31563554871,63373878283,53982844618,163513677676,30188370482,53973096552,45407431967,32293803447,35041868748,31225524825,30187665958,31281961977,43616330948,63510225148,102002224812,96347982760,116841263396,85866789220,30187398705,33234707340,36713824549,45692484623,85655939088,43522601901,93455586804,33146205737,39617673448,44395154342,45692367604,46301539910,95130550692,102001851476,33287457180,46071049096,30188235468,61144888090,120122435152,57523745584,194601713812,93744568348,156884779196,41090789026,30188372163,53770667373,76718531404,45353173715,304448756052,54618418705,97396704508,47223485714,101224274640,36563692287,45692737247,49031096282,156886582948,34957599750,30187474681,36711626645,31282359586,38899451176,36505336915,47223255819,39617670357,37391732490,101228307460,38812972760,40309317417,30187404936,31538586143,140222287876,97666192008,31282415964,30188331667,35274032574,31561813750,49031247805,31282483551,41438644266,27342962194,31282362181,30187805318,55994540113,78194873088,110546584280,45708703649,50518252236,75428803616,30186600601,30188094081,30187537591,89513972868,55994364014,51184320318,54884416182,43242678931,49431562173,43594904975,46062332027,46286781204,30188325538,111275539304,42162648293,54893708828,142565566540,454075928201}'::numeric[]))
  • Rows Removed by Filter: 602,084
  • Buffers: shared hit=2,736,611
  • Worker 0: actual time=6,861.609..7432.364 rows=42 loops=1
  • Buffers: shared hit=462,642
  • Worker 1: actual time=6,882.820..7447.494 rows=32 loops=1
  • Buffers: shared hit=463,230
  • Worker 2: actual time=6,705.813..7434.354 rows=52 loops=1
  • Buffers: shared hit=462,366
  • Worker 3: actual time=6,862.058..7428.732 rows=42 loops=1
  • Buffers: shared hit=458,069
  • Worker 4: actual time=6,723.830..7427.841 rows=54 loops=1
  • Buffers: shared hit=459,954
Planning time : 2.293 ms
Execution time : 7,455.836 ms