relation_stats.c

Go to the documentation of this file.

/*-------------------------------------------------------------------------
 * relation_stats.c
 *
 *    PostgreSQL relation statistics manipulation
 *
 * Code supporting the direct import of relation statistics, similar to
 * what is done by the ANALYZE command.
 *
 * Portions Copyright (c) 1996-2025, PostgreSQL Global Development Group
 * Portions Copyright (c) 1994, Regents of the University of California
 *
 * IDENTIFICATION
 *       src/backend/statistics/relation_stats.c
 *
 *-------------------------------------------------------------------------
 */
 
#include "postgres.h"
 
#include "access/heapam.h"
#include "catalog/indexing.h"
#include "catalog/namespace.h"
#include "statistics/stat_utils.h"
#include "utils/builtins.h"
#include "utils/fmgroids.h"
#include "utils/fmgrprotos.h"
#include "utils/lsyscache.h"
#include "utils/syscache.h"
 
 
/*
 * Positional argument numbers, names, and types for
 * relation_statistics_update().
 */
 
enum relation_stats_argnum
{
    RELSCHEMA_ARG = 0,
    RELNAME_ARG,
    RELPAGES_ARG,
    RELTUPLES_ARG,
    RELALLVISIBLE_ARG,
    RELALLFROZEN_ARG,
    NUM_RELATION_STATS_ARGS
};
 
static struct StatsArgInfo relarginfo[] =
{
    [RELSCHEMA_ARG] = {"schemaname", TEXTOID},
    [RELNAME_ARG] = {"relname", TEXTOID},
    [RELPAGES_ARG] = {"relpages", INT4OID},
    [RELTUPLES_ARG] = {"reltuples", FLOAT4OID},
    [RELALLVISIBLE_ARG] = {"relallvisible", INT4OID},
    [RELALLFROZEN_ARG] = {"relallfrozen", INT4OID},
    [NUM_RELATION_STATS_ARGS] = {0}
};
 
static bool relation_statistics_update(FunctionCallInfo fcinfo);
 
/*
 * Internal function for modifying statistics for a relation.
 */
