| 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: | Whole Thread | Raw Message | 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 |