Has anyone tried generating a dynamic memory trace of a backend Postgres process while it's running a query?
I want to characterize the memory access pattern of the Postgres database engine when it's running any given query. The usual way to do this would be to attach a dynamic instrumentation tool like DynamoRIO or Intel Pin to the backend process running the query (?). How could I find the exact backend process to attach to? Also, if there's any prior experience with generating such memory traces, it would be helpful to know what tools were used.