Обсуждение: Number of updated rows in postgres
Hi Debraj,
When you perform the update then n_tup_udate get increments where as insert or delete increments tup_inserted or tup_deleted in pg_stat_all_tables or pg_stat_database and vacuum use to remove dead rows.
On Thu, Mar 22, 2018 at 9:32 PM, Debraj Manna <subharaj.manna@gmail.com> wrote:
How are the counters n_tup_update from pg_stat_all_tables or tup_updated from pg_stat_database incremented? Is it only when we perform update or upsert or it can be incremented also when vaccum runs or we do insert or delete?I am asking in terms of postgres 9.5.4 running on Ubuntu 14.