Re: [GENERAL] Memory consumption for Query

Список
Период
Сортировка
От Albe Laurenz
Тема Re: [GENERAL] Memory consumption for Query
Дата
Msg-id A737B7A37273E048B164557ADEF4A58B53A2AEE5@ntex2010i.host.magwien.gv.at
обсуждение исходный текст
Ответ на [GENERAL] Memory consumption for Query  (dhaval jaiswal)
Ответы Re: [GENERAL] Memory consumption for Query  (dhaval jaiswal)
Список pgsql-general
dhaval jaiswal wrote:
> How to check how much memory query is consuming.
> 
> Is there tool can check of query consuming memory for the execution or output.
> 
> Let's say for following query how to calculate memory consumption.
> 
> select * from test where id=1;

That query will not consume memory worth mention unless
"test" is a non-trivial view.

You can run "EXPLAIN (ANALYZE) SELECT ..." to see how much memory is used
for memory intense operations like sort, hash or materialize.

Other operations don't really consume much memory.

Yours,
Laurenz Albe

В списке pgsql-general по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: [GENERAL] [pgadmin-hackers] file permission on ssl key
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: [GENERAL] Failed dependencies for Pgadmin4 Web in Centos 7