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 1pqrTz-0008GY-Gf for pgsql-performance@arkaria.postgresql.org; Mon, 24 Apr 2023 08:23:35 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pqrTx-0005vd-N1 for pgsql-performance@arkaria.postgresql.org; Mon, 24 Apr 2023 08:23:33 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pqrTx-0005vF-AX for pgsql-performance@lists.postgresql.org; Mon, 24 Apr 2023 08:23:33 +0000 Received: from us-smtp-delivery-124.mimecast.com ([170.10.133.124]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1pqrTu-001b3b-Cl for pgsql-performance@lists.postgresql.org; Mon, 24 Apr 2023 08:23:32 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=redhat.com; s=mimecast20190719; t=1682324608; h=from:from:reply-to:reply-to:subject:subject:date:date: message-id:message-id:to:to:cc:cc:mime-version:mime-version: content-type:content-type: content-transfer-encoding:content-transfer-encoding: in-reply-to:in-reply-to:references:references; bh=Zj/qIaiXp/Na5L7XdRgjkQWYsleVVSuupBrBksKSGq8=; b=S3QYKJunX+LIdECwBb3W49vjsbkFis1ZOzszqP7hKlZ5Nz+OLED6zRv+LpIbsTTlIa3Oug wI2zRfnDNMQdRnRQaCx9HkShvyQ81n1zOGztbcyLDIli9whXct17sT35TbmCKe8urVbPBB ZnybhWXyHZJomPFEeBceXPxkkzrFvag= Received: from mail-lf1-f70.google.com (mail-lf1-f70.google.com [209.85.167.70]) by relay.mimecast.com with ESMTP with STARTTLS (version=TLSv1.3, cipher=TLS_AES_256_GCM_SHA384) id us-mta-76-eQ_mooOkPQmmv6m7rzm40A-1; Mon, 24 Apr 2023 04:23:26 -0400 X-MC-Unique: eQ_mooOkPQmmv6m7rzm40A-1 Received: by mail-lf1-f70.google.com with SMTP id 2adb3069b0e04-4ef455ba5feso1616684e87.3 for ; Mon, 24 Apr 2023 01:23:26 -0700 (PDT) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1682324605; x=1684916605; h=content-transfer-encoding:in-reply-to:organization:from:cc :references:to:content-language:subject:reply-to:user-agent :mime-version:date:message-id:x-gm-message-state:from:to:cc:subject :date:message-id:reply-to; bh=Zj/qIaiXp/Na5L7XdRgjkQWYsleVVSuupBrBksKSGq8=; b=DL5ysSbzAzol75Vv3enbYa0vbVk5J1NnpxFdMzyBQNJNOoZflJ3btg7MWZTpDc4Xdm gJ1EWlHbI7GBS3xH5r1xcVkn6R33olxfrbQRCq/SS57ZcoC0oAvVruGJgb3fR8go4ZaJ HSi7N+FDJR9Fq+03MDq1Iw8gMY+QQr85N1GO/QtXDTQrf4HGwEx7wvF+ruXeiq3bsm5H MnFbF9bRCuyb5bNuTKGXgX7Kl2CvIfgXlMd/upD+zaqAzD5jhyrsVmRY24vDtLmFuWeN eTuEXcc1uo3++ozLMjPKxbvyOJI5ocNSvUFhs4Bk8mK9OnAfcKMg28UFSXC4LtCR7dWU tkkQ== X-Gm-Message-State: AAQBX9ft60K9LvSplGsRF2hsvG39sL/ojTQYS3Vgyf4ZvcDchRXlCPmc y7xr+wtw9c9GL8AZ5S9ne1USo4C/2q3JjRl6/i1t9VRhXUvjHXCWYHQ1KbFUNCvnjRs5Jwr6jHD rAa8xwntS6AILdQYS81C+ccw19ikAi8K0uuEZCQ== X-Received: by 2002:a19:5206:0:b0:4ea:f8cc:4c9c with SMTP id m6-20020a195206000000b004eaf8cc4c9cmr3581156lfb.63.1682324604994; Mon, 24 Apr 2023 01:23:24 -0700 (PDT) X-Google-Smtp-Source: AKy350adXAX8K7AAG/r4bDZWj0uGDxWFju7B+/nQXann6ZRK9zX1yrZELy7LouPaepgFYSszBBPPoA== X-Received: by 2002:a19:5206:0:b0:4ea:f8cc:4c9c with SMTP id m6-20020a195206000000b004eaf8cc4c9cmr3581148lfb.63.1682324604707; Mon, 24 Apr 2023 01:23:24 -0700 (PDT) Received: from [192.168.1.15] (87-56-178-202-dynamic.dk.customer.tdc.net. [87.56.178.202]) by smtp.gmail.com with ESMTPSA id j20-20020a19f514000000b004efec2462b6sm681003lfb.101.2023.04.24.01.23.23 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Mon, 24 Apr 2023 01:23:24 -0700 (PDT) Message-ID: Date: Mon, 24 Apr 2023 04:23:23 -0400 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.10.0 Reply-To: jesper.pedersen@redhat.com Subject: Re: Postgres Metrics To: =?UTF-8?Q?Andr=c3=a9_Rodrigues?= References: Cc: Joe Conway , pgsql-performance@lists.postgresql.org From: Jesper Pedersen Organization: Red Hat In-Reply-To: X-Mimecast-Spam-Score: 0 X-Mimecast-Originator: redhat.com Content-Language: en-US Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 4/15/23 10:53, Joe Conway wrote: > On 4/15/23 07:04, André Rodrigues wrote: >> Hello >> >> I have just started in the new challenger as dba postgres and I am in >> charge of enhancing our postgres monitoring( dashboards and alarms ) >> using Grafana. >> >> Could you list me relevant metrics in postgres that I can apply in my >> environment  ? >> >> In additional, If someone else has grafana template implemented, >> please share with me or some link to do that , > > See: > https://github.com/CrunchyData/pgmonitor > Or https://pgexporter.github.io/