Log size in bytes of query result - Mailing list pgsql-performance

From Franklin Haut
Subject Log size in bytes of query result
Date
Msg-id CAN1QLZ+xGmXY=Wh8-N7+rv733Et=Ro0QQJ5huFhi8pSii4BFuA@mail.gmail.com
Whole thread Raw
Responses Re: Log size in bytes of query result  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-performance
Hello

How can we generate in the log of executed querys (directory pg_log) the amount of bytes transferred between the server and the client of the result of a query?

Example:

a) select now (); - few bytes transferred
b) select * from large_table; - 20,000,000 bytes transferred

I understand that this parameter can reduce the performance of the database in general. I intend to use this information to measure the impact of each query on the total volume of bytes transferred by the network interface by IP address in a log analysis tool such as pgBadger

--
regards,

Franklin 

pgsql-performance by date:

Previous
From: Steven Winfield
Date:
Subject: RE: GCC 8.3.0 vs. 9.0.1
Next
From: Laurenz Albe
Date:
Subject: Re: Log size in bytes of query result