title: How can I see schema for queries in pg_stat_activity?
body: <p>I am trying to sort out some app performance issues with slow queries. We are using Postgresql 9.2. I can see the queries in progress easily:</p>
  
  <pre><code>postgres=# select now() - query_start, query from pg_stat_activity where state &lt;&gt; 'idle';
  
  00:00:01.535388 | select bla from product where ...
  </code></pre>
  
  <p>I need to know what schema the tables listed in the query are in. How can I see which "product" table is being queried given that there are hundreds of them in different schemas in the same database.</p>