Heap Only Update

From: Ali Mumcu <alimumcu1077(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Heap Only Update
Date: 2018-01-02 12:16:22
Message-ID: CAByegeLBV=bLHy9jV0whnU=qSmVsqTCp0yp23FPqPHCDcaeZWA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello Friends,
I am trying to find tables which Heap only update ratio less then 1 . Then
i will decrease fillfactor on these tables for more speedly update queries.

I am using this query to find hot ratio. For you , this method true or
false ?

select relname from pg_stat_user_tables where n_tup_upd>0 and
n_tup_hot_upd > 0 and n_tup_hot_upd/n_tup_upd::float < 1;

Thanks .
Best Regards.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ben Primrose 2018-01-02 15:06:49 Re: Issue on restore / recover
Previous Message Rajesh Ramachandran 2017-12-30 09:02:07 remove from list