Getting the search_path value for a query listed in pg_stat_activity output (feature request?)

Поиск
Список
Период
Сортировка
От Aleksander Kmetec - INTERA
Тема Getting the search_path value for a query listed in pg_stat_activity output (feature request?)
Дата
Msg-id 46FBBF22.3000807@intera.si
обсуждение исходный текст
Список pgsql-general
Hi, all.

Is there a way to find out which search_path a query is using?

I have around 100 schemas, each of them containing the same set of tables. When the app connects it sets the
search_path 
and then doesn't use the schema name anywhere again, which means that it's impossible to see which exact table is being

used by a query just by looking at pg_stat_activity output.

It would also be nice if it was possible to have search_path added to logged statements.

Regards,
Aleksander.

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

Предыдущее
От: Stefan Schwarzer
Дата:
Сообщение: Re: Find "smallest common year"
Следующее
От: "Scott Marlowe"
Дата:
Сообщение: Re: Find "smallest common year"