Re: docs log_executor_stats

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Uwe Bartels <uwe.bartels@xxxxxxxxx> writes:
> i know what a context switch is or a page fault/reclaim, etc.
> what i need to know is the context of the numbers:
> - numbers without brackets
> - number with brackets

It looks like the numbers in brackets are the latest raw numbers from
getrusage(), whereas the numbers before the brackets are the delta
from a getrusage() call made at the start of execution.

> - context for those numbers: are all of these numbers one-to-one related to
> my function call? Or did those numbers (signals/page reclaims) come up
> during the time of execution of that function?

It's just the overall getrusage result for the backend process.

> what I don't know and never found so far is "Local  blocks" and "Direct
> blocks". So I'd be interested to know what's this, jst for completeness.

Local blocks are (or were ... that code is gone as of 9.0) I/O for
temporary tables of the current backend.  I think direct blocks was a
count of I/Os on temp files (sort data and so on).

			regards, tom lane

-- 
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux