Обсуждение: pgadmin select slow than psql command much
HI,
Why select query in pgadmin slow than psql much ?
and i use heidisql client, select fast than pgadmin much more.
this is my test:
https://yq.aliyun.com/articles/32438
digoal,
best regards.
周正中 wrote: > Why select query in pgadmin slow than psql much ? > and i use heidisql client, select fast than pgadmin much more. > this is my test: > https://yq.aliyun.com/articles/32438 Do you see a difference in the EXPLAIN ANALYZE output? Yours, Laurenz Albe
周正中 wrote: >>> Why select query in pgadmin slow than psql much ? >>> and i use heidisql client, select fast than pgadmin much more. >>> this is my test: >>> https://yq.aliyun.com/articles/32438 >> >> Do you see a difference in the EXPLAIN ANALYZE output? > > explain analyze no difference. Please don't top post. If there is no difference in EXPLAIN ANALYZE output, that means that the statement took the same time in both cases. Maybe it took a long time to transfer the data across the network, or it took the client a long time to render the result. Is the result set large? Can you see high network or CPU activity on the client side? Yours, Laurenz Albe
2016-04-25 10:15 GMT+02:00 Albe Laurenz <laurenz.albe@wien.gv.at>:
周正中 wrote:
>>> Why select query in pgadmin slow than psql much ?
>>> and i use heidisql client, select fast than pgadmin much more.
>>> this is my test:
>>> https://yq.aliyun.com/articles/32438
>>
>> Do you see a difference in the EXPLAIN ANALYZE output?
>
> explain analyze no difference.
Please don't top post.
If there is no difference in EXPLAIN ANALYZE output, that means
that the statement took the same time in both cases.
Maybe it took a long time to transfer the data across the network,
or it took the client a long time to render the result.
It's usually the issue: long time to display rather big result sets.
Is the result set large?
Can you see high network or CPU activity on the client side?
--
explain analyze no difference.
------------------------------------------------------------------发件人:Albe Laurenz <laurenz.albe@wien.gv.at>发送时间:2016年4月22日(星期五) 17:20收件人:周正中(德歌) <dege.zzz@alibaba-inc.com>; pgsql-admin <pgsql-admin@postgresql.org>主 题:RE: [ADMIN] pgadmin select slow than psql command much周正中 wrote:
> Why select query in pgadmin slow than psql much ?
> and i use heidisql client, select fast than pgadmin much more.
> this is my test:
> https://yq.aliyun.com/articles/32438
Do you see a difference in the EXPLAIN ANALYZE output?
Yours,
Laurenz Albe