Help in Postgresql

From: mooh Rash <moohrash(at)yahoo(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Help in Postgresql
Date: 2018-05-22 12:58:29
Message-ID: 1021506835.4000295.1526993909313@mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2018-05-22 13:22:22 Re: source of connection fails at pg startup?
Previous Message Bob Jolliffe 2018-05-22 08:27:17 Re: posgresql.log