Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hP85u-0008Q3-9Y for pgsql-performance@arkaria.postgresql.org; Fri, 10 May 2019 16:09:58 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hP85s-0001rC-Q5 for pgsql-performance@arkaria.postgresql.org; Fri, 10 May 2019 16:09:56 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hP85s-0001r4-E1 for pgsql-performance@lists.postgresql.org; Fri, 10 May 2019 16:09:56 +0000 Received: from mx1.mailbox.org ([2001:67c:2050:104:0:1:25:1]) by makus.postgresql.org with esmtps (TLS1.2:RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hP85o-00057j-N5 for pgsql-performance@lists.postgresql.org; Fri, 10 May 2019 16:09:55 +0000 Received: from smtp2.mailbox.org (smtp2.mailbox.org [IPv6:2001:67c:2050:105:465:1:2:0]) (using TLSv1.2 with cipher ECDHE-RSA-CHACHA20-POLY1305 (256/256 bits)) (No client certificate requested) by mx1.mailbox.org (Postfix) with ESMTPS id 58D0B4CA33; Fri, 10 May 2019 18:09:46 +0200 (CEST) X-Virus-Scanned: amavisd-new at heinlein-support.de Received: from smtp2.mailbox.org ([80.241.60.241]) by hefe.heinlein-support.de (hefe.heinlein-support.de [91.198.250.172]) (amavisd-new, port 10030) with ESMTP id zAZ3XaOkD3PE; Fri, 10 May 2019 18:09:42 +0200 (CEST) Message-ID: <94cfe8317fdb054cc90fec529104666260c190af.camel@cybertec.at> Subject: Re: Log size in bytes of query result From: Laurenz Albe To: Franklin Haut , pgsql-performance@lists.postgresql.org Date: Fri, 10 May 2019 18:09:41 +0200 In-Reply-To: References: Organization: Cybertec Content-Type: text/plain; charset="UTF-8" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk 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 PostgreSQL, but I have no idea how hard that would be. Yours, Laurenz Albe