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 1s80fH-008vmO-TE for pgsql-general@arkaria.postgresql.org; Fri, 17 May 2024 16:42:41 +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 1s80fF-00FSb2-Pl for pgsql-general@arkaria.postgresql.org; Fri, 17 May 2024 16:42:37 +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 1s80fF-00FSau-EZ for pgsql-general@lists.postgresql.org; Fri, 17 May 2024 16:42:37 +0000 Received: from mail-ej1-x633.google.com ([2a00:1450:4864:20::633]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1s80f7-000k4u-Uc for pgsql-general@lists.postgresql.org; Fri, 17 May 2024 16:42:36 +0000 Received: by mail-ej1-x633.google.com with SMTP id a640c23a62f3a-a5ce2f0deffso247861166b.3 for ; Fri, 17 May 2024 09:42:30 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1715964149; x=1716568949; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=RhRn8YZZTpCIQ/8RkCEEsWfrnKEsVL3mlWzgHcyq8FA=; b=UarjN0cf4VIT2QMF2j32LMVe1Y2RtZ5KjeI6a6NiOCjPM/7ki63lWn+SiraM98n/dI d1AoYGfr2289SiR31JuVqLrHKpi1Xig2ShqC6ev3gwv5k5jDMA0HmDo3EgnWK6k3UUXe n+MJnp7PxkEaKWgOIL6x0rGI8crmaGJkJKIWN7oeT67fsQQJ4X3Zx/iz1FWMuUluD2f+ iK+o0mgppjlXGW6UUsoGVnmHMzsW0xwxCak8K7ceuVd7qZj7xrhuEE+kgECXsG8vIfBN NMthM2QDpm7m4kXAbN5a3VmthP7L1jM9JncMUY29hC7IMGwSwRqMmgNLCWNV2ixOt8IL 2/zw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1715964149; x=1716568949; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=RhRn8YZZTpCIQ/8RkCEEsWfrnKEsVL3mlWzgHcyq8FA=; b=rCh3xwDiLnPPHuJZsjiLRPoAdevkTJ0dnAgpJD+Gx2oD0NBNP2DuzaKi6LLGXyvBZs aRSOCZALvRo3/JOCr6XoI0O986zD/3qsl4ueG0Id7CN6qgMgnoQtkAI5cf3t669i0F0U +/WkIgy0JLVbmehYuvB1RBbobjUV4GX2whx11birQwBV7rOHB2qIX+m6dasraZ5iELe2 jjGNb1bA0FMAfx0OzopBDHUEpL1kyFIi039G/LBUtcRJ4dq8vXEtwc5VMENxxt/QFW9g hAWrdUT0DTgjAus0uj1zwUM5Kr/rpUJRtp1VPQFdIOwM7a3+u1GduL+DMWBlDaCmX0da FXZA== X-Gm-Message-State: AOJu0Yz2Nt0xPiFJK//TsnbiMasXxSJ8FM7YBi3O2QVHOzd82iWitAnv w/yW2hOvn3jFXLvhRCGz2ckDc69bFTjNL1JJ8EiGP/oRiCrTTm8/K81UuabPUwb6nrGsuxcOKM3 V/xPygjqR8A+YGmNw6GiqITkFz0aD64pN X-Google-Smtp-Source: AGHT+IFC3hjjb1Tts6kYk6HOR58oENgPTcFhdHEfqlw1yiN1i84SgNxcR3f6VSjONJ7f4zRKU/U4U4Hm1VxkQOurk/M= X-Received: by 2002:a17:907:970c:b0:a5c:e7a2:b759 with SMTP id a640c23a62f3a-a5ce7a2b854mr489750066b.34.1715964149240; Fri, 17 May 2024 09:42:29 -0700 (PDT) MIME-Version: 1.0 From: arun chirappurath Date: Fri, 17 May 2024 22:12:14 +0530 Message-ID: Subject: Execution history of a single query To: pgsql-general@lists.postgresql.org Content-Type: multipart/alternative; boundary="0000000000009018b60618a909cb" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000009018b60618a909cb Content-Type: text/plain; charset="UTF-8" Hi All, From pg_stat_statements we can get the overall execution details of queries. Can we get the execution details of a single queryid ? Like today it took 6 seconds,yesterday 5 and so on..just for one query. Thanks, Arun --0000000000009018b60618a909cb Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi All,

From= pg_stat_statements we can get the overall execution details of queries.

Can we get the execution d= etails of a single queryid ?

Like today it took 6 seconds,yesterday 5 and so on..just for one query= .

Thanks,
Arun
--0000000000009018b60618a909cb--