| From: | "Radoulov, Dimitre" <cichomitiko(at)gmail(dot)com> |
|---|---|
| To: | MichaelDBA <MichaelDBA(at)sqlexec(dot)com> |
| Cc: | pgsql-admin(at)lists(dot)postgresql(dot)org, Julien Rouhaud <rjuju123(at)gmail(dot)com> |
| Subject: | Re: Temp files for simple queries |
| Date: | 2021-06-22 12:16:31 |
| Message-ID: | 2a8094c3-e2ea-b2cb-59d5-c8a31f1cbe67@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mai Peng | 2021-06-22 13:00:28 | Deploy modifications of database objects |
| Previous Message | Radoulov, Dimitre | 2021-06-22 12:05:57 | Re: Temp files for simple queries |