Skip to content

Instantly share code, notes, and snippets.

@llowder

llowder/reports

Created February 4, 2015 03:49
Show Gist options
  • Save llowder/c107f97de497088a174c to your computer and use it in GitHub Desktop.
Save llowder/c107f97de497088a174c to your computer and use it in GitHub Desktop.
Download ZIP
Raw
reports
console=# select count(*), pg_size_pretty(pg_total_relation_size('"public"."reports"')), pg_size_pretty(pg_total_relation_size('"public"."reports"')/count(*)) as avg_size from reports ; count | pg_size_pretty | avg_size
-------+----------------+-----------
125 | 104 kB | 851 bytes
(1 row)
Raw
resource_statuses
console=# select count(*), pg_size_pretty(pg_total_relation_size('"public"."resource_statuses"')), pg_size_pretty(pg_total_relation_size('"public"."resource_statuses"')/count(*)) as avg_size from resource_statuses ;
count | pg_size_pretty | avg_size
-------+----------------+-----------
26750 | 11 MB | 444 bytes
(1 row)
Raw
unions
console=# select count(*), pg_size_pretty(pg_total_relation_size('"public"."reports"')), pg_size_pretty(pg_total_relation_size('"public"."reports"')/count(*)) as avg_size from reports union select count(*), pg_size_pretty(pg_total_relation_size('"public"."reports"')), pg_size_pretty(pg_total_relation_size('"public"."reports"')/count(*)) as avg_size from reports ;
count | pg_size_pretty | avg_size
-------+----------------+-----------
125 | 104 kB | 851 bytes
(1 row)
console=# select count(*), pg_size_pretty(pg_total_relation_size('"public"."reports"')), pg_size_pretty(pg_total_relation_size('"public"."reports"')/count(*)) as avg_rs_size from reports union select count(*), pg_size_pretty(pg_total_relation_size('"public"."reports"')), pg_size_pretty(pg_total_relation_size('"public"."reports"')/count(*)) as avg_rep_size from reports ;
count | pg_size_pretty | avg_rs_size
-------+----------------+-------------
125 | 104 kB | 851 bytes
(1 row)
console=# select count(*) as rs_count, pg_size_pretty(pg_total_relation_size('"public"."reports"')) as rs_size, pg_size_pretty(pg_total_relation_size('"public"."reports"')/count(*)) as avg_rs_size from reports union select count(*) as r_count, pg_size_pretty(pg_total_relation_size('"public"."reports"')) as r_size, pg_size_pretty(pg_total_relation_size('"public"."reports"')/count(*)) as avg_rep_size from reports ;
rs_count | rs_size | avg_rs_size
----------+---------+-------------
125 | 104 kB | 851 bytes
(1 row)
console=# select count(*) as rs_count, pg_size_pretty(pg_total_relation_size('"public"."reports"')) as rs_size, pg_size_pretty(pg_total_relation_size('"public"."reports"')/count(*)) as avg_rs_size from reports union all select count(*) as r_count, pg_size_pretty(pg_total_relation_size('"public"."reports"')) as r_size, pg_size_pretty(pg_total_relation_size('"public"."reports"')/count(*)) as avg_rep_size from reports ;
rs_count | rs_size | avg_rs_size
----------+---------+-------------
125 | 104 kB | 851 bytes
125 | 104 kB | 851 bytes
(2 rows)
console=# select count(*), pg_size_pretty(pg_total_relation_size('"public"."reports"')), pg_size_pretty(pg_total_relation_size('"public"."reports"')/count(*)) as avg_size from reports union all select count(*), pg_size_pretty(pg_total_relation_size('"public"."reports"')), pg_size_pretty(pg_total_relation_size('"public"."reports"')/count(*)) as avg__size from reports ; count | pg_size_pretty | avg_size
-------+----------------+-----------
125 | 104 kB | 851 bytes
125 | 104 kB | 851 bytes
(2 rows)
console=# select count(*), pg_size_pretty(pg_total_relation_size('"public"."reports"')), pg_size_pretty(pg_total_relation_size('"public"."reports"')/count(*)) as avg_rs_size from reports union select count(*), pg_size_pretty(pg_total_relation_size('"public"."reports"')), pg_size_pretty(pg_total_relation_size('"public"."reports"')/count(*)) as avg_rep_size from reports ; count | pg_size_pretty | avg_rs_size
-------+----------------+-------------
125 | 104 kB | 851 bytes
(1 row)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment