Re: [GENERAL] pg_catalog.pg_stat_activity and current_query

2011-03-01 Thread Szymon Guz
On 1 March 2011 09:36, Alex wrote: > 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_ac

[GENERAL] pg_catalog.pg_stat_activity and current_query

2011-03-01 Thread Alex
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()