From: | Thomas Güttler <guettliml(at)thomas-guettler(dot)de> |
---|---|
To: | pgsql-performance(at)lists(dot)postgresql(dot)org |
Subject: | Re: Profile what the production server is doing |
Date: | 2018-07-25 09:17:16 |
Message-ID: | 132f0eab-7051-c181-22b3-88c4f940105b@thomas-guettler.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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, Jul 23, 2018 at 7:18 AM Thomas Güttler <guettliml(at)thomas-guettler(dot)de <mailto:guettliml(at)thomas-guettler(dot)de>> 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?
> Which tables/index gets used the most.
>
> Before optimizing a database, I would like to know what is going
> on in the production system.
>
> I know that there are internal tables like pg_stat_statements.
> But I guess doing a snapshot every N millseconds will present a
> better picture of what is going in in real life.
>
> Is there already a tool which goes this way?
>
> Or is there a better way?
>
> Regards,
> Thomas Güttler
>
> --
> Thomas Guettler http://www.thomas-guettler.de/
> I am looking for feedback: https://github.com/guettli/programming-guidelines
>
--
Thomas Guettler http://www.thomas-guettler.de/
I am looking for feedback: https://github.com/guettli/programming-guidelines
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Güttler | 2018-07-25 09:39:14 | Re: Profile what the production server is doing |
Previous Message | Thomas Güttler | 2018-07-25 09:14:21 | Re: Profile what the production server is doing |