Date: Fri, 28 Apr 2017 09:03:42 +0200
From: =?utf-8?B?U3TDqXBoYW5l?= KANSCHINE <stephane@hexack.fr>
To: Shrinivas Devarkonda <shrinivasdevarkonda@gmail.com>,
	pgsql-admin@postgresql.org
Subject: Re: Memory consumption of a sql.
Message-ID: <20170428070342.ea2rix6l3od73h6t@office.hexack.fr>
References: 
 <CAJavUp3khqtVOPwBdgjsu+usbUcqf+x4iJHxYbkC4Q9KUEOMKQ@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: 
 <CAJavUp3khqtVOPwBdgjsu+usbUcqf+x4iJHxYbkC4Q9KUEOMKQ@mail.gmail.com>
Organization: HexACK
User-Agent: NeoMutt/20161126 (1.7.1)
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

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@hexack.fr
  +33 6 64 31 72 52


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin