[GENERAL] how to get the total statistics info and query time for many queries

2007-09-24 Thread Yinan Li
Hi, With the option "-s" and "\timing", I can get the statistics info from the postmaster process and query time from the psql process. My question is that how can I get the total statistics info and query time for many queries, such as 100 search query? Any help would be re

[GENERAL] zero value in statistics collector's result

2007-09-23 Thread Yinan Li
Hi, When I use the statistics collector to see the number of IO, I always get zero in almost all of columns. I really want to know the reason for that. The result of statistics view: # select * from pg_statio_user_tables; relid | schemaname | relname | heap_blks_read | heap_blks_hit | id