On Sun, 27 Jan 2019 at 06:29, legrand legrand
wrote:
>
> Hi,
>
> There are many tools:
> - (core) extension pg_stat_statements will give you informations of SQL
> executions,
I've had enormous success using pg_stat_statements and gathering the
data over time in Prometheus. That let me build a
On Sun, Jan 27, 2019 at 08:43:15AM +, 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.
Hi,
There are many tools:
- (core) extension pg_stat_statements will give you informations of SQL
executions,
- extension pgsentinel https://github.com/pgsentinel/pgsentinel
gives the same results as Oracle ASH view
- java front end PASH viewer https://github.com/dbacvetkov/PASH-Viewer
gives
Hi Team, I've few Questions on SQL perf tuning.
1) Is there any SQL monitoring report that's available in Oracle.
Highlight of the report is it tells the % of time spent on CPU & IO. And which
step took how much % in overall execution.
2) Is there anyway to know the historical
