Re: Sample values for pg_stat_statements

2019-01-31 Thread Andres Freund
On 2018-11-29 16:58:05 +0100, Dmitry Dolgov wrote: > > On Mon, Oct 1, 2018 at 8:30 AM Michael Paquier wrote: > > > > On Tue, Apr 17, 2018 at 05:58:44PM +0200, Vik Fearing wrote: > > > I think I handle that well enough with permission checking, but I'm open > > > to more debate on it. > > > > The r

Re: Sample values for pg_stat_statements

2018-11-29 Thread Dmitry Dolgov
> On Mon, Oct 1, 2018 at 8:30 AM Michael Paquier wrote: > > On Tue, Apr 17, 2018 at 05:58:44PM +0200, Vik Fearing wrote: > > I think I handle that well enough with permission checking, but I'm open > > to more debate on it. > > The recent version bump in pg_stat_statements (Sorry my fault!) is > c

Re: Sample values for pg_stat_statements

2018-09-30 Thread Michael Paquier
On Tue, Apr 17, 2018 at 05:58:44PM +0200, Vik Fearing wrote: > I think I handle that well enough with permission checking, but I'm open > to more debate on it. The recent version bump in pg_stat_statements (Sorry my fault!) is causing this patch to not apply anymore. I have moved it to next CF wi

Re: Sample values for pg_stat_statements

2018-06-21 Thread Michael Paquier
On Thu, Jun 21, 2018 at 12:28:01PM +0200, Daniel Gustafsson wrote: > I happened to notice that this patch was moved from Returned with Feedback to > Needs Review after the CF closed, which means it’s now sitting open in a > closed > CF. The intended flow after RWF is that the patch is resubmitted

Re: Sample values for pg_stat_statements

2018-06-21 Thread Daniel Gustafsson
> On 17 Apr 2018, at 17:58, Vik Fearing wrote: > Thanks! Attached is a patch addressing your concerns. I happened to notice that this patch was moved from Returned with Feedback to Needs Review after the CF closed, which means it’s now sitting open in a closed CF. The intended flow after RWF i

Re: Sample values for pg_stat_statements

2018-04-17 Thread Vik Fearing
On 03/10/2018 03:02 PM, Tomas Vondra wrote: > Hi, > > I've looked at this patch today. I like the idea / intent in general, as > it helps with some investigation tasks. That being said, I have a couple > of questions/comments based on read through the patch: Thanks! Attached is a patch addressin

Re: Sample values for pg_stat_statements

2018-03-28 Thread David Steele
On 3/21/18 1:31 PM, David Steele wrote: > > On 3/10/18 9:02 AM, Tomas Vondra wrote: >> >> I've looked at this patch today. I like the idea / intent in general, as >> it helps with some investigation tasks. That being said, I have a couple >> of questions/comments based on read through the patch: >

Re: Sample values for pg_stat_statements

2018-03-23 Thread legrand legrand
+1 If pgss had a PlanId column (just after QueryId), that would be wonderfull ;o) Question: Is there a simple way to "un-normalize" the query (I mean rebuild the original query as it was before normalization) ? Regards PAscal -- Sent from: http://www.postgresql-archive.org/PostgreSQL-hackers

Re: Re: Sample values for pg_stat_statements

2018-03-21 Thread David Steele
Hi Vik, On 3/10/18 9:02 AM, Tomas Vondra wrote: > > I've looked at this patch today. I like the idea / intent in general, as > it helps with some investigation tasks. That being said, I have a couple > of questions/comments based on read through the patch: It looks like there are some privacy co

Re: Sample values for pg_stat_statements

2018-03-11 Thread Greg Stark
I've often wanted something similar. But I've struggled to come up with a good way to decide which parameters to keep. And as someone mentioned, there's the question of how to deal with very large constants. The other day I was poking around with pg_stat_statements and jsonlog and I thought of ano

Re: Sample values for pg_stat_statements

2018-03-10 Thread Tomas Vondra
Hi, I've looked at this patch today. I like the idea / intent in general, as it helps with some investigation tasks. That being said, I have a couple of questions/comments based on read through the patch: 1) I see you've renamed the .sql script from 1.4 to 1.6. I thought we've abandoned that app

Re: Sample values for pg_stat_statements

2018-03-01 Thread Vik Fearing
On 03/01/2018 07:26 PM, Andres Freund wrote: > Hm. Isn't this going to blow up the size of the file in cases with a > number of parameters quite considerably, a file limit notwithstanding? > Wonder if the size limit wouldn't have to be across all params. It is across all params (per queryid). --

Re: Sample values for pg_stat_statements

2018-03-01 Thread Andres Freund
Hi, On 2017-12-31 12:34:17 +0100, Vik Fearing wrote: > Often when looking through pg_stat_statements, it would be nice to have > some sample values for the constants and parameters. This patch > implements that by taking the values from the first execution of the > normalized query. > > To keep

Re: Sample values for pg_stat_statements

2018-02-26 Thread Julian Markwort
Hi Vik, this is my review of your patch. I hope I've ticked all the necessary boxes. Submission review: Patch has context, applies cleanly, make and make check run successfully, patch contains tests for the added functionality. The patch doesn't seem to contain any documentation regarding the ne