auto_explain.c File Reference

#include "postgres.h"
#include <limits.h>
#include "access/parallel.h"
#include "commands/defrem.h"
#include "commands/explain.h"
#include "commands/explain_format.h"
#include "commands/explain_state.h"
#include "common/pg_prng.h"
#include "executor/instrument.h"
#include "nodes/makefuncs.h"
#include "nodes/value.h"
#include "parser/scansup.h"
#include "utils/guc.h"
#include "utils/varlena.h"

Include dependency graph for auto_explain.c:

Go to the source code of this file.

Data Structures
struct	auto_explain_option
struct	auto_explain_extension_options

Macros
#define	auto_explain_enabled()

Typedefs
typedef struct auto_explain_option	auto_explain_option
typedef struct auto_explain_extension_options	auto_explain_extension_options

Functions
	PG_MODULE_MAGIC_EXT (.name="auto_explain",.version=PG_VERSION)
static void	explain_ExecutorStart (QueryDesc *queryDesc, int eflags)
static void	explain_ExecutorRun (QueryDesc *queryDesc, ScanDirection direction, uint64 count)
static void	explain_ExecutorFinish (QueryDesc *queryDesc)
static void	explain_ExecutorEnd (QueryDesc *queryDesc)
static bool	check_log_extension_options (char **newval, void **extra, GucSource source)
static void	assign_log_extension_options (const char *newval, void *extra)
static void	apply_extension_options (ExplainState *es, auto_explain_extension_options *ext)
static char *	auto_explain_scan_literal (char **endp, char **nextp)
static int	auto_explain_split_options (char *rawstring, auto_explain_option *options, int maxoptions, char **errmsg)
void	_PG_init (void)

Variables
static int	auto_explain_log_min_duration = -1
static int	auto_explain_log_parameter_max_length = -1
static bool	auto_explain_log_analyze = false
static bool	auto_explain_log_verbose = false
static bool	auto_explain_log_buffers = false
static bool	auto_explain_log_io = false
static bool	auto_explain_log_wal = false
static bool	auto_explain_log_triggers = false
static bool	auto_explain_log_timing = true
static bool	auto_explain_log_settings = false
static int	auto_explain_log_format = EXPLAIN_FORMAT_TEXT
static int	auto_explain_log_level = LOG
static bool	auto_explain_log_nested_statements = false
static double	auto_explain_sample_rate = 1
static char *	auto_explain_log_extension_options = NULL
static auto_explain_extension_options *	extension_options = NULL
static const struct config_enum_entry	format_options []
static const struct config_enum_entry	loglevel_options []
static int	nesting_level = 0
static bool	current_query_sampled = false
static ExecutorStart_hook_type	prev_ExecutorStart = NULL
static ExecutorRun_hook_type	prev_ExecutorRun = NULL
static ExecutorFinish_hook_type	prev_ExecutorFinish = NULL
static ExecutorEnd_hook_type	prev_ExecutorEnd = NULL

Macro Definition Documentation

auto_explain_enabled

#define auto_explain_enabled

(

)

Value:

    (auto_explain_log_min_duration >= 0 && \
     (nesting_level == 0 || auto_explain_log_nested_statements) && \
     current_query_sampled)

Definition at line 104 of file auto_explain.c.

{
    /* Define custom GUC variables. */
    DefineCustomIntVariable("auto_explain.log_min_duration",
                            "Sets the minimum execution time above which plans will be logged.",
                            "-1 disables logging plans. 0 means log all plans.",
                            &auto_explain_log_min_duration,
                            -1,
                            -1, INT_MAX,
                            PGC_SUSET,
                            GUC_UNIT_MS,
                            NULL,
                            NULL,
                            NULL);
 
    DefineCustomIntVariable("auto_explain.log_parameter_max_length",
                            "Sets the maximum length of query parameter values to log.",
                            "-1 means log values in full.",
                            &auto_explain_log_parameter_max_length,
                            -1,
                            -1, INT_MAX,
                            PGC_SUSET,
                            GUC_UNIT_BYTE,
                            NULL,
                            NULL,
                            NULL);
 
    DefineCustomBoolVariable("auto_explain.log_analyze",
                             "Use EXPLAIN ANALYZE for plan logging.",
                             NULL,
                             &auto_explain_log_analyze,
                             false,
                             PGC_SUSET,
                             0,
                             NULL,
                             NULL,
                             NULL);
 
    DefineCustomBoolVariable("auto_explain.log_settings",
                             "Log modified configuration parameters affecting query planning.",
                             NULL,
                             &auto_explain_log_settings,
                             false,
                             PGC_SUSET,
                             0,
                             NULL,
                             NULL,
                             NULL);
 
    DefineCustomBoolVariable("auto_explain.log_verbose",
                             "Use EXPLAIN VERBOSE for plan logging.",
                             NULL,
                             &auto_explain_log_verbose,
                             false,
                             PGC_SUSET,
                             0,
                             NULL,
                             NULL,
                             NULL);
 
    DefineCustomBoolVariable("auto_explain.log_buffers",
                             "Log buffers usage.",
                             NULL,
                             &auto_explain_log_buffers,
                             false,
                             PGC_SUSET,
                             0,
                             NULL,
                             NULL,
                             NULL);
 
    DefineCustomBoolVariable("auto_explain.log_io",
                             "Log I/O statistics.",
                             NULL,
                             &auto_explain_log_io,
                             false,
                             PGC_SUSET,
                             0,
                             NULL,
                             NULL,
                             NULL);
 
    DefineCustomBoolVariable("auto_explain.log_wal",
                             "Log WAL usage.",
                             NULL,
                             &auto_explain_log_wal,
                             false,
                             PGC_SUSET,
                             0,
                             NULL,
                             NULL,
                             NULL);
 
    DefineCustomBoolVariable("auto_explain.log_triggers",
                             "Include trigger statistics in plans.",
                             "This has no effect unless log_analyze is also set.",
                             &auto_explain_log_triggers,
                             false,
                             PGC_SUSET,
                             0,
                             NULL,
                             NULL,
                             NULL);
 
    DefineCustomEnumVariable("auto_explain.log_format",
                             "EXPLAIN format to be used for plan logging.",
                             NULL,
                             &auto_explain_log_format,
                             EXPLAIN_FORMAT_TEXT,
                             format_options,
                             PGC_SUSET,
                             0,
                             NULL,
                             NULL,
                             NULL);
 
    DefineCustomEnumVariable("auto_explain.log_level",
                             "Log level for the plan.",
                             NULL,
                             &auto_explain_log_level,
                             LOG,
                             loglevel_options,
                             PGC_SUSET,
                             0,
                             NULL,
                             NULL,
                             NULL);
 
    DefineCustomBoolVariable("auto_explain.log_nested_statements",
                             "Log nested statements.",
                             NULL,
                             &auto_explain_log_nested_statements,
                             false,
                             PGC_SUSET,
                             0,
                             NULL,
                             NULL,
                             NULL);
 
    DefineCustomBoolVariable("auto_explain.log_timing",
                             "Collect timing data, not just row counts.",
                             NULL,
                             &auto_explain_log_timing,
                             true,
                             PGC_SUSET,
                             0,
                             NULL,
                             NULL,
                             NULL);
 
    DefineCustomStringVariable("auto_explain.log_extension_options",
                               "Extension EXPLAIN options to be added.",
                               NULL,
                               &auto_explain_log_extension_options,
                               NULL,
                               PGC_SUSET,
                               0,
                               check_log_extension_options,
                               assign_log_extension_options,
                               NULL);
 
    DefineCustomRealVariable("auto_explain.sample_rate",
                             "Fraction of queries to process.",
                             NULL,
                             &auto_explain_sample_rate,
                             1.0,
                             0.0,
                             1.0,
                             PGC_SUSET,
                             0,
                             NULL,
                             NULL,
                             NULL);
 
    MarkGUCPrefixReserved("auto_explain");
 
    /* Install hooks. */
    prev_ExecutorStart = ExecutorStart_hook;
    ExecutorStart_hook = explain_ExecutorStart;
    prev_ExecutorRun = ExecutorRun_hook;
    ExecutorRun_hook = explain_ExecutorRun;
    prev_ExecutorFinish = ExecutorFinish_hook;
    ExecutorFinish_hook = explain_ExecutorFinish;
    prev_ExecutorEnd = ExecutorEnd_hook;
    ExecutorEnd_hook = explain_ExecutorEnd;
}
 
