Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bLnqQ-00024N-Io for pgsql-hackers@arkaria.postgresql.org; Sat, 09 Jul 2016 08:42:38 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1bLnqP-00005Z-ED for pgsql-hackers@arkaria.postgresql.org; Sat, 09 Jul 2016 08:42:37 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1bLnqN-00005Q-KH for pgsql-hackers@postgresql.org; Sat, 09 Jul 2016 08:42:35 +0000 Received: from jiboia.ensmp.fr ([194.214.158.137]) by makus.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bLnqJ-0006KN-MN for pgsql-hackers@postgresql.org; Sat, 09 Jul 2016 08:42:33 +0000 Received: from cri.ensmp.fr (AGrenoble-653-1-69-83.w92-129.abo.wanadoo.fr [92.129.7.83]) (authenticated bits=0) by jiboia.ensmp.fr (8.15.2/8.15.1/JMMC-22/Oct/2013) with ESMTPSA id u698gRqt010858 (version=TLSv1.2 cipher=ECDHE-RSA-AES256-GCM-SHA384 bits=256 verify=NO) for ; Sat, 9 Jul 2016 10:42:28 +0200 Date: Sat, 9 Jul 2016 10:42:27 +0200 (CEST) From: Fabien COELHO X-X-Sender: fabien@sto Reply-To: Fabien COELHO To: PostgreSQL Developers Subject: pgbench - compute & show latency consistently Message-ID: User-Agent: Alpine 2.20 (DEB 67 2015-01-07) MIME-Version: 1.0 Content-Type: multipart/mixed; BOUNDARY="8323329-1253761932-1468053748=:3412" X-Miltered: at jiboia.ensmp.fr with ID 5780B8F3.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: 5780B8F3.000 from AGrenoble-653-1-69-83.w92-129.abo.wanadoo.fr/AGrenoble-653-1-69-83.w92-129.abo.wanadoo.fr/92.129.7.83/cri.ensmp.fr/ X-Pg-Spam-Score: -3.2 (---) 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 This message is in MIME format. The first part should be readable text, while the remaining parts are likely unreadable without MIME-aware tools. --8323329-1253761932-1468053748=:3412 Content-Type: text/plain; format=flowed; charset=US-ASCII Currently the latency is not computed and displayed consistently: - the computation is wrong under -t (duration is zero...) - depending on the conditions it is shown with a ":" syntax or a "=" syntax. The attached minor patch makes the computation & display more consistent. -- Fabien. --8323329-1253761932-1468053748=:3412 Content-Type: text/x-diff; name=pgbench-latency-t-1.patch Content-Transfer-Encoding: BASE64 Content-ID: Content-Description: Content-Disposition: attachment; filename=pgbench-latency-t-1.patch ZGlmZiAtLWdpdCBhL2RvYy9zcmMvc2dtbC9yZWYvcGdiZW5jaC5zZ21sIGIv ZG9jL3NyYy9zZ21sL3JlZi9wZ2JlbmNoLnNnbWwNCmluZGV4IGYzYWZlZGIu LjI2YzAzMGUgMTAwNjQ0DQotLS0gYS9kb2Mvc3JjL3NnbWwvcmVmL3BnYmVu Y2guc2dtbA0KKysrIGIvZG9jL3NyYy9zZ21sL3JlZi9wZ2JlbmNoLnNnbWwN CkBAIC0xMjU0LDggKzEyNTQsOCBAQCBudW1iZXIgb2YgY2xpZW50czogMTAN CiBudW1iZXIgb2YgdGhyZWFkczogMQ0KIG51bWJlciBvZiB0cmFuc2FjdGlv bnMgcGVyIGNsaWVudDogMTAwMA0KIG51bWJlciBvZiB0cmFuc2FjdGlvbnMg YWN0dWFsbHkgcHJvY2Vzc2VkOiAxMDAwMC8xMDAwMA0KLWxhdGVuY3kgYXZl cmFnZSA9IDE1Ljg0NCBtcw0KLWxhdGVuY3kgc3RkZGV2ID0gMi43MTUgbXMN CitsYXRlbmN5IGF2ZXJhZ2U6IDE1Ljg0NCBtcw0KK2xhdGVuY3kgc3RkZGV2 OiAyLjcxNSBtcw0KIHRwcyA9IDYxOC43NjQ1NTUgKGluY2x1ZGluZyBjb25u ZWN0aW9ucyBlc3RhYmxpc2hpbmcpDQogdHBzID0gNjIyLjk3NzY5OCAoZXhj bHVkaW5nIGNvbm5lY3Rpb25zIGVzdGFibGlzaGluZykNCiBzY3JpcHQgc3Rh dGlzdGljczoNCmRpZmYgLS1naXQgYS9zcmMvYmluL3BnYmVuY2gvcGdiZW5j aC5jIGIvc3JjL2Jpbi9wZ2JlbmNoL3BnYmVuY2guYw0KaW5kZXggODdmYjAw Ni4uNmViOWYyOCAxMDA2NDQNCi0tLSBhL3NyYy9iaW4vcGdiZW5jaC9wZ2Jl bmNoLmMNCisrKyBiL3NyYy9iaW4vcGdiZW5jaC9wZ2JlbmNoLmMNCkBAIC0z MjM3LDggKzMyMzcsOCBAQCBwcmludFNpbXBsZVN0YXRzKGNoYXIgKnByZWZp eCwgU2ltcGxlU3RhdHMgKnNzKQ0KIAlkb3VibGUJCWxhdGVuY3kgPSBzcy0+ c3VtIC8gc3MtPmNvdW50Ow0KIAlkb3VibGUJCXN0ZGRldiA9IHNxcnQoc3Mt PnN1bTIgLyBzcy0+Y291bnQgLSBsYXRlbmN5ICogbGF0ZW5jeSk7DQogDQot CXByaW50ZigiJXMgYXZlcmFnZSA9ICUuM2YgbXNcbiIsIHByZWZpeCwgMC4w MDEgKiBsYXRlbmN5KTsNCi0JcHJpbnRmKCIlcyBzdGRkZXYgPSAlLjNmIG1z XG4iLCBwcmVmaXgsIDAuMDAxICogc3RkZGV2KTsNCisJcHJpbnRmKCIlcyBh dmVyYWdlOiAlLjNmIG1zXG4iLCBwcmVmaXgsIDAuMDAxICogbGF0ZW5jeSk7 DQorCXByaW50ZigiJXMgc3RkZGV2OiAlLjNmIG1zXG4iLCBwcmVmaXgsIDAu MDAxICogc3RkZGV2KTsNCiB9DQogDQogLyogcHJpbnQgb3V0IHJlc3VsdHMg Ki8NCkBAIC0zMjkxLDkgKzMyOTEsOSBAQCBwcmludFJlc3VsdHMoVFN0YXRl ICp0aHJlYWRzLCBTdGF0c0RhdGEgKnRvdGFsLCBpbnN0cl90aW1lIHRvdGFs X3RpbWUsDQogCWlmICh0aHJvdHRsZV9kZWxheSB8fCBwcm9ncmVzcyB8fCBs YXRlbmN5X2xpbWl0KQ0KIAkJcHJpbnRTaW1wbGVTdGF0cygibGF0ZW5jeSIs ICZ0b3RhbC0+bGF0ZW5jeSk7DQogCWVsc2UNCi0JCS8qIG9ubHkgYW4gYXZl cmFnZSBsYXRlbmN5IGNvbXB1dGVkIGZyb20gdGhlIGR1cmF0aW9uIGlzIGF2 YWlsYWJsZSAqLw0KKwkJLyogbm8gbWVhc3VyZSwgc2hvdyBhdmVyYWdlIGxh dGVuY3kgY29tcHV0ZWQgZnJvbSBydW4gdGltZSAqLw0KIAkJcHJpbnRmKCJs YXRlbmN5IGF2ZXJhZ2U6ICUuM2YgbXNcbiIsDQotCQkJICAgMTAwMC4wICog ZHVyYXRpb24gKiBuY2xpZW50cyAvIHRvdGFsLT5jbnQpOw0KKwkJCSAgIDEw MDAuMCAqIHRpbWVfaW5jbHVkZSAqIG5jbGllbnRzIC8gdG90YWwtPmNudCk7 DQogDQogCWlmICh0aHJvdHRsZV9kZWxheSkNCiAJew0K --8323329-1253761932-1468053748=:3412 Content-Type: text/plain Content-Disposition: inline Content-Transfer-Encoding: 8bit MIME-Version: 1.0 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers --8323329-1253761932-1468053748=:3412--