On Fri, Nov 11, 2011 at 4:18 AM, Raghavendra <
raghavendra@enterprisedb.com> wrote:
> Respected,
>
> All the time we see 'idle in transaction' in pg_stat_activity and dig
> details with process pid from pg_logs for the query,query execution time
> etc..
> Instead of searching with process pid,
Respected,
All the time we see 'idle in transaction' in pg_stat_activity and dig
details with process pid from pg_logs for the query,query execution time
etc..
Instead of searching with process pid, am trying to pull the information
with shell scripting for lines prefixed with 'idle in transaction
