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 <ayisan1...@gmail.com>: >I try it, but there is no enhancement. >I read this link is about TOAST and also its sub_links; >https://blog.gojekengineering.com/a-toast-from-postgresql-83b83d0d0683 >When I execute this query, except JSON data like; >SELECT paramuser_id, paramperson_id, paramisdeleted, paramactiontime > FROM zamazin; >It takes 94 ms. :) > > >Andreas Joseph Krogh <andr...@visena.com>, 7 Şub 2020 Cum, 17:42 tarihinde >şunu yazdı: > >> På fredag 07. februar 2020 kl. 15:35:04, skrev Asya Nevra Buyuksoy < >> ayisan1...@gmail.com>: >> >> 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. >> >> -- >> Andreas Joseph Krogh >> >> -- Sendt fra min Android-enhet med K-9 e-post. Unnskyld min kortfattethet.
