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
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 |