We find few queries running three times simultaneously with sameparameters on postgres db

Поиск
Список
Период
Сортировка
Искать
От
amandeep singh
Тема
We find few queries running three times simultaneously with sameparameters on postgres db
Дата
Msg-id
MAXPR0101MB191541848D3CD85B118AC07080490@MAXPR0101MB1915.INDPRD01.PROD.OUTLOOK.COM
Список
Дерево обсуждения
We find few queries running three times simultaneously with sameparameters on postgres db amandeep singh <singh_a@live.in>
Re: We find few queries running three times simultaneously with sameparameters on postgres db Andreas Kretschmer <andreas@a-kretschmer.de>
Re: We find few queries running three times simultaneously with sameparameters on postgres db Saurabh Agrawal <mail@saurabhagrawal.net>
Re: We find few queries running three times simultaneously with sameparameters on postgres db Edson Carlos Ericksson Richter <richter@simkorp.com.br>
Re: We find few queries running three times simultaneously with same parameters on postgres db Andreas Kretschmer <andreas@a-kretschmer.de>
Re: We find few queries running three times simultaneously with sameparameters on postgres db amandeep singh <singh_a@live.in>
Re: We find few queries running three times simultaneously with sameparameters on postgres db Edson Carlos Ericksson Richter <richter@simkorp.com.br>
Re: We find few queries running three times simultaneously with sameparameters on postgres db amandeep singh <singh_a@live.in>
Re: We find few queries running three times simultaneously with sameparameters on postgres db amandeep singh <singh_a@live.in>
Re: We find few queries running three times simultaneously with sameparameters on postgres db Melvin Davidson <melvin6925@gmail.com>

Hi Team


We have been observing our postgres database from past few days,We found few queries running three times simultaneously with same parameters.I would like to back track how a query is running multiple times.

2018-06-26 15:22:13.620045+05:30 | 00:00:00.198777 | active | 22234 | select * from xyz where x_id=$1 

2018-06-26 15:22:13.618832+05:30 | 00:00:00.19999 | active | 22233 | select * from xyz where x_id=$1

2018-06-26 15:22:13.612721+05:30 | 00:00:00.206101 | active | 23927 | select * from xyz where x_id=$1

Our application is developed in java struts 1.3 and hibernate as ORM and tomcat 8.5 for hosting.

PostgreSQL version: 10.3

Kindly suggest.

Thanks and Regards:
Amandeep Singh
В списке pgsql-general по дате отправления
От: Magnus Hagander
Дата:
От: Andreas Kretschmer
Дата:
FAQ