Feedback-ID: i374947ac:Fastmail
Content-Type: multipart/alternative;
 boundary="------------PbCpPQ2u366tc7DhW0dBGgu7"
Message-ID: <c4f422f4-d08e-04c4-af79-8f53d55f4e6b@quadratum-braccas.com>
Date: Fri, 2 Sep 2022 10:13:01 -0600
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:91.0) Gecko/20100101
 Thunderbird/91.12.0
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Language: en-US
From: Sbob <sbob@quadratum-braccas.com>
Subject: pgbench log output
Archived-At: 
 <https://www.postgresql.org/message-id/c4f422f4-d08e-04c4-af79-8f53d55f4e6b%40quadratum-braccas.com>
Precedence: bulk

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

All;


I setup a test sql script with a number of inserts, I used pgbench to 
run it and I specified the -l log option. The resulting log file looks 
like this:

$ head pgbench_log.12694
0 1 170027 0 1662132851 580065
1 1 168589 0 1662132851 581837
2 1 165515 0 1662132851 581860
3 1 162207 0 1662132851 581870
4 1 159079 0 1662132851 581883
5 1 156086 0 1662132851 582010
6 1 153096 0 1662132851 582027
7 1 150002 0 1662132851 582040
8 1 146826 0 1662132851 582051
9 1 143813 0 1662132851 582065


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?


Thanks in advance

--------------PbCpPQ2u366tc7DhW0dBGgu7
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>All;</p>
    <p><br>
    </p>
    <p>I setup a test sql script with a number of inserts, I used
      pgbench to run it and I specified the -l log option. The resulting
      log file looks like this:</p>
    <p><span style="font-family:monospace"><span
          style="color:#000000;background-color:#ffffff;">$ head
          pgbench_log.12694           </span><br>
        0 1 170027 0 1662132851 580065
        <br>
        1 1 168589 0 1662132851 581837
        <br>
        2 1 165515 0 1662132851 581860
        <br>
        3 1 162207 0 1662132851 581870
        <br>
        4 1 159079 0 1662132851 581883
        <br>
        5 1 156086 0 1662132851 582010
        <br>
        6 1 153096 0 1662132851 582027
        <br>
        7 1 150002 0 1662132851 582040
        <br>
        8 1 146826 0 1662132851 582051
        <br>
        9 1 143813 0 1662132851 582065<br>
        <br>
        <br>
      </span></p>
    <p><br>
    </p>
    <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>
    <p><br>
    </p>
    <p>Thanks in advance<br>
    </p>
  </body>
</html>

--------------PbCpPQ2u366tc7DhW0dBGgu7--