Re: Running concurrent txns and measuring the timings in Postgres

On 7/24/19 1:52 PM, Souvik Bhattacherjee wrote:
> >Well it depends on the part you have not filled in, what client(s) you
> > are using and how the transactions are being generated?
>
> Using a psql client and txns are generated manually at this point. Each
> txn is
> stored separately in a .sql file and are fired from different psql
> sessions, if that
> helps.
>

A quick demo:

psql -d production -U postgres -c "\timing" -c "select line_id, category
from avail_headers order by line_id;"

Timing is on.
Time: 0.710 ms

> On Wed, Jul 24, 2019 at 4:44 PM Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com
> <mailto:adrian(dot)klaver(at)aklaver(dot)com>> wrote:
>
> On 7/24/19 1:42 PM, Souvik Bhattacherjee wrote:
> >  > The duplicate elimination is being handled by ON CONFLICT or
> some custom
> >  > process in the code generating the transactions?
> >
> > Yes, we used ON CONFLICT for that. Thanks btw.
> >
> >  > If the transactions are being created from a single app/script
> could you
> >  > not just use 'timing' to mark the beginning of the
> transactions and the
> >  > end and record that somewhere(db table and/or file)?
> >
> > So did you mean to say that I need to get the timestamps of the
> > beginning/end
> > of the txn since \timing only produces elapsed time?  Surely that
> would
> > solve the
> > problem but I'm not sure how to get that done in Postgres.
> >
> > I wanted to check to see if there are simpler ways to get this
> done in
> > Postgres
> > before trying out something similar to Rob's suggestion or yours.
> >
>
> Well it depends on the part you have not filled in, what client(s) you
> are using and how the transactions are being generated?
>
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com