Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps
 (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1oU9kb-0006Li-Bw
	for pgsql-admin@arkaria.postgresql.org; Fri, 02 Sep 2022 16:42:37 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1oU9kZ-0006dz-AM
	for pgsql-admin@arkaria.postgresql.org; Fri, 02 Sep 2022 16:42:35 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <sbob@quadratum-braccas.com>)
	id 1oU9kY-0006dq-Pz
	for pgsql-admin@lists.postgresql.org; Fri, 02 Sep 2022 16:42:34 +0000
Received: from wout2-smtp.messagingengine.com ([64.147.123.25])
	by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <sbob@quadratum-braccas.com>)
	id 1oU9kW-0004Y8-2m
	for pgsql-admin@lists.postgresql.org; Fri, 02 Sep 2022 16:42:33 +0000
Received: from compute5.internal (compute5.nyi.internal [10.202.2.45])
	by mailout.west.internal (Postfix) with ESMTP id 765063200413;
	Fri,  2 Sep 2022 12:42:30 -0400 (EDT)
Received: from mailfrontend2 ([10.202.2.163])
  by compute5.internal (MEProxy); Fri, 02 Sep 2022 12:42:30 -0400
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=
	quadratum-braccas.com; h=cc:cc:content-type:date:date:from:from
	:in-reply-to:in-reply-to:message-id:mime-version:references
	:reply-to:sender:subject:subject:to:to; s=fm3; t=1662136949; x=
	1662223349; bh=eMuIhbX8O6zVG6Ig1/uUC+jvwlYG0WKHVPUKdXW1Y3Q=; b=B
	1+q+u289zspuO84xAUsK6FXLyThEVPWXEOgopTmEo3SKEOwKmdnwjvt6RVafULEz
	GaTMjbiSDpe910qJo8bLv1AOCq03042dd9gMQb8M2IxwQQ3t7hES3PQVBOGninUS
	nlQ9VP6BV33K0ufwulzMzK5RrLrXyS3+o0qvOPaA/v8KzBmEtE2NZK2V39vAr26B
	LtXSzkjyX8OX9girJ3vDdzlLxMRXOQ2QGvexeUAhNBgujfOa6sL4ornmtNYWPMgY
	qlBlP/S/CB6nSFQ2H1F4YaHD3/oBanWGiW+fSRWyZi8p3X9fCswGM6DToAecEc1Z
	qK7/BvKKQUhDDCHvIgFsg==
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=
	messagingengine.com; h=cc:cc:content-type:date:date:feedback-id
	:feedback-id:from:from:in-reply-to:in-reply-to:message-id
	:mime-version:references:reply-to:sender:subject:subject:to:to
	:x-me-proxy:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=
	fm1; t=1662136949; x=1662223349; bh=eMuIhbX8O6zVG6Ig1/uUC+jvwlYG
	0WKHVPUKdXW1Y3Q=; b=S5/jK9xqZZWru3o+YYXBZ50fuuOQYGjmJorGDLHZOJfu
	xIqlgpVO+kvh8pcnYj/tvjdyyp19vWoFEm//YarPety3gQlGQZdIea9mnDBfnB9P
	7hoDdmQnXaEl8dTmpGIe5m0uVuk6ZJ9uhBcy/kb+CXRqwI4KrNeVMHItTLyW1Yjz
	twtbQc45SlT7YAlyhtVZUlHDqL5M+5e0pKNJ5ulEvZ6b1zBsPq3l1TLxjsRWIhrt
	+ENMOWfpJ419doR/5CzFP42lzLI6sPi5vw3TzPMKHh/wjvwdqAjy4gnym68ZN+9D
	nQDAbKdsL7oKqobYVD6xVYQxJoFcz2WNk4aoQJ2ePw==
X-ME-Sender: <xms:dTISYx5AgxMwM8oQjBLp4BYJ_jIrUa7fAbBNu7dTlLj_C-CfurGiNg>
    <xme:dTISY-5cG6IpjKiN9DLPA_idqqM2g_jx5umnSbXrnTi-JaeOdztZ4FG-1Rf6Ry4Fa
    dqvog9F8YpnxaitB5s>
X-ME-Received: 
 <xmr:dTISY4e97KEKp_IEODvw1cZ4d8JpA-hlxz70v3lRv1wbjDZUnfgNA7rlkw7pFlrxXslhzpJRyTzIb1XVF62ayImz6dXlQABtBw>
X-ME-Proxy-Cause: 
 gggruggvucftvghtrhhoucdtuddrgedvfedrvdeltddguddtiecutefuodetggdotefrod
    ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfgh
    necuuegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmd
    enucfjughrpegtkfffgggfuffvvehfhfgjsegrtderredtfeejnecuhfhrohhmpefusgho
    sgcuoehssghosgesqhhurggurhgrthhumhdqsghrrggttggrshdrtghomheqnecuggftrf
    grthhtvghrnheptdfftdeffedthedtvdekheetkeetjefgkeetheevgefhleefjeefteef
    teduteelnecuffhomhgrihhnpehpohhsthhgrhgvshhqlhdrohhrghenucevlhhushhtvg
    hrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpehssghosgesqhhurggurhgr
    thhumhdqsghrrggttggrshdrtghomh
X-ME-Proxy: <xmx:dTISY6Joa7O_THsVWBetmg54Ba90yXLGqEsOHiSmyonYs5_UmqRIOw>
    <xmx:dTISY1LdWBIwwIw4SLNIsTi7ztesNmsMVNrveVzmjEiPc1aNt2GHeQ>
    <xmx:dTISYzyELEs9PjbqU2SitFCR5g9mDYRRk4NOtoZHoQUPIaNn5_9ZEQ>
    <xmx:dTISYzgmlq_bM2T-FYMXgDzzwhkqUPRfSchh4GzZPu8yDtR9dsB_9A>
