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