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 1tjlJ4-00DBL8-6W for pgsql-general@arkaria.postgresql.org; Sun, 16 Feb 2025 20:32:02 +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 1tjlJ0-00AY81-QA for pgsql-general@arkaria.postgresql.org; Sun, 16 Feb 2025 20:31:58 +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 1tjlJ0-00AY5a-DT for pgsql-general@lists.postgresql.org; Sun, 16 Feb 2025 20:31:58 +0000 Received: from mail-pj1-x1035.google.com ([2607:f8b0:4864:20::1035]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tjlIx-001DQM-2n for pgsql-general@lists.postgresql.org; Sun, 16 Feb 2025 20:31:57 +0000 Received: by mail-pj1-x1035.google.com with SMTP id 98e67ed59e1d1-2fc737aeeb1so393299a91.3 for ; Sun, 16 Feb 2025 12:31:55 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1739737913; x=1740342713; 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=936n3Q1rgyIoAiweD0ijV0X1xZeDEPXl/BF9VFpMqEo=; b=Wmbx+K6YYg7Xhdqq149c0hA2wl19LjdneTdALyKP3+bdhd5XVeIiAOxB8/ouhrFmaZ 4vaDq74cZ4Hny28wTam7S/tYLDrEFHwGWW1AzBSz7rJqDNmhnB/oBvDfGCHwBiZIe79J gO5q9eobSlElOC/S/OL5CdlnVckDBZqRwvrbc9SFFEimNNxp9dIma7WxeabQ5h9LaIDj WR3NNtxZA0JT68UUOUaCxp5D9Ey6iq18MJC1cJ5uwCDex+jD6Q6oyzZuVXlcdUXz1Hrv Od8DR+GOuqffWvK33qEFABLuamVi58Lddk4Bpm/MXITj5Sy/R037Vhrye+kDBdoCTIS6 iDVA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1739737913; x=1740342713; 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=936n3Q1rgyIoAiweD0ijV0X1xZeDEPXl/BF9VFpMqEo=; b=xQsclr9ykN1qs3SqpNyww8TDFf6NzgtHP/l0gmn2twUIGyj6wfofGblmLfXx2nJpNZ cysvAcUiGSQNZTaghL6TBFWKwrox1EKEjENcxA29EQ/A4eVGeBxvHXYG1h2E2/0i/R/w tj/CXKtzwNL55wpLQqEj5i+oQvZqhrgeXlRcQ3rnJCKVzLzU85+ymJ99rEvG/u6tXxJB imGDgadVukW61C0H6x30q3+/T8mQ6Pj5KuGj7ulrBNkSnL8N65l4jr5dOUcxfp6mJHOb i2SZATBfaUYBwVCz7MrwoEhXUtRqQrYWKH5acdYdpwoHGZ3j7X51P8M7Aw1ngxAAHrII koEw== X-Gm-Message-State: AOJu0Yxoo64rQmKbq1Cxj1b3AZPNyLHcbdrRrsDTGfiMx6OhVT1cNBRe zF1sTV/qTGMoTsiy5JvAuX34wnB3VQwH7uR2URbIhiIav37QQAXDwx4oegzV9N23Ldh/vjrH5wp 4bpx2TPtQ5M/AUa5vJ2xRn+VJHBE4BxHn X-Gm-Gg: ASbGncvWU2QQUQCx46FzW8b89+MBuHMQLN10x36YXC/PkpXKbXCYSq3RnGFO1XflxLy cr70V3i8cwshndeFZpRnZMgjBkUKg0XgjJWWiOw4jcgqhX2w2KBSNTzlMhVmOsJ8JxTvVwF3CV9 +ccCQi6TV8NsYpXKfUYGeJFiCH+4Q= X-Google-Smtp-Source: AGHT+IE187b7k9SuKQR5Gw05TrpmZ1r/ZkvZfahLkxz/zjdBXoXwto2f5RPrM3/vSIefJW6ui+guFBLjchpeRcXRgJg= X-Received: by 2002:a17:90a:d604:b0:2f2:a664:df19 with SMTP id 98e67ed59e1d1-2fc40d13ed9mr12479833a91.7.1739737913009; Sun, 16 Feb 2025 12:31:53 -0800 (PST) MIME-Version: 1.0 References: <54274170-49f7-4c88-8c23-431d50dd6a9f@dalibo.com> In-Reply-To: <54274170-49f7-4c88-8c23-431d50dd6a9f@dalibo.com> From: sud Date: Mon, 17 Feb 2025 02:01:40 +0530 X-Gm-Features: AWEUYZm-J6_2qCMERHOtTCyhawLzlj-d_guQCGgOlZD5PYzRCiHtbMsg1vu0KPY Message-ID: Subject: Re: Question on Alerts To: Guillaume Lelarge Cc: pgsql-general@lists.postgresql.org Content-Type: multipart/alternative; boundary="0000000000004eabcf062e484c76" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000004eabcf062e484c76 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Sun, Feb 16, 2025 at 10:05=E2=80=AFPM Guillaume Lelarge < guillaume.lelarge@dalibo.com> wrote: > > You should probably look at check_postgres and check_pgactivity. Their > source code contain numerous SQL queries, that could help you write your > own. > > Regards. > > Thank you very much. I am a bit new to postgres here. Can you please guide me , where exactly I can get the source code for check_postgres and check_pgactivity? --0000000000004eabcf062e484c76 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable

On Sun, Feb 16, 202= 5 at 10:05=E2=80=AFPM Guillaume Lelarge <guillaume.lelarge@dalibo.com> wrote:

You should probably look at check_postgres and check_pgactivity. Their
source code contain numerous SQL queries, that could help you write your own.

Regards.


Thank you very much. I am = a bit new to postgres here. Can you please guide me , where exactly I can g= et the source code for=C2=A0 check_postgres and check_pgactivity?
--0000000000004eabcf062e484c76--