Postgres Pro
Downloads
Home   >   mailing lists

How to know detailed information about HOT(Heap-Only Tuples)? - Mailing list pgsql-general

From 高健
Subject How to know detailed information about HOT(Heap-Only Tuples)?
Date
Msg-id CAL454F0CMm=BKStXwCyKv-Teg4UhyBjnq=qigYw+stqK8DXFRQ@mail.gmail.com
Whole thread Raw
Responses Re: How to know detailed information about HOT(Heap-Only Tuples)?  (Luca Ferrari <fluca1978@infinito.it>)
Re: How to know detailed information about HOT(Heap-Only Tuples)?  (Adrian Klaver <adrian.klaver@gmail.com>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Nik Tek
Date:
Subject: Re: No caching sql query
Next
From: Raghavendra
Date:
Subject: Re: PostgreSQL 9.2 Logging