MIME-Version: 1.0
References: <CAD=mzVXZiDmAsTE1XiXnq1DFHM22uwnD8jckmBN_bTakk3u2AQ@mail.gmail.com>
 <CAGeimVqF+2vAwbMRznGvbAWs=1u+4zLkZ11irO3yuBP6sLmPow@mail.gmail.com>
In-Reply-To: <CAGeimVqF+2vAwbMRznGvbAWs=1u+4zLkZ11irO3yuBP6sLmPow@mail.gmail.com>
From: sud <suds1434@gmail.com>
Date: Tue, 20 Aug 2024 12:49:12 +0530
Message-ID: <CAD=mzVVtnELmUbTGVecmjGZ8HwiVvhj7V5XBPR5Woref0BN=Rg@mail.gmail.com>
Subject: Re: Insert query performance
To: Muhammad Ikram <mmikram@gmail.com>
Cc: pgsql-general <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000b1b7510620183e5e"
Archived-At: <https://www.postgresql.org/message-id/CAD%3DmzVVtnELmUbTGVecmjGZ8HwiVvhj7V5XBPR5Woref0BN%3DRg%40mail.gmail.com>
Precedence: bulk

--000000000000b1b7510620183e5e
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Mon, Aug 19, 2024 at 1:25=E2=80=AFPM Muhammad Ikram <mmikram@gmail.com> =
wrote:

> Hi Sud,
>
> Please make following change in your postgresql.conf file
>
> log_statement =3D '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.

--000000000000b1b7510620183e5e
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><br></div><div class=3D"gmail_quote"><div=
 dir=3D"ltr" class=3D"gmail_attr">On Mon, Aug 19, 2024 at 1:25=E2=80=AFPM M=
uhammad Ikram &lt;<a href=3D"mailto:mmikram@gmail.com">mmikram@gmail.com</a=
>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0px=
 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><di=
v dir=3D"ltr">Hi Sud,<div><br></div><div>Please make following change in yo=
ur postgresql.conf file</div><div><br></div><div>log_statement =3D &#39;all=
&#39;=C2=A0<br></div><div><br></div></div></blockquote><div><br></div><div>=
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 is=
sues 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=C2=A0performance overhead.</di=
v></div></div>

--000000000000b1b7510620183e5e--