Method: Webhookdb::Postgres::Maintenance::Tables#query

Defined in:
lib/webhookdb/postgres/maintenance.rb

#query ⇒ Object 



138
139
140
141
142
143
144
145
146
147
148
149
150
151
 
# File 'lib/webhookdb/postgres/maintenance.rb', line 138

def query
  return "    SELECT\n        relname AS \"relation\",\n        reltuples as \"tuples\",\n        pg_size_pretty(pg_total_relation_size(C .oid)) as \"size\"\n    FROM pg_class C\n    LEFT JOIN pg_namespace N ON (N.oid = C.relnamespace)\n    WHERE nspname NOT IN ('pg_catalog', 'information_schema')\n    AND C.relkind = 'r'\n    AND nspname !~ '^pg_toast'\n    ORDER BY C.relname\n  SQL\nend\n"