Thread: getting daily stats for event counts

David Gauthier <davegauthierpg@gmail.com> writes:
> I have a table which logs the inception of an event with an
> "incept_datetime" (timestamptz) field.  I want to know how many events
> occurred per day from one date to the next using midnight as a marker for
> each day reported.  The end result should be something like...

> 2019-06-23  44
> 2019-06-24  18
> 2019-06-25  38
> etc...

> Is there a query that can do this ?

Something involving GROUP BY date_trunc('day', incept_datetime)
ought to do it, possibly with some fooling around required
depending on what definition of "midnight" you want to use.

            regards, tom lane