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.
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
