Re: [ADMIN] RE: 回复：[ADMIN] pgadmin select slow than psql command much

2016-04-25 10:15 GMT+02:00 Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)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?
>
>

--
Guillaume.
http://blog.guillaume.lelarge.info
http://www.dalibo.com