/*
 * ExecutorStart hook: start up logging if needed
 */
static void
explain_ExecutorStart(QueryDesc *queryDesc, int eflags)
{
    /*
     * At the beginning of each top-level statement, decide whether we'll
     * sample this statement.  If nested-statement explaining is enabled,
     * either all nested statements will be explained or none will.
     *
     * When in a parallel worker, we should do nothing, which we can implement
     * cheaply by pretending we decided not to sample the current statement.
     * If EXPLAIN is active in the parent session, data will be collected and
     * reported back to the parent, and it's no business of ours to interfere.
     */
    if (nesting_level == 0)
    {
        if (auto_explain_log_min_duration >= 0 && !IsParallelWorker())
            current_query_sampled = (pg_prng_double(&pg_global_prng_state) < auto_explain_sample_rate);
        else
            current_query_sampled = false;
    }
 
    if (auto_explain_enabled())
    {
        /* We're always interested in runtime */
        queryDesc->query_instr_options |= INSTRUMENT_TIMER;
 
        /* Enable per-node instrumentation iff log_analyze is required. */
        if (auto_explain_log_analyze && (eflags & EXEC_FLAG_EXPLAIN_ONLY) == 0)
        {
            if (auto_explain_log_timing)
                queryDesc->instrument_options |= INSTRUMENT_TIMER;
            else
                queryDesc->instrument_options |= INSTRUMENT_ROWS;
            if (auto_explain_log_buffers)
                queryDesc->instrument_options |= INSTRUMENT_BUFFERS;
            if (auto_explain_log_io)
                queryDesc->instrument_options |= INSTRUMENT_IO;
            if (auto_explain_log_wal)
                queryDesc->instrument_options |= INSTRUMENT_WAL;
        }
    }
 
    if (prev_ExecutorStart)
        prev_ExecutorStart(queryDesc, eflags);
    else
        standard_ExecutorStart(queryDesc, eflags);
}
 
/*
 * ExecutorRun hook: all we need do is track nesting depth
 */
static void
explain_ExecutorRun(QueryDesc *queryDesc, ScanDirection direction,
                    uint64 count)
{
    nesting_level++;
    PG_TRY();
    {
        if (prev_ExecutorRun)
            prev_ExecutorRun(queryDesc, direction, count);
        else
            standard_ExecutorRun(queryDesc, direction, count);
    }
    PG_FINALLY();
    {
        nesting_level--;
    }
    PG_END_TRY();
}
 
/*
 * ExecutorFinish hook: all we need do is track nesting depth
 */
static void
explain_ExecutorFinish(QueryDesc *queryDesc)
{
    nesting_level++;
    PG_TRY();
    {
        if (prev_ExecutorFinish)
            prev_ExecutorFinish(queryDesc);
        else
            standard_ExecutorFinish(queryDesc);
    }
    PG_FINALLY();
    {
        nesting_level--;
    }
    PG_END_TRY();
}
 
/*
 * ExecutorEnd hook: log results if needed
 */
static void
explain_ExecutorEnd(QueryDesc *queryDesc)
{
    if (queryDesc->query_instr && auto_explain_enabled())
    {
        MemoryContext oldcxt;
        double      msec;
 
        /*
         * Make sure we operate in the per-query context, so any cruft will be
         * discarded later during ExecutorEnd.
         */
        oldcxt = MemoryContextSwitchTo(queryDesc->estate->es_query_cxt);
 
        /* Log plan if duration is exceeded. */
        msec = INSTR_TIME_GET_MILLISEC(queryDesc->query_instr->total);
        if (msec >= auto_explain_log_min_duration)
        {
            ExplainState *es = NewExplainState();
 
            es->analyze = (queryDesc->instrument_options && auto_explain_log_analyze);
            es->verbose = auto_explain_log_verbose;
            es->buffers = (es->analyze && auto_explain_log_buffers);
            es->io = (es->analyze && auto_explain_log_io);
            es->wal = (es->analyze && auto_explain_log_wal);
            es->timing = (es->analyze && auto_explain_log_timing);
            es->summary = es->analyze;
            /* No support for MEMORY */
            /* es->memory = false; */
            es->format = auto_explain_log_format;
            es->settings = auto_explain_log_settings;
 
            apply_extension_options(es, extension_options);
 
            ExplainBeginOutput(es);
            ExplainQueryText(es, queryDesc);
            ExplainQueryParameters(es, queryDesc->params, auto_explain_log_parameter_max_length);
            ExplainPrintPlan(es, queryDesc);
            if (es->analyze && auto_explain_log_triggers)
                ExplainPrintTriggers(es, queryDesc);
            if (es->costs)
                ExplainPrintJITSummary(es, queryDesc);
            if (explain_per_plan_hook)
                (*explain_per_plan_hook) (queryDesc->plannedstmt,
                                          NULL, es,
                                          queryDesc->sourceText,
                                          queryDesc->params,
                                          queryDesc->estate->es_queryEnv);
            ExplainEndOutput(es);
 
            /* Remove last line break */
            if (es->str->len > 0 && es->str->data[es->str->len - 1] == '\n')
                es->str->data[--es->str->len] = '\0';
 
            /* Fix JSON to output an object */
            if (auto_explain_log_format == EXPLAIN_FORMAT_JSON)
            {
                es->str->data[0] = '{';
                es->str->data[es->str->len - 1] = '}';
            }
 
            /*
             * Note: we rely on the existing logging of context or
             * debug_query_string to identify just which statement is being
             * reported.  This isn't ideal but trying to do it here would
             * often result in duplication.
             */
            ereport(auto_explain_log_level,
                    (errmsg("duration: %.3f ms  plan:\n%s",
                            msec, es->str->data),
                     errhidestmt(true)));
        }
 
        MemoryContextSwitchTo(oldcxt);
    }
 
    if (prev_ExecutorEnd)
        prev_ExecutorEnd(queryDesc);
    else
        standard_ExecutorEnd(queryDesc);
}
 
