Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1al0Zv-0001Bj-FN for pgsql-hackers@arkaria.postgresql.org; Tue, 29 Mar 2016 20:49:31 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1al0Zv-0004HO-21 for pgsql-hackers@arkaria.postgresql.org; Tue, 29 Mar 2016 20:49:31 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1al0Ya-0002ne-6e for pgsql-hackers@postgresql.org; Tue, 29 Mar 2016 20:48:08 +0000 Received: from boipeva.ensmp.fr ([194.214.158.136]) by magus.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1al0YX-0004DL-0r for pgsql-hackers@postgresql.org; Tue, 29 Mar 2016 20:48:07 +0000 Received: from cri.ensmp.fr (152.200.219.88.rev.sfr.net [88.219.200.152]) (authenticated bits=0) by boipeva.ensmp.fr (8.15.2/8.15.1/JMMC-22/Oct/2013) with ESMTPSA id u2TKm1kG012103 (version=TLSv1 cipher=ECDHE-RSA-AES256-SHA bits=256 verify=NO); Tue, 29 Mar 2016 22:48:02 +0200 Date: Tue, 29 Mar 2016 22:48:00 +0200 (CEST) From: Fabien COELHO X-X-Sender: fabien@sto To: Alvaro Herrera cc: PostgreSQL Developers Subject: Re: pgbench stats per script & other stuff In-Reply-To: <20160329192230.GA907630@alvherre.pgsql> Message-ID: References: <20160329192230.GA907630@alvherre.pgsql> User-Agent: Alpine 2.10 (DEB 1266 2009-07-14) MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Miltered: at boipeva.ensmp.fr with ID 56FAEA01.000 by Joe's j-chkmail (http : // j-chkmail dot ensmp dot fr)! X-j-chkmail-Auth: USER-ID fabien.coelho X-j-chkmail-Enveloppe: 56FAEA01.000 from 152.200.219.88.rev.sfr.net/152.200.219.88.rev.sfr.net/88.219.200.152/cri.ensmp.fr/ X-Pg-Spam-Score: -2.9 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-hackers Precedence: bulk Sender: pgsql-hackers-owner@postgresql.org >> Indeed. The documentation is manually edited when submitting changes so as >> to minimize diffs, but then it does not correspond anymore to any actual >> output, so it is easy to do it wrong. > > Well, you fixed the "latency stddev" line to the sample output too, but > in my trial run that line was not displayed, only the latency average. > What are the command line args that supposedly produced this output? > Maybe we should add it as a SGML comment, or even display it to the > doc's reader. Good point. The test above shows the stats if there was -P , -L & --rate, because under these conditions the necessary data was collected, so they can be computed. Thus the output in the documentation assumes that one of these was used. I nearly always use "-P 1". Note that the documentation is not really precise, "will look similar to", so there is no commitment. If you feel like removing the stddev line from the doc because it is not there with usual options, fine with me. -- Fabien. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers