Search Postgresql Archives

Re: count(*) vs count(id)

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

Subject: Re: count(*) vs count(id)
From: Tom Lane <tgl@xxxxxxxxxxxxx>
Date: Mon, 01 Feb 2021 19:34:58 -0500
Cc: Rob Sargent <robjsargent@xxxxxxxxx>, "pgsql-generallists.postgresql.org" <pgsql-general@xxxxxxxxxxxxxxxxxxxx>
Comments: In-reply-to Matt Zagrabelny <mzagrabe@xxxxxxxxx> message dated "Mon, 01 Feb 2021 18:32:18 -0600"
In-reply-to: <CAOLfK3W99Cdf9Sq+XyJv5MAjp9wsYBKpAC2UAVp7+dB881KmjQ@mail.gmail.com>
References: <CAOLfK3VWa_Mv3OSumvpHZdppd+qDj8EUWCdxY5+vUe=gAo+h0A@mail.gmail.com> <cb465259-e29a-8fc2-1890-2666b8d79f36@gmail.com> <CAOLfK3W99Cdf9Sq+XyJv5MAjp9wsYBKpAC2UAVp7+dB881KmjQ@mail.gmail.com>

Matt Zagrabelny <mzagrabe@xxxxxxxxx> writes:
> On Mon, Feb 1, 2021 at 5:57 PM Rob Sargent <robjsargent@xxxxxxxxx> wrote:
>> You got one null from count(*) likely.

> What is count(*) counting then? I thought it was rows.

Yeah, but count(id) only counts rows where id isn't null.

			regards, tom lane

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

Follow-Ups:
- Re: count(*) vs count(id)
  - From: Matt Zagrabelny

References:
- count(*) vs count(id)
  - From: Matt Zagrabelny
- Re: count(*) vs count(id)
  - From: Rob Sargent
- Re: count(*) vs count(id)
  - From: Matt Zagrabelny

Prev by Date: Re: count(*) vs count(id)
Next by Date: Re: count(*) vs count(id)
Previous by thread: Re: count(*) vs count(id)
Next by thread: Re: count(*) vs count(id)
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