Number of internal operations for a single DML/DDL

From: Nikhil Shetty <nikhil(dot)dba04(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Number of internal operations for a single DML/DDL
Date: 2021-03-18 05:45:44
Message-ID: CAFpL5Vzr8K3dUEd_wOTvJEE3xNg9ELTYxX56hbHtqrbYhRx=_g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi Team,

I wanted to know how many internal operations postgres performs for a
single DML or DDL statement.

For ex: if I run an insert like insert into emp values(1,'Name'); then one
operation postgres does, is it internally updates the pg_stat_*_tables to
increase the count of n_tup_ins and n_live_tup for the emp table.
Apart from these what all operations does postgres do internally, I wanted
an average estimated count as I know it would be difficult to get the
details for each of the DML/DDL statements

Thanks and Regards,
Nikhil

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message David G. Johnston 2021-03-18 06:09:22 Re: Number of internal operations for a single DML/DDL
Previous Message Laurenz Albe 2021-03-17 12:37:18 Re: Encryption key storage