> I reviewed v6:
>
> - applies to master cleanly, builds, tests pass and all works as expected
> - overall, the patch looks great and I found no major issues
> - tests and docs look good overall

Thanks for the valuable feedback!

> - in docs, one minor comment:
>     > "Total number of statements executed using a generic plan" vs. what we 
> already have for `calls`
>     here, in "Number of times the statement was executed", I see some 
> inconsistencies:
>         - the word "total" should be removed, I think
>         - and maybe we should make wording consistent with the existing text 
> – "number of times the statement ...")

good point. Changed to:

> +       Number of times the statement was executed using a generic plan
> +       Number of times the statement was executed using a custom plan

> - Also very minor, the test queries have duplicate `calls` columns:

good catch. fixed.

>     > plan->status = PLAN_CACHE_STATUS_UNKNOWN;
>     (here I'm not 100% sure, as palloc0 in CreateCachedPlan should 
> zero-initialize it to PLAN_CACHE_STATUS_UNKNOWN anyway)

Yeah, good catch also. The initialization actually occurs in
GetCachedPlan which returns
a CachedPlan for the CachedPlanSource, so I fixed this by initializing
the status
there.

> Ah, one more thing: the subject here and in CommitFest entry, "track generic 
> and custom plans"
> slightly confused me at first, I think it's worth including words "calls" or 
> "execution" there, and in
> the commit message, for clarity. Or just including the both column names as 
> is.

changed the subject of the CF entry to be more clear.

attached v7 which addresses the comments.

Now, one thing I don't like is the fact that the columns stats_since
and minmax_stats_since
are in between counters all of the sudden. I think we either need to
move them to
the front of the view, after the query field  or within this patch
move them after the
new generic/custom plan counters. I prefer the former since we do it
once in a major version
and do not have to worry about it once new counters are added.

It just feels odd that they sit in between the counters as they have a
high level purpose.

Thanks!

Sami Imseih
Amazon Web Services (AWS)

Attachment: v7-0001-Add-plan_cache-counters-to-pg_stat_statements.patch
Description: Binary data

Reply via email to