Re: Insert query performance - Mailing list pgsql-general

From sud
Subject Re: Insert query performance
Date
Msg-id CAD=mzVVtnELmUbTGVecmjGZ8HwiVvhj7V5XBPR5Woref0BN=Rg@mail.gmail.com
Whole thread Raw
In response to Re: Insert query performance  (Muhammad Ikram <mmikram@gmail.com>)
Responses Re: Insert query performance
List pgsql-general

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: Muhammad Ikram
Date:
Subject: Re: Insert query performance