From: | Justin Pryzby <pryzby(at)telsasoft(dot)com> |
---|---|
To: | ldh(at)laurent-hasson(dot)com |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, David Rowley <dgrowleyml(at)gmail(dot)com>, Peter Geoghegan <pg(at)bowt(dot)ie>, pgsql-performance(at)postgresql(dot)org |
Subject: | Re: Big performance slowdown from 11.2 to 13.3 |
Date: | 2021-07-22 16:35:56 |
Message-ID: | 20210722163556.GH19620@telsasoft.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
On Thu, Jul 22, 2021 at 04:30:00PM +0000, ldh(at)laurent-hasson(dot)com wrote:
> Hello Justin,
>
> > log_executor_stats=on; client_min_messages=debug;
>
> Would the results then come in EXPLAIN or would I need to pick something up from the logs?
If you're running with psql, and client_min_messages=debug, then it'll show up
as a debug message to the client:
ts=# SET log_executor_stats=on; SET client_min_messages=debug; explain analyze SELECT 1;
SET
SET
LOG: EXECUTOR STATISTICS
DETAIL: ! system usage stats:
! 0.000011 s user, 0.000209 s system, 0.000219 s elapsed
! [0.040608 s user, 0.020304 s system total]
! 7808 kB max resident size
...
It can but doesn't have to use "explain" - that just avoids showing the query
output, since it's not what's interesting here.
--
Justin
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Geoghegan | 2021-07-22 16:36:02 | Re: Big performance slowdown from 11.2 to 13.3 |
Previous Message | ldh@laurent-hasson.com | 2021-07-22 16:30:00 | RE: Big performance slowdown from 11.2 to 13.3 |