| From: | wd <wd(at)wdicc(dot)com> |
|---|---|
| To: | fabriziomello(at)gmail(dot)com |
| Cc: | PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: How to find which query a waiting query waiting for? |
| Date: | 2012-12-08 12:32:32 |
| Message-ID: | CABexzmiDJio3m9euD_SC373oa4DyE2D=-cvVB0X6Nup-hW-mPw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I know how to do this, thanks.
On Fri, Dec 7, 2012 at 11:09 PM, Fabrízio de Royes Mello <
fabriziomello(at)gmail(dot)com> wrote:
>
> On Fri, Dec 7, 2012 at 1:02 PM, wd <wd(at)wdicc(dot)com> wrote:
>
>> hi,
>>
>> From pg_stat_activity I can find a query is at waiting state, and from
>> pg_locks and pg_class can find which relation the query is waiting for, But
>> how to find witch query is lock the relation?
>>
>
> Maybe you found what you need here [1].
>
> [1] http://wiki.postgresql.org/wiki/Lock_Monitoring
>
> --
> Fabrízio de Royes Mello
> Consultoria/Coaching PostgreSQL
> >> Blog sobre TI: http://fabriziomello.blogspot.com
> >> Perfil Linkedin: http://br.linkedin.com/in/fabriziomello
> >> Twitter: http://twitter.com/fabriziomello
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Condor | 2012-12-08 13:54:17 | Query and index ... unexpected result need advice. |
| Previous Message | Jeff Janes | 2012-12-08 01:33:45 | Re: Large temporary file generated during query |