| From: | Kenny Bachman <kenny(dot)bachman17(at)gmail(dot)com> |
|---|---|
| To: | Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Subject: | Postgresql 14 performance |
| Date: | 2022-08-21 16:05:32 |
| Message-ID: | CAC0w7LL+uFgPvctiHMxrVZV-DnNVg2K_wFaeZwM96XQFkjk1uA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Hi Team,
Have a lovely Sunday.
I have a problem with PostgreSQL performance. I am using PostgreSQL 14.5 on
Linux physical server. My query was taking 1 or 2 seconds yesterday, but
today it is taking 5-6 seconds. Also, nothing has changed in the database.
Also, when I run the query for the second time, the query runs for the same
time, so I expect it to be more performant the second time because of the
cache.
(the database cache hit ratio is 97,8)
Lastly, some other queries take milliseconds normally, but sometimes they
take minutes. I didn't understand why this is happening. (There is no lock,
no table bloating and up to date analyze)
I am adding the explain analyze output as an attachment.
| Attachment | Content-Type | Size |
|---|---|---|
| exec_plan.txt | text/plain | 102.6 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Wim Bertels | 2022-08-21 17:06:35 | Re: Postgresql 14 performance |
| Previous Message | Vijaykumar Jain | 2022-08-20 07:19:30 | Re: Zombie process pile up and cannot terminate |