Re: EXPLAIN: showing ReadStream / prefetch stats

Поиск
Список
Период
Сортировка
От Tomas Vondra
Тема Re: EXPLAIN: showing ReadStream / prefetch stats
Дата
Msg-id 0fa0794e-7e34-4fdb-8e35-a59ef8ce5246@vondra.me
обсуждение
Ответ на Re: EXPLAIN: showing ReadStream / prefetch stats  (Tomas Vondra <tomas@vondra.me>)
Ответы Re: EXPLAIN: showing ReadStream / prefetch stats
Список pgsql-hackers
On 3/16/26 18:49, Tomas Vondra wrote:
> On 3/16/26 18:14, Melanie Plageman wrote:
>> ...
>>
>> I see a couple more issues with the counting in read_stream.c.
>>
>> You are double-counting stalls for synchronous IO. You increment
>> stalls in read_stream_next_buffer() but we actually execute
>> synchronous IO in WaitReadBuffers and return needed_wait as true,
>> which will count a stall again.
>>
>> You are not counting fast path IOs because those don't go through
>> read_stream_start_pending_read() and instead are started directly by
>> StartReadBuffer() in read_stream_next_buffer(). Simple diff attached
>> should fix this.
>>
>> Also, per worker stats are not displayed when BUFFERS false is passed
>> even with IO true because of a small oversight. I fixed it in the
>> attached diff.
>>
> 
> Thanks!
> 

Here's a v2 with your fixes merged. No other changes.


regards

-- 
Tomas Vondra

Вложения

В списке pgsql-hackers по дате отправления: