Postgres Pro
Downloads
Home   >   mailing lists

psql: what's the SQL to compute the ratio of table sizes? - Mailing list pgsql-general

From Kynn Jones
Subject psql: what's the SQL to compute the ratio of table sizes?
Date
Msg-id c2350ba40810171230rf9ebce4rfc4433b278127242@mail.gmail.com
Whole thread Raw
Responses Re: psql: what's the SQL to compute the ratio of table sizes?  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Re: psql: what's the SQL to compute the ratio of table sizes?  (Steve Atkins <steve@blighty.com>)
Re: psql: what's the SQL to compute the ratio of table sizes?  (Josh Williams <joshwilliams@ij.net>)
List pgsql-general
Tree view
Suppose I have two table X and Y and I want to compute the ratio of the number of rows in X and the number of rows in Y.  What would be the SQL I could type into a psql session to get this number?

This is an example of the recurring problem of performing arithmetic using the result of various calls to count(*) (or other mathematic functions).

TIA!

Kynn

pgsql-general by date:

Previous
From: "Serge Fonville"
Date:
Subject: Re: Annoying Reply-To
Next
From: "Dave Coventry"
Date:
Subject: Re: Annoying Reply-To