Postgres Pro
Downloads
Home   >   mailing lists

Re: We find few queries running three times simultaneously with sameparameters on postgres db - Mailing list pgsql-general

From amandeep singh
Subject Re: We find few queries running three times simultaneously with sameparameters on postgres db
Date
Msg-id MAXPR0101MB1915D511FAD2B161D13EDD0380490@MAXPR0101MB1915.INDPRD01.PROD.OUTLOOK.COM
Whole thread Raw
In response to Re: We find few queries running three times simultaneously with same parameters on postgres db  (Andreas Kretschmer <andreas@a-kretschmer.de>)
Responses Re: We find few queries running three times simultaneously with sameparameters on postgres db
Re: We find few queries running three times simultaneously with sameparameters on postgres db
List pgsql-general
Tree view
Hi Andreas

The value for $1 is same in all queries.

@Edson: number of such running queries are always  3.

From: Andreas Kretschmer
Sent: Tuesday, 26 June, 6:04 PM
Subject: Re: We find few queries running three times simultaneously with same parameters on postgres db
To: pgsql-general@lists.postgresql.org


On 26 June 2018 12:32:44 CEST, Andreas Kretschmer wrote: > > >Am 26.06.2018 um 12:19 schrieb amandeep singh: >> 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. > >they are independend each other. You can run those queries with EXPLAIN > >ANALYSE to see the execution plan. > >Regards, Andreas seems like i misunderstud your query. are you sure, that the parameter $1 is equal across all different connections? Andreas -- 2ndQuadrant - The PostgreSQL Support Company

pgsql-general by date:

Previous
From: chiru r
Date:
Subject: Re: Schema/Data conversion opensource tools from MySQL to PostgreSQL
Next
From: Melvin Davidson
Date:
Subject: Re: We find few queries running three times simultaneously with sameparameters on postgres db