Subject: Re: Temp files for simple queries
To: MichaelDBA <MichaelDBA@sqlexec.com>
Cc: pgsql-admin@lists.postgresql.org, Julien Rouhaud <rjuju123@gmail.com>
References: <45cc44dd-b830-5df5-1f09-171e9874bbc0@gmail.com>
 <16aa733d-bcaf-0aa6-f3f0-5206de695e92@gmail.com>
 <20210622115506.o2u4u5krplxxc54k@nol>
 <6fab4381-4a47-0b99-43a9-1ff1c97efd39@sqlexec.com>
From: "Radoulov, Dimitre" <cichomitiko@gmail.com>
Message-ID: <2a8094c3-e2ea-b2cb-59d5-c8a31f1cbe67@gmail.com>
Date: Tue, 22 Jun 2021 14:16:31 +0200
User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:78.0) Gecko/20100101
 Thunderbird/78.11.0
MIME-Version: 1.0
In-Reply-To: <6fab4381-4a47-0b99-43a9-1ff1c97efd39@sqlexec.com>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 8bit
Content-Language: en-US
Archived-At: 
 <https://www.postgresql.org/message-id/2a8094c3-e2ea-b2cb-59d5-c8a31f1cbe67%40gmail.com>
Precedence: bulk

Hello Michael,

On 22/06/2021 14.00, MichaelDBA wrote:
> I'm wondering if bloat could be causing a problem.  Perhaps more 
> blocks are written to disk including a lot of blocks with little or no 
> data due to bloat.
>
Using the query suggested here: 
www.citusdata.com/blog/2017/10/20/monitoring-your-bloat-in-postgres/, I 
get the following:


databasename | db1
schemaname   | schema1
tablename    | t1
can_estimate | t
est_rows     | 160
pct_bloat    | 18
mb_bloat     | 0.06
table_mb     | 0.352

So the bloat doesn't seem significant.


Best regards
Dimitre