Re: Update blocking a select count(*)?

From: Benedict Holland <benedict(dot)m(dot)holland(at)gmail(dot)com>
To: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Update blocking a select count(*)?
Date: 2012-06-15 19:04:32
Message-ID: CAD+mzow8T8NoN-OY8nCgZFfDnQZuyqxWhB3e+QXpbs=L9zbSTg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Sure. The last column are the series of commands to produce the outputs.
This is coming from pgadmin3. I should have mentioned before that this is
running windows but that shouldn't matter for this particular sense I hope.

The first column is the PID, the last column is the command running. The
dates are the start time of the operations. The YES/NO is the running state
of the process. In the activity section the 2nd to last column is the
process blocking the executing process.

Thanks,
~Ben

On Fri, Jun 15, 2012 at 2:54 PM, Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov
> wrote:

> Benedict Holland <benedict(dot)m(dot)holland(at)gmail(dot)com> wrote:
> > Sorry about the raw text but this is what I am seeing:
> >
> > [wrapped text without column headers]
>
> Could you try that as an attachment, to avoid wrapping? Also, the
> column headers, and/or the query used to generate those results
> would be helpful.
>
> -Kevin
>

Attachment Content-Type Size
email.txt text/plain 4.3 KB

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Benedict Holland 2012-06-15 19:12:00 Re: Update blocking a select count(*)?
Previous Message Kevin Grittner 2012-06-15 19:03:35 Re: Update blocking a select count(*)?