Re: Additional DTrace Probes

From: Robert Lor <Robert(dot)Lor(at)Sun(dot)COM>
To: ITAGAKI Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
Cc: pgsql-hackers list <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Additional DTrace Probes
Date: 2009-03-08 20:07:26
Message-ID: 49B4257E.1020003@sun.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

ITAGAKI Takahiro wrote:
> This will introduce SLRU and Executor probes.
> We already have Lock, LWLock, Buffer, I/O and XLogs probes.
>
> I'd like to have the following probes, too. In my experience,
> they could be bottlenecks or consume much time in some situations.
>
> - idle in transaction
> - spinlock wait-and-retry
> - CPU: Trigger execution
> - CPU: Encoding conversion
> - Network: send() and recv()
> - smgr: lseek() calls
> - Tempfile reads and writes
>
>
Great suggestions. If you have particular use cases in mind, please send
them to the list. This will help determine what kind of data to be made
available via the probes. It'll also be helpful if you know the
locations for the probes.

-Robert

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Dickson S. Guedes 2009-03-08 20:29:21 Re: ERROR: "failed to locate grouping columns"
Previous Message Tom Lane 2009-03-08 19:49:04 Re: status of remaining patches