title: How to get a status of a running query in postgresql database
body: <p>I have a select query running very long. How will I get a status of that query, like how long will it be running? Whether it is accessing a data from the tables or not.</p>
  <p>Note : As per <code>pg_stat_activity</code> the query state is shown as active and not in a waiting state.
  Like in Oracle, we can see the source/target and processing status of a query - is there something like this in postgresql?</p>