| 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:14:21 |
| Message-ID: | 661a7b2f-5e63-e961-6b5d-8a14dd55c34a@thomas-guettler.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Am 23.07.2018 um 13:38 schrieb Julien Rouhaud:
> Hi,
>
> On Mon, Jul 23, 2018 at 1:18 PM, Thomas Güttler
> <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?
>
> You can look at powa (https://powa.readthedocs.io/) which aims to
> provide this kind of information.
>
AFAIK powa is based on pg_stat_statements not on statistical samples.
But maye I am wrong.
Regards,
Thomas Güttler
--
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:17:16 | Re: Profile what the production server is doing |
| Previous Message | Flo Rance | 2018-07-23 15:16:57 | Re: Profile what the production server is doing |