public inbox for [email protected]  

help / color / mirror / Atom feed

From: Muneeb Anwar <[email protected]>
To: [email protected]
Subject: Generating memory trace from Postgres backend process
Date: Tue, 15 Aug 2023 10:18:29 +0100
Message-ID: <CAHjT0+4ThHYjKFKXJppCO8hkc8Cn3amTiFOSsmuzFr83BA3kYw@mail.gmail.com> (raw)

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

view thread (2+ messages)

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Generating memory trace from Postgres backend process
  In-Reply-To: <CAHjT0+4ThHYjKFKXJppCO8hkc8Cn3amTiFOSsmuzFr83BA3kYw@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox