Beside the fields evalue1 & evalue2 the variables are either integer or text.
The design of database is very bad. It runs in a virtual machine on NFS. Every join takes ages, so now the attempt to have all data in one table.
NFS and virtual machine is not necessarily bad. I would check your indexes though (make sure the columns you join on are indexed and your where clauses are too).