(2013/10/21 20:17), KONDO Mitsumasa wrote: > (2013/10/18 22:21), Andrew Dunstan wrote: >> If we're going to extend pg_stat_statements, even more than min and max >> I'd like to see the standard deviation in execution time. > OK. I do! I am making some other patches, please wait more! I add stddev_time and fix some sources.
Psql result of my latest patch is under following. userid | 10 dbid | 16384 query | UPDATE pgbench_tellers SET tbalance = tbalance + ? WHERE tid = ?; calls | 74746 total_time | 1094.2919999998 min_time | 0.007 max_time | 15.091 stddev_time | 0.100439187720684 rows | 74746 shared_blks_hit | 302346 shared_blks_read | 6 shared_blks_dirtied | 161 shared_blks_written | 0 local_blks_hit | 0 local_blks_read | 0 local_blks_dirtied | 0 local_blks_written | 0 temp_blks_read | 0 temp_blks_written | 0 blk_read_time | 0 blk_write_time | 0 I don't think a lot that order of columns in this table. If have any idea, please send me. And thanks for a lot of comments and discussion, I am going to refer to these for not only this patch but also development of pg_statsinfo and pg_stats_reporter:-) Regards, -- Mitsumasa KONDO NTT Open Source Software Center -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