static bool
relation_statistics_update(FunctionCallInfo fcinfo)
{
    bool        result = true;
    char       *nspname;
    char       *relname;
    Oid         reloid;
    Relation    crel;
    BlockNumber relpages = 0;
    bool        update_relpages = false;
    float       reltuples = 0;
    bool        update_reltuples = false;
    BlockNumber relallvisible = 0;
    bool        update_relallvisible = false;
    BlockNumber relallfrozen = 0;
    bool        update_relallfrozen = false;
    HeapTuple   ctup;
    Form_pg_class pgcform;
    int         replaces[4] = {0};
    Datum       values[4] = {0};
    bool        nulls[4] = {0};
    int         nreplaces = 0;
 
    stats_check_required_arg(fcinfo, relarginfo, RELSCHEMA_ARG);
    stats_check_required_arg(fcinfo, relarginfo, RELNAME_ARG);
 
    nspname = TextDatumGetCString(PG_GETARG_DATUM(RELSCHEMA_ARG));
    relname = TextDatumGetCString(PG_GETARG_DATUM(RELNAME_ARG));
 
    reloid = stats_lookup_relid(nspname, relname);
 
    if (RecoveryInProgress())
        ereport(ERROR,
                (errcode(ERRCODE_OBJECT_NOT_IN_PREREQUISITE_STATE),
                 errmsg("recovery is in progress"),
                 errhint("Statistics cannot be modified during recovery.")));
 
    stats_lock_check_privileges(reloid);
 
    if (!PG_ARGISNULL(RELPAGES_ARG))
    {
        relpages = PG_GETARG_UINT32(RELPAGES_ARG);
        update_relpages = true;
    }
 
    if (!PG_ARGISNULL(RELTUPLES_ARG))
    {
        reltuples = PG_GETARG_FLOAT4(RELTUPLES_ARG);
        if (reltuples < -1.0)
        {
            ereport(WARNING,
                    (errcode(ERRCODE_INVALID_PARAMETER_VALUE),
                     errmsg("reltuples cannot be < -1.0")));
            result = false;
        }
        else
            update_reltuples = true;
    }
 
    if (!PG_ARGISNULL(RELALLVISIBLE_ARG))
    {
        relallvisible = PG_GETARG_UINT32(RELALLVISIBLE_ARG);
        update_relallvisible = true;
    }
 
    if (!PG_ARGISNULL(RELALLFROZEN_ARG))
    {
        relallfrozen = PG_GETARG_UINT32(RELALLFROZEN_ARG);
        update_relallfrozen = true;
    }
 
    /*
     * Take RowExclusiveLock on pg_class, consistent with
     * vac_update_relstats().
     */
    crel = table_open(RelationRelationId, RowExclusiveLock);
 
    ctup = SearchSysCache1(RELOID, ObjectIdGetDatum(reloid));
    if (!HeapTupleIsValid(ctup))
        elog(ERROR, "pg_class entry for relid %u not found", reloid);
 
    pgcform = (Form_pg_class) GETSTRUCT(ctup);
 
    if (update_relpages && relpages != pgcform->relpages)
    {
        replaces[nreplaces] = Anum_pg_class_relpages;
        values[nreplaces] = UInt32GetDatum(relpages);
        nreplaces++;
    }
 
    if (update_reltuples && reltuples != pgcform->reltuples)
    {
        replaces[nreplaces] = Anum_pg_class_reltuples;
        values[nreplaces] = Float4GetDatum(reltuples);
        nreplaces++;
    }
 
    if (update_relallvisible && relallvisible != pgcform->relallvisible)
    {
        replaces[nreplaces] = Anum_pg_class_relallvisible;
        values[nreplaces] = UInt32GetDatum(relallvisible);
        nreplaces++;
    }
 
    if (update_relallfrozen && relallfrozen != pgcform->relallfrozen)
    {
        replaces[nreplaces] = Anum_pg_class_relallfrozen;
        values[nreplaces] = UInt32GetDatum(relallfrozen);
        nreplaces++;
    }
 
    if (nreplaces > 0)
    {
        TupleDesc   tupdesc = RelationGetDescr(crel);
        HeapTuple   newtup;
 
        newtup = heap_modify_tuple_by_cols(ctup, tupdesc, nreplaces,
                                           replaces, values, nulls);
        CatalogTupleUpdate(crel, &newtup->t_self, newtup);
        heap_freetuple(newtup);
    }
 
    ReleaseSysCache(ctup);
 
    /* release the lock, consistent with vac_update_relstats() */
    table_close(crel, RowExclusiveLock);
 
    CommandCounterIncrement();
 
    return result;
}
 
/*
 * Clear statistics for a given pg_class entry; that is, set back to initial
 * stats for a newly-created table.
 */
Datum
pg_clear_relation_stats(PG_FUNCTION_ARGS)
{
    LOCAL_FCINFO(newfcinfo, 6);
 
    InitFunctionCallInfoData(*newfcinfo, NULL, 6, InvalidOid, NULL, NULL);
 
    newfcinfo->args[0].value = PG_GETARG_DATUM(0);
    newfcinfo->args[0].isnull = PG_ARGISNULL(0);
    newfcinfo->args[1].value = PG_GETARG_DATUM(1);
    newfcinfo->args[1].isnull = PG_ARGISNULL(1);
    newfcinfo->args[2].value = UInt32GetDatum(0);
    newfcinfo->args[2].isnull = false;
    newfcinfo->args[3].value = Float4GetDatum(-1.0);
    newfcinfo->args[3].isnull = false;
    newfcinfo->args[4].value = UInt32GetDatum(0);
    newfcinfo->args[4].isnull = false;
    newfcinfo->args[5].value = UInt32GetDatum(0);
    newfcinfo->args[5].isnull = false;
 
    relation_statistics_update(newfcinfo);
    PG_RETURN_VOID();
}
 
Datum
pg_restore_relation_stats(PG_FUNCTION_ARGS)
{
    LOCAL_FCINFO(positional_fcinfo, NUM_RELATION_STATS_ARGS);
    bool        result = true;
 
    InitFunctionCallInfoData(*positional_fcinfo, NULL,
                             NUM_RELATION_STATS_ARGS,
                             InvalidOid, NULL, NULL);
 
    if (!stats_fill_fcinfo_from_arg_pairs(fcinfo, positional_fcinfo,
                                          relarginfo))
        result = false;
 
    if (!relation_statistics_update(positional_fcinfo))
        result = false;
 
    PG_RETURN_BOOL(result);
}