title: Nested materialized views find out actions on commit?
body: <p>I'd like to find out what actions (i.e. selects, inserts, updates) a database does in response to say:</p>
  
  <p>insert into T (col_x, col_y, col_z) values (val_x, val_y, val_z);</p>
  
  <p>T in this case is a table with a materialized view log but has a tree of nested materialized views which are based on it which refresh on commit. (e.g. T1 is based on T, T2 is based on T1 and U1 etc). </p>
  
  <p>I want to see what the database does in response to the commit, so I can see if their are things I could do to speed up the process (i.e. add indexes or modify the materialized views).</p>
  
  <p>I'd prefer a solution that doesn't require database system user/direct machine access, but its ok if that is the only solution possible.</p>