-----Original Message----- From: Justin Pryzby <pryzby@xxxxxxxxxxxxx> Sent: Thursday, July 22, 2021 12:23 To: ldh@xxxxxxxxxxxxxxxxxx Cc: Tom Lane <tgl@xxxxxxxxxxxxx>; David Rowley <dgrowleyml@xxxxxxxxx>; Peter Geoghegan <pg@xxxxxxx>; pgsql-performance@xxxxxxxxxxxxxx Subject: Re: Big performance slowdown from 11.2 to 13.3 On Thu, Jul 22, 2021 at 04:16:34PM +0000, ldh@xxxxxxxxxxxxxxxxxx wrote: > Is it fair then to deduce that the total memory usage would be 2,400,305kB + 126,560kB? Is this what under the covers V11 is consuming more or less? It might be helpful to know how much RAM v11 is using. Could you run the query with log_executor_stats=on; client_min_messages=debug; The interesting part is this: ! 7808 kB max resident size -- Justin ------------------------------------------- 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? Thank you, Laurent.
