Share via

pg_stat_statements Extension issue in Azure Database for PostgreSQL flexible server

Naveen Kumar Kakarla (Quadrant Resource) 201 Reputation points
2024-07-02T16:04:24.9766667+00:00

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

Azure Database for PostgreSQL

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. GeethaThatipatri-MSFT 29,587 Reputation points Microsoft Employee Moderator
    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

    User's image

    Step 2 Create extensions as shown

    User's image

    Please follow the above steps and let me know if you are still getting the error.

    Regards

    Geetha

    1 person found this answer helpful.
  2. Naveen Kumar Kakarla (Quadrant Resource) 201 Reputation points
    2024-07-02T16:14:56.0566667+00:00

    PostgreSQL version is 15.6

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.