Обсуждение: 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

On Wed, Apr 7, 2021 at 7:13 AM Hellmuth Vargas <hivs77@gmail.com> wrote:

?? Well, the truth does not show the data that I request, what I request is that by configuring some parameter, the size of the obtained records can be obtained from the execution of a query something similar to the log_min_duration_statement parameter 

Now I think it is pertinent to write here because, according to I have carefully reviewed the documentation, this functionality does not exist

You were provided the closest answer to what you wanted from what does exist today.  As you say, your exact request is not available.  Feature requests belong on pgsql-general, not psql-hackers.

As this wasn't a question or request about active development work the -general list is the preferred location.

David J.