Re: We find few queries running three times simultaneously with sameparameters on postgres db
| От | amandeep singh |
|---|---|
| Тема | Re: We find few queries running three times simultaneously with sameparameters on postgres db |
| Дата | |
| Msg-id | MAXPR0101MB1915D511FAD2B161D13EDD0380490@MAXPR0101MB1915.INDPRD01.PROD.OUTLOOK.COM обсуждение исходный текст |
| Ответ на | Re: We find few queries running three times simultaneously with same parameters on postgres db (Andreas Kretschmer <andreas@a-kretschmer.de>) |
| Ответы |
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 |
| Список | pgsql-general |
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 по дате отправления: