Nested Loop  (cost=4′457′610.54..5′301′200.44 rows=643′327 width=38) (actual time=623.378..61′661.663 rows=35′916 loops=1)
  Buffers: shared hit=10′640′612, temp read=2′743 written=5′765
  ->  HashAggregate  (cost=4′457′610.39..5′059′435.25 rows=51′301 width=51) (actual time=604.228..1′125.164 rows=51′301 loops=1)
        Group Key: dict_1.word
        Planned Partitions: 128  Peak Memory Usage: 1′581 kB  Disk Usage: 24′576 kB  HashAgg Batches: 128
        Buffers: shared hit=323, temp read=2′743 written=5′765
        ->  Nested Loop  (cost=0.01..1′026′856.02 rows=51′301′000 width=23) (actual time=0.042..226.516 rows=467′753 loops=1)
              Buffers: shared hit=323
              ->  Seq Scan on dict dict_1  (cost=0.00..836.01 rows=51′301 width=19) (actual time=0.014..6.930 rows=51′301 loops=1)
                    Buffers: shared hit=323
              ->  Function Scan on generate_series i  (cost=0.01..10.01 rows=1′000 width=4) (actual time=0.002..0.002 rows=9 loops=51′301)
  ->  Bitmap Heap Scan on dict  (cost=0.15..4.57 rows=13 width=19) (actual time=1.169..1.170 rows=1 loops=51′301)
        Recheck Cond: ((length(word) = length(dict_1.word)) AND (word ~~ ANY ((array_agg(((substr(dict_1.word, 1, (i.i - 1)) || '_'::text) || substr(dict_1.word, (i.i + 1))))))))
        Rows Removed by Index Recheck: 1
        Filter: (word <> dict_1.word)
        Rows Removed by Filter: 1
        Heap Blocks: exact=81′313
        Buffers: shared hit=10′640′289
        ->  Bitmap Index Scan on dict_length_word_idx  (cost=0.00..0.15 rows=13 width=0) (actual time=1.160..1.160 rows=11 loops=51′301)
              Index Cond: ((length(word) = length(dict_1.word)) AND (word ~~ ANY ((array_agg(((substr(dict_1.word, 1, (i.i - 1)) || '_'::text) || substr(dict_1.word, (i.i + 1))))))))
              Buffers: shared hit=10′558′976
Planning Time: 0.255 ms
  Buffers: shared hit=2
Execution Time: 62′012.139 ms