pgbench log output

From: Sbob <sbob(at)quadratum-braccas(dot)com>
To: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: pgbench log output
Date: 2022-09-02 16:13:01
Message-ID: c4f422f4-d08e-04c4-af79-8f53d55f4e6b@quadratum-braccas.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message David G. Johnston 2022-09-02 16:22:56 Re: pgbench log output
Previous Message Doug Reynolds 2022-08-31 17:59:20 Re: Performance issue after creating partitions