pgstatindex.c File Reference

#include "postgres.h"
#include "access/gin_private.h"
#include "access/hash.h"
#include "access/htup_details.h"
#include "access/nbtree.h"
#include "access/relation.h"
#include "access/table.h"
#include "catalog/namespace.h"
#include "catalog/pg_am.h"
#include "funcapi.h"
#include "miscadmin.h"
#include "storage/bufmgr.h"
#include "storage/lmgr.h"
#include "utils/builtins.h"
#include "utils/rel.h"
#include "utils/varlena.h"

Include dependency graph for pgstatindex.c:

Go to the source code of this file.

Data Structures
struct	BTIndexStat
struct	GinIndexStat
struct	HashIndexStat

Macros
#define	IS_INDEX(r)   ((r)->rd_rel->relkind == RELKIND_INDEX)
#define	IS_BTREE(r)   ((r)->rd_rel->relam == BTREE_AM_OID)
#define	IS_GIN(r)   ((r)->rd_rel->relam == GIN_AM_OID)
#define	IS_HASH(r)   ((r)->rd_rel->relam == HASH_AM_OID)

Typedefs
typedef struct BTIndexStat	BTIndexStat
typedef struct GinIndexStat	GinIndexStat
typedef struct HashIndexStat	HashIndexStat

Functions
	PG_FUNCTION_INFO_V1 (pgstatindex)
	PG_FUNCTION_INFO_V1 (pgstatindexbyid)
	PG_FUNCTION_INFO_V1 (pg_relpages)
	PG_FUNCTION_INFO_V1 (pg_relpagesbyid)
	PG_FUNCTION_INFO_V1 (pgstatginindex)
	PG_FUNCTION_INFO_V1 (pgstathashindex)
	PG_FUNCTION_INFO_V1 (pgstatindex_v1_5)
	PG_FUNCTION_INFO_V1 (pgstatindexbyid_v1_5)
	PG_FUNCTION_INFO_V1 (pg_relpages_v1_5)
	PG_FUNCTION_INFO_V1 (pg_relpagesbyid_v1_5)
	PG_FUNCTION_INFO_V1 (pgstatginindex_v1_5)
Datum	pgstatginindex_internal (Oid relid, FunctionCallInfo fcinfo)
static Datum	pgstatindex_impl (Relation rel, FunctionCallInfo fcinfo)
static int64	pg_relpages_impl (Relation rel)
static void	GetHashPageStats (Page page, HashIndexStat *stats)
Datum	pgstatindex (PG_FUNCTION_ARGS)
Datum	pgstatindex_v1_5 (PG_FUNCTION_ARGS)
Datum	pgstatindexbyid (PG_FUNCTION_ARGS)
Datum	pgstatindexbyid_v1_5 (PG_FUNCTION_ARGS)
Datum	pg_relpages (PG_FUNCTION_ARGS)
Datum	pg_relpages_v1_5 (PG_FUNCTION_ARGS)
Datum	pg_relpagesbyid (PG_FUNCTION_ARGS)
Datum	pg_relpagesbyid_v1_5 (PG_FUNCTION_ARGS)
Datum	pgstatginindex (PG_FUNCTION_ARGS)
Datum	pgstatginindex_v1_5 (PG_FUNCTION_ARGS)
Datum	pgstathashindex (PG_FUNCTION_ARGS)

Macro Definition Documentation

IS_BTREE

#define IS_BTREE

(

r

)

((r)->rd_rel->relam == BTREE_AM_OID)

Definition at line 71 of file pgstatindex.c.

IS_GIN

#define IS_GIN

(

r

)

((r)->rd_rel->relam == GIN_AM_OID)

Definition at line 72 of file pgstatindex.c.

IS_HASH

#define IS_HASH

(

r

)

((r)->rd_rel->relam == HASH_AM_OID)

Definition at line 73 of file pgstatindex.c.

IS_INDEX

#define IS_INDEX

(

r

)

((r)->rd_rel->relkind == RELKIND_INDEX)

Definition at line 70 of file pgstatindex.c.

Typedef Documentation

BTIndexStat

typedef struct BTIndexStat BTIndexStat

GinIndexStat

typedef struct GinIndexStat GinIndexStat

HashIndexStat

typedef struct HashIndexStat HashIndexStat

Function Documentation

GetHashPageStats()

static void GetHashPageStats ( Page  page, HashIndexStat *  stats  )

static

Definition at line 720 of file pgstatindex.c.

{
    OffsetNumber maxoff = PageGetMaxOffsetNumber(page);
    int         off;
 
    /* count live and dead tuples, and free space */
    for (off = FirstOffsetNumber; off <= maxoff; off++)
    {
        ItemId      id = PageGetItemId(page, off);
 
        if (!ItemIdIsDead(id))
            stats->live_items++;
        else
            stats->dead_items++;
    }
    stats->free_space += PageGetExactFreeSpace(page);
}

References HashIndexStat::dead_items, FirstOffsetNumber, HashIndexStat::free_space, ItemIdIsDead, HashIndexStat::live_items, PageGetExactFreeSpace(), PageGetItemId(), and PageGetMaxOffsetNumber().

Referenced by pgstathashindex().

PG_FUNCTION_INFO_V1() [1/11]

PG_FUNCTION_INFO_V1

(

pg_relpages

)

PG_FUNCTION_INFO_V1() [2/11]

PG_FUNCTION_INFO_V1

(

pg_relpages_v1_5

)

PG_FUNCTION_INFO_V1() [3/11]

PG_FUNCTION_INFO_V1

(

pg_relpagesbyid

)

PG_FUNCTION_INFO_V1() [4/11]

PG_FUNCTION_INFO_V1

(

pg_relpagesbyid_v1_5

)

PG_FUNCTION_INFO_V1() [5/11]

PG_FUNCTION_INFO_V1

(

pgstatginindex

)

PG_FUNCTION_INFO_V1() [6/11]

PG_FUNCTION_INFO_V1

(

pgstatginindex_v1_5

)

PG_FUNCTION_INFO_V1() [7/11]

PG_FUNCTION_INFO_V1

(

pgstathashindex

)

PG_FUNCTION_INFO_V1() [8/11]

PG_FUNCTION_INFO_V1

(

pgstatindex

)

PG_FUNCTION_INFO_V1() [9/11]

PG_FUNCTION_INFO_V1

(

pgstatindex_v1_5

)

PG_FUNCTION_INFO_V1() [10/11]

PG_FUNCTION_INFO_V1

(

pgstatindexbyid

)

PG_FUNCTION_INFO_V1() [11/11]

PG_FUNCTION_INFO_V1

(

pgstatindexbyid_v1_5

)

pg_relpages()

Datum pg_relpages

(

PG_FUNCTION_ARGS

)

Definition at line 383 of file pgstatindex.c.

{
    text       *relname = PG_GETARG_TEXT_PP(0);
    Relation    rel;
    RangeVar   *relrv;
 
    if (!superuser())
        ereport(ERROR,
                (errcode(ERRCODE_INSUFFICIENT_PRIVILEGE),
                 errmsg("must be superuser to use pgstattuple functions")));
 
    relrv = makeRangeVarFromNameList(textToQualifiedNameList(relname));
    rel = relation_openrv(relrv, AccessShareLock);
 
    PG_RETURN_INT64(pg_relpages_impl(rel));
}

References AccessShareLock, ereport, errcode(), errmsg(), ERROR, makeRangeVarFromNameList(), PG_GETARG_TEXT_PP, pg_relpages_impl(), PG_RETURN_INT64, relation_openrv(), relname, superuser(), and textToQualifiedNameList().

pg_relpages_impl()

static int64 pg_relpages_impl ( Relation  rel )

static

Definition at line 444 of file pgstatindex.c.

{
    int64       relpages;
 
    if (!RELKIND_HAS_STORAGE(rel->rd_rel->relkind))
        ereport(ERROR,
                (errcode(ERRCODE_WRONG_OBJECT_TYPE),
                 errmsg("cannot get page count of relation \"%s\"",
                        RelationGetRelationName(rel)),
                 errdetail_relkind_not_supported(rel->rd_rel->relkind)));
 
    /* note: this will work OK on non-local temp tables */
 
    relpages = RelationGetNumberOfBlocks(rel);
 
    relation_close(rel, AccessShareLock);
 
    return relpages;
}

