Re: pg_stat_statements: calls under-estimation propagation

> <br />> I forgot about removal of the relevant SGML, amended here in v6. <br /><br />Thank you for this! <br
/>idid a quick test with following steps: <br />1. Applied v6 patch <br />2. make and make install on
pg_stat_statements;<br />3. Restarted Postgres with pg_stat_statements loaded with <br />pg_stat_statements.max = 4 <br
/>4.Dropped and created extension pg_stat_statements. <br /><br />Executed following: <br />select * from
pg_stat_statements_reset();<br />select * from pgbench_branches ; <br />select * from pgbench_history ; <br /> select *
frompgbench_tellers ; <br /> select * from pgbench_accounts; <br /><br />I expected 4 rows in pg_stat_statements view
foreach of 4 queries <br />above. But i saw just 2 rows. <br /><br />select * from pg_stat_statements; <br /><br
/>userid| dbid  | stat_session_id |              query              |       quer <br />y_id       | calls | total_time
| rows  | shared_blks_hit | shared_blks_read | <br />shared_blks_dirtied | shared_blks_written | local_blks_hit |
local_blks_read| l <br />ocal_blks_dirtied | local_blks_written | temp_blks_read | temp_blks_written | bl <br
/>k_read_time| blk_write_time <br />--------+-------+-----------------+---------------------------------+-----------
<br/>-----------+-------+------------+--------+-----------------+------------------+- <br
/>--------------------+---------------------+----------------+-----------------+--<br
/>------------------+--------------------+----------------+-------------------+---<br />------------+----------------
<br/>     10 | 12900 |        21595345 | select * from pgbench_accounts; | -803800319 <br />3522943111 |     1 |  
 108.176| 100000 |            1640 |                0 | <br />                  0 |                   0 |            
 0|               0 | <br />                0 |                  0 |              0 |                 0 | <br />       
 0 |              0 <br />     10 | 12900 |        21595345 | select * from pgbench_tellers ; | -149722997 <br
/>7134331757|     1 |      0.227 |     10 |               1 |                0 | <br />                  0 |          
       0 |              0 |               0 | <br />                0 |                  0 |              0 |          
     0 | <br />          0 |              0 <br />(2 rows) <br /><br /><br />Am i doing something wrong? <br /><br
/>regards<br />Sameer <br /><br /><hr align="left" width="300" /> View this message in context: <a
href="http://postgresql.1045698.n5.nabble.com/pg-stat-statements-calls-under-estimation-propagation-tp5738128p5771960.html">Re:
pg_stat_statements:calls under-estimation propagation</a><br /> Sent from the <a
href="http://postgresql.1045698.n5.nabble.com/PostgreSQL-hackers-f1928748.html">PostgreSQL- hackers mailing list
archive</a>at Nabble.com.<br />