Postgres Pro
Downloads
Home   >   mailing lists

Re: Number of updated rows in postgres - Mailing list pgsql-admin

From Shreeyansh Dba
Subject Re: Number of updated rows in postgres
Date
Msg-id CAGDYbUOaErFFz0R+1P3p_KeT=ieSdBBFGD0ZZZtp0uEpNfX6MA@mail.gmail.com
Whole thread Raw
In response to Number of updated rows in postgres  (Debraj Manna <subharaj.manna@gmail.com>)
List pgsql-admin
Tree view
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.

pgsql-admin by date:

Previous
From: Debraj Manna
Date:
Subject: Number of updated rows in postgres
Next
From: "Heinemann, Manfred (IMS)"
Date:
Subject: RE: Function search_path