Postgres Pro
Downloads
Home   >   mailing lists

Re: [ADMIN] Memory consumption of a sql. - Mailing list pgsql-admin

From Stéphane KANSCHINE
Subject Re: [ADMIN] Memory consumption of a sql.
Date
Msg-id 20170428070342.ea2rix6l3od73h6t@office.hexack.fr
Whole thread Raw
In response to [ADMIN] Memory consumption of a sql.  (Shrinivas Devarkonda <shrinivasdevarkonda@gmail.com>)
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: Shrinivas Devarkonda
Date:
Subject: [ADMIN] Memory consumption of a sql.
Next
From: Steven Chang
Date:
Subject: Re: [ADMIN] Memory consumption of a sql.