/*
 * GUC check hook for auto_explain.log_extension_options.
 */
static bool
check_log_extension_options(char **newval, void **extra, GucSource source)
{
    char       *rawstring;
    auto_explain_extension_options *result;
    auto_explain_option *options;
    int         maxoptions = 8;
    Size        rawstring_len;
    Size        allocsize;
    char       *errmsg;
 
    /* NULL or empty string means no options. */
    if (*newval == NULL || (*newval)[0] == '\0')
    {
        *extra = NULL;
        return true;
    }
 
    rawstring_len = strlen(*newval) + 1;
 
retry:
    /* Try to allocate an auto_explain_extension_options object. */
    allocsize = offsetof(auto_explain_extension_options, options) +
        sizeof(auto_explain_option) * maxoptions +
        rawstring_len;
    result = (auto_explain_extension_options *) guc_malloc(LOG, allocsize);
    if (result == NULL)
        return false;
 
    /* Copy the string after the options array. */
    rawstring = (char *) &result->options[maxoptions];
    memcpy(rawstring, *newval, rawstring_len);
 
    /* Parse. */
    options = result->options;
    result->noptions = auto_explain_split_options(rawstring, options,
                                                  maxoptions, &errmsg);
    if (result->noptions < 0)
    {
        GUC_check_errdetail("%s", errmsg);
        guc_free(result);
        return false;
    }
 
    /*
     * Retry with a larger array if needed.
     *
     * It should be impossible for this to loop more than once, because
     * auto_explain_split_options tells us how many entries are needed.
     */
    if (result->noptions > maxoptions)
    {
        maxoptions = result->noptions;
        guc_free(result);
        goto retry;
    }
 
    /* Validate each option against its registered check handler. */
    for (int i = 0; i < result->noptions; i++)
    {
        if (!GUCCheckExplainExtensionOption(options[i].name, options[i].value,
                                            options[i].type))
        {
            guc_free(result);
            return false;
        }
    }
 
    *extra = result;
    return true;
}
 
/*
 * GUC assign hook for auto_explain.log_extension_options.
 */
static void
assign_log_extension_options(const char *newval, void *extra)
{
    extension_options = (auto_explain_extension_options *) extra;
}
 
/*
 * Apply parsed extension options to an ExplainState.
 */
static void
apply_extension_options(ExplainState *es, auto_explain_extension_options *ext)
{
    if (ext == NULL)
        return;
 
    for (int i = 0; i < ext->noptions; i++)
    {
        auto_explain_option *opt = &ext->options[i];
        DefElem    *def;
        Node       *arg;
 
        if (opt->value == NULL)
            arg = NULL;
        else if (opt->type == T_Integer)
            arg = (Node *) makeInteger(strtol(opt->value, NULL, 0));
        else if (opt->type == T_Float)
            arg = (Node *) makeFloat(opt->value);
        else
            arg = (Node *) makeString(opt->value);
 
        def = makeDefElem(opt->name, arg, -1);
        ApplyExtensionExplainOption(es, def, NULL);
    }
}
 
/*
 * auto_explain_scan_literal - In-place scanner for single-quoted string
 * literals.
 *
 * This is the single-quote analog of scan_quoted_identifier from varlena.c.
 */
static char *
auto_explain_scan_literal(char **endp, char **nextp)
{
    char       *token = *nextp + 1;
 
    for (;;)
    {
        *endp = strchr(*nextp + 1, '\'');
        if (*endp == NULL)
            return NULL;        /* mismatched quotes */
        if ((*endp)[1] != '\'')
            break;              /* found end of literal */
        /* Collapse adjacent quotes into one quote, and look again */
        memmove(*endp, *endp + 1, strlen(*endp));
        *nextp = *endp;
    }
    /* *endp now points at the terminating quote */
    *nextp = *endp + 1;
 
    return token;
}
 
/*
 * auto_explain_split_options - Parse an option string into an array of
 * auto_explain_option structs.
 *
 * Much of this logic is similar to SplitIdentifierString and friends, but our
 * needs are different enough that we roll our own parsing logic. The goal here
 * is to accept the same syntax that the main parser would accept inside of
 * an EXPLAIN option list. While we can't do that perfectly without adding a
 * lot more code, the goal of this implementation is to be close enough that
 * users don't really notice the differences.
 *
 * The input string is modified in place (null-terminated, downcased, quotes
 * collapsed).  All name and value pointers in the output array refer into
 * this string, so the caller must ensure the string outlives the array.
 *
 * Returns the full number of options in the input string, but stores no
 * more than maxoptions into the caller-provided array. If a syntax error
 * occurs, returns -1 and sets *errmsg.
 */
