pgstattuple module
Hi,
I have tested "pgstattuple" with lot of scenarios & want to clarify some
of the things.
In the Readme file you have explained clearly about pgstattuple
function. I mean explanation for each column.
But for some of the functions like btree index metapage,single btree
pages,bt page items are not clear to me.
I have gone through the portal also but unable to find correct
information. So if you have any links or document for the above
functions please share with me. Actually I want to understand what these
columns are & the sizes are in (KB, bytes)
Thanks & Regards
M.AHRAM KHAN
Khan, Mahmood Ahram wrote:
But for some of the functions like btree index metapage,single btree
pages,bt page items are not clear to me.
Those functions display the contents of b-tree pages. They're really
meant for debugging purposes. You'll need to understand the internal
structure of a b-tree index to make sense of the output. The b-tree
internals are explained in the source tree, in
src/backend/access/nbtree/README, and the source files in the same
directory.
In fact, in 8.3, those functions have been moved to a new, separate
contrib module called pageinspect, along with similar functions for
debugging heap contents. Hopefully that makes the distinction between
functions useful for DBAs and functions useful for developers more clear.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com