Skip to content

Instantly share code, notes, and snippets.

@aronr
Created October 3, 2012 19:28
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save aronr/3829229 to your computer and use it in GitHub Desktop.
Save aronr/3829229 to your computer and use it in GitHub Desktop.
Nuxeo DB after running services tests, late in v3.0 (7ee4c2180e9c3e5415bf673ca6a311a6364ebeb4 as of 2012-10-01)
nuxeo=# SELECT schemaname,relname,n_live_tup FROM pg_stat_user_tables ORDER BY n_live_tup DESC;
schemaname | relname | n_live_tup
------------+--------------------------------------------------+------------
public | hierarchy | 462
public | fulltext | 132
public | hierarchy_read_acl | 132
public | misc | 131
public | dublincore | 131
public | ancestors | 130
public | content | 54
public | collectionspace_core | 47
public | view | 40
public | relations_common | 21
public | id_generators | 18
public | file | 14
public | picture | 10
public | image_metadata | 10
public | iptc | 10
public | dimensionsubgroup | 9
public | aclr_permission | 6
public | dimensions_common | 6
public | titlegroup | 5
public | collectionobjects_common | 5
public | persontermgroup | 3
public | acls | 3
public | measuredpartgroup | 3
public | persons_common | 3
public | personauthorities_common | 2
public | intakes_common | 2
public | blobs_common | 2
public | objectexit_common | 1
public | media_common | 1
public | aclr | 1
public | versions | 1
public | reports_common | 1
public | repositories | 1
public | reports_common_fordoctypes | 1
public | acquisitions_common | 1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment