Search Postgresql Archives

Re: problem with query

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: problem with query
From: Laurenz Albe <laurenz.albe@xxxxxxxxxxx>
Date: Tue, 21 May 2024 12:09:19 +0200
Cc: pgsql-general@xxxxxxxxxxxxxxxxxxxx
In-reply-to: <CAGB0_67gRyJkCycv6vJA_8fFtNUu7H-f-nsKastZTe93gobBHA@mail.gmail.com>
References: <CAGB0_6600w5C=hvhgfMWCqO9BCwCg+3s0PxXuoQv48NLqTp6dA@mail.gmail.com> <CAApHDvq=sj+vVQ6HKOdNLeWbQnHErg5QPSz26s0a90PtY1NLdw@mail.gmail.com> <CAGB0_67gRyJkCycv6vJA_8fFtNUu7H-f-nsKastZTe93gobBHA@mail.gmail.com>
User-agent: Evolution 3.50.4 (3.50.4-1.fc39)

On Mon, 2024-05-20 at 13:08 +0200, Sašo Gantar wrote:
[execution plan without query text or explanation]

The time is lost here:

  ->  WindowAgg  (cost=310.01..358.34 rows=537 width=888) (actual time=0.057..19.955 rows=473 loops=401)
        Buffers: shared hit=1710825

Yours,
Laurenz Albe

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: problem with query
  - From: Sašo Gantar

References:
- problem with query
  - From: Sašo Gantar
- Re: problem with query
  - From: David Rowley
- Re: problem with query
  - From: Sašo Gantar

Prev by Date: Re: How to update upper-bound of tstzrange ?
Next by Date: Re: How to update upper-bound of tstzrange ?
Previous by thread: Re: problem with query
Next by thread: Re: problem with query
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux