Re: PostgreSQL log query's result size

On Tue, Apr 06, 2021 at 02:03:03PM -0500, Hellmuth Vargas wrote:
> Could you tell me if it is possible that as well as the configuration that
> the log presents the duration of the delayed queries, it can also present
> the size of the result data? especially those who want to return a lot of
> information

I think you can get what you want by with auto_explain.
https://www.postgresql.org/docs/current/auto-explain.html

You can set:
auto_explain.log_analyze

And then the "width" and "rows" are logged:
Result (cost=0.00..0.01 rows=1 width=4) (actual time=0.002..0.004 rows=1 loops=1)

PS, you should first ask on the pgsql-general list, rather than this
development list.

--
Justin