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

Reply via email to