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.postgresql.org/33/3130/ > > I pushed the

Re: more detailed description of tup_returned and tup_fetched

2021-06-30 Thread Fujii Masao
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.postgresql.org/33/3130/ I pushed the patch to 15dev. Thanks! Regards, -- Fujii Masao Advanced

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: >>> pg_stat_database.tup_fetched: >>> Number of index

Re: more detailed description of tup_returned and tup_fetched

2021-05-21 Thread Fujii Masao
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: pg_stat_database.tup_fetched: Number of index entries returned by scans on indexes in this database Is this the sum of

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 Is this the sum of pg_stat_all_indexes.idx_tup_read?

Re: more detailed description of tup_returned and tup_fetched

2021-05-20 Thread Fujii Masao
On 2021/05/20 9:46, Masahiro Ikeda wrote: 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, and

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, and pg_stat_all_tables.seq_tup_read is also

Re: more detailed description of tup_returned and tup_fetched

2021-05-18 Thread Fujii Masao
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, and pg_stat_all_tables.seq_tup_read is also incremented. I thought it's ok because Tid Range Scan is like sequential

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 scan. > > Yes, you're right. One

Re: more detailed description of tup_returned and tup_fetched

2021-05-18 Thread Fujii Masao
On 2021/05/18 13:20, Masahiro Ikeda wrote: 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, I worried the difference between "tup_returned" and "tup_fetched"

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, I worried the difference between "tup_returned" and "tup_fetched" in

Re: more detailed description of tup_returned and tup_fetched

2021-05-17 Thread Fujii Masao
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, I worried the difference between "tup_returned" and "tup_fetched" in pg_stat_database. I assumed that "tup_returned" means the number of tuples that

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 the number of tuples >> that returned to clients. Of course, this

Re: more detailed description of tup_returned and tup_fetched

2021-05-17 Thread Fujii Masao
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 the number of tuples that returned to clients. Of course, this is wrong. - Number of rows returned by queries in

more detailed description of tup_returned and tup_fetched

2021-05-14 Thread Masahiro Ikeda
Hi, I worried the difference between "tup_returned" and "tup_fetched" in pg_stat_database. I assumed that "tup_returned" means the number of tuples that returned to clients. Of course, this is wrong. So, why don't you describe in more detail? If my understanding is right, they correspond to