RES: Log number of tuples returned

De: Justin Pryzby Enviado:quinta-feira, 29 de abril de 2021 12:08 Para: Edson Richter Cc:pgsql-performance@lists.postgresql.org Assunto: Re: Log number of tuples returned On Thu, Apr 29, 20

Re: Log number of tuples returned

On Thu, Apr 29, 2021 at 03:01:29PM +, Edson Richter wrote: > Which postgresql logging parameters should I activate to log the “number of > tuples returned” for a query? > I would like to debug some dynamicly generated queries in the system that are > returning a absurd number of tuples (> 2,6

Log number of tuples returned

Hi! Which postgresql logging parameters should I activate to log the “number of tuples returned” for a query? I would like to debug some dynamicly generated queries in the system that are returning a absurd number of tuples (> 2,6mi of records). Thanks, ER Enviado do Email

Re: Error while calling proc with table type from Application (npgsql)

On Thu, Apr 29, 2021 at 02:52:23PM +0530, aditya desai wrote: > Hi, > One of the procs which accept tabletype as parameter gives below error > while being called from Application. Could not find a concrete solution for > this. Can someone help? > > call PROCEDURE ABC (p_optiontable optiontype) Wh

Error while calling proc with table type from Application

Hi, One of the procs which accept tabletype as parameter gives below error while being called from Application. Could not find a concrete solution for this. Can someone help? call PROCEDURE ABC (p_optiontable optiontype) Below is the error while executing proc - “the clr type system.data.datat