References AccessShareLock, ereport, errcode(), errdetail_relkind_not_supported(), errmsg(), ERROR, RelationData::rd_rel, relation_close(), RelationGetNumberOfBlocks, and RelationGetRelationName.

Referenced by pg_relpages(), pg_relpages_v1_5(), pg_relpagesbyid(), and pg_relpagesbyid_v1_5().

pg_relpages_v1_5()

Datum pg_relpages_v1_5

(

PG_FUNCTION_ARGS

)

Definition at line 402 of file pgstatindex.c.

{
    text       *relname = PG_GETARG_TEXT_PP(0);
    Relation    rel;
    RangeVar   *relrv;
 
    relrv = makeRangeVarFromNameList(textToQualifiedNameList(relname));
    rel = relation_openrv(relrv, AccessShareLock);
 
    PG_RETURN_INT64(pg_relpages_impl(rel));
}

References AccessShareLock, makeRangeVarFromNameList(), PG_GETARG_TEXT_PP, pg_relpages_impl(), PG_RETURN_INT64, relation_openrv(), relname, and textToQualifiedNameList().

pg_relpagesbyid()

Datum pg_relpagesbyid

(

PG_FUNCTION_ARGS

)

Definition at line 416 of file pgstatindex.c.

{
    Oid         relid = PG_GETARG_OID(0);
    Relation    rel;
 
    if (!superuser())
        ereport(ERROR,
                (errcode(ERRCODE_INSUFFICIENT_PRIVILEGE),
                 errmsg("must be superuser to use pgstattuple functions")));
 
    rel = relation_open(relid, AccessShareLock);
 
    PG_RETURN_INT64(pg_relpages_impl(rel));
}

References AccessShareLock, ereport, errcode(), errmsg(), ERROR, PG_GETARG_OID, pg_relpages_impl(), PG_RETURN_INT64, relation_open(), and superuser().

pg_relpagesbyid_v1_5()

Datum pg_relpagesbyid_v1_5

(

PG_FUNCTION_ARGS

)

Definition at line 433 of file pgstatindex.c.

{
    Oid         relid = PG_GETARG_OID(0);
    Relation    rel;
 
    rel = relation_open(relid, AccessShareLock);
 
    PG_RETURN_INT64(pg_relpages_impl(rel));
}

References AccessShareLock, PG_GETARG_OID, pg_relpages_impl(), PG_RETURN_INT64, and relation_open().

pgstatginindex()

Datum pgstatginindex

(

PG_FUNCTION_ARGS

)

Definition at line 473 of file pgstatindex.c.

{
    Oid         relid = PG_GETARG_OID(0);
 
    if (!superuser())
        ereport(ERROR,
                (errcode(ERRCODE_INSUFFICIENT_PRIVILEGE),
                 errmsg("must be superuser to use pgstattuple functions")));
 
    PG_RETURN_DATUM(pgstatginindex_internal(relid, fcinfo));
}

References ereport, errcode(), errmsg(), ERROR, PG_GETARG_OID, PG_RETURN_DATUM, pgstatginindex_internal(), and superuser().

pgstatginindex_internal()

Datum pgstatginindex_internal	(	Oid	relid,
		FunctionCallInfo	fcinfo
	)

Definition at line 495 of file pgstatindex.c.

