ilike search really uses its index?
LIKE with a wildcard at the start of the expression can't use a btree index. In order to make that query use an index, you need to create a trigram index for which you need to install the pg_trgm extension first.

create index on test_table using gin (nickname gin_trgm_ops);