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 1s9N3b-001n5l-VU for pgsql-general@arkaria.postgresql.org; Tue, 21 May 2024 10:49:25 +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 1s9N3b-009NHb-WD for pgsql-general@arkaria.postgresql.org; Tue, 21 May 2024 10:49: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 1s9N3b-009NHP-LN for pgsql-general@lists.postgresql.org; Tue, 21 May 2024 10:49:23 +0000 Received: from mail-vs1-xe2e.google.com ([2607:f8b0:4864:20::e2e]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1s9N3Z-0001MB-6Z for pgsql-general@lists.postgresql.org; Tue, 21 May 2024 10:49:23 +0000 Received: by mail-vs1-xe2e.google.com with SMTP id ada2fe7eead31-47f13801f3aso1110950137.0 for ; Tue, 21 May 2024 03:49:21 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1716288560; x=1716893360; 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=iNKw7Rf4ZUi/Vr7T5tC4LmbASGcJCiI5ATEBPRs5DlY=; b=Nc7LAvzmjw3VQLgy0m27UVss1uJCa5+TFFqB99ugyfxgHnDcaP5Jz9PHmvQL3xpOY+ /VmR1eZ+ikh1+zUFM6ulIp6www5m8tM1ubHngn/fmJdw22IMHCkLPq+cd2nMd1gXLx6P Lu/NSqHw4tzhjznnFxXqJKU9zO+5FUjIYhrNbEBHJAaenGRMr37IDRLEdErx/QAkMdRb tBlad18urSMu80nhJnrwWCsc7Dfgv9dx/VBAchzI3on5GRu0CtObCyRsI3DdvDm0nhn6 rJU7TcVPEWYgpK7DcN0AYYb8taxlrpJgvj1VuKHeXKph2SkKmYvUrtRDFwq/BC8hBGBz cTsw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1716288560; x=1716893360; 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=iNKw7Rf4ZUi/Vr7T5tC4LmbASGcJCiI5ATEBPRs5DlY=; b=V3NqiRAV7OqPftH0em4R9yK77sZmABeRftYnddDG79+0VwlWChH4tZr0Tp0HQXNm54 kOFmHYtVrTZPm7kGrKMBeanFYEJCfcUDvEViYQXufNuBpeSjxufSWiScWZ2VeohfiLzU xaU9CglErz2hXPxaI3X+EmtTIWSpd7D6tTMoLFLylyag4g/CFO+LeD4Sj2iPY0mx8cx1 TmFmR3qQ8J+DUAHi3l0OnAlOl7OIeqiBma0FjjPfJ+LsyqifBuHqfkXbLp4dtIOh/Osc A3jBDe6t01taF1m1Efd+TdS/NEv95btdtEfrn9xbRrFnW0VYLmazItNQ8f3Sz83G4RjI eUNg== X-Forwarded-Encrypted: i=1; AJvYcCWTsgUB6zMy+m4cACfJf4Wct/gfHsvyso75Ly0ixye2+2lBamPTHZvsdhO5NFLIimIs4ZXdTmHs1CwlV1kl4REpPhdI/rvUgIq+9FpSTev02kih X-Gm-Message-State: AOJu0YzAsl7F+3kaDAXWGaUJLVi+YPg6CoEYHtMXAD+dn6VjP/bIpQzV KsvxSC8o0oAkNay8ks8YuhIbkgRZsMTZ6Rx7Av5iHZpon6RNsUE6fGMq3YgYVMftiVajdhnCco7 CQLVKWvi2GxgmpBdt2cp85U3qgshPPAHnjEQ= X-Google-Smtp-Source: AGHT+IEKo9fDSDivmGl09J5G06Mc/rb5ulpIUv2a6RynYERCLdc8bla4CoSJ4jpE6GH7tUmh1UCKqDlxhYn9I+R4uho= X-Received: by 2002:a05:6102:954:b0:47e:f57b:5559 with SMTP id ada2fe7eead31-48077e07d20mr31326348137.18.1716288560034; Tue, 21 May 2024 03:49:20 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: =?UTF-8?B?U2HFoW8gR2FudGFy?= Date: Tue, 21 May 2024 12:49:08 +0200 Message-ID: Subject: Re: problem with query To: Laurenz Albe Cc: David Rowley , pgsql-general@lists.postgresql.org Content-Type: multipart/alternative; boundary="000000000000f3ff680618f49149" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000f3ff680618f49149 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable thanks for the info, but is there any solution, given that it's system tables? regards On Tue, 21 May 2024 at 12:09, Laurenz Albe wrote= : > On Mon, 2024-05-20 at 13:08 +0200, Sa=C5=A1o Gantar wrote: > [execution plan without query text or explanation] > > The time is lost here: > > -> WindowAgg (cost=3D310.01..358.34 rows=3D537 width=3D888) (actual > time=3D0.057..19.955 rows=3D473 loops=3D401) > Buffers: shared hit=3D1710825 > > Yours, > Laurenz Albe > --000000000000f3ff680618f49149 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
thanks for the info, but is there any solution, given that= it's system tables?

regards

On Tue, 21 May= 2024 at 12:09, Laurenz Albe <laurenz.albe@cybertec.at> wrote:
On Mon, 2024-05-20 at 13:08 +0200, Sa=C5=A1o Gant= ar wrote:
[execution plan without query text or explanation]

The time is lost here:

=C2=A0 ->=C2=A0 WindowAgg=C2=A0 (cost=3D310.01..358.34 rows=3D537 width= =3D888) (actual time=3D0.057..19.955 rows=3D473 loops=3D401)
=C2=A0 =C2=A0 =C2=A0 =C2=A0 Buffers: shared hit=3D1710825

Yours,
Laurenz Albe
--000000000000f3ff680618f49149--