On Mon, Sep 23, 2013 at 1:26 PM, samthakur74 <samthaku...@gmail.com> wrote: >> >> I forgot about removal of the relevant SGML, amended here in v6. > > Thank you for this! > i did a quick test with following steps: > 1. Applied v6 patch > 2. make and make install on pg_stat_statements; > 3. Restarted Postgres with pg_stat_statements loaded with > pg_stat_statements.max = 4 > 4. Dropped and created extension pg_stat_statements. > > Executed following: > select * from pg_stat_statements_reset(); > select * from pgbench_branches ; > select * from pgbench_history ; > select * from pgbench_tellers ; > select * from pgbench_accounts; > > I expected 4 rows in pg_stat_statements view for each of 4 queries > above. But i saw just 2 rows. > > select * from pg_stat_statements; > > userid | dbid | stat_session_id | query | > quer > y_id | calls | total_time | rows | shared_blks_hit | > shared_blks_read | > shared_blks_dirtied | shared_blks_written | local_blks_hit | local_blks_read > | l > ocal_blks_dirtied | local_blks_written | temp_blks_read | temp_blks_written > | bl > k_read_time | blk_write_time > --------+-------+-----------------+---------------------------------+----------- > -----------+-------+------------+--------+-----------------+------------------+- > --------------------+---------------------+----------------+-----------------+-- > ------------------+--------------------+----------------+-------------------+--- > ------------+---------------- > 10 | 12900 | 21595345 | select * from pgbench_accounts; | > -803800319 > 3522943111 | 1 | 108.176 | 100000 | 1640 | > 0 | > 0 | 0 | 0 | 0 > | > 0 | 0 | 0 | 0 > | > 0 | 0 > 10 | 12900 | 21595345 | select * from pgbench_tellers ; | > -149722997 > 7134331757 | 1 | 0.227 | 10 | 1 | > 0 | > 0 | 0 | 0 | 0 > | > 0 | 0 | 0 | 0 > | > 0 | 0 > (2 rows) > > > Am i doing something wrong? > Yes i was. Just saw a warning when pg_stat_statements is loaded that valid values for pg_stat_statements.max is between 100 and 2147483647. Not sure why though. regards Sameer
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers