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
обсуждение исходный текст
Ответы Re: We find few queries running three times simultaneously with sameparameters on postgres db
Список pgsql-general

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
Дата:
Сообщение: Re: Single query uses all system memory
Следующее
От: Andreas Kretschmer
Дата:
Сообщение: Re: We find few queries running three times simultaneously with sameparameters on postgres db