Re: Expose Parallelism counters planned/execute in pg_stat_statements

2022-10-12 Thread Michael Paquier
On Tue, Aug 16, 2022 at 02:58:43PM +0800, Julien Rouhaud wrote: > I don't think that's an improvement. With this patch if you see the > "paral_planned_not_exec" counter going up, you still don't know if this is > because of the !es_use_parallel_mode or if you simply have too many parallel >

Re: Expose Parallelism counters planned/execute in pg_stat_statements

2022-08-16 Thread Julien Rouhaud
Hi, On Fri, Jul 29, 2022 at 08:36:44AM -0500, Daymel Bonne Solís wrote: > > We have rewritten the patch and added the necessary columns to have the > number of times a parallel query plan was not executed using parallelism. > > We are investigating how to add more information related to the

Re: Expose Parallelism counters planned/execute in pg_stat_statements

2022-08-15 Thread Daymel Bonne Solís
Hi: We have rewritten the patch and added the necessary columns to have the > number of times a parallel query plan was not executed using parallelism. > > This version includes comments on the source code and documentation. Regards v3-0001-Add-parallel-counters-to-pg_stat_statements.patch

Re: Expose Parallelism counters planned/execute in pg_stat_statements

2022-07-29 Thread Daymel Bonne Solís
Hi, El lun, 25 jul 2022 a la(s) 14:19, Anthony Sotolongo (asotolo...@gmail.com) escribió: > On 23-07-22 00:03, Julien Rouhaud wrote: > > Hi, > > > > On Fri, Jul 22, 2022 at 02:11:35PM -0400, Anthony Sotolongo wrote: > >> On 22-07-22 12:08, Julien Rouhaud wrote: > >>> With your current patch it

Re: Expose Parallelism counters planned/execute in pg_stat_statements

2022-07-25 Thread Anthony Sotolongo
On 23-07-22 00:03, Julien Rouhaud wrote: Hi, On Fri, Jul 22, 2022 at 02:11:35PM -0400, Anthony Sotolongo wrote: On 22-07-22 12:08, Julien Rouhaud wrote: With your current patch it only says if the plan and execution had parallelism enabled, but not if it could actually use with parallelism at

Re: Expose Parallelism counters planned/execute in pg_stat_statements

2022-07-22 Thread Julien Rouhaud
Hi, On Fri, Jul 22, 2022 at 02:11:35PM -0400, Anthony Sotolongo wrote: > > On 22-07-22 12:08, Julien Rouhaud wrote: > > > > With your current patch it only says if the plan and execution had > > parallelism > > enabled, but not if it could actually use with parallelism at all. It gives > > some

Re: Expose Parallelism counters planned/execute in pg_stat_statements

2022-07-22 Thread Anthony Sotolongo
On 22-07-22 12:08, Julien Rouhaud wrote: Hi, On Fri, Jul 22, 2022 at 11:17:52AM -0400, Anthony Sotolongo wrote: On 21-07-22 20:35, Justin Pryzby wrote: On Thu, Jul 21, 2022 at 06:26:58PM -0400, Anthony Sotolongo wrote: Hi all: Here's a patch to add counters about  planned/executed  for

Re: Expose Parallelism counters planned/execute in pg_stat_statements

2022-07-22 Thread Julien Rouhaud
Hi, On Fri, Jul 22, 2022 at 11:17:52AM -0400, Anthony Sotolongo wrote: > > On 21-07-22 20:35, Justin Pryzby wrote: > > On Thu, Jul 21, 2022 at 06:26:58PM -0400, Anthony Sotolongo wrote: > > > Hi all: > > > Here's a patch to add counters about  planned/executed  for parallelism  > > > to > > >

Re: Expose Parallelism counters planned/execute in pg_stat_statements

2022-07-22 Thread Anthony Sotolongo
On 21-07-22 20:35, Justin Pryzby wrote: On Thu, Jul 21, 2022 at 06:26:58PM -0400, Anthony Sotolongo wrote: Hi all: Here's a patch to add counters about  planned/executed  for parallelism  to pg_stat_statements, as a way to follow-up on if the queries are planning/executing with parallelism,

Re: Expose Parallelism counters planned/execute in pg_stat_statements

2022-07-21 Thread Justin Pryzby
On Thu, Jul 21, 2022 at 06:26:58PM -0400, Anthony Sotolongo wrote: > Hi all: > Here's a patch to add counters about  planned/executed  for parallelism  to > pg_stat_statements, as a way to follow-up on if the queries are > planning/executing with parallelism, this can help to understand if you

Expose Parallelism counters planned/execute in pg_stat_statements

2022-07-21 Thread Anthony Sotolongo
Hi all: Here's a patch to add counters about  planned/executed  for parallelism  to pg_stat_statements, as a way to follow-up on if the queries are planning/executing with parallelism, this can help to understand if you have a good/bad configuration or if your hardware is enough We