static int
auto_explain_split_options(char *rawstring, auto_explain_option *options,
                           int maxoptions, char **errmsg)
{
    char       *nextp = rawstring;
    int         noptions = 0;
    bool        done = false;
 
    *errmsg = NULL;
 
    while (scanner_isspace(*nextp))
        nextp++;                /* skip leading whitespace */
 
    if (*nextp == '\0')
        return 0;               /* empty string is fine */
 
    while (!done)
    {
        char       *name;
        char       *name_endp;
        char       *value = NULL;
        char       *value_endp = NULL;
        NodeTag     type = T_Invalid;
 
        /* Parse the option name. */
        name = scan_identifier(&name_endp, &nextp, ',', true);
        if (name == NULL || name_endp == name)
        {
            *errmsg = "option name missing or empty";
            return -1;
        }
 
        /* Skip whitespace after the option name. */
        while (scanner_isspace(*nextp))
            nextp++;
 
        /*
         * Determine whether we have an option value.  A comma or end of
         * string means no value; otherwise we have one.
         */
        if (*nextp != '\0' && *nextp != ',')
        {
            if (*nextp == '\'')
            {
                /* Single-quoted string literal. */
                type = T_String;
                value = auto_explain_scan_literal(&value_endp, &nextp);
                if (value == NULL)
                {
                    *errmsg = "unterminated single-quoted string";
                    return -1;
                }
            }
            else if (isdigit((unsigned char) *nextp) ||
                     ((*nextp == '+' || *nextp == '-') &&
                      isdigit((unsigned char) nextp[1])))
            {
                char       *endptr;
                long        intval;
                char        saved;
 
                /* Remember the start of the next token, and find the end. */
                value = nextp;
                while (*nextp && *nextp != ',' && !scanner_isspace(*nextp))
                    nextp++;
                value_endp = nextp;
 
                /* Temporarily '\0'-terminate so we can use strtol/strtod. */
                saved = *value_endp;
                *value_endp = '\0';
 
                /*
                 * Integer, float, or neither?
                 *
                 * NB: Since we use strtol and strtod here rather than
                 * pg_strtoint64_safe, some syntax that would be accepted by
                 * the main parser is not accepted here, e.g. 100_000. On the
                 * plus side, strtol and strtod won't allocate, and
                 * pg_strtoint64_safe might. For now, it seems better to keep
                 * things simple here.
                 */
                errno = 0;
                intval = strtol(value, &endptr, 0);
                if (errno == 0 && *endptr == '\0' && endptr != value &&
                    intval == (int) intval)
                    type = T_Integer;
                else
                {
                    type = T_Float;
                    (void) strtod(value, &endptr);
                    if (*endptr != '\0')
                    {
                        *value_endp = saved;
                        *errmsg = "invalid numeric value";
                        return -1;
                    }
                }
 
                /* Remove temporary terminator. */
                *value_endp = saved;
            }
            else
            {
                /* Identifier, possibly double-quoted. */
                type = T_String;
                value = scan_identifier(&value_endp, &nextp, ',', true);
                if (value == NULL)
                {
                    /*
                     * scan_identifier will return NULL if it finds an
                     * unterminated double-quoted identifier or it finds no
                     * identifier at all because the next character is
                     * whitespace or the separator character, here a comma.
                     * But the latter case is impossible here because the code
                     * above has skipped whitespace and checked for commas.
                     */
                    *errmsg = "unterminated double-quoted string";
                    return -1;
                }
            }
        }
 
        /* Skip trailing whitespace. */
        while (scanner_isspace(*nextp))
            nextp++;
 
        /* Expect comma or end of string. */
        if (*nextp == ',')
        {
            nextp++;
            while (scanner_isspace(*nextp))
                nextp++;
            if (*nextp == '\0')
            {
                *errmsg = "trailing comma in option list";
                return -1;
            }
        }
        else if (*nextp == '\0')
            done = true;
        else
        {
            *errmsg = "expected comma or end of option list";
            return -1;
        }
 
        /*
         * Now safe to null-terminate the name and value.  We couldn't do this
         * earlier because in the unquoted case, the null terminator position
         * may coincide with a character that the scanning logic above still
         * needed to read.
         */
        *name_endp = '\0';
        if (value_endp != NULL)
            *value_endp = '\0';
 
        /* Always count this option, and store the details if there is room. */
        if (noptions < maxoptions)
        {
            options[noptions].name = name;
            options[noptions].type = type;
            options[noptions].value = value;
        }
        noptions++;
    }
 
    return noptions;
}

Typedef Documentation

auto_explain_extension_options

typedef struct auto_explain_extension_options auto_explain_extension_options

auto_explain_option

typedef struct auto_explain_option auto_explain_option

Function Documentation

_PG_init()

void _PG_init

(

void

)

Definition at line 136 of file auto_explain.c.

{
    /* Define custom GUC variables. */
    DefineCustomIntVariable("auto_explain.log_min_duration",
                            "Sets the minimum execution time above which plans will be logged.",
                            "-1 disables logging plans. 0 means log all plans.",
                            &auto_explain_log_min_duration,
                            -1,
                            -1, INT_MAX,
                            PGC_SUSET,
                            GUC_UNIT_MS,
                            NULL,
                            NULL,
                            NULL);
 
    DefineCustomIntVariable("auto_explain.log_parameter_max_length",
                            "Sets the maximum length of query parameter values to log.",
                            "-1 means log values in full.",
                            &auto_explain_log_parameter_max_length,
                            -1,
                            -1, INT_MAX,
                            PGC_SUSET,
                            GUC_UNIT_BYTE,
                            NULL,
                            NULL,
                            NULL);
 
    DefineCustomBoolVariable("auto_explain.log_analyze",
                             "Use EXPLAIN ANALYZE for plan logging.",
                             NULL,
                             &auto_explain_log_analyze,
                             false,
                             PGC_SUSET,
                             0,
                             NULL,
                             NULL,
                             NULL);
 
    DefineCustomBoolVariable("auto_explain.log_settings",
                             "Log modified configuration parameters affecting query planning.",
                             NULL,
                             &auto_explain_log_settings,
                             false,
                             PGC_SUSET,
                             0,
                             NULL,
                             NULL,
                             NULL);
 
    DefineCustomBoolVariable("auto_explain.log_verbose",
                             "Use EXPLAIN VERBOSE for plan logging.",
                             NULL,
                             &auto_explain_log_verbose,
                             false,
                             PGC_SUSET,
                             0,
                             NULL,
                             NULL,
                             NULL);
 
    DefineCustomBoolVariable("auto_explain.log_buffers",
                             "Log buffers usage.",
                             NULL,
                             &auto_explain_log_buffers,
                             false,
                             PGC_SUSET,
                             0,
                             NULL,
                             NULL,
                             NULL);
 
    DefineCustomBoolVariable("auto_explain.log_io",
                             "Log I/O statistics.",
                             NULL,
                             &auto_explain_log_io,
                             false,
                             PGC_SUSET,
                             0,
                             NULL,
                             NULL,
                             NULL);
 
    DefineCustomBoolVariable("auto_explain.log_wal",
                             "Log WAL usage.",
                             NULL,
                             &auto_explain_log_wal,
                             false,
                             PGC_SUSET,
                             0,
                             NULL,
                             NULL,
                             NULL);
 
    DefineCustomBoolVariable("auto_explain.log_triggers",
                             "Include trigger statistics in plans.",
                             "This has no effect unless log_analyze is also set.",
                             &auto_explain_log_triggers,
                             false,
                             PGC_SUSET,
                             0,
                             NULL,
                             NULL,
                             NULL);
 
    DefineCustomEnumVariable("auto_explain.log_format",
                             "EXPLAIN format to be used for plan logging.",
                             NULL,
                             &auto_explain_log_format,
                             EXPLAIN_FORMAT_TEXT,
                             format_options,
                             PGC_SUSET,
                             0,
                             NULL,
                             NULL,
                             NULL);
 
    DefineCustomEnumVariable("auto_explain.log_level",
                             "Log level for the plan.",
                             NULL,
                             &auto_explain_log_level,
                             LOG,
                             loglevel_options,
                             PGC_SUSET,
                             0,
                             NULL,
                             NULL,
                             NULL);
 
    DefineCustomBoolVariable("auto_explain.log_nested_statements",
                             "Log nested statements.",
                             NULL,
                             &auto_explain_log_nested_statements,
                             false,
                             PGC_SUSET,
                             0,
                             NULL,
                             NULL,
                             NULL);
 
    DefineCustomBoolVariable("auto_explain.log_timing",
                             "Collect timing data, not just row counts.",
                             NULL,
                             &auto_explain_log_timing,
                             true,
                             PGC_SUSET,
                             0,
                             NULL,
                             NULL,
                             NULL);
 
    DefineCustomStringVariable("auto_explain.log_extension_options",
                               "Extension EXPLAIN options to be added.",
                               NULL,
                               &auto_explain_log_extension_options,
                               NULL,
                               PGC_SUSET,
                               0,
                               check_log_extension_options,
                               assign_log_extension_options,
                               NULL);
 
    DefineCustomRealVariable("auto_explain.sample_rate",
                             "Fraction of queries to process.",
                             NULL,
                             &auto_explain_sample_rate,
                             1.0,
                             0.0,
                             1.0,
                             PGC_SUSET,
                             0,
                             NULL,
                             NULL,
                             NULL);
 
    MarkGUCPrefixReserved("auto_explain");
 
    /* Install hooks. */
    prev_ExecutorStart = ExecutorStart_hook;
    ExecutorStart_hook = explain_ExecutorStart;
    prev_ExecutorRun = ExecutorRun_hook;
    ExecutorRun_hook = explain_ExecutorRun;
    prev_ExecutorFinish = ExecutorFinish_hook;
    ExecutorFinish_hook = explain_ExecutorFinish;
    prev_ExecutorEnd = ExecutorEnd_hook;
    ExecutorEnd_hook = explain_ExecutorEnd;
}

