Re: pg_stat_statements: calls under-estimation propagation

>
> 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?

regards
Sameer




--
View this message in context: http://postgresql.1045698.n5.nabble.com/pg-stat-statements-calls-under-estimation-propagation-tp5738128p5771960.html
Sent from the PostgreSQL - hackers mailing list archive at Nabble.com.