Re: Help in Postgresql

On Tue, May 22, 2018 at 8:58 AM, mooh Rash <moohrash@yahoo.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