Re: Memory consumption of a sql.

[Steven Chang <stevenchang1213@xxxxxxxxx>]

Hello,

     explain (buffers, analyze)  your sql statements .......

     data size ??? 

     You can put your data in a table, and check its size.

     I don't what you want to check ??

     buffer usages, intermediate temp object size or sorting size or some other thing ??

     You can also try pg_stat_statements contrib module for your intending analysis.

BR ,

Steven

2017-04-28 14:46 GMT+08:00 Shrinivas Devarkonda <shrinivasdevarkonda@xxxxxxxxx>:

Hi All,

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

Please guide.

--

Regards,

Shrinivas Devarkonda.