On Sat, Apr 25, 2015 at 4:23 PM, Julien Rouhaud wrote:
> There are at least two projects that provides this kind of statistics
> for backends: pg_proctab (https://github.com/markwkm/pg_proctab) and
> pg_stat_kcache (https://github.com/dalibo/pg_stat_kcache). Michael also
> wrote an article on this
Le 24/04/2015 21:11, Jim Nasby a écrit :
> On 4/24/15 6:29 AM, Robert Haas wrote:
>> On Thu, Apr 23, 2015 at 9:28 PM, Tom Lane wrote:
>>> The reason nobody's gotten around to that in the last fifteen years is
>>> that per-process rusage isn't actually all that interesting; there's
>>> too much tha
On 4/24/15 6:29 AM, Robert Haas wrote:
On Thu, Apr 23, 2015 at 9:28 PM, Tom Lane wrote:
The reason nobody's gotten around to that in the last fifteen years is
that per-process rusage isn't actually all that interesting; there's
too much that happens in background daemons, for instance.
There'
On Thu, Apr 23, 2015 at 9:28 PM, Tom Lane wrote:
> The reason nobody's gotten around to that in the last fifteen years is
> that per-process rusage isn't actually all that interesting; there's
> too much that happens in background daemons, for instance.
There's *some* stuff that happens in backgr
Jeff Janes writes:
> On Thu, Apr 23, 2015 at 10:17 AM, Heikki Linnakangas
> wrote:
>> In a nutshell, I don't think PostgreSQL should get involved in that...
> I have often wanted an SQL function which would expose the back-end's
> rusage statistics to the front-end. This could support a \timing
On Thu, Apr 23, 2015 at 10:17 AM, Heikki Linnakangas
wrote:
> On 04/23/2015 08:00 PM, Radovan Jablonovsky wrote:
>
>> During current encounters with amazon web services - RDS, the DBA does not
>> have access to OS/linux shell of underlying instance. That render some
>> postgresql monitoring techn
On 04/23/2015 08:00 PM, Radovan Jablonovsky wrote:
During current encounters with amazon web services - RDS, the DBA does not
have access to OS/linux shell of underlying instance. That render some
postgresql monitoring technique of process CPU and memory usage, not
useful. Even if the AWS provide
During current encounters with amazon web services - RDS, the DBA does not
have access to OS/linux shell of underlying instance. That render some
postgresql monitoring technique of process CPU and memory usage, not
useful. Even if the AWS provide internal tools/programming interface for
monitoring,