References assign_log_extension_options(), auto_explain_log_analyze, auto_explain_log_buffers, auto_explain_log_extension_options, auto_explain_log_format, auto_explain_log_io, auto_explain_log_level, auto_explain_log_min_duration, auto_explain_log_nested_statements, auto_explain_log_parameter_max_length, auto_explain_log_settings, auto_explain_log_timing, auto_explain_log_triggers, auto_explain_log_verbose, auto_explain_log_wal, auto_explain_sample_rate, check_log_extension_options(), DefineCustomBoolVariable(), DefineCustomEnumVariable(), DefineCustomIntVariable(), DefineCustomRealVariable(), DefineCustomStringVariable(), ExecutorEnd_hook, ExecutorFinish_hook, ExecutorRun_hook, ExecutorStart_hook, explain_ExecutorEnd(), explain_ExecutorFinish(), explain_ExecutorRun(), explain_ExecutorStart(), EXPLAIN_FORMAT_TEXT, format_options, GUC_UNIT_BYTE, GUC_UNIT_MS, LOG, loglevel_options, MarkGUCPrefixReserved(), PGC_SUSET, prev_ExecutorEnd, prev_ExecutorFinish, prev_ExecutorRun, and prev_ExecutorStart.

apply_extension_options()

static void apply_extension_options ( ExplainState *  es, auto_explain_extension_options *  ext  )

static

Definition at line 590 of file auto_explain.c.

{
    if (ext == NULL)
        return;
 
    for (int i = 0; i < ext->noptions; i++)
    {
        auto_explain_option *opt = &ext->options[i];
        DefElem    *def;
        Node       *arg;
 
        if (opt->value == NULL)
            arg = NULL;
        else if (opt->type == T_Integer)
            arg = (Node *) makeInteger(strtol(opt->value, NULL, 0));
        else if (opt->type == T_Float)
            arg = (Node *) makeFloat(opt->value);
        else
            arg = (Node *) makeString(opt->value);
 
        def = makeDefElem(opt->name, arg, -1);
        ApplyExtensionExplainOption(es, def, NULL);
    }
}

References ApplyExtensionExplainOption(), arg, fb(), i, makeDefElem(), makeFloat(), makeInteger(), makeString(), auto_explain_option::name, auto_explain_extension_options::noptions, auto_explain_extension_options::options, auto_explain_option::type, and auto_explain_option::value.

Referenced by explain_ExecutorEnd().

assign_log_extension_options()

static void assign_log_extension_options ( const char *  newval, void *  extra  )

static

Definition at line 581 of file auto_explain.c.

{
    extension_options = (auto_explain_extension_options *) extra;
}

References extension_options.

Referenced by _PG_init().

auto_explain_scan_literal()

static char * auto_explain_scan_literal ( char **  endp, char **  nextp  )

static

Definition at line 622 of file auto_explain.c.

{
    char       *token = *nextp + 1;
 
    for (;;)
    {
        *endp = strchr(*nextp + 1, '\'');
        if (*endp == NULL)
            return NULL;        /* mismatched quotes */
        if ((*endp)[1] != '\'')
            break;              /* found end of literal */
        /* Collapse adjacent quotes into one quote, and look again */
        memmove(*endp, *endp + 1, strlen(*endp));
        *nextp = *endp;
    }
    /* *endp now points at the terminating quote */
    *nextp = *endp + 1;
 
    return token;
}

References fb(), and token.

Referenced by auto_explain_split_options().

auto_explain_split_options()

static int auto_explain_split_options ( char *  rawstring, auto_explain_option *  options, int  maxoptions, char **  errmsg  )

static

Definition at line 663 of file auto_explain.c.

