| 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: | Whole Thread | Raw Message | 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 |