{
    Relation    rel;
    Buffer      buffer;
    Page        page;
    GinMetaPageData *metadata;
    GinIndexStat stats;
    HeapTuple   tuple;
    TupleDesc   tupleDesc;
    Datum       values[3];
    bool        nulls[3] = {false, false, false};
    Datum       result;
 
    rel = relation_open(relid, AccessShareLock);
 
    if (!IS_INDEX(rel) || !IS_GIN(rel))
        ereport(ERROR,
                (errcode(ERRCODE_WRONG_OBJECT_TYPE),
                 errmsg("relation \"%s\" is not a GIN index",
                        RelationGetRelationName(rel))));
 
    /*
     * Reject attempts to read non-local temporary relations; we would be
     * likely to get wrong data since we have no visibility into the owning
     * session's local buffers.
     */
    if (RELATION_IS_OTHER_TEMP(rel))
        ereport(ERROR,
                (errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
                 errmsg("cannot access temporary indexes of other sessions")));
 
    /*
     * Read metapage
     */
    buffer = ReadBuffer(rel, GIN_METAPAGE_BLKNO);
    LockBuffer(buffer, GIN_SHARE);
    page = BufferGetPage(buffer);
    metadata = GinPageGetMeta(page);
 
    stats.version = metadata->ginVersion;
    stats.pending_pages = metadata->nPendingPages;
    stats.pending_tuples = metadata->nPendingHeapTuples;
 
    UnlockReleaseBuffer(buffer);
    relation_close(rel, AccessShareLock);
 
    /*
     * Build a tuple descriptor for our result type
     */
    if (get_call_result_type(fcinfo, NULL, &tupleDesc) != TYPEFUNC_COMPOSITE)
        elog(ERROR, "return type must be a row type");
 
    values[0] = Int32GetDatum(stats.version);
    values[1] = UInt32GetDatum(stats.pending_pages);
    values[2] = Int64GetDatum(stats.pending_tuples);
 
    /*
     * Build and return the tuple
     */
    tuple = heap_form_tuple(tupleDesc, values, nulls);
    result = HeapTupleGetDatum(tuple);
 
    return result;
}

References AccessShareLock, BufferGetPage(), elog(), ereport, errcode(), errmsg(), ERROR, get_call_result_type(), GIN_METAPAGE_BLKNO, GIN_SHARE, GinPageGetMeta, GinMetaPageData::ginVersion, heap_form_tuple(), HeapTupleGetDatum(), Int32GetDatum(), Int64GetDatum(), IS_GIN, IS_INDEX, LockBuffer(), GinMetaPageData::nPendingHeapTuples, GinMetaPageData::nPendingPages, GinIndexStat::pending_pages, GinIndexStat::pending_tuples, ReadBuffer(), relation_close(), RELATION_IS_OTHER_TEMP, relation_open(), RelationGetRelationName, TYPEFUNC_COMPOSITE, UInt32GetDatum(), UnlockReleaseBuffer(), values, and GinIndexStat::version.

Referenced by pgstatginindex(), and pgstatginindex_v1_5().

pgstatginindex_v1_5()

Datum pgstatginindex_v1_5

(

PG_FUNCTION_ARGS

)

Definition at line 487 of file pgstatindex.c.

{
    Oid         relid = PG_GETARG_OID(0);
 
    PG_RETURN_DATUM(pgstatginindex_internal(relid, fcinfo));
}

References PG_GETARG_OID, PG_RETURN_DATUM, and pgstatginindex_internal().

pgstathashindex()

Datum pgstathashindex

(

PG_FUNCTION_ARGS

)

Definition at line 567 of file pgstatindex.c.

{
    Oid         relid = PG_GETARG_OID(0);
    BlockNumber nblocks;
    BlockNumber blkno;
    Relation    rel;
    HashIndexStat stats;
    BufferAccessStrategy bstrategy;
    HeapTuple   tuple;
    TupleDesc   tupleDesc;
    Datum       values[8];
    bool        nulls[8] = {0};
    Buffer      metabuf;
    HashMetaPage metap;
    float8      free_percent;
    uint64      total_space;
 
    rel = index_open(relid, AccessShareLock);
 
    /* index_open() checks that it's an index */
    if (!IS_HASH(rel))
        ereport(ERROR,
                (errcode(ERRCODE_WRONG_OBJECT_TYPE),
                 errmsg("relation \"%s\" is not a hash index",
                        RelationGetRelationName(rel))));
 
    /*
     * Reject attempts to read non-local temporary relations; we would be
     * likely to get wrong data since we have no visibility into the owning
     * session's local buffers.
     */
    if (RELATION_IS_OTHER_TEMP(rel))
        ereport(ERROR,
                (errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
                 errmsg("cannot access temporary indexes of other sessions")));
 
    /* Get the information we need from the metapage. */
    memset(&stats, 0, sizeof(stats));
    metabuf = _hash_getbuf(rel, HASH_METAPAGE, HASH_READ, LH_META_PAGE);
    metap = HashPageGetMeta(BufferGetPage(metabuf));
    stats.version = metap->hashm_version;
    stats.space_per_page = metap->hashm_bsize;
    _hash_relbuf(rel, metabuf);
 
    /* Get the current relation length */
    nblocks = RelationGetNumberOfBlocks(rel);
 
    /* prepare access strategy for this index */
    bstrategy = GetAccessStrategy(BAS_BULKREAD);
 
    /* Start from blkno 1 as 0th block is metapage */
    for (blkno = 1; blkno < nblocks; blkno++)
    {
        Buffer      buf;
        Page        page;
 
        CHECK_FOR_INTERRUPTS();
 
        buf = ReadBufferExtended(rel, MAIN_FORKNUM, blkno, RBM_NORMAL,
                                 bstrategy);
        LockBuffer(buf, BUFFER_LOCK_SHARE);
        page = (Page) BufferGetPage(buf);
 
        if (PageIsNew(page))
            stats.unused_pages++;
        else if (PageGetSpecialSize(page) !=
                 MAXALIGN(sizeof(HashPageOpaqueData)))
            ereport(ERROR,
                    (errcode(ERRCODE_INDEX_CORRUPTED),
                     errmsg("index \"%s\" contains corrupted page at block %u",
                            RelationGetRelationName(rel),
                            BufferGetBlockNumber(buf))));
        else
        {
            HashPageOpaque opaque;
            int         pagetype;
 
            opaque = HashPageGetOpaque(page);
            pagetype = opaque->hasho_flag & LH_PAGE_TYPE;
 
            if (pagetype == LH_BUCKET_PAGE)
            {
                stats.bucket_pages++;
                GetHashPageStats(page, &stats);
            }
            else if (pagetype == LH_OVERFLOW_PAGE)
            {
                stats.overflow_pages++;
                GetHashPageStats(page, &stats);
            }
            else if (pagetype == LH_BITMAP_PAGE)
                stats.bitmap_pages++;
            else if (pagetype == LH_UNUSED_PAGE)
                stats.unused_pages++;
            else
                ereport(ERROR,
                        (errcode(ERRCODE_INDEX_CORRUPTED),
                         errmsg("unexpected page type 0x%04X in HASH index \"%s\" block %u",
                                opaque->hasho_flag, RelationGetRelationName(rel),
                                BufferGetBlockNumber(buf))));
        }
        UnlockReleaseBuffer(buf);
    }
 
    /* Done accessing the index */
    index_close(rel, AccessShareLock);
 
    /* Count unused pages as free space. */
    stats.free_space += (uint64) stats.unused_pages * stats.space_per_page;
 
    /*
     * Total space available for tuples excludes the metapage and the bitmap
     * pages.
     */
    total_space = (uint64) (nblocks - (stats.bitmap_pages + 1)) *
        stats.space_per_page;
 
    if (total_space == 0)
        free_percent = 0.0;
    else
        free_percent = 100.0 * stats.free_space / total_space;
 
    /*
     * Build a tuple descriptor for our result type
     */
    if (get_call_result_type(fcinfo, NULL, &tupleDesc) != TYPEFUNC_COMPOSITE)
        elog(ERROR, "return type must be a row type");
 
    tupleDesc = BlessTupleDesc(tupleDesc);
 
    /*
     * Build and return the tuple
     */
    values[0] = Int32GetDatum(stats.version);
    values[1] = Int64GetDatum((int64) stats.bucket_pages);
    values[2] = Int64GetDatum((int64) stats.overflow_pages);
    values[3] = Int64GetDatum((int64) stats.bitmap_pages);
    values[4] = Int64GetDatum((int64) stats.unused_pages);
    values[5] = Int64GetDatum(stats.live_items);
    values[6] = Int64GetDatum(stats.dead_items);
    values[7] = Float8GetDatum(free_percent);
    tuple = heap_form_tuple(tupleDesc, values, nulls);
 
    PG_RETURN_DATUM(HeapTupleGetDatum(tuple));
}

References _hash_getbuf(), _hash_relbuf(), AccessShareLock, BAS_BULKREAD, HashIndexStat::bitmap_pages, BlessTupleDesc(), HashIndexStat::bucket_pages, buf, BUFFER_LOCK_SHARE, BufferGetBlockNumber(), BufferGetPage(), CHECK_FOR_INTERRUPTS, HashIndexStat::dead_items, elog(), ereport, errcode(), errmsg(), ERROR, Float8GetDatum(), HashIndexStat::free_space, get_call_result_type(), GetAccessStrategy(), GetHashPageStats(), HASH_METAPAGE, HASH_READ, HashMetaPageData::hashm_bsize, HashMetaPageData::hashm_version, HashPageOpaqueData::hasho_flag, HashPageGetMeta, HashPageGetOpaque, heap_form_tuple(), HeapTupleGetDatum(), if(), index_close(), index_open(), Int32GetDatum(), Int64GetDatum(), IS_HASH, LH_BITMAP_PAGE, LH_BUCKET_PAGE, LH_META_PAGE, LH_OVERFLOW_PAGE, LH_PAGE_TYPE, LH_UNUSED_PAGE, HashIndexStat::live_items, LockBuffer(), MAIN_FORKNUM, MAXALIGN, HashIndexStat::overflow_pages, PageGetSpecialSize(), PageIsNew(), PG_GETARG_OID, PG_RETURN_DATUM, RBM_NORMAL, ReadBufferExtended(), RELATION_IS_OTHER_TEMP, RelationGetNumberOfBlocks, RelationGetRelationName, HashIndexStat::space_per_page, TYPEFUNC_COMPOSITE, UnlockReleaseBuffer(), HashIndexStat::unused_pages, values, and HashIndexStat::version.

pgstatindex()

Datum pgstatindex

(

PG_FUNCTION_ARGS

)

Definition at line 145 of file pgstatindex.c.

{
    text       *relname = PG_GETARG_TEXT_PP(0);
    Relation    rel;
    RangeVar   *relrv;
 
    if (!superuser())
        ereport(ERROR,
                (errcode(ERRCODE_INSUFFICIENT_PRIVILEGE),
                 errmsg("must be superuser to use pgstattuple functions")));
 
    relrv = makeRangeVarFromNameList(textToQualifiedNameList(relname));
    rel = relation_openrv(relrv, AccessShareLock);
 
    PG_RETURN_DATUM(pgstatindex_impl(rel, fcinfo));
}

References AccessShareLock, ereport, errcode(), errmsg(), ERROR, makeRangeVarFromNameList(), PG_GETARG_TEXT_PP, PG_RETURN_DATUM, pgstatindex_impl(), relation_openrv(), relname, superuser(), and textToQualifiedNameList().

pgstatindex_impl()

static Datum pgstatindex_impl ( Relation  rel, FunctionCallInfo  fcinfo  )

static

Definition at line 216 of file pgstatindex.c.

