Log size in bytes of query result

Franklin Haut <[email protected]>
Newsgroups gmane.comp.db.postgresql.performance
Message-ID <CAN1QLZ+xGmXY=Wh8-N7+rv733Et=Ro0QQJ5huFhi8pSii4BFuA@mail.gmail.com>
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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.