Thread: Log number of tuples returned

Log number of tuples returned

From
Edson Richter
Date:

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 para Windows 10

 

Re: Log number of tuples returned

From
Justin Pryzby
Date:
On Thu, Apr 29, 2021 at 03:01:29PM +0000, 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,6miof records).
 

You can load the auto_explain extension and set:
auto_explain.log_analyze

And then the "rows" are logged:
          
 
 Result  (cost=0.00..0.01 rows=1 width=4) (actual time=0.002..0.004 rows=1 loops=1)
                      
 

https://www.postgresql.org/docs/current/auto-explain.html

-- 
Justin



RES: Log number of tuples returned

From
Edson Richter
Date:

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, 2021 at 03:01:29PM +0000, 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,6mi of records).

You can load the auto_explain extension and set:
auto_explain.log_analyze

And then the "rows" are logged:                                                                                                   
 Result  (cost=0.00..0.01 rows=1 width=4) (actual time=0.002..0.004 rows=1 loops=1)                                                           

https://www.postgresql.org/docs/current/auto-explain.html

--
Justin

 

 

Perfect, Thanks!

 

ER.