Re: 9.5: pg_stat_statement and pgbench execution time discrepancies

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Pavel Suderevsky <psuderevsky(at)gmail(dot)com>
Cc: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: 9.5: pg_stat_statement and pgbench execution time discrepancies
Date: 2016-07-21 19:54:51
Message-ID: 5129.1469130891@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Pavel Suderevsky <psuderevsky(at)gmail(dot)com> writes:
> During performance tests it was mentioned that pgbench common results are
> being different from what pg_stat_statements provides.

Well, they're not measuring even approximately the same thing, so I'm
not sure why that surprises you. pg_stat_statements only measures
the executor runtime, omitting parse/plan times as well as network
transmission times. pgbench is reporting the overall time as seen
from the client side.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2016-07-21 20:06:41 Re: For storing XML version in our table.
Previous Message Andrew Geery 2016-07-21 19:49:14 gin index operator class functions in sql?