Re: pg_stat_statements -- Historical Query

From: Julien Rouhaud <rjuju123(at)gmail(dot)com>
To: Melvin Davidson <melvin6925(at)gmail(dot)com>
Cc: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>, anand086 <anand086(at)gmail(dot)com>, PostgreSQL mailing lists <pgsql-general(at)postgresql(dot)org>
Subject: Re: pg_stat_statements -- Historical Query
Date: 2017-08-10 13:12:16
Message-ID: CAOBaU_ZaRSa7SJ1Da39VmS3WOr9gnyGu2twPJvB4pwq6a=W3Hw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Aug 10, 2017 at 3:00 PM, Melvin Davidson <melvin6925(at)gmail(dot)com> wrote:
>
> If you are interested in historical stats, you would probably fair a lot better with PgBadger. It is free
> and highly customizable. In addition to SQL call rates at different times, it provides analysis of
> most used queries, slowest queries, etc.

So is doing powa, but in real time.

>
> https://sourceforge.net/projects/pgbadger/
>

FYI pgBadger is no longer available on sourceforge (see the
downladable file), you should now download it on
https://github.com/dalibo/pgbadger/releases

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Colin 't Hart 2017-08-10 13:49:35 Re: How to ALTER EXTENSION name OWNER TO new_owner ?
Previous Message John McKown 2017-08-10 13:06:29 Re: About using IMCS moldule