Sorry for the misunderstanding. I have a table like; CREATE TABLE zamazin ( paramuser_id text, paramperson_id integer, paramdata json, paramisdeleted boolean, paramactiontime timestamp without time zone ) paramdata row size is 110KB and over.
When I execute this query like; *select * from zamazin* it takes *600 seconds*. But when analyze the query ; *"Seq Scan on public.zamazin (cost=0.00..21.77 rows=1077 width=49) (actual time=0.008..0.151 rows=1077 loops=1)"" Output: paramuser_id, paramperson_id, paramdata, paramisdeleted, paramactiontime"" Buffers: shared hit=11""Planning time: 0.032 ms""Execution time: 0.236 ms"* Why the query takes a long time, I do not understand. I assume that this relates to the TOAST structure. png.png (11K) <https://mail.google.com/mail/u/0?ui=2&ik=887fea0f99&attid=0.1&permmsgid=msg-a:r3734143643823656667&view=att&disp=safe&realattid=f_k6c77tsa1> Andreas Joseph Krogh <andr...@visena.com>, 7 Şub 2020 Cum, 16:12 tarihinde şunu yazdı: > På fredag 07. februar 2020 kl. 14:07:28, skrev Asya Nevra Buyuksoy < > ayisan1...@gmail.com>: > > Hello everybody, > > [...] > > How I can achieve good performance? > > > Nobody here understands anything unless you show the exact query and > schema... > > And of course you'll be encurraged to upgrade to latest version (12.1) as > 9.4.1 is now 5 years old.. > > -- > Andreas Joseph Krogh >
