Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uUXYQ-004r8w-MG for pgsql-admin@arkaria.postgresql.org; Wed, 25 Jun 2025 21:21:14 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1uUXYO-0068ws-H7 for pgsql-admin@arkaria.postgresql.org; Wed, 25 Jun 2025 21:21:13 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uUXYO-0068wj-3x for pgsql-admin@lists.postgresql.org; Wed, 25 Jun 2025 21:21:12 +0000 Received: from mail-qv1-xf31.google.com ([2607:f8b0:4864:20::f31]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uUXYJ-0046PY-2X for pgsql-admin@lists.postgresql.org; Wed, 25 Jun 2025 21:21:12 +0000 Received: by mail-qv1-xf31.google.com with SMTP id 6a1803df08f44-6fafd3cc8f9so5939706d6.3 for ; Wed, 25 Jun 2025 14:21:07 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1750886466; x=1751491266; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=+YYQNfQQKhliujGg6lGnXwr9FxrleOK1+INAs84gXTU=; b=MPxP12O+ockcz72FagWZ/NLJQ19QMDek7QkAmTR24cSyt/VqYKyRbjyBMVjAjgtCDd ap5CQtR7zbQNbnfSRSfE2ExD7SZ7jPrAdUuWcfqulo+Gv3D+dbPsjRQn4oiQDL7QBo7l rrchmt4WzJrxw90gicmZJuv+SUxdrs3lmdTTiuftuynFWLioLhlZ5eJnZvLxpgzfY8nj M9b4biAC6SAQXgflZist+FhTN0Rd0P9MO0UmahmA7gvgbwwRkmq7fv1/epAsvnMFAszP KTpY1DSKM0xG6SNi9uvZEZji6OnqKEBYIsjcSzF4zsn/7Q+HqM8iwgioD7wL9yWNltUQ 3L/g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1750886466; x=1751491266; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=+YYQNfQQKhliujGg6lGnXwr9FxrleOK1+INAs84gXTU=; b=rFA63Bc1gVFZhkrvUo2pWI6ucEhAikkc10Mzbzih9n9M2uMb00z4BDTx3SfpFQgLe4 +iGqzYzwbQ1eGFb7WLP+Y2wYPleggrydx5ue9r/mjLlF5CRbL2kjrAdAiTWr7YPUUlbs PpmdtKDv/NAP3lR2CgFHqviOB2J4Y3Ehs9ZeZrF92afI15KDBLzfQE1JilcufFSRzt03 89WfcsiINA95/W4ZbtBG/xG7LYQ49QIx59gXP8wD2JLS1gaflglJ8GI8WVSVz4uIXm0T sBqkEXFtEJwhyM+Q/ER88pnkPP7MxPdVKUrnLW+yMJm3G6/ofXfZv0dsNo58Kj+5PqLv syWg== X-Gm-Message-State: AOJu0Yw8B4qjkJWmbqcxxSGjp9iFAU+Q4LrGlDiidhyjBRh74m5E20lD U9m0bjRrUwgKd8hiih4bbhq7MySwjyt2Cfghdyg3inMHbasxFWyxcA8oF7lke1Q3bc7djzgeU6d YTnrujyyESqFk+gfgqKJ1Bjx+4j9Tzdri97oCjaw= X-Gm-Gg: ASbGncs9BlziTcjYeriw7C6+uGNvRdtXEqorji7jwIMrzKAg4Sk/aSQ1YkjuAwl+kM5 Uz+jtxR/SZlCE0yyQo9EP/5mA5pL3PnRgqAdZwflrB91vBQtpd+lNFKQ3RbFczWPx7zNdAeczA5 w/36XK/wirI/I5EhPR3RDsGPObpVzop6usQbMYdf4b5ayJ67vxbIdooaUNQ7mRefStJyI5kKKPg EAx X-Google-Smtp-Source: AGHT+IHWcNzfYOzO+vfAv9DFeMqpnAemeOmElCHHKm3meOyyG5S5iZyvK8HsKD6ZiOUdPmrVrYnmkEhzvZaNAfbl628= X-Received: by 2002:a05:6214:54c6:b0:6fb:4e82:6e8 with SMTP id 6a1803df08f44-6fd5ef454f2mr81218476d6.14.1750886465626; Wed, 25 Jun 2025 14:21:05 -0700 (PDT) MIME-Version: 1.0 References: <21822fab-95d8-444d-b151-f4f88acbc233@quadratum-braccas.com> In-Reply-To: <21822fab-95d8-444d-b151-f4f88acbc233@quadratum-braccas.com> From: "David G. Johnston" Date: Wed, 25 Jun 2025 14:20:28 -0700 X-Gm-Features: Ac12FXwsi-NRhtwSoO4Wqtj1jqtrX3Xq2nVCFZ4UlF2NfbHX_NFq8VbIgigi-W8 Message-ID: Subject: Re: plprofiler report question To: Sbob Cc: pgsql-admin@lists.postgresql.org Content-Type: multipart/alternative; boundary="000000000000d3653006386c056f" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000d3653006386c056f Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Wed, Jun 25, 2025 at 2:08=E2=80=AFPM Sbob w= rote: > Sorry if this is off topic. I have setup plprofiler and generated a test > report. The times are all shown as : > > self_time =3D 894 =C2=B5s > total_time =3D 894 =C2=B5s > > > not sure what the =C2=B5s is, is this supposed to be milliseconds? > > ms is milliseconds 1e-3 seconds =C2=B5s or us is microseconds 1e-6 seconds ns is nanoseconds 1e-9 seconds David J. --000000000000d3653006386c056f Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Wed, Jun 25, 2025 at 2:08=E2=80=AFPM Sbob <sbob@quadratum-braccas.com> w= rote:
Sorry if this is off topic.= I have setup plprofiler and generated a test
report. The times are all shown as :

self_time =3D 894 =C2=B5s
total_time =3D 894 =C2=B5s


not sure what the =C2=B5s is, is this supposed to be milliseconds?

<= /blockquote>

ms is milliseconds 1e-3 seconds
=C2= =B5s or us is microseconds 1e-6 seconds
ns is nanoseconds 1e-9 seco= nds

David J.

--000000000000d3653006386c056f--