Re: Occupation bloc in pages of table

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: luchot(at)voila(dot)fr
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Occupation bloc in pages of table
Date: 2006-06-23 16:09:41
Message-ID: 16264.1151078981@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

luchot <luchot(at)voila(dot)fr> writes:
> I would want if it is possible for each pages of a table to have the occupation of blocs in percentage in order to see if the page is good full or not.

There is not any magic way of getting that information, but you could
modify contrib/pgstattuple to produce such a report.

regards, tom lane

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Daniel Xavier de Sousa 2006-06-23 18:32:35 Buffers to Nest Loop Join
Previous Message Markus Schaber 2006-06-23 12:40:47 Re: Help tuning autovacuum - seeing lots of relationbloat