| From: | Melvin Davidson <melvin6925(at)gmail(dot)com> |
|---|---|
| To: | mooh Rash <moohrash(at)yahoo(dot)com> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Help in Postgresql |
| Date: | 2018-05-22 13:49:05 |
| Message-ID: | CANu8FizE6oVC=S4xYpjqCXCeuX67D6Af11-cDRk1ykXKtauk6w@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, May 22, 2018 at 8:58 AM, mooh Rash <moohrash(at)yahoo(dot)com> wrote:
> Hi ,
>
> I am a PhD student searching in query optimization. I want to access the
> information about queries and statistics. Especially, I am interested in finding
> out how I can collect the history information (user, when, query,
> query_plan) from postgreqsl. Also, I wonder if there is a plan-table in
> postgresql than I can access, and I can access it?. I appreciate if you
> guide me in getting the mentioned information that are necessary for my
> research.
>
> Best,
> Moohanad
>
> I want to access the information about queries and statistics
*I strongly recommend you install PgBadger, which analyzes the log file to
provide you the information you need.*
*https://sourceforge.net/projects/pgbadger/
<https://sourceforge.net/projects/pgbadger/>*
--
*Melvin Davidson*
*Maj. Database & Exploration Specialist*
*Universe Exploration Command – UXC*
Employment by invitation only!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2018-05-22 13:58:16 | Re: source of connection fails at pg startup? |
| Previous Message | Adrian Klaver | 2018-05-22 13:22:22 | Re: source of connection fails at pg startup? |