| From: | amandeep singh <singh_a(at)live(dot)in> |
|---|---|
| To: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>, Andreas Kretschmer <andreas(at)a-kretschmer(dot)de> |
| Subject: | Re: We find few queries running three times simultaneously with same parameters on postgres db |
| Date: | 2018-06-26 17:26:14 |
| Message-ID: | MAXPR0101MB1915D511FAD2B161D13EDD0380490@MAXPR0101MB1915.INDPRD01.PROD.OUTLOOK.COM |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi Andreas
The value for $1 is same in all queries.
@Edson: number of such running queries are always 3.
Get Outlook for Android<https://aka.ms/ghei36>
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(at)lists(dot)postgresql(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Melvin Davidson | 2018-06-26 18:13:21 | Re: We find few queries running three times simultaneously with same parameters on postgres db |
| Previous Message | chiru r | 2018-06-26 16:03:26 | Re: Schema/Data conversion opensource tools from MySQL to PostgreSQL |