Limit  (cost=0.00..20331.77 rows=100 width=8) (actual time=7573.524..7573.528 rows=0 loops=1)
  ->  Seq Scan on users usr1  (cost=0.00..314669449.46 rows=1547674 width=8) (actual time=7573.523..7573.527 rows=0 loops=1)
        Filter: ((id <> 5248022) AND ((SubPlan 1) >= 3))
        Rows Removed by Filter: 4642055
        SubPlan 1
          ->  Aggregate  (cost=67.68..67.69 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=4642054)
                ->  Hash Join  (cost=47.52..65.18 rows=1000 width=0) (actual time=0.001..0.001 rows=0 loops=4642054)
                      Hash Cond: ((regexp_split_to_table(lower(unaccent(btrim((usr1.full_name_pp)::text))), '\s+'::text)) = (regexp_split_to_table(lower(unaccent('Okere Ifeanyichukwu Luther'::text)), '\s+'::text)))
                      ->  ProjectSet  (cost=0.00..5.03 rows=1000 width=32) (actual time=0.000..0.000 rows=0 loops=4642054)
                            ->  Result  (cost=0.00..0.01 rows=1 width=0) (actual time=0.000..0.000 rows=1 loops=4642054)
                      ->  Hash  (cost=35.02..35.02 rows=1000 width=32) (actual time=0.041..0.043 rows=3 loops=1)
                            Buckets: 1024  Batches: 1  Memory Usage: 9kB
                            ->  HashAggregate  (cost=7.52..25.02 rows=1000 width=32) (actual time=0.026..0.037 rows=3 loops=1)
                                  Group Key: regexp_split_to_table(lower(unaccent('Okere Ifeanyichukwu Luther'::text)), '\s+'::text)
                                  Batches: 1  Memory Usage: 73kB
                                  ->  ProjectSet  (cost=0.00..5.02 rows=1000 width=32) (actual time=0.017..0.019 rows=3 loops=1)
                                        ->  Result  (cost=0.00..0.01 rows=1 width=0) (actual time=0.001..0.001 rows=1 loops=1)
Planning Time: 3.059 ms
Execution Time: 7574.043 ms