Feedback-ID: i374947ac:Fastmail
Received: by mail.messagingengine.com (Postfix) with ESMTPA; Fri,
 2 Sep 2022 12:42:29 -0400 (EDT)
Content-Type: multipart/alternative;
 boundary="------------HpYZWZNkG8FSSnn20xFDf0ng"
Message-ID: <29c00021-e1ac-422d-e889-a8c5f386aafc@quadratum-braccas.com>
Date: Fri, 2 Sep 2022 10:42:28 -0600
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:91.0) Gecko/20100101
 Thunderbird/91.12.0
Subject: Re: pgbench log output
Content-Language: en-US
To: "David G. Johnston" <david.g.johnston@gmail.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
References: <c4f422f4-d08e-04c4-af79-8f53d55f4e6b@quadratum-braccas.com>
 <CAKFQuwYzG1vEjL=hnt4EZoUNSQtUO6muOd-dFn2hXjFD1jO4vg@mail.gmail.com>
From: Sbob <sbob@quadratum-braccas.com>
In-Reply-To: 
 <CAKFQuwYzG1vEjL=hnt4EZoUNSQtUO6muOd-dFn2hXjFD1jO4vg@mail.gmail.com>
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Archived-At: 
 <https://www.postgresql.org/message-id/29c00021-e1ac-422d-e889-a8c5f386aafc%40quadratum-braccas.com>
Precedence: bulk

This is a multi-part message in MIME format.
--------------HpYZWZNkG8FSSnn20xFDf0ng
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit

Perfect! Thanks


On 9/2/22 10:22, David G. Johnston wrote:
> On Fri, Sep 2, 2022 at 9:13 AM Sbob <sbob@quadratum-braccas.com> wrote:
>
>     However I do not understand what data is represented / how to
>     decipher the log file, can someone enlighten me or point me to
>     docs that lay this out?
>
> pgbench is a client application since it doesn't require being on the 
> server to run - just a connection to a database.  So you'd find it 
> under the "Client Applications" chapter in the Documentation's Table 
> of Contents.
>
> Or just use the Index.
>
> Or search.
>
> https://www.postgresql.org/docs/current/pgbench.html
>
> The section named "Per-Transaction Logging" sounds like it is relevant 
> here.
>
> David J.
>
--------------HpYZWZNkG8FSSnn20xFDf0ng
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit

<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <p>Perfect! Thanks</p>
    <p><br>
    </p>
    <div class="moz-cite-prefix">On 9/2/22 10:22, David G. Johnston
      wrote:<br>
    </div>
    <blockquote type="cite"
cite="mid:CAKFQuwYzG1vEjL=hnt4EZoUNSQtUO6muOd-dFn2hXjFD1jO4vg@mail.gmail.com">
      <meta http-equiv="content-type" content="text/html; charset=UTF-8">
      <div dir="ltr">
        <div dir="ltr">
          <div class="gmail_default"
            style="font-family:arial,helvetica,sans-serif"><span
              style="font-family:Arial,Helvetica,sans-serif">On Fri, Sep
              2, 2022 at 9:13 AM Sbob &lt;<a
                href="mailto:sbob@quadratum-braccas.com"
                moz-do-not-send="true" class="moz-txt-link-freetext">sbob@quadratum-braccas.com</a>&gt;
              wrote:</span></div>
        </div>
        <div class="gmail_quote">
          <blockquote class="gmail_quote" style="margin:0px 0px 0px
            0.8ex;border-left:1px solid
            rgb(204,204,204);padding-left:1ex">
            <div>
              <p>However I do not understand what data is represented /
                how to decipher the log file, can someone enlighten me
                or point me to docs that lay this out?</p>
            </div>
          </blockquote>
          <div>
            <div class="gmail_default"
              style="font-family:arial,helvetica,sans-serif">pgbench is
              a client application since it doesn't require being on the
              server to run - just a connection to a database.  So you'd
              find it under the "Client Applications" chapter in the
              Documentation's Table of Contents.</div>
            <br>
          </div>
          <div>
            <div class="gmail_default"
              style="font-family:arial,helvetica,sans-serif">Or just use
              the Index.</div>
            <div class="gmail_default"
              style="font-family:arial,helvetica,sans-serif"><br>
            </div>
            <div class="gmail_default"
              style="font-family:arial,helvetica,sans-serif">Or search.</div>
            <div class="gmail_default"
              style="font-family:arial,helvetica,sans-serif"><br>
            </div>
          </div>
          <div><a
              href="https://www.postgresql.org/docs/current/pgbench.html"
              moz-do-not-send="true" class="moz-txt-link-freetext">https://www.postgresql.org/docs/current/pgbench.html</a></div>
          <div><br>
          </div>
          <div>
            <div class="gmail_default"
              style="font-family:arial,helvetica,sans-serif">The section
              named "Per-Transaction Logging" sounds like it is relevant
              here.</div>
            <div class="gmail_default"
              style="font-family:arial,helvetica,sans-serif"><br>
            </div>
            <div class="gmail_default"
              style="font-family:arial,helvetica,sans-serif">David J.</div>
            <div class="gmail_default"
              style="font-family:arial,helvetica,sans-serif"><br>
            </div>
          </div>
        </div>
      </div>
    </blockquote>
  </body>
</html>

--------------HpYZWZNkG8FSSnn20xFDf0ng--