hey tom and others
look at these
how is the sum of all tables != database
qe18=# SELECT
pg_stat_get_db_blocks_fetched(771773788),pg_stat_get_db_blocks_hit(771773788);
pg_stat_get_db_blocks_fetched |
pg_stat_get_db_blocks_hit
wht i wanted to do is... identify the tables which are getting used simultaneously... so that i can move them to different tablespaces
for that i tried to do sampling of "pg_statio_user_tables" for top 20 tables...(in terms of usage)... so that i know how much io is being done... for
i just noted one more thing...
pg_stat_get_db_blocks_fetched/hit is getting updated
but pg_stat_get_blocks_fetched/hit are not getting
updated.
why is this happening..
Regards
Himanshu
--- Himanshu Baweja [EMAIL PROTECTED] wrote:
wht i wanted to do is... identify the tables which
--- Tom Lane [EMAIL PROTECTED] wrote:
That's pretty difficult to credit after looking at
the pgstat.c code:
every incoming blocks_fetched count is added to both
per-table and
per-database stats. I wonder if you are looking at
the wrong per-table
entries?
i am 100% sure
SELECT
--- Tom Lane [EMAIL PROTECTED] wrote:
Himanshu Baweja [EMAIL PROTECTED] writes:
SELECT pg_stat_get_db_blocks_fetched(764755937),
pg_stat_get_db_blocks_hit(764755937);
gives be constantly increasing stats and
SELECT relname,heap_blks_read from
pg_statio_user_tables order