We got this requirement from one of our clients as they were able to derive a count of internal operations for their oracle databases and they wanted to know how it can be done for Postgres. It is basically to check the I/O that happens at the backend for each DML/DDL. We did know that it is very tough to get the exact or at least an estimated count and so requested help from the community.
I wanted to know how many internal operations postgres performs for a single DML or DDL statement.
Why?
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
Frankly, that number doesn’t exist; the nature of the input and the state of the system directly impacts what any individual command does internally and so one cannot derive a count, or even an understanding of what happens, without knowledge of those two things. Which brings us again to “why?”.