Re: How Do You Associate a Query With its Invoking Procedure?

pg_stat_statement is a global tracker that throws away execution context, in this case the process id, needed to track the level of detail you desire.  I think the best you can do is log all statements and durations to the log file and parse that.

For the "what queries are invoked by it" you can just read the source code...

As there is no canned solution to provide the answer you seek the final solution you come up with will be influenced by your access patterns, specific needs, and (in)ability to write C code (though maybe there is an extension out there you could leverage...).

David J.