Number of updated rows in postgres

From: Debraj Manna <subharaj(dot)manna(at)gmail(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Number of updated rows in postgres
Date: 2018-03-22 16:02:56
Message-ID: CAF6DVKONvy8kuE4JC951YjeH0G_L2WtUDfYO+FsLyBLj2MoGGw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.*

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Shreeyansh Dba 2018-03-22 17:13:23 Re: Number of updated rows in postgres
Previous Message Moradhassel, Kavian 2018-03-22 15:03:50 RE: GRANT CREATE or ALTER SCHEMA?