Re: [PATCH] Add features to pg_stat_statements - Mailing list pgsql-hackers

+1 !

An other way is to log evictions, it provides informations about time and
amount :

    for (i = 0; i < nvictims; i++)
    {
        hash_search(pgssp_hash, &entries[i]->key, HASH_REMOVE, NULL);
    }

    pfree(entries);

    /* trace when evicting entries, if appening too often this can slow queries
...
     * increasing pg_stat_sql_plans.max value could help */
     ereport(LOG,
        (errmsg("pg_stat_sql_plans evicting %d entries", nvictims),
        errhidecontext(true), errhidestmt(true)));



--
Sent from: https://www.postgresql-archive.org/PostgreSQL-hackers-f1928748.html