[
http://jira.nuxeo.org/browse/NXP-4177?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=61539#action_61539
]
Benoit Delbosc commented on NXP-4177:
-------------------------------------
repostats now displays more info when run on the root of the repository
Stats for /
Total number of documents (without versions):7812
Number of MailFolder docs: 1
Number of Picture docs: 1436
...
Number of Workspace docs: 246
Versions: 673
Total number of documents (with versions): 8485
Proxies: 37
Mark as deleted: 1563
Folders
Maximum depth: 14 in ....
Maximum children: 204 in ...
Repository performance during stats was ...
The select groovy script has been enhanced (and fixed) to display:
* uid of the document
* the path
* flag if the document is a version/proxy/locked
* total row count
127.0.0.1>select * from Document where ecm:fulltext like '%nuxeodm-final%'
a6c304a0-175a-47fc-bb9c-585a5c17d2d0
/default-domain/workspaces/documents-templates/french/nuxeodm-final
a81fad57-5c54-46b3-9f2a-b445ecc4ef52
/default-domain/workspaces/documents-templates/french/nuxeodm-final [version 1]
ad436fd7-ea87-47b6-a76b-4c4d09830bae
/default-domain/sections/marketing/nuxeodm-final_1239205168059 [proxy]
(3 rows)
> Improve nxshell repostats command to display versions and proxies count
> -----------------------------------------------------------------------
>
> Key: NXP-4177
> URL: http://jira.nuxeo.org/browse/NXP-4177
> Project: Nuxeo Enterprise Platform
> Issue Type: Improvement
> Components: Installers / Admin tools
> Affects Versions: 5.3 RC
> Reporter: Benoit Delbosc
> Assignee: Benoit Delbosc
> Fix For: 5.3 GA
>
> Original Estimate: 3 hours
> Remaining Estimate: 3 hours
>
> Repostats command don't display the number of versioned documents neither the
> number of proxies, this make difficult to understand other number like total
> export or import documents.
> For instance we can add to the output:
> Number of versioned documents: (SELECT COUNT(*) FROM Document WHERE
> ecm:isCheckedInVersion=1)
> Number of proxies: (SELECT COUNT(*) FROM Document WHERE ecm:isProxy=1)
> Number of document marked as deleted: XXX
> Total documents and versions: XXXX
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.nuxeo.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
_______________________________________________
ECM-tickets mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm-tickets
