Re: Profile what the production server is doing

2018-07-25 Thread Julien Rouhaud
On Wed, Jul 25, 2018 at 11:14 AM, Thomas Güttler wrote: > > AFAIK powa is based on pg_stat_statements not on statistical samples. > But maye I am wrong. Indeed, it's based on pg_stat_statements, but other extensions are supported too. Since pg_stat_statements already provides cumulated counters,

Re: Profile what the production server is doing

2018-07-25 Thread Flo Rance
As you already open an issue on their website regarding this point, you should maybe wait for them to answer. As far as I know, it's still used by some companies in production. Flo On Wed, Jul 25, 2018 at 11:39 AM, Thomas Güttler < guettl...@thomas-guettler.de> wrote: > > > Am 23.07.2018 um 17:

Re: Profile what the production server is doing

2018-07-25 Thread Thomas Güttler
Am 23.07.2018 um 17:16 schrieb Flo Rance: pgobserver might do that as well, particulary useful for functions performances. https://github.com/zalando/PGObserver Thank you for pointing me to this. After googling for "PGObserver powa" I found nice collection of current tools: https://

Re: Profile what the production server is doing

2018-07-25 Thread Thomas Güttler
Am 23.07.2018 um 16:01 schrieb Baron Schwartz: I'm biased, but I think VividCortex (my company's product) is amazing at this. Looks goog, but "Contact us for pricing options" from https://www.vividcortex.com/product/pricing Why do you hide your prices? Regards, Thomas Güttler On Mon,

Re: Profile what the production server is doing

2018-07-25 Thread Thomas Güttler
Am 23.07.2018 um 13:38 schrieb Julien Rouhaud: 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.