Re: pg_stat_statements_info

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxx> 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@xxxxxxxxx>:
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.oliver@xxxxxxxxx

[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux