From that query plan it looks like you don't have a index on code_1_text or the index isn't being used.
Perhaps try running a tune table.