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.