Skip to content

collect_pg_stat_statements_stats exceeded limits on size of allocations #141

Description

@itrifonovdba

Hi!
Could you please suggest, what could be the reason for the error when calling the function? We get an error.
invalid memory alloc request size 1868601608 +
while executing query on dblink connection named ""server_connection"" +
PL/pgSQL function collect_pg_stat_statements_stats(jsonb,integer,integer,integer) line 643 at FOR over SELECT rows +
SQL statement ""SELECT collect_pg_stat_statements_stats(server_properties, sserver_id, s_id, topn)"" +
PL/pgSQL function take_sample(integer,boolean) line 596 at PERFORM +
PL/pgSQL function take_sample_subset(integer,integer) line 27 at assignment +
SQL function ""take_sample"" statement 1 +
Failed on request of size 1868601608 in memory context ""ExprContext"": exceeded limits on size of allocations (1073741823)

Version pg_profile 4.2.b.

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions