| From: | Justin Pryzby <pryzby(at)telsasoft(dot)com> |
|---|---|
| To: | Edson Richter <edsonrichter(at)hotmail(dot)com> |
| Cc: | pgsql-performance(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Log number of tuples returned |
| Date: | 2021-04-29 15:08:26 |
| Message-ID: | 20210429150825.GK27406@telsasoft.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Edson Richter | 2021-04-29 15:31:04 | RES: Log number of tuples returned |
| Previous Message | Edson Richter | 2021-04-29 15:01:29 | Log number of tuples returned |