"NSO" <nso(at)fmf(dot)vtu(dot)lt> writes:
> Query runs very long:
> Total query runtime: 23625 ms.
> Data retrieval runtime: 266 ms.
> 50 rows retrieved.
Notice that the query itself took 266ms. The rest of the time was
wasted by your client app trying to format a 23Kb by 50 row table
for display. You need to replace your client-side code with something
less inefficient about handling wide values.
regards, tom lane