From: Sbob <sbob@quadratum-braccas.com>
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: pgbench log output
Date: Fri, 2 Sep 2022 10:13:01 -0600
Message-ID: <c4f422f4-d08e-04c4-af79-8f53d55f4e6b@quadratum-braccas.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: sbob@quadratum-braccas.com, pgsql-admin@lists.postgresql.org
Subject: Re: pgbench log output
In-Reply-To: <c4f422f4-d08e-04c4-af79-8f53d55f4e6b@quadratum-braccas.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox