explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CqER

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

Finalize GroupAggregate (cost=888,651,975.13..888,913,538.02 rows=7,287 width=24) (actual rows= loops=)

  • Group Key: ts_time
2. 0.000 0.000 ↓ 0.0

Gather Merge (cost=888,651,975.13..888,913,355.84 rows=14,574 width=24) (actual rows= loops=)

  • Workers Planned: 2
3. 0.000 0.000 ↓ 0.0

Partial GroupAggregate (cost=888,650,975.11..888,910,673.62 rows=7,287 width=24) (actual rows= loops=)

  • Group Key: ts_time
4. 0.000 0.000 ↓ 0.0

Sort (cost=888,650,975.11..888,715,881.52 rows=25,962,564 width=16) (actual rows= loops=)

  • Sort Key: ts_time
5. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on tallnskinny (cost=0.00..884,122,599.00 rows=25,962,564 width=16) (actual rows= loops=)

  • Filter: (ts_key = ANY ('{63,21,78,38,97,58,32,91,88,59,24,93,31,67,90,5,75,7,87,32,42,35,2,69,17,8,72,64,40,5,61,29,43,86,24,87,79,70,15,1,97,79,9,39,88,9,4,64,37,64,62,33,5,83,77,53,87,80,47,26,84,39,39,86,7,67,8,80,47,22,62,28,63,53,17,91,43,56,19,53,74,99,55,90,19,21,4,99,12,64,80,94,7,56,59,14,64,52,84,9,96,96,19,60,64,54,40,1,54,90,41,71,93,76,18,72,68,41,78,88,59,33,84,35,49,30,68,31,68,49,95,12,97,98,96,12,33,82,60,30,70,60,6,28,27,8,61,14,43,96,20,10,93,29,49,90,71,85,67,26,56,24,97,30,41,37,50,91,24,92,13,30,40,9,41,85,52,31,55,15,54,18,55,75,55,69,91,63,41,74,72,36,75,13,43,72,43,49,85,73,17,86,13,93,48,15,28,80,62,92,95,93,84,54,90,21,32,35,5,98,50,13,50,20,73,72,81,81,68,39,85,51,9,57,39,47,86,1,83,26,57,85,14,92,40,7,18,50,1,22,46,15,8,20,5,33,63,87,63,70,53,54,61,14,71,63,3,26,89,7,72,87,19,25,44,16,74,80,73,7,45,30,63,24,71,52,85,37,92,6,64,7,44,1,87,15,9,32,53,73,73,84,65,82,51,12,70,90,38,8,71,22,36,12,45,55,80,40,85,86,74,66,39,17,51,73,27,97,83,3,22,87,64,56,24,61,24,4,35,60,6,49,75,61,92,21,95,83,16,71,81,18,78,43,48,65,95,19,42,36,25,5,26,95,20,66,99,53,27,68,85,48,86,96,4,44,98,6,19,98,30,2,35,40,94,58,50,47,89,36,74,57,40,15,73,28,95,67,40,78,60,23,77,53,84,96,97,8,87,1,59,68,82,71,96,19,88,68,18,75,27,62,87,25,75,58,14,84,95,66,31,43,51,7,82,69,82,29,50,54,60,23,98,94,24,7,62,38,59,11,5,72,27,30,73,3,64,3,61,52,10,22,71,58,80,73,18,55,85,12,85,59,14,40,47,4,5,60,30,64,38,50,59,50,24,79,53,38,76,36,53,20,53,56,8,60,38,42,7,24,73,44,71,76,29,15,1,33,89,9,59,5,10,19,18,36,20,37,19,68,90,85,95,93,95,87,24,4,48,48,12,87,93,77,81,64,71,10,36,83,4,58,9,88,8,92,98,99,71,60,97,47,5,16,58,69,66,47,55,41,22,3,4,83,84,36,22,70,76,17,80,25,69,59,38,84,50,92,39,20,24,62,42,36,45,89,20,56,2,97,4,98,32,66,37,39,3,21,58,85,64,43,98,15,50,8,81,46,12,55,29,65,20,14,82,10,92,1,93,48,72,59,88,22,76,46,97,52,38,85,64,53,18,40,38,63,56,63,40,25,82,53,38,35,9,83,80,47,70,28,30,14,15,69,3,81,27,38,21,63,34,94,87,73,12,10,24,43,9,24,84,31,66,31,83,16,95,18,83,77,65,44,91,20,23,95,44,67,80,1,77,76,70,94,75,50,88,12,14,53,86,51,4,1,70,40,51,37,61,24,86,99,40,8,8,79,82,71,27,43,3,4,43,55,86,38,74,12,17,25,81,86,82,66,20,49,99,70,99,78,76,73,36,45,77,88,25,30,14,30,21,30,40,95,5,24,79,7,99,97,65,98,42,28,29,24,17,71,46,77,92,23,92,35,29,22,99,41,55,11,90,27,15,33,47,28,24,47,31,66,19,26,83,27,99,49,24,13,23,5,3,93,73,77,52,36,76,86,27,56,34,19,42,34,2,45,4,58,80,43,52,77,97,18,53,9,68,51,21,28,96,98,62,58,45,44,66,51,53,20,20,52,63,7,89,8,65,88,84,56,14,72,31,69,70,71,9,26,85,25,91,81,78,69,70,88,34,74,78,7,60,70,49,25,35,22,34,3,64,86,75,85,88,40,41,64,52,84,2,93,86,86,91,12,29,76,9,92,5,93,70,99,96,23,51,57,49,1,27,41,83,36,15,82,23,90,8,58,73,99,87,48,53,41,90,44,15,90,84,54,61,81,72,79,3,84,18,53,81,86,90,2,8,4,90,27,9,62,47,91,40,19,20,95,90,99,45,49,64,13,74,58,73,64,58,6,34,16,43,14,24,77,79,38,96,38,20,72,68,19,47,27,67,1,68,35,83,71,81,2,96,56,1,49,32,19,34,71,70,54,5,2,13,77,6,52,1,86,40,91,64,32,55,77,83,43,75,39,83,78,81,40,46,67,82,44,46,33,31,62,22,64,60,77,1,76,77,65,69,39,66,79,13,83,55,29,43,99,64,15,49,30,29,91,32,64,6,36,3,49,83,75,47,18,52,9,30,45,79,83,53,89,44,40,40,1,74,40,26,75,19,95,98,11,72,88,32,86,83,47,49,74,40,51,47,1,27,67,46,64,93,3,1,47,69,63,49,52,12,61,10,19,96,15,60,24,76,99,56,7,34,79,99,38,95,38,62,14,5,28,87,35,30,44,9,12,31,87,96,41,12,82,37,15}'::bigint[]))