Re: 9.5: pg_stat_statement and pgbench execution time discrepancies - Mailing list pgsql-general

From Tom Lane
Subject Re: 9.5: pg_stat_statement and pgbench execution time discrepancies
Date
Msg-id 5129.1469130891@sss.pgh.pa.us
Whole thread Raw
In response to 9.5: pg_stat_statement and pgbench execution time discrepancies  (Pavel Suderevsky <psuderevsky@gmail.com>)
List pgsql-general
Pavel Suderevsky <psuderevsky@gmail.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


pgsql-general by date:

Previous
From: Andrew Geery
Date:
Subject: gin index operator class functions in sql?
Next
From: "David G. Johnston"
Date:
Subject: Re: For storing XML version in our table.