select statements have many shared_blks_dirtied and written

From: James Pang <jamespang886(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: select statements have many shared_blks_dirtied and written
Date: 2024-02-20 08:20:03
Message-ID: CAHgTRfftPv9NmWBxfxCZMZAL3_bxP8HthyNbZxXKHN=Uagt3jg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

We have several sql "select ... from ... where ..." ,from
pg_stat_statements, we found the select sql has many shared_blks_dirtied,
shared_blks_written. is it by "hint bits" updates ? when checkpoint just
completed, we saw many wal_fpi , wal_bytes with this select sql too.

Thanks,

James

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Laurenz Albe 2024-02-20 08:34:03 Re: select statements have many shared_blks_dirtied and written
Previous Message Fabrice Chapuis 2024-02-20 07:47:52 pg_restore option --clean