Re: more detailed description of tup_returned and tup_fetched

2021-06-30 Thread Masahiro Ikeda
On 2021/06/30 20:59, Fujii Masao wrote: > > > On 2021/05/24 11:37, Masahiro Ikeda wrote: >> Thanks for checking the patch! >> I thought this patch will be applied in V15 dev cycle. >> >> OK. I added the patch to the next CF. >> https://commitfest.po

Re: more detailed description of tup_returned and tup_fetched

2021-05-23 Thread Masahiro Ikeda
On 2021/05/21 22:26, Fujii Masao wrote: > > > On 2021/05/20 17:38, Masahiro Ikeda wrote: >> >> >> On 2021/05/20 17:00, Fujii Masao wrote: >>> On 2021/05/20 9:46, Masahiro Ikeda wrote: >>>> On 2021/05/18 20:10, Fujii Masao wrote: >>>&

Re: more detailed description of tup_returned and tup_fetched

2021-05-20 Thread Masahiro Ikeda
On 2021/05/20 17:00, Fujii Masao wrote: > On 2021/05/20 9:46, Masahiro Ikeda wrote: >> On 2021/05/18 20:10, Fujii Masao wrote: >>>>> pg_stat_database.tup_fetched: >>>>> Number of index entries returned by scans on indexes in this database >>>>

Re: more detailed description of tup_returned and tup_fetched

2021-05-19 Thread Masahiro Ikeda
On 2021/05/18 20:10, Fujii Masao wrote: > > > On 2021/05/18 18:23, Masahiro Ikeda wrote: >> >> >> On 2021/05/18 16:01, Fujii Masao wrote: >>> On 2021/05/18 13:20, Masahiro Ikeda wrote: >>>> Tid Range Scan increments the tup_returned,

Re: more detailed description of tup_returned and tup_fetched

2021-05-18 Thread Masahiro Ikeda
On 2021/05/18 16:01, Fujii Masao wrote: > On 2021/05/18 13:20, Masahiro Ikeda wrote: >> Tid Range Scan increments the tup_returned, and >> pg_stat_all_tables.seq_tup_read is also incremented. I thought it's ok >> because >> Tid Range Scan is like sequential s

Re: more detailed description of tup_returned and tup_fetched

2021-05-17 Thread Masahiro Ikeda
On 2021/05/17 20:46, Fujii Masao wrote: > > > On 2021/05/17 18:58, Masahiro Ikeda wrote: >> >> >> On 2021/05/17 15:32, Fujii Masao wrote: >>> >>> >>> On 2021/05/14 17:00, Masahiro Ikeda wrote: >>>> Hi, >>>

Re: more detailed description of tup_returned and tup_fetched

2021-05-17 Thread Masahiro Ikeda
On 2021/05/17 15:32, Fujii Masao wrote: > > > On 2021/05/14 17:00, Masahiro Ikeda wrote: >> Hi, >> >> I worried the difference between "tup_returned" and "tup_fetched" in >> pg_stat_database. I assumed that "tup_returned" means th

more detailed description of tup_returned and tup_fetched

2021-05-14 Thread Masahiro Ikeda
anding is right, they correspond to "seq_tup_read" and "idx_tup_fetch" in pg_stat_all_tables. Regards, -- Masahiro Ikeda NTT DATA CORPORATION diff --git a/doc/src/sgml/monitoring.sgml b/doc/src/sgml/monitoring.sgml index dcbb10fb6f..09a22a43ac 100644 --- a/doc/src/sgml/monito