Number of internal operations for a single DML/DDL

Поиск
Список
Период
Сортировка
От Nikhil Shetty
Тема Number of internal operations for a single DML/DDL
Дата
Msg-id CAFpL5Vzr8K3dUEd_wOTvJEE3xNg9ELTYxX56hbHtqrbYhRx=_g@mail.gmail.com
обсуждение исходный текст
Ответы Re: Number of internal operations for a single DML/DDL  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список 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

В списке pgsql-admin по дате отправления:

Предыдущее
От: John Scalia
Дата:
Сообщение: Re: Looking find the each row size of table
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: Number of internal operations for a single DML/DDL