Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qJ6xb-0004kq-1O for pgadmin-hackers@arkaria.postgresql.org; Tue, 11 Jul 2023 06:34:55 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1qJ6xY-0004hk-RT for pgadmin-hackers@arkaria.postgresql.org; Tue, 11 Jul 2023 06:34:52 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qJ6xY-0004hb-JV for pgadmin-hackers@lists.postgresql.org; Tue, 11 Jul 2023 06:34:52 +0000 Received: from mail-qt1-x834.google.com ([2607:f8b0:4864:20::834]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qJ6xU-003QOe-T9 for pgadmin-hackers@postgresql.org; Tue, 11 Jul 2023 06:34:51 +0000 Received: by mail-qt1-x834.google.com with SMTP id d75a77b69052e-401e0ceb4e6so42927281cf.1 for ; Mon, 10 Jul 2023 23:34:48 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb.com; s=google; t=1689057287; x=1691649287; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=5CoCVSOMXyWMx1BkvrmhZBHJsVtDAfYfI5XxHj1rEek=; b=NTvDB2Ev+WZSU2QDqSG4c8rxmC1CVX6Dq5kbttPgAaTV/hxxk0SRl55AxVKnuvA97G XKOa1zETPxZUKm+wm5wAhO6N+XaY8Indehs9+BhP9VGdeTOv8qeGI2XlUPgxCGs7+UNW CvXwlwXxGAwsvRAhGx72P02vIb+FTUdgEQ3H00IolrcH8bSeLTTh7ln0h2jgE3c0l8tz Qb29w3KRYn++BcHFDLyFm0bk3ISIlwxd5DSlIzMX0YYRd78M0j5If+VouWxZOn3oqv0d rs6WxdVn26qeyHnGeFpE/Xsrd2pxqGTmTg1S/2LUFkMq1cSYkX91wZdhbr/rIJBKRYKw YyQA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1689057287; x=1691649287; 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=5CoCVSOMXyWMx1BkvrmhZBHJsVtDAfYfI5XxHj1rEek=; b=NuZnnmBOsM6WsLMOxEMxFucpFTvSxhwP8spZPLuDmN8/pl8xTaGT0FO92VHTMmiiCp 6LIQobAaTYp3pD2OSV7BIc7rwVdOVDRZr9n+ajTp3sIkpNKglhE0LzYpBPHulVc1JODB XCV+PPIxWnfqHTD7RSpY0h1DH6bzyATOcXygXFiU1T3Vu6EPFJm1CVuGv/68L+ubCuZb uw22PuiAJ9fQy6bK/pdKbByGWjhOHZi4kyqt+Pj1yn0hgHcU9CLOLJyC6rPZIrzAn2+B 2Ftn0l0Q/3Mk9HfIixHOVzjnn3j/MfxrSul4id3CoC8YZDfiTppYHe8vaIckdhKgXf89 JouA== X-Gm-Message-State: ABy/qLYpk0Kf30lWeeWdfrcWYjBojxvliS/xFl+sIa+xdBKvESCgUgKv BztphHdBSEQIrSIuMAkdMiUMYi8j9vAjU/vFXk8fmA== X-Google-Smtp-Source: APBJJlGn7FkJJH8S/1QqFG+EYcnWUde3eF2xGKt+ydIhUuFRNg3GbbKoORw71tkHcRNrCx6X9CKsPKCj8+SfAzJ2s8g= X-Received: by 2002:ac8:5a44:0:b0:403:a900:1fe7 with SMTP id o4-20020ac85a44000000b00403a9001fe7mr9823927qta.55.1689057286918; Mon, 10 Jul 2023 23:34:46 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Ashesh Vashi Date: Tue, 11 Jul 2023 12:04:35 +0530 Message-ID: Subject: Re: Pgadmin4 System Stats Extension Design To: Sahil Harpal Cc: Dave Page , Aditya Toshniwal , Akshay Joshi , Khushboo Vashi , pgadmin-hackers@postgresql.org Content-Type: multipart/alternative; boundary="00000000000097a9020600304b28" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000097a9020600304b28 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Tue, Jul 11, 2023 at 11:58=E2=80=AFAM Sahil Harpal wrote: > Hi, > > I have written code for the Summary and CPU tabs and would like to post i= t > here for review. > > I'm currently displaying the static values in the process info pie chart > because of a minor bug. The pg_sys_process_info() query takes much longer > (around 2 mins) to execute and prevents the updation of other graphs and > tables. I tried adding it in separate useInterval with larger pollDelay, > but it didn't work. In the patch, I commented out that snippet (In > Summary.jsx). > Try preloading the extension in the PostgreSQL server. e.g. Add this extension in the 'shared_preload_libraries' in postgresql.conf. Reference: https://pgpedia.info/s/shared_preload_libraries.html -- Ashesh > > I'm attaching the *WIP.patch* file which contains the latest changes and > also the SS of the Summary and CPU tabs. > > --00000000000097a9020600304b28 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
= On Tue, Jul 11, 2023 at 11:58=E2=80=AFAM Sahil Harpal <sahilharpal1234@gmail.com> wrote:
Hi,
I have written code for the Summary and CPU tabs and would= like to post it here for review.

I'm currently displaying the s= tatic values in the process info pie chart because of a minor bug. The pg_s= ys_process_info() query takes much longer (around 2 mins) to execute and pr= events the updation of other graphs and tables. I tried adding it in separa= te useInterval with larger pollDelay, but it didn't work. In the patch,= I commented out that snippet (In Summary.jsx).
Try preloading the extension in the PostgreSQL server.
e.g.= =C2=A0 Add this extension in the 'shared_preload_libraries' in post= gresql.conf.

Reference:=C2=A0https://pgpedia.info/s/shared_preload_libraries.h= tml

-- Ashesh

I'm a= ttaching the WIP.patch file which contains the latest changes and al= so the SS of the Summary and CPU tabs.

3D""
--00000000000097a9020600304b28--