On Wed, Jan 25, 2023 at 10:57:58AM -0700, Scott Ribe wrote: > > On Jan 25, 2023, at 10:55 AM, Clive Swan <cliveswan@xxxxxxxxx> wrote: > > > > SQL Server has a handy SQL "tool" to spot expensive and/or long running queries. > > > > Is there a similar query/tool for Postgresql?? > > - pg_stat_statements extension > - log_min_duration config parameter FYI, log_min_duration_statement will not print the duration until the query completes, so it is good for analysis later. -- Bruce Momjian <bruce@xxxxxxxxxx> https://momjian.us EDB https://enterprisedb.com Embrace your flaws. They make you human, rather than perfect, which you will never be.
