Re: Insert query performance - Mailing list pgsql-general

From Muhammad Ikram
Subject Re: Insert query performance
Date
Msg-id CAGeimVqjCKdUp2fNYS_2FpE1OyXiue=dRu43MHzcG_SD7Kxw1Q@mail.gmail.com
Whole thread Raw
In response to Re: Insert query performance  (sud <suds1434@gmail.com>)
List pgsql-general
It will record all statements in logs. If you are concerned about query times then you may use pg_stat_statements.


Muhammad Ikram



On Tue, 20 Aug 2024 at 12:19, sud <suds1434@gmail.com> wrote:

On Mon, Aug 19, 2024 at 1:25 PM Muhammad Ikram <mmikram@gmail.com> wrote:
Hi Sud,

Please make following change in your postgresql.conf file

log_statement = 'all' 


Will this put all the internal sql query or the recursive query entries in the pg_stats_statement view which we can analyze then? And also to debug issues in the production will it be a good idea to set it for a few times and then turn it off or it can have significant performance overhead.

pgsql-general by date:

Previous
From: sud
Date:
Subject: Re: Insert query performance
Next
From: David Rowley
Date:
Subject: Re: Insert query performance