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 Andreas Kretschmer
Subject Re: We find few queries running three times simultaneously with sameparameters on postgres db
Date
Msg-id d27c8cfc-043a-01f5-5727-d19c96291a55@a-kretschmer.de
Whole thread Raw
In response to We find few queries running three times simultaneously with sameparameters on postgres db  (amandeep singh <singh_a@live.in>)
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 same parameters on postgres db
List pgsql-general
Tree view 

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

-- 
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com

pgsql-general by date:

Previous
From: amandeep singh
Date:
Subject: We find few queries running three times simultaneously with sameparameters on postgres db
Next
From: Fabio Pardi
Date:
Subject: Re: Single query uses all system memory