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 1s98zs-0004jb-0K for pgsql-admin@arkaria.postgresql.org; Mon, 20 May 2024 19:48:37 +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 1s98zs-004jhb-2o for pgsql-admin@arkaria.postgresql.org; Mon, 20 May 2024 19:48:36 +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 1s98zr-004jhR-Kz for pgsql-admin@lists.postgresql.org; Mon, 20 May 2024 19:48:35 +0000 Received: from mail-pg1-x532.google.com ([2607:f8b0:4864:20::532]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1s98zp-001AjF-Ax for pgsql-admin@lists.postgresql.org; Mon, 20 May 2024 19:48:34 +0000 Received: by mail-pg1-x532.google.com with SMTP id 41be03b00d2f7-60585faa69fso2536663a12.1 for ; Mon, 20 May 2024 12:48:33 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1716234512; x=1716839312; darn=lists.postgresql.org; h=to:message-id:subject:date:mime-version:from :content-transfer-encoding:from:to:cc:subject:date:message-id :reply-to; bh=2cSsKnagWM4bpa3zQW1COBi/KcAfAUDx23GmvBkoTFI=; b=X65k+4stNpVdpABVfbaGOiZcVFmZM2rcV3cN5fFB1b/OiEz2SyveGG8QilIJ2S/Blc NiVGGt7s/+P8rdFSoRXe2L/638rQptBkmTL/1wlGLMRSk5CD16kCzXhcHPeovdQMWYky ZVoIym//gRK7Fqxbt5JyX6W6LQhzt/nQp5+jgqo4nHDcSDq8Hb/eWE+m7fyr1c49UfIu kYMaC3EWI8hmmzN7cmvv7q8X/id0iXgvXGslehFY+35sp6Ty0+lGnZlLatm1CXmnlTa0 ocWPiw+eplu3PkhHucX1ZO8k1wKs3ekfYyDF/gMk6faeMtKvBEKWIwIgK4VkpxNQbmRY JUrg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1716234512; x=1716839312; h=to:message-id:subject:date:mime-version:from :content-transfer-encoding:x-gm-message-state:from:to:cc:subject :date:message-id:reply-to; bh=2cSsKnagWM4bpa3zQW1COBi/KcAfAUDx23GmvBkoTFI=; b=AzWLxyasQXBt4F2oywImrland7jkPWt/N+G5g1ZShpsDbIR18ZQKC7TYBCM0UKaUwl XqFXk4ePJBS1R8FSM+hQ6Itfae03x6ZM8khsD0kjYsCBj+ZUpMAWUsv1pfnPHPHFWdLj eGxNknDJAG8ads5Bhsl07Z/OcNsnmj8QPlrnjkaye7G7KdD6WVUSOSY9xXIqkSeDurjL Ae4nGh33VJyp5852m0FsgG+xNYMZmVZdjX9ZjnBWiDMnS+rFBuA7t4LlD3eAQalnnuQO fnXHsMZKdqHohbEGuXs9d9jqGwSUPYm6ms05FlOZ2CUtHRKAhPI4V4wp4PxfzG3+tKWa letQ== X-Gm-Message-State: AOJu0YzjJAQPbAbsYOarbriHYchlwPJqaUZU9JCPCSVPMSZcQR1JhTpg XsQmRdkyHb4tUtBRvB19EkdYs8qso0jYxLWvpWqbU+eHmIcXsisCNJm+hA== X-Google-Smtp-Source: AGHT+IHeh4Xaf6GBIoomzi5sgNI1eDmqoBxnlycz2LYkBXl6lnthJG1ou+NekvAGKW4GC1Us/mNyfA== X-Received: by 2002:a17:903:1107:b0:1f2:f33a:7bbf with SMTP id d9443c01a7336-1f2f33a8237mr76163175ad.25.1716234511472; Mon, 20 May 2024 12:48:31 -0700 (PDT) Received: from smtpclient.apple ([2603:8001:203:f62:844e:2880:a719:9513]) by smtp.gmail.com with ESMTPSA id 41be03b00d2f7-6626deab667sm4251283a12.3.2024.05.20.12.48.30 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Mon, 20 May 2024 12:48:30 -0700 (PDT) Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable From: Teja Jakkidi Mime-Version: 1.0 (1.0) Date: Mon, 20 May 2024 12:48:19 -0700 Subject: Query_id is not being populated for all the pids Message-Id: To: pgsql-admin X-Mailer: iPhone Mail (21E236) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hello Admins, When we query pg_stat_statements in Postgres, it has a column =E2=80=9Cquery= _id=E2=80=9D which is not having any value for most of the sessions.=20 Compute_query_id is set to AUTO Can someone please help me understand why the query_id is missing most of th= e sessions and how is it populated in the background? Thank you, J. Teja.=