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