Re: Buffer pool statistics in Explain Analyze

From: ITAGAKI Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
To: "Vladimir Sitnikov" <sitnikov(dot)vladimir(at)gmail(dot)com>
Cc: "Gregory Stark" <stark(at)enterprisedb(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Buffer pool statistics in Explain Analyze
Date: 2008-10-13 02:30:19
Message-ID: 20081013112341.8799.52131E4D@oss.ntt.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


"Vladimir Sitnikov" <sitnikov(dot)vladimir(at)gmail(dot)com> wrote:

> I've tried to use "ReadBufferCount and friends" from
> storage\buffer\buf_init.c, however it is showing zeroes for some unknown yet
> reason. Hope, there is no fundamental problem behind.

I think those vairables are hard to use and have no reliability
for your purpose.

How about adding buffer usage counters into HeapScanDesc and IndexScanDesc?
It requires only changes in ReadBufferWithStrategy and lower layer functions.

Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2008-10-13 03:12:29 A small note about the difficulty of managing subprojects
Previous Message ITAGAKI Takahiro 2008-10-13 01:36:59 Re: [PATCH] Extending pg_class info + more flexible TOAST chunk size