On Thu, Sep 28, 2017 at 3:31 PM, Seamus Abshere wrote:
> > > > Does anybody have a function lying around (preferably pl/pgsql) that
> > > > takes a table name and returns coverage counts?
> > >
> > > What is "coverage count"?
>
> Ah, I should have explained better. I meant how much of a column is
> > > Does anybody have a function lying around (preferably pl/pgsql) that
> > > takes a table name and returns coverage counts?
> >
> > What is "coverage count"?
Ah, I should have explained better. I meant how much of a column is
null.
Basically you have to
0. count how many total records in a
On Thu, Sep 28, 2017 at 12:15 PM, Tomas Vondra wrote:
>
>
> On 09/28/2017 04:34 PM, Seamus Abshere wrote:
> > hey,
> >
> > Does anybody have a function lying around (preferably pl/pgsql) that
> > takes a table name and returns coverage counts?
> >
>
> What is "coverage count"?
>
I'm guessing it
On 09/28/2017 04:34 PM, Seamus Abshere wrote:
> hey,
>
> Does anybody have a function lying around (preferably pl/pgsql) that
> takes a table name and returns coverage counts?
>
What is "coverage count"?
cheers
--
Tomas Vondra http://www.2ndQuadrant.com
PostgreSQL Developme
hey,
Does anybody have a function lying around (preferably pl/pgsql) that
takes a table name and returns coverage counts?
e.g.
#> select * from column_counts('cats'::regclass);
column_name | all_count | present_count | null_count | coverage |
---
name | 300 |