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
|