How to know detailed information about HOT(Heap-Only Tuples)?

From: 高健 <luckyjackgao(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: How to know detailed information about HOT(Heap-Only Tuples)?
Date: 2013-08-22 02:20:43
Message-ID: CAL454F0CMm=BKStXwCyKv-Teg4UhyBjnq=qigYw+stqK8DXFRQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi:

I have heard that Heap-Only Tuples is introduce from 8.3.
And I am searching information for it.

How can I get a detailed information of HOT?
For example:
according to a table, How many tuples are heap only tuples , and how many
are not?

And also , Is there any options which can influence HOT occurrance?

Best Regards

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Raghavendra 2013-08-22 03:48:33 Re: PostgreSQL 9.2 Logging
Previous Message Nik Tek 2013-08-22 01:05:52 Re: No caching sql query