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 1qXwYW-000O7V-7u for pgadmin-hackers@arkaria.postgresql.org; Mon, 21 Aug 2023 04:30:20 +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 1qXwXX-002GwH-3O for pgadmin-hackers@arkaria.postgresql.org; Mon, 21 Aug 2023 04:29:18 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qXwXW-002Gw9-IY for pgadmin-hackers@lists.postgresql.org; Mon, 21 Aug 2023 04:29:18 +0000 Received: from mail-yw1-x1131.google.com ([2607:f8b0:4864:20::1131]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qXwXS-0005Ej-HA for pgadmin-hackers@postgresql.org; Mon, 21 Aug 2023 04:29:16 +0000 Received: by mail-yw1-x1131.google.com with SMTP id 00721157ae682-59205f26e47so9078587b3.2 for ; Sun, 20 Aug 2023 21:29:14 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb.com; s=google; t=1692592154; x=1693196954; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=5/QbfvYgfB1gEibnFqpV1ZNqalmv2uoH3F3gbtZWcpQ=; b=ZTGalTPhrSWjVjdZLLUIMODYFabJTjpKv/cwfX8cxQGDWUfm/XlFPg9Ej16nVxAC6P s0KjLKSGu3FJ4FEioOXdpvDBo7udDcXxFBpMf847rDpQMI0bg4IB8mi/4NmNgNhsV4PI mZWksNPPvYH4C0GASO65cEilea17PTu27wDSETaUO8HzQJALkuLVlSKcLgYMO10njCEM N4yxg7iiMyqD4IiKnOj9A+0eqpo+xO0Af5UjzVOMK5Be2RlysfOze6726xX3V8EUzDO7 h+1G3F41esQ9l7s4MlTbuoJTP2l7vQy6gu8yA8fi4B33zoxpNJ56TnpEDS7mVgYJu+PY +7OA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1692592154; x=1693196954; 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=5/QbfvYgfB1gEibnFqpV1ZNqalmv2uoH3F3gbtZWcpQ=; b=JfhxIHMq3inU629urp9w6uZ/CHu6wTCWmE/KPHODYomOrhEDbfyBrngx+Koxxp7AkK 6j/9Bp5X/um1LWiOaJkRJwzWShj7zb/g8H8x79sCVeeEB6SZFCzNPGxv937f6nhXI+Ew 2oUzE4hHWOQFraXT/+jQ7Bh/ByAK976ZEF/810u2sXcwzMoqMwuwEVZguk80lg3Xna0o YG2PAodklTHMxroSZ/DnDoFNVXi4f7NYUsJ9qUOqjiI8PQFMz4NpQz+bDapRlDDmcDYI zOjIcH7SnftIbFxcx7L5zzwsT4I9StBRKdxerFsodQ0T/B/BaFxSme2/ZFHo75imvKl9 S6hw== X-Gm-Message-State: AOJu0Yx40fPic7d8Nl+HEXN8oA8NdlJ8Dl9u2OBQMORPQGChrL59dubv 2bGmZ2A4oA5Rg8BnHqRKw20K4lPVHfjFj51ZEWTnbA== X-Google-Smtp-Source: AGHT+IFa1bDW8I+TLM9cWYQeSxM2jpjiWWEqljfonwnQaGYR8IZ7rneYoFpAXIXwhTtJ8UG/29aByqZO9oHeSdrvxD0= X-Received: by 2002:a81:72c1:0:b0:577:606c:284b with SMTP id n184-20020a8172c1000000b00577606c284bmr5217566ywc.16.1692592153767; Sun, 20 Aug 2023 21:29:13 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Khushboo Vashi Date: Mon, 21 Aug 2023 09:59:02 +0530 Message-ID: Subject: Re: Pgadmin4 System Stats Extension Design To: Sahil Harpal Cc: pgadmin-hackers@postgresql.org, Dave Page , Aditya Toshniwal , Akshay Joshi , Ashesh Vashi Content-Type: multipart/alternative; boundary="0000000000001347e90603675266" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000001347e90603675266 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Sat, Aug 19, 2023 at 4:21=E2=80=AFPM Sahil Harpal wrote: > On Thu, 10 Aug 2023 at 00:37, Sahil Harpal > wrote: > >> Pending Work: >> >> 1. Process information - >> - Issue: The pg_sys_process_info() query takes much longer (more >> than 2 mins) to execute and prevents the updation of other graphs = and >> tables. >> >> This may happen on Windows, can you try to fetch these details separatel= y (not combining with other charts) only for Windows? > >> 1. Disk information - >> - Issue: The pg_sys_disk_info() query returns NULL value for some >> of the drive letters. >> >> If it returns NULL then do not show anything for that field for particular Disk. > >> 1. StreamingChart - >> - Issue: Graph shifting glitch. For the first time, graphs start >> from the opposite side, and after the following API call or a few = seconds >> later, those get adjusted. >> >> I need suggestions for labels for different tables and charts. Also, >> could you please clarify the use of the counterData variable, which is u= sed >> for some of the charts (tps_stats, ti_stats, to_stats, and bio_stats)? >> > > Could you please help me with these blockers and doubts? > > Thank you, > Sahil > --0000000000001347e90603675266 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable


=
On Sat, Aug 19, 2023 at 4:21=E2=80=AF= PM Sahil Harpal <sahilharpa= l1234@gmail.com> wrote:
3D""
On Thu, 10= Aug 2023 at 00:37, Sahil Harpal <sahilharpal1234@gmail.com> wrote:
=
Pending Work:
  1. Process information -
      2. =
    • Issue: The pg_sys_process_info() query takes much longer (more than 2 m= ins) to execute and prevents the updation of other graphs and tables.=C2=A0=
This may happen on Windows, can you try to fetch these details separately = (not combining with other=C2=A0charts) only for Windows?
  1. Disk information -
    • Issue: The=C2=A0= pg_sys_disk_info() query returns NULL value for some of the drive letters.<= /li>
= If it returns=C2=A0NULL then do not show anything=C2=A0for that field for p= articular Disk.
  1. StreamingCha= rt -=C2=A0
    • Issue: Graph shifting=C2=A0glitch.=C2=A0For the first time, graphs start = from the opposite side, and after the following API call or a few seconds l= ater, those get adjusted.
I need suggestions for labels = for different tables and charts. Also, could you please clarify the use of = the counterData variable, which is used for some of the charts (tps_stats, = ti_stats, to_stats, and bio_stats)?

=
Could you please help me with these blockers and=C2=A0doubts?

Thank you,
Sahil
--0000000000001347e90603675266--