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 1qMaH8-002kyM-J2 for pgadmin-hackers@arkaria.postgresql.org; Thu, 20 Jul 2023 20:29:26 +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 1qMaH6-00GuT2-CR for pgadmin-hackers@arkaria.postgresql.org; Thu, 20 Jul 2023 20:29:24 +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 1qMaH6-00GuSi-1o for pgadmin-hackers@lists.postgresql.org; Thu, 20 Jul 2023 20:29:24 +0000 Received: from mail-pg1-x52c.google.com ([2607:f8b0:4864:20::52c]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qMaH2-000nq3-KN for pgadmin-hackers@postgresql.org; Thu, 20 Jul 2023 20:29:23 +0000 Received: by mail-pg1-x52c.google.com with SMTP id 41be03b00d2f7-5638180156aso144766a12.0 for ; Thu, 20 Jul 2023 13:29:21 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1689884959; x=1690489759; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=jP/vKc1kgdyxngOs1NzSpNLl00XXjAllb5gyJGINFhc=; b=pUB2Hh6gxOzUJ/5RMjh7ql4jjfibwWyg8Ie5zx+LuPMdaqqAtOoGCwiICgahvYCXKJ 5e7o8IyiaXrBlP+U4SyOZLRpBf1Q2JtvdM4EEVe3aExyEjbiBFt/USdbRsgF/gRgOpia +nh+H0kP8oUypiXuTRh4Sb3UO7MbTljJbKq1rgRRK4+CGNJDxUizP3r1QzPXd+HujG0f apv9Sbq8e7zrY8RUyumCs0r8J8IA0U0tB/qyYltfdDF3MocIdkPx4z7AcMZqfdA9qw4Q hWfYpSUzdKdkmEWWsuTNZ3R+p87UKX30etlAfN9Tc0rcRQjJPqI+2+BxdANy93lbb5H9 ja5w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1689884959; x=1690489759; 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=jP/vKc1kgdyxngOs1NzSpNLl00XXjAllb5gyJGINFhc=; b=Op9VgHDu6KQDThsQaFiuBxCrypAPEeLjjfLEm+DkIXjZ6/jXdvYEXnbWveznXFSo4V hMPSeEKQqpq5uVEoL72MpSY7DkDGBOwwmSVlCtCAUZ4wKv65JUQD78kJ+2W5aQeqZsf9 HE5zE7l4oI3mtRuGZSJhzs8zq7S1iK5B8RZjkErV2C1LHv017mQeHTnb4V8GsD/qaMod JX9lc7QSX7zhR0TVM0ipzyc0GPg+qhq7IzkvsTuGMcpc6QJrpdmIvR1IY078RxN1O8b5 culh8Fg0F97OJNelqQZSRRYRo23chhjqQYczlOB50nmZfhCOK5isEYcj4YXMb9dyo3/X kPxw== X-Gm-Message-State: ABy/qLZP1z/yhOBuV5k3qNtEaf4xW0PUP4YNjMptL7C1gTyIruG5ebO4 RJ3OhYNXUavSfoPA+WW294d/lwK60S3pL/Sr70o= X-Google-Smtp-Source: APBJJlG25KObEPqCIQjIBxDjXD05vQ0hfeFp9CfpmwCCJAG4zOAIRKYRp6KHFTTcHis1jEAAaMYwy0nPRgNQjG+ZK2g= X-Received: by 2002:a17:90a:4882:b0:263:d249:9b7 with SMTP id b2-20020a17090a488200b00263d24909b7mr317895pjh.25.1689884959440; Thu, 20 Jul 2023 13:29:19 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Sahil Harpal Date: Fri, 21 Jul 2023 01:59:07 +0530 Message-ID: Subject: Re: Pgadmin4 System Stats Extension Design To: Ashesh Vashi Cc: Aditya Toshniwal , Dave Page , Akshay Joshi , Khushboo Vashi , pgadmin-hackers@postgresql.org Content-Type: multipart/alternative; boundary="000000000000b803680600f1008e" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000b803680600f1008e Content-Type: text/plain; charset="UTF-8" On Wed, Jul 12, 2023, 4:33 PM Ashesh Vashi wrote: > If it is an extension issue, you may want to create an issue in its github > repo with reproduction steps, current & expected behaviour. > I think the issue is mostly with windows systems can anyone please confirm whether the pg_sys_process_info() take long time to execute on Linux or Mac systems also? Like in case of Windows it call Win32_Process. If we somehow we able to execute this query seperately, I think we would probably resolve this issue as then it won't block others. > --000000000000b803680600f1008e Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Wed, Jul 12, 2023, 4:33 PM Ashesh= Vashi <ashesh.vashi@enterprisedb.com> wrot= e:
If it is an extension issue, you may want to create an issue i= n its github repo with reproduction steps, current & expected behaviour= .=C2=A0=C2=A0
<= br>
I think the issue is mostly with windows systems= can anyone please confirm whether the pg_sys_process_info() take long time= to execute on Linux or Mac systems also? Like in case of Windows it call W= in32_Process.=C2=A0
If we somehow we able to execute= this query seperately, I think we would probably resolve this issue as the= n it won't block others.
--000000000000b803680600f1008e--