From: | Kashif Zeeshan <kashi(dot)zeeshan(at)gmail(dot)com> |
---|---|
To: | Dimitrios Apostolou <jimis(at)gmx(dot)net> |
Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: pg_stat_io clarifications: background worker, writes and reads |
Date: | 2024-05-15 04:03:55 |
Message-ID: | CAAPsdhc+Axq=ZbY2pOicU58asj4TJG9u9iR6PFMNiKP4yW3G+g@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi
background workers are used to perform tasks on db e.g. I/O, replication,
clone schema, vacuum etc, you can find more details on following links.
Regards
Kashif Zeeshan
Bitnine
On Wed, May 15, 2024 at 1:26 AM Dimitrios Apostolou <jimis(at)gmx(dot)net> wrote:
> Hello list,
>
> what is the "background worker" in the pg_stat_io statistics view? I'm
> reading the documentation but can't figure this one out knowing that it is
> not autovacuum or bgwriter. And I'm not aware of any extension I might
> have with registered background worker.
>
> Additionally, how can it be evictions > writes? I would expect every
> eviction to cause a write.
>
> Finally about "hits", I understand they are reads found in shared_buffers,
> so they never registered into the "reads" counter. So is "reads" in
> pg_stat_io the equivalent to misses, i.e. the opposite of "hits", the read
> attempts not found in the shared_buffers, that needed to be fetched from
> the disk (or OS buffercache)?
>
> backend_type | object | context | reads | read_time |
> writes | write_time | writebacks | writeback_time | extends | extend_time |
> op_bytes | hits | evictions | reuses | fsyncs | fsync_time |
> stats_reset
>
> -------------------+---------------+---------+---------+-------------+--------+------------+------------+----------------+---------+-------------+----------+-----------+-----------+--------+--------+------------+-------------------------------
> background worker | relation | normal | 5139575 | 2196288.011 |
> 63277 | 1766.94 | 0 | 0 | 0 | 0 |
> 8192 | 876913705 | 5139653 | | 0 | 0 | 2024-04-08
> 08:50:02.971192+00
>
>
> Thank you in advance,
> Dimitris
>
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Muhammad Imtiaz | 2024-05-15 04:21:52 | Re: pg_stat_io clarifications: background worker, writes and reads |
Previous Message | sud | 2024-05-15 03:02:50 | Re: Adding constraints faster |