{
    Datum       result;
    BlockNumber nblocks;
    BlockNumber blkno;
    BTIndexStat indexStat;
    BufferAccessStrategy bstrategy = GetAccessStrategy(BAS_BULKREAD);
 
    if (!IS_INDEX(rel) || !IS_BTREE(rel))
        ereport(ERROR,
                (errcode(ERRCODE_WRONG_OBJECT_TYPE),
                 errmsg("relation \"%s\" is not a btree index",
                        RelationGetRelationName(rel))));
 
    /*
     * Reject attempts to read non-local temporary relations; we would be
     * likely to get wrong data since we have no visibility into the owning
     * session's local buffers.
     */
    if (RELATION_IS_OTHER_TEMP(rel))
        ereport(ERROR,
                (errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
                 errmsg("cannot access temporary tables of other sessions")));
 
    /*
     * Read metapage
     */
    {
        Buffer      buffer = ReadBufferExtended(rel, MAIN_FORKNUM, 0, RBM_NORMAL, bstrategy);
        Page        page = BufferGetPage(buffer);
        BTMetaPageData *metad = BTPageGetMeta(page);
 
        indexStat.version = metad->btm_version;
        indexStat.level = metad->btm_level;
        indexStat.root_blkno = metad->btm_root;
 
        ReleaseBuffer(buffer);
    }
 
    /* -- init counters -- */
    indexStat.internal_pages = 0;
    indexStat.leaf_pages = 0;
    indexStat.empty_pages = 0;
    indexStat.deleted_pages = 0;
 
    indexStat.max_avail = 0;
    indexStat.free_space = 0;
 
    indexStat.fragments = 0;
 
    /*
     * Scan all blocks except the metapage
     */
    nblocks = RelationGetNumberOfBlocks(rel);
 
    for (blkno = 1; blkno < nblocks; blkno++)
    {
        Buffer      buffer;
        Page        page;
        BTPageOpaque opaque;
 
        CHECK_FOR_INTERRUPTS();
 
        /* Read and lock buffer */
        buffer = ReadBufferExtended(rel, MAIN_FORKNUM, blkno, RBM_NORMAL, bstrategy);
        LockBuffer(buffer, BUFFER_LOCK_SHARE);
 
        page = BufferGetPage(buffer);
        opaque = BTPageGetOpaque(page);
 
        /*
         * Determine page type, and update totals.
         *
         * Note that we arbitrarily bucket deleted pages together without
         * considering if they're leaf pages or internal pages.
         */
        if (P_ISDELETED(opaque))
            indexStat.deleted_pages++;
        else if (P_IGNORE(opaque))
            indexStat.empty_pages++;    /* this is the "half dead" state */
        else if (P_ISLEAF(opaque))
        {
            int         max_avail;
 
            max_avail = BLCKSZ - (BLCKSZ - ((PageHeader) page)->pd_special + SizeOfPageHeaderData);
            indexStat.max_avail += max_avail;
            indexStat.free_space += PageGetFreeSpace(page);
 
            indexStat.leaf_pages++;
 
            /*
             * If the next leaf is on an earlier block, it means a
             * fragmentation.
             */
            if (opaque->btpo_next != P_NONE && opaque->btpo_next < blkno)
                indexStat.fragments++;
        }
        else
            indexStat.internal_pages++;
 
        /* Unlock and release buffer */
        LockBuffer(buffer, BUFFER_LOCK_UNLOCK);
        ReleaseBuffer(buffer);
    }
 
    relation_close(rel, AccessShareLock);
 
    /*----------------------------
     * Build a result tuple
     *----------------------------
     */
    {
        TupleDesc   tupleDesc;
        int         j;
        char       *values[10];
        HeapTuple   tuple;
 
        /* Build a tuple descriptor for our result type */
        if (get_call_result_type(fcinfo, NULL, &tupleDesc) != TYPEFUNC_COMPOSITE)
            elog(ERROR, "return type must be a row type");
 
        j = 0;
        values[j++] = psprintf("%d", indexStat.version);
        values[j++] = psprintf("%d", indexStat.level);
        values[j++] = psprintf(INT64_FORMAT,
                               (1 + /* include the metapage in index_size */
                                indexStat.leaf_pages +
                                indexStat.internal_pages +
                                indexStat.deleted_pages +
                                indexStat.empty_pages) * BLCKSZ);
        values[j++] = psprintf("%u", indexStat.root_blkno);
        values[j++] = psprintf(INT64_FORMAT, indexStat.internal_pages);
        values[j++] = psprintf(INT64_FORMAT, indexStat.leaf_pages);
        values[j++] = psprintf(INT64_FORMAT, indexStat.empty_pages);
        values[j++] = psprintf(INT64_FORMAT, indexStat.deleted_pages);
        if (indexStat.max_avail > 0)
            values[j++] = psprintf("%.2f",
                                   100.0 - (double) indexStat.free_space / (double) indexStat.max_avail * 100.0);
        else
            values[j++] = pstrdup("NaN");
        if (indexStat.leaf_pages > 0)
            values[j++] = psprintf("%.2f",
                                   (double) indexStat.fragments / (double) indexStat.leaf_pages * 100.0);
        else
            values[j++] = pstrdup("NaN");
 
        tuple = BuildTupleFromCStrings(TupleDescGetAttInMetadata(tupleDesc),
                                       values);
 
        result = HeapTupleGetDatum(tuple);
    }
 
    return result;
}

