Re: Log size in bytes of query result

2019-05-10 Thread Sergei Kornilov
Hi > extension that hooks into PostgreSQL We have any hooks that can be used for such purposes? Sometimes I think how to implement counters "bytes sent to client"/"bytes recv from client" in pg_stat_statements but did not found good place. Where we can accumulate such counters and how they can

Re: Log size in bytes of query result

2019-05-10 Thread Laurenz Albe
Franklin Haut wrote: > 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? As far as I know, there is no parameter to do that. You'd have to write an extension that hooks into PostgreS

Log size in bytes of query result

2019-05-10 Thread Franklin Haut
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 tha