pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpgbench log output
3+ messages / 2 participants
[nested] [flat]
* pgbench log output
@ 2022-09-02 16:13 Sbob <sbob@quadratum-braccas.com>
2022-09-02 16:22 ` Re: pgbench log output David G. Johnston <david.g.johnston@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Sbob @ 2022-09-02 16:13 UTC (permalink / raw)
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: pgbench log output
2022-09-02 16:13 pgbench log output Sbob <sbob@quadratum-braccas.com>
@ 2022-09-02 16:22 ` David G. Johnston <david.g.johnston@gmail.com>
2022-09-02 16:42 ` Re: pgbench log output Sbob <sbob@quadratum-braccas.com>
0 siblings, 1 reply; 3+ messages in thread
From: David G. Johnston @ 2022-09-02 16:22 UTC (permalink / raw)
To: Sbob <sbob@quadratum-braccas.com>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
On Fri, Sep 2, 2022 at 9:13 AM Sbob <sbob@quadratum-braccas.com> wrote:
> 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?
>
pgbench is a client application since it doesn't require being on the
server to run - just a connection to a database. So you'd find it under
the "Client Applications" chapter in the Documentation's Table of Contents.
Or just use the Index.
Or search.
https://www.postgresql.org/docs/current/pgbench.html
The section named "Per-Transaction Logging" sounds like it is relevant here.
David J.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: pgbench log output
2022-09-02 16:13 pgbench log output Sbob <sbob@quadratum-braccas.com>
2022-09-02 16:22 ` Re: pgbench log output David G. Johnston <david.g.johnston@gmail.com>
@ 2022-09-02 16:42 ` Sbob <sbob@quadratum-braccas.com>
0 siblings, 0 replies; 3+ messages in thread
From: Sbob @ 2022-09-02 16:42 UTC (permalink / raw)
To: David G. Johnston <david.g.johnston@gmail.com>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Perfect! Thanks
On 9/2/22 10:22, David G. Johnston wrote:
> On Fri, Sep 2, 2022 at 9:13 AM Sbob <sbob@quadratum-braccas.com> wrote:
>
> 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?
>
> pgbench is a client application since it doesn't require being on the
> server to run - just a connection to a database. So you'd find it
> under the "Client Applications" chapter in the Documentation's Table
> of Contents.
>
> Or just use the Index.
>
> Or search.
>
> https://www.postgresql.org/docs/current/pgbench.html
>
> The section named "Per-Transaction Logging" sounds like it is relevant
> here.
>
> David J.
>
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2022-09-02 16:42 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2022-09-02 16:13 pgbench log output Sbob <sbob@quadratum-braccas.com>
2022-09-02 16:22 ` David G. Johnston <david.g.johnston@gmail.com>
2022-09-02 16:42 ` Sbob <sbob@quadratum-braccas.com>
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