Re: We find few queries running three times simultaneously with sameparameters on postgres db

Поиск
Список
Период
Сортировка
От Andreas Kretschmer
Тема Re: We find few queries running three times simultaneously with sameparameters on postgres db
Дата
Msg-id d27c8cfc-043a-01f5-5727-d19c96291a55@a-kretschmer.de
обсуждение исходный текст
Ответ на We find few queries running three times simultaneously with sameparameters on postgres db  (amandeep singh <singh_a@live.in>)
Ответы 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
Список pgsql-general
Дерево обсуждения 

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 по дате отправления:

Предыдущее
От: amandeep singh
Дата:
Сообщение: We find few queries running three times simultaneously with sameparameters on postgres db
Следующее
От: Fabio Pardi
Дата:
Сообщение: Re: Single query uses all system memory