Re: pg_stat_statements_info

From: Holger Jakobs <holger(at)jakobs(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: pg_stat_statements_info
Date: 2023-09-11 21:45:43
Message-ID: 3047F5E5-A503-44EB-9F12-642E80CCD5DC@jakobs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

It's just not in a schema contained in you search_path

Am 11. September 2023 23:26:22 MESZ schrieb Wells Oliver <wells(dot)oliver(at)gmail(dot)com>:
>I don't have this view:
>
>ERROR: relation "pg_stat_statements_info" does not exist
>LINE 1: select * from pg_stat_statements_info;
> ^
>But I definitely have the pg_stat_statements extension installed and
>query pg_stat_statements quite frequently... What gives?
>
>--
>Wells Oliver
>wells(dot)oliver(at)gmail(dot)com <wellsoliver(at)gmail(dot)com>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Wells Oliver 2023-09-11 21:51:53 Re: pg_stat_statements_info
Previous Message Wells Oliver 2023-09-11 21:26:22 pg_stat_statements_info