Re: Profile what the production server is doing

pgobserver might do that as well, particulary useful for functions performances. https://github.com/zalando/PGObserver On Mon, Jul 23, 2018 at 1:18 PM, Thomas Güttler < guettl...@thomas-guettler.de> wrote: > Is there a tool which does this for PostgreSQL? > > Take a "snapshot" of what the server

Re: Profile what the production server is doing

I'm biased, but I think VividCortex (my company's product) is amazing at this. On Mon, Jul 23, 2018 at 7:18 AM Thomas Güttler wrote: > Is there a tool which does this for PostgreSQL? > > Take a "snapshot" of what the server is doing about 10 times per second. > Write this to a file. > After N ho

Re: Profile what the production server is doing

Hi, On Mon, Jul 23, 2018 at 1:18 PM, Thomas Güttler wrote: > Is there a tool which does this for PostgreSQL? > > Take a "snapshot" of what the server is doing about 10 times per second. > Write this to a file. > After N hours you can aggregate the file. > What does the server do most of the time?

Profile what the production server is doing

Is there a tool which does this for PostgreSQL? Take a "snapshot" of what the server is doing about 10 times per second. Write this to a file. After N hours you can aggregate the file. What does the server do most of the time? Which tables/index gets used the most. Before optimizing a database,