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 1qWZES-003fRw-8L for pgadmin-hackers@arkaria.postgresql.org; Thu, 17 Aug 2023 09:23:56 +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 1qWZEQ-00Fba6-V2 for pgadmin-hackers@arkaria.postgresql.org; Thu, 17 Aug 2023 09:23:55 +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 1qWZEQ-00FbZx-IG for pgadmin-hackers@lists.postgresql.org; Thu, 17 Aug 2023 09:23:54 +0000 Received: from mail-yw1-x112c.google.com ([2607:f8b0:4864:20::112c]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qWZEN-000bGt-Cp for pgadmin-hackers@postgresql.org; Thu, 17 Aug 2023 09:23:52 +0000 Received: by mail-yw1-x112c.google.com with SMTP id 00721157ae682-58caaedb20bso16287677b3.1 for ; Thu, 17 Aug 2023 02:23:51 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb.com; s=google; t=1692264230; x=1692869030; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=tT8L2ldRf2a9fHQGQ8pR7E5xqqJ51Htvna98WoKbZqA=; b=gSZw2KUKEks8Kb/4cmaMKKLweQznxxsvOIkMcNRDOplYrfWPQndge75WljaGzHzahs H7kB078YLaExrcac49t+FTJApsVtmRyY3R+h1t3kEHuaQyjhEYy/5DDqQU8JoajkvK1R mqYN4wkTWasF25C9KtRVP9Pwy245Oz/N6UH79UyzytvhJ0hBPJOAPCObDCdAoHKI8cmx udiYb+F51W0/t5MdvwrTlnZbSBWzKOnZoO7/CWtoLmzVmEvfrZHQWv2fZJKN155/LdCP 1rE/oCnGloRxNVK9izqpmzz4usAb0fCyIofjfTtOuCLYAYWuGft/SdEW7rz/NbhuPVY9 WIww== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1692264230; x=1692869030; 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=tT8L2ldRf2a9fHQGQ8pR7E5xqqJ51Htvna98WoKbZqA=; b=hn1zWvOyccQ0281KLwpDPRotkF8C/hLLFI3ON1pn46euZEPvy7imcn5p870kmn8J4i aWnRPL6imJhji32ZtyHrs0mwWd7gyUFL3PRplWozGJ2kbej1vHZ9IYhCAtCB0oqtq4be lwruyfgfdxxDcI1v8EhkWaVV8mPzkidIcj7SFBxijIgsJykeW5nwywoOLbbGWfoi7twk ESalltBfWwg4gjY6Ohtqwtug6tXx1QEh/lfxRZVLzChgrNSYBQr47VDJjMuSvnbkEDIN 01rtY7jCpiqNrd/IQhi/bcm5qPoGFY6VonEJgrD6y68aCHFGlnGoCiDnDG/gXhMFfcMn tOcg== X-Gm-Message-State: AOJu0YwWrTjTC8f4/QncJOb26O2IUlXBXnyOlq/ehGHSppz53MTTgzZT s2fOJ2jE4pMWsilcVUPY6/iAF+3hXnFJXBXEj2eyRA== X-Google-Smtp-Source: AGHT+IHUheWaiiHI44SH1SX81rQG3uydb4ULMlgrXNdxPTpiL9ZpAkHd7JJ86Lj7ijFie2USBbCgno7vwwy/ADmpnoQ= X-Received: by 2002:a0d:d8d2:0:b0:583:d722:9ae9 with SMTP id a201-20020a0dd8d2000000b00583d7229ae9mr4435877ywe.41.1692264230545; Thu, 17 Aug 2023 02:23:50 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Khushboo Vashi Date: Thu, 17 Aug 2023 14:53:38 +0530 Message-ID: Subject: Re: Pgadmin4 System Stats Extension Design To: Sahil Harpal Cc: pgadmin-hackers@postgresql.org Content-Type: multipart/alternative; boundary="0000000000005406a806031af854" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000005406a806031af854 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Thu, Aug 17, 2023 at 2:50=E2=80=AFPM Sahil Harpal wrote: > On Thu, 17 Aug 2023 at 14:39, Khushboo Vashi < > khushboo.vashi@enterprisedb.com> wrote: > >> Sample data of my system to fix this issue: >> >> 1. process331: >> 1. memory_bytes:null >> 2. memory_usage:null >> 3. name:"QuickLookUIServi" >> 4. pid:938 >> 5. row_number:331 >> >> Okay, so it is an issue of null value then. > Are null values being returned for all processes or only for specific one= s? > It returns null for some of the processes, not for all. Also can you please verify it by running "SELECT * FROM > pg_sys_cpu_memory_by_process();" query in the query tool? Just want to > ensure I'm not making mistakes while processing the queries output. > >> --0000000000005406a806031af854 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable


=
On Thu, Aug 17, 2023 at 2:50=E2=80=AF= PM Sahil Harpal <sahilharpa= l1234@gmail.com> wrote:
3D""
On Thu, 17 Aug 2023 at 14:39, Khushboo Vashi = <kh= ushboo.vashi@enterprisedb.com> wrote:
S= ample data of my system to fix this issue:
  1. process33= 1= :
    1. memory_bytes= := null
    2. = memory_usage:null
    3. name:"QuickLookUIServi"
    4. pid:938
    5. row_number:331
Okay, so it is an issue of null value then.
Are null v= alues being returned for all processes or only for specific ones?
It returns null for some of the processes, not fo= r all.

Also can you please verify it by r= unning "SELECT * FROM pg_sys_cpu_memory_by_process();" query in t= he query tool? Just want to ensure I'm not making mistakes while proces= sing the queries output.
--0000000000005406a806031af854--