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

Поиск
Список
Период
Сортировка
От Albe Laurenz
Тема RE: 回复:[ADMIN] pgadmin select slow than psql command much
Дата
Msg-id A737B7A37273E048B164557ADEF4A58B5384402C@ntex2010i.host.magwien.gv.at
обсуждение исходный текст
Ответ на pgadmin select slow than psql command much  ("周正中(德歌)" <dege.zzz@alibaba-inc.com>)
Ответы Re: [ADMIN] RE: 回复:[ADMIN] pgadmin select slow than psql command much  (Guillaume Lelarge <guillaume@lelarge.info>)
Список pgsql-admin
周正中 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

В списке pgsql-admin по дате отправления:

Предыдущее
От: Joey Ayap
Дата:
Сообщение: PostgreSQL migrating from 9.2 to 9.5 with data dir on different volume
Следующее
От: Guillaume Lelarge
Дата:
Сообщение: Re: [ADMIN] RE: 回复:[ADMIN] pgadmin select slow than psql command much