Re: Profile what the production server is doing

From: Julien Rouhaud <rjuju123(at)gmail(dot)com>
To: Thomas Güttler <guettliml(at)thomas-guettler(dot)de>
Cc: postgres performance list <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Profile what the production server is doing
Date: 2018-07-23 11:38:04
Message-ID: CAOBaU_YdJN8c0cwxQG6uXvFb9-Y5pZrANfD6rL=ArKxuvgdv=w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Baron Schwartz 2018-07-23 14:01:31 Re: Profile what the production server is doing
Previous Message Thomas Güttler 2018-07-23 11:18:02 Profile what the production server is doing