Aggregate  (cost=1′192′809.98..1′192′810.03 rows=1 width=8) (actual time=22′756.161..22′756.164 rows=1 loops=1)
  ->  Nested Loop  (cost=60.46..1′152′809.98 rows=8′000′000 width=32) (actual time=3.466..22′739.232 rows=156′800 loops=1)
        ->  Nested Loop  (cost=60.03..52′809.98 rows=1′000′000 width=40) (actual time=3.443..25.458 rows=19′600 loops=1)
              ->  Nested Loop  (cost=59.98..160.03 rows=1′000 width=36) (actual time=3.316..3.497 rows=140 loops=1)
                    ->  Aggregate  (cost=59.98..60.03 rows=1 width=32) (actual time=3.302..3.303 rows=1 loops=1)
                          ->  Function Scan on regexp_split_to_table line  (cost=0.00..55.00 rows=995 width=32) (actual time=0.247..0.340 rows=140 loops=1)
                                Filter: (btrim(line) <> ''::text)
                                Rows Removed by Filter: 2
                    ->  Function Scan on generate_subscripts x  (cost=0.00..50.00 rows=1′000 width=4) (actual time=0.012..0.102 rows=140 loops=1)
              ->  Memoize  (cost=0.05..50.05 rows=1′000 width=4) (actual time=0.103..0.123 rows=140 loops=140)
                    Cache Key: (array_agg(regexp_split_to_array(line.line, ''::text)))
                    Cache Mode: binary
                    Hits: 139  Misses: 1  Evictions: 0  Overflows: 0  Memory Usage: 159kB
                    ->  Function Scan on generate_subscripts y  (cost=0.00..50.00 rows=1′000 width=4) (actual time=0.010..0.022 rows=140 loops=1)
        ->  ProjectSet  (cost=0.42..0.70 rows=8 width=32) (actual time=1.157..1.158 rows=8 loops=19′600)
              ->  Aggregate  (cost=0.42..0.47 rows=1 width=256) (actual time=1.155..1.155 rows=1 loops=19′600)
                    ->  Function Scan on generate_series i  (cost=0.00..0.20 rows=4 width=4) (actual time=0.000..0.001 rows=4 loops=19′600)
Planning Time: 0.236 ms
Execution Time: 22′756.404 ms