Re: refreshing query id for pg_stat_statements based on comment in sql

2022-03-07 Thread Julien Rouhaud
Hi, On Mon, Mar 07, 2022 at 09:42:26AM -0800, Zhihong Yu wrote: > Hi, > Currently the query id for pg_stat_statements gets calculated based on the > parse nodes specifics. > This means that the user cannot add a comment to a SQL query to test > something. (though some other RDBMS allows this pract

Re: refreshing query id for pg_stat_statements based on comment in sql

2022-03-07 Thread Bruce Momjian
On Mon, Mar 7, 2022 at 09:42:26AM -0800, Zhihong Yu wrote: > Hi, > Currently the query id for pg_stat_statements gets calculated based on the > parse nodes specifics.  > This means that the user cannot add a comment to a SQL query to test > something. > (though some other RDBMS allows this practi

refreshing query id for pg_stat_statements based on comment in sql

2022-03-07 Thread Zhihong Yu
Hi, Currently the query id for pg_stat_statements gets calculated based on the parse nodes specifics. This means that the user cannot add a comment to a SQL query to test something. (though some other RDBMS allows this practice). Consider this use case: for query q, admin looks at stats and perfor