From 9e905f5552e767ed63cac78e424536c8104485f9 Mon Sep 17 00:00:00 2001 From: teodor Date: Tue, 27 Dec 2011 12:44:02 +0000 Subject: [PATCH] spgist_stat => README --- README.gevel | 25 +++++++++++++++++++++++-- 1 file changed, 23 insertions(+), 2 deletions(-) diff --git a/README.gevel b/README.gevel index 4d7c2a5..46e7619 100644 --- a/README.gevel +++ b/README.gevel @@ -2,12 +2,12 @@ Gevel contrib module provides several functions useful for analyzing GiST and GI [Online version] of this document (http://www.sai.msu.su/~megera/oddmuse/index.cgi/Gevel) -Caution: This module was designed for advanced users of GIN and GiST indices ! +Caution: This module was designed for advanced users of GIN, GiST and SP-GiST indices ! Authors * Oleg Bartunov , Moscow, Moscow University, Russia - * Teodor Sigaev , Moscow, Delta-Soft Ltd.,Russia + * Teodor Sigaev , Moscow, Moscow University, Russia License @@ -123,6 +123,27 @@ regression=# select gist_tree('pix'); 1 | t | (28048,49694),(25000,25000) (29 rows) + * spgist_stat(INDEXNAME) - show some statistics about SP-GiST tree + +# SELECT spgist_stat('spgist_idx'); + spgist_stat +---------------------------------- + totalPages: 21 + + deletedPages: 0 + + innerPages: 3 + + leafPages: 18 + + emptyPages: 1 + + usedSpace: 121.27 kbytes+ + freeSpace: 46.07 kbytes + + fillRatio: 72.47% + + leafTuples: 3669 + + innerTuples: 20 + + innerAllTheSame: 0 + + leafPlaceholders: 569 + + innerPlaceholders: 0 + + leafRedirects: 0 + + innerRedirects: 0 + * gin_stat(INDEXNAME) prints estimated counts for each indexed values Note: since 8.4 gin_stat function has gin_stat(INDEXNAME, COLNUMBER) prototype, single-argument function will return result for a first -- 2.46.1