{
    char       *nextp = rawstring;
    int         noptions = 0;
    bool        done = false;
 
    *errmsg = NULL;
 
    while (scanner_isspace(*nextp))
        nextp++;                /* skip leading whitespace */
 
    if (*nextp == '\0')
        return 0;               /* empty string is fine */
 
    while (!done)
    {
        char       *name;
        char       *name_endp;
        char       *value = NULL;
        char       *value_endp = NULL;
        NodeTag     type = T_Invalid;
 
        /* Parse the option name. */
        name = scan_identifier(&name_endp, &nextp, ',', true);
        if (name == NULL || name_endp == name)
        {
            *errmsg = "option name missing or empty";
            return -1;
        }
 
        /* Skip whitespace after the option name. */
        while (scanner_isspace(*nextp))
            nextp++;
 
        /*
         * Determine whether we have an option value.  A comma or end of
         * string means no value; otherwise we have one.
         */
        if (*nextp != '\0' && *nextp != ',')
        {
            if (*nextp == '\'')
            {
                /* Single-quoted string literal. */
                type = T_String;
                value = auto_explain_scan_literal(&value_endp, &nextp);
                if (value == NULL)
                {
                    *errmsg = "unterminated single-quoted string";
                    return -1;
                }
            }
            else if (isdigit((unsigned char) *nextp) ||
                     ((*nextp == '+' || *nextp == '-') &&
                      isdigit((unsigned char) nextp[1])))
            {
                char       *endptr;
                long        intval;
                char        saved;
 
                /* Remember the start of the next token, and find the end. */
                value = nextp;
                while (*nextp && *nextp != ',' && !scanner_isspace(*nextp))
                    nextp++;
                value_endp = nextp;
 
                /* Temporarily '\0'-terminate so we can use strtol/strtod. */
                saved = *value_endp;
                *value_endp = '\0';
 
                /*
                 * Integer, float, or neither?
                 *
                 * NB: Since we use strtol and strtod here rather than
                 * pg_strtoint64_safe, some syntax that would be accepted by
                 * the main parser is not accepted here, e.g. 100_000. On the
                 * plus side, strtol and strtod won't allocate, and
                 * pg_strtoint64_safe might. For now, it seems better to keep
                 * things simple here.
                 */
                errno = 0;
                intval = strtol(value, &endptr, 0);
                if (errno == 0 && *endptr == '\0' && endptr != value &&
                    intval == (int) intval)
                    type = T_Integer;
                else
                {
                    type = T_Float;
                    (void) strtod(value, &endptr);
                    if (*endptr != '\0')
                    {
                        *value_endp = saved;
                        *errmsg = "invalid numeric value";
                        return -1;
                    }
                }
 
                /* Remove temporary terminator. */
                *value_endp = saved;
            }
            else
            {
                /* Identifier, possibly double-quoted. */
                type = T_String;
                value = scan_identifier(&value_endp, &nextp, ',', true);
                if (value == NULL)
                {
                    /*
                     * scan_identifier will return NULL if it finds an
                     * unterminated double-quoted identifier or it finds no
                     * identifier at all because the next character is
                     * whitespace or the separator character, here a comma.
                     * But the latter case is impossible here because the code
                     * above has skipped whitespace and checked for commas.
                     */
                    *errmsg = "unterminated double-quoted string";
                    return -1;
                }
            }
        }
 
        /* Skip trailing whitespace. */
        while (scanner_isspace(*nextp))
            nextp++;
 
        /* Expect comma or end of string. */
        if (*nextp == ',')
        {
            nextp++;
            while (scanner_isspace(*nextp))
                nextp++;
            if (*nextp == '\0')
            {
                *errmsg = "trailing comma in option list";
                return -1;
            }
        }
        else if (*nextp == '\0')
            done = true;
        else
        {
            *errmsg = "expected comma or end of option list";
            return -1;
        }
 
        /*
         * Now safe to null-terminate the name and value.  We couldn't do this
         * earlier because in the unquoted case, the null terminator position
         * may coincide with a character that the scanning logic above still
         * needed to read.
         */
        *name_endp = '\0';
        if (value_endp != NULL)
            *value_endp = '\0';
 
        /* Always count this option, and store the details if there is room. */
        if (noptions < maxoptions)
        {
            options[noptions].name = name;
            options[noptions].type = type;
            options[noptions].value = value;
        }
        noptions++;
    }
 
    return noptions;
}

References auto_explain_scan_literal(), errmsg, fb(), name, noptions, scan_identifier(), scanner_isspace(), T_Invalid, type, and value.

Referenced by check_log_extension_options().

check_log_extension_options()

static bool check_log_extension_options ( char **  newval, void **  extra, GucSource  source  )

static

Definition at line 506 of file auto_explain.c.

{
    char       *rawstring;
    auto_explain_extension_options *result;
    auto_explain_option *options;
    int         maxoptions = 8;
    Size        rawstring_len;
    Size        allocsize;
    char       *errmsg;
 
    /* NULL or empty string means no options. */
    if (*newval == NULL || (*newval)[0] == '\0')
    {
        *extra = NULL;
        return true;
    }
 
    rawstring_len = strlen(*newval) + 1;
 
retry:
    /* Try to allocate an auto_explain_extension_options object. */
    allocsize = offsetof(auto_explain_extension_options, options) +
        sizeof(auto_explain_option) * maxoptions +
        rawstring_len;
    result = (auto_explain_extension_options *) guc_malloc(LOG, allocsize);
    if (result == NULL)
        return false;
 
    /* Copy the string after the options array. */
    rawstring = (char *) &result->options[maxoptions];
    memcpy(rawstring, *newval, rawstring_len);
 
    /* Parse. */
    options = result->options;
    result->noptions = auto_explain_split_options(rawstring, options,
                                                  maxoptions, &errmsg);
    if (result->noptions < 0)
    {
        GUC_check_errdetail("%s", errmsg);
        guc_free(result);
        return false;
    }
 
    /*
     * Retry with a larger array if needed.
     *
     * It should be impossible for this to loop more than once, because
     * auto_explain_split_options tells us how many entries are needed.
     */
    if (result->noptions > maxoptions)
    {
        maxoptions = result->noptions;
        guc_free(result);
        goto retry;
    }
 
    /* Validate each option against its registered check handler. */
    for (int i = 0; i < result->noptions; i++)
    {
        if (!GUCCheckExplainExtensionOption(options[i].name, options[i].value,
                                            options[i].type))
        {
            guc_free(result);
            return false;
        }
    }
 
    *extra = result;
    return true;
}

References auto_explain_split_options(), errmsg, fb(), GUC_check_errdetail, guc_free(), guc_malloc(), GUCCheckExplainExtensionOption(), i, LOG, memcpy(), name, newval, result, type, and value.

Referenced by _PG_init().

explain_ExecutorEnd()

static void explain_ExecutorEnd ( QueryDesc *  queryDesc )

static

Definition at line 421 of file auto_explain.c.

