| From: | Willy-Bas Loos <willybas(at)gmail(dot)com> |
|---|---|
| To: | Scott Mead <scott(at)scottrmead(dot)com> |
| Cc: | Vick Khera <vivek(at)khera(dot)org>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: where is pg_stat_activity (and others) in the documentation? |
| Date: | 2010-11-17 07:46:22 |
| Message-ID: | AANLkTi=1aP0J7QWsc0r4Q7emBZjFkbhj1oxRhGsx0DUr@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> You can find out exactly what you're waiting for by correlating this to the
> pg_locks table.
> Grab the 'procpid' of your waiting query and run:
> select * from pg_locks where pid=<thepid> and granted='f';
> Notice, in the pg_locks table, the logic works slightly different... if
> you're 'waiting' (pg_stat_activity), then you haven't been 'granted'
> (pg_locks).
>
Thanks.
> As far as documentation:
> http://www.postgresql.org/docs/current/static/monitoring-stats.html
>
I do think that we need per-column documentation of the Standard Statistics
Views.
Would it be considered for the documentation if i give describing them a
try?
If so, where do i send it ?
Cheers,
WBL
--
"Patriotism is the conviction that your country is superior to all others
because you were born in it." -- George Bernard Shaw
| From | Date | Subject | |
|---|---|---|---|
| Next Message | maarten | 2010-11-17 07:55:06 | Re: median for postgresql 8.3 |
| Previous Message | Tom Lane | 2010-11-17 05:58:39 | Re: strange row count estimates with conditions on multiple column |