Try \o <filename> in psql, to redirect the output to file, and prevent it from processing the json (ie. format it)
Den 7. februar 2020 15:59:05 CET, skrev Asya Nevra Buyuksoy <ayisan1096@gmail.com>:
I try it, but there is no enhancement.
I read this link is about TOAST and also its sub_links;
When I execute this query, except JSON data like;
SELECT paramuser_id, paramperson_id, paramisdeleted, paramactiontime
FROM zamazin;
It takes 94 ms. :)
I use pgadmin3.
Try "psql", it has the lowest overhead (I think). pgAdmin might use time presenting the results etc. which is easy to overlook.
--
Sendt fra min Android-enhet med K-9 e-post. Unnskyld min kortfattethet.