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
---+--
--- 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 o
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 by heap_blks_read DESC
> LIMIT 15;"
> is still sh
--- 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
Himanshu Baweja <[EMAIL PROTECTED]> writes:
> 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.
That's pretty difficult to credit after looking at the pgstat.c code:
every incoming blocks_fetche
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
> are
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 differen
