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

From: Aleksander Kmetec - INTERA <aleksander(dot)kmetec(at)intera(dot)si>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Getting the search_path value for a query listed in pg_stat_activity output (feature request?)
Date: 2007-09-27 14:33:06
Message-ID: 46FBBF22.3000807@intera.si
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Browse pgsql-general by date

  From Date Subject
Next Message Stefan Schwarzer 2007-09-27 14:54:52 Re: Find "smallest common year"
Previous Message Nis Jørgensen 2007-09-27 14:15:59 Re: Why the ERROR: duplicate key violates unique constraint "master_pkey" is raised? - Is this a Bug?