Re: Performance of SELECT directly and from application

Поиск
Список
Период
Сортировка
От dbatoCloud Solution
Тема Re: Performance of SELECT directly and from application
Дата
Msg-id CAEz7P_u9K=Xj6jsSXD5Z78X_uLMJXu4L=_PP1swROQSOjNFokw@mail.gmail.com
обсуждение исходный текст
Ответ на Performance of SELECT directly and from application  (Jessica Holle <jessica.holle@vit.de>)
Список pgsql-admin
please share the output of explain also let me know if pgbench is
enabled configuration in postgresql.conf file


Thanks
Ashok

On Wed, Jun 24, 2020, 09:00 Jessica Holle <jessica.holle@vit.de> wrote:

> Hi,
>
> we use PostgreSQL 12.3.1 and have a little bit trouble with performance.
> When the statement comes from the application (wildfly) duration is
> about 24982.819 ms. When I do the statement directly with psql duration
> is 967.773 ms.
> Duration from Wildfly is known becaue we use in postgresql.conf
> "log_min_duration_statement = 5000". There I see, that from application
> are 3 variables used.
> Is there any idea why this can happen or a hint to solve this issue?
>
> Kind regards,
> Jessica
>
>
>



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

Предыдущее
От: Laurenz Albe
Дата:
Сообщение: Re: Performance of SELECT directly and from application
Следующее
От: Jessica Holle
Дата:
Сообщение: Re: Performance of SELECT directly and from application