Re: Is it useful to record whether plans are generic or custom?

Hi Atsushi,

+1: Your proposal is a good answer for time based performance analysis 
(even if parsing durationor blks are not differentiated) .

As it makes pgss number of columns wilder, may be an other solution 
would be to create a pg_stat_statements_xxx view with the same key 
as pgss (dbid,userid,queryid) and all thoses new counters.

And last solution would be to display only generic counters, 
because in most cases (and per default) executions are custom ones 
(and generic counters = 0).
if not (when generic counters != 0), customs ones could be deducted from 
total_exec_time - total_generic_time, calls - generic_calls.

Good luck for this feature development
Regards
PAscal



--
Sent from: https://www.postgresql-archive.org/PostgreSQL-hackers-f1928748.html