Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
930 questions
PostgreSQL version is 15.6
pg_stat_statements Extension issue in Azure Database for PostgreSQL flexible server
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(25.6, 86%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENK%3C/text%3E%3C/svg%3E)
Naveen Kumar Kakarla (Quadrant Resource)
201
Reputation points
pg_stat_statements extension is enabled in Azure Database for PostgreSQL flexible server, but when I run the command select * from pg_stat_statements it is giving ERROR: relation "pg_stat_statements" does not exist
{count} votes
-
GeethaThatipatri-MSFT 29,007 Reputation points Microsoft Employee2024-07-02T16:09:56.5766667+00:00 @Naveen Kumar Kakarla (Quadrant Resource) Thanks for posting your question in the Microsoft Q&A forum.
Which version of Postgres flex you are using and region?
Regards
Geetha
Sign in to comment
2 answers
Sort by: Most helpful
-
Naveen Kumar Kakarla (Quadrant Resource) 201 Reputation points
2024-07-02T16:14:56.0566667+00:00 -
GeethaThatipatri-MSFT 29,007 Reputation points Microsoft Employee
2024-07-03T00:07:55.8033333+00:00 @Naveen Kumar Kakarla (Quadrant Resource)
I hope you followed the below steps.Add PG_STAT_STATEMENTS under Azure.extensions
Step 2 Create extensions as shown
Please follow the above steps and let me know if you are still getting the error.
Regards
Geetha