On Sat, Sep 26, 2015 at 11:06 PM, Guillaume Lelarge <guilla...@lelarge.info>
wrote:

> Le 27 sept. 2015 8:02 AM, "Guillaume Lelarge" <guilla...@lelarge.info> a
> écrit :
> >
> > Le 26 sept. 2015 6:26 PM, "Adam Scott" <adam.c.sc...@gmail.com> a
> écrit :
> > >
> > > How do we measure queries per second (QPS), not transactions per
> second, in PostgreSQL without turning on full logging which has a
> performance penalty and can soak up lots of disk space?
> > >
> >
> > The only way I can think of is to write an extension that will execute
> some code at the end of the execution of a query.
> >
> > Note that this might get tricky. Do you want to count any query? Such as
> those in explicit transactions and those in plpgsql functions? People might
> not see this your way, which may explain why I don't know of any such
> extension.
> >
>
> Thinking about this, such an extension already exists. It's
> pg_stat_statements. You need to sum the count column of the
> pg_stat_statements from time to time. The difference between two sums will
> be your number of queries.
>

That is what I was thinking, but the pg_stat_statement does discard
 statements sometimes, discarding the counts with them.  You would have set
pg_stat_statements.max to a higher value than you ever expect to get
reached.

Cheers,

Jeff

Reply via email to