Re: pg_stat_statements_info

Поиск
Список
Период
Сортировка
От Wells Oliver
Тема Re: pg_stat_statements_info
Дата
Msg-id CAOC+FBWfKTNQzf2pNLEscQAHdRwW8aQ_A43rYuUNOOLzGTnFoQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: pg_stat_statements_info  (Holger Jakobs <holger@jakobs.com>)
Список pgsql-admin
Дерево обсуждения
Hmm, what schema is it in? Why would pg_stat_statements be in a different, available schema?

On Mon, Sep 11, 2023 at 2:46 PM Holger Jakobs <holger@jakobs.com> wrote:
It's just not in a schema contained in you search_path


Am 11. September 2023 23:26:22 MESZ schrieb Wells Oliver <wells.oliver@gmail.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?



--

В списке pgsql-admin по дате отправления:

Предыдущее
От: Holger Jakobs
Дата:
Сообщение: Re: pg_stat_statements_info
Следующее
От: Wells Oliver
Дата:
Сообщение: btree/gist index on date and searching using BETWEEN or >= and <=