{
    if (queryDesc->query_instr && auto_explain_enabled())
    {
        MemoryContext oldcxt;
        double      msec;
 
        /*
         * Make sure we operate in the per-query context, so any cruft will be
         * discarded later during ExecutorEnd.
         */
        oldcxt = MemoryContextSwitchTo(queryDesc->estate->es_query_cxt);
 
        /* Log plan if duration is exceeded. */
        msec = INSTR_TIME_GET_MILLISEC(queryDesc->query_instr->total);
        if (msec >= auto_explain_log_min_duration)
        {
            ExplainState *es = NewExplainState();
 
            es->analyze = (queryDesc->instrument_options && auto_explain_log_analyze);
            es->verbose = auto_explain_log_verbose;
            es->buffers = (es->analyze && auto_explain_log_buffers);
            es->io = (es->analyze && auto_explain_log_io);
            es->wal = (es->analyze && auto_explain_log_wal);
            es->timing = (es->analyze && auto_explain_log_timing);
            es->summary = es->analyze;
            /* No support for MEMORY */
            /* es->memory = false; */
            es->format = auto_explain_log_format;
            es->settings = auto_explain_log_settings;
 
            apply_extension_options(es, extension_options);
 
            ExplainBeginOutput(es);
            ExplainQueryText(es, queryDesc);
            ExplainQueryParameters(es, queryDesc->params, auto_explain_log_parameter_max_length);
            ExplainPrintPlan(es, queryDesc);
            if (es->analyze && auto_explain_log_triggers)
                ExplainPrintTriggers(es, queryDesc);
            if (es->costs)
                ExplainPrintJITSummary(es, queryDesc);
            if (explain_per_plan_hook)
                (*explain_per_plan_hook) (queryDesc->plannedstmt,
                                          NULL, es,
                                          queryDesc->sourceText,
                                          queryDesc->params,
                                          queryDesc->estate->es_queryEnv);
            ExplainEndOutput(es);
 
            /* Remove last line break */
            if (es->str->len > 0 && es->str->data[es->str->len - 1] == '\n')
                es->str->data[--es->str->len] = '\0';
 
            /* Fix JSON to output an object */
            if (auto_explain_log_format == EXPLAIN_FORMAT_JSON)
            {
                es->str->data[0] = '{';
                es->str->data[es->str->len - 1] = '}';
            }
 
            /*
             * Note: we rely on the existing logging of context or
             * debug_query_string to identify just which statement is being
             * reported.  This isn't ideal but trying to do it here would
             * often result in duplication.
             */
            ereport(auto_explain_log_level,
                    (errmsg("duration: %.3f ms  plan:\n%s",
                            msec, es->str->data),
                     errhidestmt(true)));
        }
 
        MemoryContextSwitchTo(oldcxt);
    }
 
    if (prev_ExecutorEnd)
        prev_ExecutorEnd(queryDesc);
    else
        standard_ExecutorEnd(queryDesc);
}

References ExplainState::analyze, apply_extension_options(), auto_explain_enabled, auto_explain_log_analyze, auto_explain_log_buffers, auto_explain_log_format, auto_explain_log_io, auto_explain_log_level, auto_explain_log_min_duration, auto_explain_log_parameter_max_length, auto_explain_log_settings, auto_explain_log_timing, auto_explain_log_triggers, auto_explain_log_verbose, auto_explain_log_wal, ExplainState::buffers, ExplainState::costs, StringInfoData::data, ereport, errhidestmt(), errmsg, EState::es_query_cxt, EState::es_queryEnv, QueryDesc::estate, EXPLAIN_FORMAT_JSON, explain_per_plan_hook, ExplainBeginOutput(), ExplainEndOutput(), ExplainPrintJITSummary(), ExplainPrintPlan(), ExplainPrintTriggers(), ExplainQueryParameters(), ExplainQueryText(), extension_options, fb(), ExplainState::format, INSTR_TIME_GET_MILLISEC, QueryDesc::instrument_options, ExplainState::io, StringInfoData::len, MemoryContextSwitchTo(), NewExplainState(), QueryDesc::params, QueryDesc::plannedstmt, prev_ExecutorEnd, QueryDesc::query_instr, ExplainState::settings, QueryDesc::sourceText, standard_ExecutorEnd(), ExplainState::str, ExplainState::summary, ExplainState::timing, Instrumentation::total, ExplainState::verbose, and ExplainState::wal.

Referenced by _PG_init().

explain_ExecutorFinish()

static void explain_ExecutorFinish ( QueryDesc *  queryDesc )

static

Definition at line 400 of file auto_explain.c.

{
    nesting_level++;
    PG_TRY();
    {
        if (prev_ExecutorFinish)
            prev_ExecutorFinish(queryDesc);
        else
            standard_ExecutorFinish(queryDesc);
    }
    PG_FINALLY();
    {
        nesting_level--;
    }
    PG_END_TRY();
}

References nesting_level, PG_END_TRY, PG_FINALLY, PG_TRY, prev_ExecutorFinish, and standard_ExecutorFinish().

Referenced by _PG_init().

explain_ExecutorRun()

static void explain_ExecutorRun ( QueryDesc *  queryDesc, ScanDirection  direction, uint64  count  )

static

Definition at line 378 of file auto_explain.c.

{
    nesting_level++;
    PG_TRY();
    {
        if (prev_ExecutorRun)
            prev_ExecutorRun(queryDesc, direction, count);
        else
            standard_ExecutorRun(queryDesc, direction, count);
    }
    PG_FINALLY();
    {
        nesting_level--;
    }
    PG_END_TRY();
}

References nesting_level, PG_END_TRY, PG_FINALLY, PG_TRY, prev_ExecutorRun, and standard_ExecutorRun().

Referenced by _PG_init().

explain_ExecutorStart()

static void explain_ExecutorStart ( QueryDesc *  queryDesc, int  eflags  )

static

Definition at line 327 of file auto_explain.c.

{
    /*
     * At the beginning of each top-level statement, decide whether we'll
     * sample this statement.  If nested-statement explaining is enabled,
     * either all nested statements will be explained or none will.
     *
     * When in a parallel worker, we should do nothing, which we can implement
     * cheaply by pretending we decided not to sample the current statement.
     * If EXPLAIN is active in the parent session, data will be collected and
     * reported back to the parent, and it's no business of ours to interfere.
     */
    if (nesting_level == 0)
    {
        if (auto_explain_log_min_duration >= 0 && !IsParallelWorker())
            current_query_sampled = (pg_prng_double(&pg_global_prng_state) < auto_explain_sample_rate);
        else
            current_query_sampled = false;
    }
 
    if (auto_explain_enabled())
    {
        /* We're always interested in runtime */
        queryDesc->query_instr_options |= INSTRUMENT_TIMER;
 
        /* Enable per-node instrumentation iff log_analyze is required. */
        if (auto_explain_log_analyze && (eflags & EXEC_FLAG_EXPLAIN_ONLY) == 0)
        {
            if (auto_explain_log_timing)
                queryDesc->instrument_options |= INSTRUMENT_TIMER;
            else
                queryDesc->instrument_options |= INSTRUMENT_ROWS;
            if (auto_explain_log_buffers)
                queryDesc->instrument_options |= INSTRUMENT_BUFFERS;
            if (auto_explain_log_io)
                queryDesc->instrument_options |= INSTRUMENT_IO;
            if (auto_explain_log_wal)
                queryDesc->instrument_options |= INSTRUMENT_WAL;
        }
    }
 
    if (prev_ExecutorStart)
        prev_ExecutorStart(queryDesc, eflags);
    else
        standard_ExecutorStart(queryDesc, eflags);
}

