Skip to content
By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post
About re:Post

Missing Aurora Function after upgrade from aurora pg 12 to pg 13

0

Hello,

We recently upgraded from aurora pg 12.4 to aurora 13.4 and after that, we noticed that this query stopped working,

select sum(allocated) from aurora_stat_memctx_usage()

I did not see anything in the change log about this method going away, but I'm unable to call it on any of our aurora 13.4 instances, but it works fine on our aurora 12.4 instance.

Any help would be appreciated.

Topics
AnalyticsDatabase
Tags
Aurora PostgreSQLPostgreSQLAmazon Aurora
Language
English

asked 4 years ago222 views

1 Answer
0

aurora_stat_memctx_usage() function is available in Aurora versions 13.11 and above and hence you were unable to use it. Try upgrading your DB instance to a higher version and then re-run this function. Refer to this document: https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora_stat_memctx_usage.html

AWS
EXPERT

answered a year ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Relevant content