Re: Log size in bytes of query result

2019-05-22 Thread Dmitry Dolgov
> On Wed, May 22, 2019 at 2:51 PM Franklin Haut wrote: > > By my analysis, I see that the most efficient way to perform this control > would be in the existing medium in postgresql that is the log file (pg_log) > adding a few more variables for each query executed. > On Fri, May 10, 2019 at 6:42

Re: Log size in bytes of query result

2019-05-22 Thread Franklin Haut
@Sergei and @Laurenz Thank you for reply. I think it is important to have other resource indicators consumed by the query besides the execution time as the amount of Bytes sent / received by each query, how many blocks / bytes were read / written from the cache or had to be loaded from the disk o

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