MIME-Version: 1.0
From: Sreejith P <sreejith@lifetrenz.com>
Date: Wed, 20 Nov 2024 16:20:55 +0530
Message-ID: <CAOW_W8PZ7Op_vOT9szMnpZE4jOmP09NWfc3M1ORTFMzjebpK5w@mail.gmail.com>
Subject: Suddenly all queries moved to seq scan
To: pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000b9f8b2062755ee69"
Archived-At: <https://www.postgresql.org/message-id/CAOW_W8PZ7Op_vOT9szMnpZE4jOmP09NWfc3M1ORTFMzjebpK5w%40mail.gmail.com>
Precedence: bulk

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

Hi,

We are using PostgresQL 10 in our production database.  We have around 890
req /s request on peak time.

We have 1 primary and 4 slave databases as well in the same postgres
cluster.

2 days back we applied some patches in the primary server and restarted. We
didn't do anything on the secondary server.

Next day, After 18 hours all our queries from secondary servers started
taking too much time.  queries were working in 2 sec started taking 80
seconds. Almost all queries behaved the same way.

After half an hour of outage we restarted all db servers and system back to
normal.

Still we are not able to understand the root case. We couldn't find any
error log or fatal errors.  During the incident, in  one of the read server
disks was full. We couldn't see any replication lag or query
cancellation due to replication.

please help

Regards
Sreejith

--=20


=C2=A0

*Solutions for Care Anywhere*
*dWise HealthCare IT Solutions Pvt.=20
Ltd.* | www.lifetrenz.com <http://www.lifetrenz.com>
*Disclaimer*:
 The=20
information and attachments contained in this email are intended=20
for=20
exclusive use of the addressee(s) and may contain confidential or=20
privileged information. If you are not the intended recipient, please=20
notify the sender immediately and destroy all copies of this message and
=20
any attachments. The views expressed in this email are, unless=20
otherwise=20
stated, those of the author and not those of dWise HealthCare IT Solutions=
=20
or its management.

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

<div dir=3D"ltr"><div dir=3D"ltr">Hi,<div><br></div><div>We are using Postg=
resQL=C2=A010 in our production database.=C2=A0 We have around 890 req /s r=
equest on peak time.</div><div><br></div><div>We have 1 primary and 4 slave=
 databases as well in the same postgres cluster.=C2=A0</div><div><br></div>=
<div>2 days back we applied some patches in the primary server and restarte=
d. We didn&#39;t do anything on the secondary server.</div><div><br></div><=
div>Next day, After 18 hours all our queries from secondary servers started=
 taking too much time.=C2=A0 queries were working in 2 sec started taking 8=
0 seconds. Almost all queries behaved the same way.</div><div><br></div><di=
v>After half an hour of outage we restarted all db servers and system back =
to normal.</div><div><br></div><div>Still we are not able to understand the=
 root case. We couldn&#39;t=C2=A0find any error log or fatal errors.=C2=A0 =
During the incident, in=C2=A0 one of the read server disks was full. We cou=
ldn&#39;t=C2=A0see any replication lag or query cancellation=C2=A0due to re=
plication.</div><div><br></div><div>please help</div><div><br></div><div>Re=
gards</div><div>Sreejith</div><div><br></div><div><br></div><div><br></div>=
<div><br></div></div>
</div>

<br>
<div><p style=3D"margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:Calibri=
,sans-serif"><img></p><p style=3D"margin:0cm 0cm 0.0001pt;font-size:11pt;fo=
nt-family:Calibri,sans-serif"><img src=3D"https://www.lifetrenz.com/lt-logo=
.png">=C2=A0</p><p style=3D"margin:0cm 0cm 0.0001pt;font-size:11pt;font-fam=
ily:Calibri,sans-serif"><b><span style=3D"color:rgb(0,32,96)">Solutions for=
 Care Anywhere</span></b></p></div><hr><span><font color=3D"#888888"><b><sp=
an style=3D"color:rgb(31,73,125);font-family:&quot;Calibri&quot;,sans-serif=
;font-size:11pt">dWise HealthCare IT Solutions Pvt. Ltd.</span></b><span st=
yle=3D"color:rgb(31,73,125);font-family:&quot;Calibri&quot;,sans-serif;font=
-size:11pt"> | </span><span lang=3D"EN-US" style=3D"color:rgb(31,73,125);fo=
nt-family:&quot;Arial&quot;,sans-serif;font-size:7pt"><a href=3D"http://www=
.lifetrenz.com" target=3D"_blank"><span style=3D"color:rgb(5,99,193)">www.l=
ifetrenz.com</span></a><br></span><font color=3D"gray"><b><span lang=3D"EN-=
US" style=3D"font-family:&quot;Arial&quot;,sans-serif;font-size:7pt">Discla=
imer</span></b><span lang=3D"EN-US" style=3D"font-family:&quot;Arial&quot;,=
sans-serif;font-size:7pt">:
 The information and attachments contained in this email are intended=20
for exclusive use of the addressee(s) and may contain confidential or=20
privileged information. If you are not the intended recipient, please=20
notify the sender immediately and destroy all copies of this message and
 any attachments. The views expressed in this email are, unless=20
otherwise stated, those of the author and not those of dWise HealthCare IT =
Solutions or its management.</span></font></font></span>
--000000000000b9f8b2062755ee69--