References auto_explain_enabled, auto_explain_log_analyze, auto_explain_log_buffers, auto_explain_log_io, auto_explain_log_min_duration, auto_explain_log_timing, auto_explain_log_wal, auto_explain_sample_rate, current_query_sampled, EXEC_FLAG_EXPLAIN_ONLY, INSTRUMENT_BUFFERS, INSTRUMENT_IO, QueryDesc::instrument_options, INSTRUMENT_ROWS, INSTRUMENT_TIMER, INSTRUMENT_WAL, IsParallelWorker, nesting_level, pg_global_prng_state, pg_prng_double(), prev_ExecutorStart, QueryDesc::query_instr_options, and standard_ExecutorStart().

Referenced by _PG_init().

PG_MODULE_MAGIC_EXT()

PG_MODULE_MAGIC_EXT	(	.	name = "auto_explain",
		.	version = PG_VERSION
	)

Variable Documentation

auto_explain_log_analyze

bool auto_explain_log_analyze = false

static

Definition at line 38 of file auto_explain.c.

Referenced by _PG_init(), explain_ExecutorEnd(), and explain_ExecutorStart().

auto_explain_log_buffers

bool auto_explain_log_buffers = false

static

Definition at line 40 of file auto_explain.c.

Referenced by _PG_init(), explain_ExecutorEnd(), and explain_ExecutorStart().

auto_explain_log_extension_options

char* auto_explain_log_extension_options = NULL

static

Definition at line 50 of file auto_explain.c.

Referenced by _PG_init().

auto_explain_log_format

int auto_explain_log_format = EXPLAIN_FORMAT_TEXT

static

Definition at line 46 of file auto_explain.c.

Referenced by _PG_init(), and explain_ExecutorEnd().

auto_explain_log_io

bool auto_explain_log_io = false

static

Definition at line 41 of file auto_explain.c.

Referenced by _PG_init(), explain_ExecutorEnd(), and explain_ExecutorStart().

auto_explain_log_level

int auto_explain_log_level = LOG

static

Definition at line 47 of file auto_explain.c.

Referenced by _PG_init(), and explain_ExecutorEnd().

auto_explain_log_min_duration

int auto_explain_log_min_duration = -1

static

Definition at line 36 of file auto_explain.c.

Referenced by _PG_init(), explain_ExecutorEnd(), and explain_ExecutorStart().

auto_explain_log_nested_statements

bool auto_explain_log_nested_statements = false

static

Definition at line 48 of file auto_explain.c.

Referenced by _PG_init().

auto_explain_log_parameter_max_length

int auto_explain_log_parameter_max_length = -1

static

Definition at line 37 of file auto_explain.c.

Referenced by _PG_init(), and explain_ExecutorEnd().

auto_explain_log_settings

bool auto_explain_log_settings = false

static

Definition at line 45 of file auto_explain.c.

Referenced by _PG_init(), and explain_ExecutorEnd().

auto_explain_log_timing

bool auto_explain_log_timing = true

static

Definition at line 44 of file auto_explain.c.

Referenced by _PG_init(), explain_ExecutorEnd(), and explain_ExecutorStart().

auto_explain_log_triggers

bool auto_explain_log_triggers = false

static

Definition at line 43 of file auto_explain.c.

Referenced by _PG_init(), and explain_ExecutorEnd().

auto_explain_log_verbose

bool auto_explain_log_verbose = false

static

Definition at line 39 of file auto_explain.c.

Referenced by _PG_init(), and explain_ExecutorEnd().

auto_explain_log_wal

bool auto_explain_log_wal = false

static

Definition at line 42 of file auto_explain.c.

Referenced by _PG_init(), explain_ExecutorEnd(), and explain_ExecutorStart().

auto_explain_sample_rate

double auto_explain_sample_rate = 1

static

Definition at line 49 of file auto_explain.c.

Referenced by _PG_init(), and explain_ExecutorStart().

current_query_sampled

bool current_query_sampled = false

static

Definition at line 102 of file auto_explain.c.

Referenced by explain_ExecutorStart().

extension_options

auto_explain_extension_options* extension_options = NULL

static

Definition at line 74 of file auto_explain.c.

Referenced by assign_log_extension_options(), and explain_ExecutorEnd().

format_options

const struct config_enum_entry format_options[]

static

Initial value:

= {
    {"text", EXPLAIN_FORMAT_TEXT, false},
    {"xml", EXPLAIN_FORMAT_XML, false},
    {"json", EXPLAIN_FORMAT_JSON, false},
    {"yaml", EXPLAIN_FORMAT_YAML, false},
    {NULL, 0, false}
}

Definition at line 76 of file auto_explain.c.

                                                         {
    {"text", EXPLAIN_FORMAT_TEXT, false},
    {"xml", EXPLAIN_FORMAT_XML, false},
    {"json", EXPLAIN_FORMAT_JSON, false},
    {"yaml", EXPLAIN_FORMAT_YAML, false},
    {NULL, 0, false}
};

Referenced by _PG_init().

loglevel_options

const struct config_enum_entry loglevel_options[]

static

Initial value:

= {
    {"debug5", DEBUG5, false},
    {"debug4", DEBUG4, false},
    {"debug3", DEBUG3, false},
    {"debug2", DEBUG2, false},
    {"debug1", DEBUG1, false},
    {"debug", DEBUG2, true},
    {"info", INFO, false},
    {"notice", NOTICE, false},
    {"warning", WARNING, false},
    {"log", LOG, false},
    {NULL, 0, false}
}

Definition at line 84 of file auto_explain.c.

                                                           {
    {"debug5", DEBUG5, false},
    {"debug4", DEBUG4, false},
    {"debug3", DEBUG3, false},
    {"debug2", DEBUG2, false},
    {"debug1", DEBUG1, false},
    {"debug", DEBUG2, true},
    {"info", INFO, false},
    {"notice", NOTICE, false},
    {"warning", WARNING, false},
    {"log", LOG, false},
    {NULL, 0, false}
};

Referenced by _PG_init().

nesting_level

int nesting_level = 0

static

Definition at line 99 of file auto_explain.c.

Referenced by explain_ExecutorFinish(), explain_ExecutorRun(), and explain_ExecutorStart().

prev_ExecutorEnd

ExecutorEnd_hook_type prev_ExecutorEnd = NULL

static

Definition at line 113 of file auto_explain.c.

Referenced by _PG_init(), and explain_ExecutorEnd().

prev_ExecutorFinish

ExecutorFinish_hook_type prev_ExecutorFinish = NULL

static

Definition at line 112 of file auto_explain.c.

Referenced by _PG_init(), and explain_ExecutorFinish().

prev_ExecutorRun

ExecutorRun_hook_type prev_ExecutorRun = NULL

static

Definition at line 111 of file auto_explain.c.

Referenced by _PG_init(), and explain_ExecutorRun().

prev_ExecutorStart

ExecutorStart_hook_type prev_ExecutorStart = NULL

static

Definition at line 110 of file auto_explain.c.

Referenced by _PG_init(), and explain_ExecutorStart().