[prev in list] [next in list] [prev in thread] [next in thread] 

List:       pgsql-performance
Subject:    Re: Q on SQL Performance tuning
From:       Justin Pryzby <pryzby () telsasoft ! com>
Date:       2019-01-27 14:31:08
Message-ID: 20190127143108.GK13248 () telsasoft ! com
[Download RAW message or body]

On Sun, Jan 27, 2019 at 08:43:15AM +0000, Bhupathi, Kaushik (CORP) wrote:
> 2)      Is there anyway to know the historical execution plan details of a \
> particular SQL ? Per my understanding so far since there is no concept of shared \
> pool unlike Oracle every execution demands a new hard parse. However wanted to \
> check with experts to know if any extension available on this?

There's also autoexplain, althought I think that's typically configured to only
output plans for queries which longer than a minimum duration.

Justin


[prev in list] [next in list] [prev in thread] [next in thread]