Re: Memory consumption of a sql.

From: Stéphane KANSCHINE <stephane(at)hexack(dot)fr>
To: Shrinivas Devarkonda <shrinivasdevarkonda(at)gmail(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Memory consumption of a sql.
Date: 2017-04-28 07:03:42
Message-ID: 20170428070342.ea2rix6l3od73h6t@office.hexack.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Le ven. 28 avril, vers 12:16, Shrinivas Devarkonda exprimait :

> Hi All,

Hey !

> Is there any way to print / get the memory consumption taken by sql in
> postgresql 9.x ? Can we also get/print the data size returned by Sql ?
>
> There is no parameters in log_line_prefix in postgresql.conf

Did you already have a look et pg_stat_statements ?

https://www.postgresql.org/docs/9.6/static/pgstatstatements.html

Regards,
--
Stéphane KANSCHINE - http://www.hexack.fr./ - http://www.nuajik.com./
@ stephane(at)hexack(dot)fr
 +33 6 64 31 72 52

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Steven Chang 2017-04-28 07:15:08 Re: Memory consumption of a sql.
Previous Message Shrinivas Devarkonda 2017-04-28 06:46:56 Memory consumption of a sql.