explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Alh5

Settings
# exclusive inclusive rows x rows loops node
1. 0.235 51.269 ↑ 1.0 1 1

Aggregate (cost=20,194.03..20,194.04 rows=1 width=32) (actual time=51.269..51.269 rows=1 loops=1)

2. 49.100 51.034 ↓ 11.7 646 1

Bitmap Heap Scan on sub_tasks (cost=481.95..20,193.89 rows=55 width=5) (actual time=2.247..51.034 rows=646 loops=1)

  • Recheck Cond: ((state)::text = 'completed'::text)
  • Filter: ((task_id = ANY ('{84002,83836,84499,79178,25576,84314,39892,33780,9239,84575,8303,74408,38009,31366,87869,12748,7641,17045,13828,74009,58379,12304,29790,42328,82880,84381,8582,8735,9952,39320,25939,24348,41263,24972,71219,60389,81926,85035,27143,32025,25511,62795,45685,27210,28700,80780,83256,59252,79174,30660,47730,80677,19358,75192,42861,35654,50497,69465,40411,41215,79574,57076,42466,81164,81700,13313,30518,34453,82758,85143,40349,17613,8642,33264,35004,45744,79723,76204,87852,83618,43376,44358,88141,37734,19374,24366,73545,11905,62133,63741,47060,57356,28557,62860,67100,42023,53819,28701,10390,34366,54853,77771,76308,39351,30383,84368,51085,62366,35226,71129,78966,44992,31915,83183,81921,82896,16650,50499,25117,46323,72322,74412,18466,43164,8400,41354,29676,28839,19710,76945,8201,84666,32071,8596,51101,80535,76860,24157,26907,76950,26151,79331,80570,73748,74921,74140,74141,78452,31376,38873,69470,79171,77892,78026,68393,77969,79698,43056,41383,81053,67932,82474,58669,50656,9852,83755,81202,81643,13667,85216,26511,82101,76814,12862,8649,29769,47084,12398,62798,30144,83092,31212,19439,50164,31627,7845,7966,8766,7879,9203,38821,29694,40042,38810,17041,13605,14162,39923,39982,42522,25707,42887,43033,16978,43246,44067,19537,19096,19549,45328,49064,49732,23979,45630,22763,56418,25558,25943,51106,30786,30730,31213,51871,32531,35755,34318,34751,35779,39376,40333,41554,42525,42041,42342,43535,43533,43500,43718,43753,52286,43851,44771,44825,45320,42568,49658,50120,47840,52866,51252,51607,52910,80142,13302,13830,14251,62859,62861,18895,62265,52960,22732,64031,66006,55498,56102,76692,7882,9243,33281,38851,62093,27263,44868,44688,42504,25508,27118,68746,71753,76932,82320,76779,75607,78962,79953,75593,78908,78965,79366,79180,77361,79775,75587,80360,76259,80632,80354,81018,83576,80930,81188,81206,81222,80828,79456,81723,81962,82986,83817,80919,82352,84692,86287,88497,75000,83926,88195,78408,83664,88164,83828,84465,84970,39294,51366,87615,43193,87055,30572,81978,87450,89983,83724,90139,44758,77908,90526,39834,80154,85302,81762,67935,80216,33425,83999,83424,87132}'::integer[])) AND (task_id = ANY ('{84002,83836,84499,79178,25576,84314,39892,33780,9239,84575,8303,74408,38009,31366,87869,12748,7641,17045,13828,74009,58379,12304,29790,42328,82880,84381,8582,8735,9952,39320,25939,24348,41263,24972,71219,60389,81926,85035,27143,32025,25511,62795,45685,43000,27210,28700,80780,83256,59252,79174,30660,47730,80677,19358,75192,42861,35654,50497,69465,40411,41215,79574,57076,42466,81164,81700,13313,30518,34453,82758,85143,40349,17613,8642,33264,35004,45744,79723,33982,76204,87852,83618,43376,46061,44358,88141,37734,19374,39270,24366,73545,11905,62133,63741,47060,57356,28557,62860,67100,42023,53819,28701,10390,34366,54853,77771,76308,39351,30383,84368,51085,22548,62366,35226,71129,78966,44992,31915,83183,81921,82896,16650,50499,25117,46323,72322,74412,18466,43164,13831,8400,41354,29676,28839,19710,76945,8201,84666,16862,32071,8596,51101,43005,80535,76860,24157,26907,76950,26151,79331,80570,73748,74921,74140,74141,78452,31376,38873,69470,79171,44068,29405,77892,78026,68393,77969,79698,43056,41383,81053,67932,82474,58669,50656,9852,83755,81202,81643,13667,85216,26511,82101,76814,34292,12862,12301,8649,29769,47084,12398,62798,30144,83092,31212,19439,50164,31627,7777,7845,7966,8766,7879,41162,9203,38821,10627,29694,40042,38810,16723,17041,13605,14162,39923,39982,42522,25707,42887,43033,16978,43246,43847,44067,19537,19096,19549,45328,49064,49732,23979,50258,45630,22763,56418,25558,25943,51106,30786,30730,31213,51871,32531,35755,34318,34293,34751,35779,39376,40333,41554,42525,42041,42342,44319,43535,43533,43540,43500,43718,43753,52286,43851,44771,44825,45320,42568,49658,50120,47840,52866,51252,51607,52910,80142,10377,13302,13830,14251,62859,62861,18895,62265,52960,22732,64031,66006,55498,56102,57085,76692,7882,9243,33281,38851,62093,27263,44868,44688,42504,25508,27076,27118,68746,71753,76932,82320,76779,75607,78962,79953,75593,78908,78965,79366,79180,77361,79775,75587,80360,76259,80632,80354,81018,78680,83576,80930,81188,81206,81222,80828,79456,81723,81962,82986,83817,80919,82352,84692,86287,88497,75000,83926,88195,78408,83664,88164,83828,84465,84970,39294,51366,87615,43193,90066,87055,30572,88051,81978,87450,89983,83724,90139,44758,77908,90526,39834,80154,85302,90650,81762,67935,80216,91412,33425,83999,92044,90965,83424,92304,87132,92370}'::integer[])))
  • Rows Removed by Filter: 19711
  • Heap Blocks: exact=788
3. 1.934 1.934 ↑ 1.0 20,357 1

Bitmap Index Scan on index_sub_tasks_on_state (cost=0.00..481.93 rows=20,486 width=0) (actual time=1.934..1.934 rows=20,357 loops=1)

  • Index Cond: ((state)::text = 'completed'::text)