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 |
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(*)? |