Re: High Disk Utilization Due to Query on Large Table - Mailing list pgsql-admin

From Laurenz Albe
Subject Re: High Disk Utilization Due to Query on Large Table
Date
Msg-id 0ee846d4003ff880a4faf77e52bb0ab73c1b230a.camel@cybertec.at
Whole thread Raw
In response to High Disk Utilization Due to Query on Large Table  (kasem adel <kasemadel8@gmail.com>)
List pgsql-admin
On Tue, 2025-01-21 at 20:10 +0200, kasem adel wrote:
> We are experiencing high disk utilization caused by a query running on a table
> containing 300,000,000 rows. This issue has occurred after running the ANALYZE
> process with default values.

If you are waiting for someone to connect to your system and fix the problem,
you are going to wait in vain.  If you want help, you have to provide information
that allows us to help you.

Please post the query and its EXPLAIN (ANALYZE, BUFFERS, SETTINGS) output.
Also tell us which PostgreSQL version you are using.

Yours,
Laurenz Albe



pgsql-admin by date:

Previous
From: shammat@gmx.net
Date:
Subject: Re: Is there a way to check if objects are created with quotes or not?
Next
From:
Date:
Subject: RE: Commit with wait event on advisory lock!