Re: Insert query performance

From: sud <suds1434(at)gmail(dot)com>
To: Muhammad Ikram <mmikram(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Insert query performance
Date: 2024-08-20 07:19:12
Message-ID: CAD=mzVVtnELmUbTGVecmjGZ8HwiVvhj7V5XBPR5Woref0BN=Rg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Aug 19, 2024 at 1:25 PM Muhammad Ikram <mmikram(at)gmail(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Muhammad Ikram 2024-08-20 10:59:13 Re: Insert query performance
Previous Message sud 2024-08-20 07:09:01 Re: Insert query performance