pg_catalog.pg_stat_activity and current_query

Поиск
Список
Период
Сортировка
От Alex
Тема pg_catalog.pg_stat_activity and current_query
Дата
Msg-id cb45f32a-9b25-4402-afb6-fd63a58b6f75@v31g2000vbs.googlegroups.com
обсуждение исходный текст
Ответы Re: pg_catalog.pg_stat_activity and current_query  (Szymon Guz <mabewlun@gmail.com>)
Список pgsql-general
Good morning,

I'm trying to make a Postgre profiler reading
pg_catalog.pg_stat_activity.
But when I read that view... I always find my query.

Example:

ResultSet rs = st.executeQuery("SELECT query_start,current_query FROM
pg_catalog.pg_stat_activity where xact_start is not null");
while(rs.next()) {
  String sQuery = rs.getString("current_query");
  qStart = rs.getTimestamp("query_start");
  if(!qStart.equals(qStart_last)){
    display.append(sQuery+'\n');
    qStart_last=(Timestamp)qStart.clone();
  }
}

Always prints "SELECT query_start,current_query FROM
pg_catalog.pg_stat_activity where xact_start is not null" :)

I'd like to discard my query... any ideas?

Thanks

В списке pgsql-general по дате отправления:

Предыдущее
От: Orhan Kavrakoglu
Дата:
Сообщение: Re: how to avoid repeating expensive computation in select
Следующее
От: Szymon Guz
Дата:
Сообщение: Re: pg_catalog.pg_stat_activity and current_query