Re: [GENERAL] 9.5: pg_stat_statement and pgbench execution time discrepancies

2016-07-21 Thread Tom Lane
Pavel Suderevsky 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 th

[GENERAL] 9.5: pg_stat_statement and pgbench execution time discrepancies

2016-07-21 Thread Pavel Suderevsky
Hi, During performance tests it was mentioned that pgbench common results are being different from what pg_stat_statements provides. PostgreSQL version 9.5.3, centos 7.2. First run after pg_stat_extension created and first pgbench run. *pgbench *-c 30 -T 300 -U postgres -P 10 -r -v > statement