References AccessShareLock, BAS_BULKREAD, BTMetaPageData::btm_level, BTMetaPageData::btm_root, BTMetaPageData::btm_version, BTPageGetMeta, BTPageGetOpaque, BTPageOpaqueData::btpo_next, BUFFER_LOCK_SHARE, BUFFER_LOCK_UNLOCK, BufferGetPage(), BuildTupleFromCStrings(), CHECK_FOR_INTERRUPTS, BTIndexStat::deleted_pages, elog(), BTIndexStat::empty_pages, ereport, errcode(), errmsg(), ERROR, BTIndexStat::fragments, BTIndexStat::free_space, get_call_result_type(), GetAccessStrategy(), HeapTupleGetDatum(), INT64_FORMAT, BTIndexStat::internal_pages, IS_BTREE, IS_INDEX, j, BTIndexStat::leaf_pages, BTIndexStat::level, LockBuffer(), MAIN_FORKNUM, BTIndexStat::max_avail, P_IGNORE, P_ISDELETED, P_ISLEAF, P_NONE, PageGetFreeSpace(), psprintf(), pstrdup(), RBM_NORMAL, ReadBufferExtended(), relation_close(), RELATION_IS_OTHER_TEMP, RelationGetNumberOfBlocks, RelationGetRelationName, ReleaseBuffer(), BTIndexStat::root_blkno, SizeOfPageHeaderData, TupleDescGetAttInMetadata(), TYPEFUNC_COMPOSITE, values, and BTIndexStat::version.

Referenced by pgstatindex(), pgstatindex_v1_5(), pgstatindexbyid(), and pgstatindexbyid_v1_5().

pgstatindex_v1_5()

Datum pgstatindex_v1_5

(

PG_FUNCTION_ARGS

)

Definition at line 170 of file pgstatindex.c.

{
    text       *relname = PG_GETARG_TEXT_PP(0);
    Relation    rel;
    RangeVar   *relrv;
 
    relrv = makeRangeVarFromNameList(textToQualifiedNameList(relname));
    rel = relation_openrv(relrv, AccessShareLock);
 
    PG_RETURN_DATUM(pgstatindex_impl(rel, fcinfo));
}

References AccessShareLock, makeRangeVarFromNameList(), PG_GETARG_TEXT_PP, PG_RETURN_DATUM, pgstatindex_impl(), relation_openrv(), relname, and textToQualifiedNameList().

pgstatindexbyid()

Datum pgstatindexbyid

(

PG_FUNCTION_ARGS

)

Definition at line 188 of file pgstatindex.c.

{
    Oid         relid = PG_GETARG_OID(0);
    Relation    rel;
 
    if (!superuser())
        ereport(ERROR,
                (errcode(ERRCODE_INSUFFICIENT_PRIVILEGE),
                 errmsg("must be superuser to use pgstattuple functions")));
 
    rel = relation_open(relid, AccessShareLock);
 
    PG_RETURN_DATUM(pgstatindex_impl(rel, fcinfo));
}

References AccessShareLock, ereport, errcode(), errmsg(), ERROR, PG_GETARG_OID, PG_RETURN_DATUM, pgstatindex_impl(), relation_open(), and superuser().

pgstatindexbyid_v1_5()

Datum pgstatindexbyid_v1_5

(

PG_FUNCTION_ARGS

)

Definition at line 205 of file pgstatindex.c.

{
    Oid         relid = PG_GETARG_OID(0);
    Relation    rel;
 
    rel = relation_open(relid, AccessShareLock);
 
    PG_RETURN_DATUM(pgstatindex_impl(rel, fcinfo));
}

References AccessShareLock, PG_GETARG_OID, PG_RETURN_DATUM, pgstatindex_impl(), and relation_open().