Getting the search_path value for a query listed in pg_stat_activity output (feature request?)
Getting the search_path value for a query listed in pg_stat_activity output (feature request?)
От:
Aleksander Kmetec - INTERA <aleksander.kmetec@intera.si>
Дата:
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.