Hi,
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.
best regards,
Muneeb Khan