Re: [ADMIN] Memory consumption of a sql.

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