From: | dbatoCloud Solution <dbatocloud17(at)gmail(dot)com> |
---|---|
To: | Jessica Holle <jessica(dot)holle(at)vit(dot)de> |
Cc: | Pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Performance of SELECT directly and from application |
Date: | 2020-06-24 06:38:42 |
Message-ID: | CAEz7P_u9K=Xj6jsSXD5Z78X_uLMJXu4L=_PP1swROQSOjNFokw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(dot)holle(at)vit(dot)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
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Jessica Holle | 2020-06-25 11:13:46 | Re: Performance of SELECT directly and from application |
Previous Message | Laurenz Albe | 2020-06-24 06:14:31 | Re: Performance of SELECT directly and from application |