diff options
author | Jochen Topf <jochen@topf.org> | 2014-09-14 16:56:55 +0200 |
---|---|---|
committer | Jochen Topf <jochen@topf.org> | 2014-09-14 16:58:43 +0200 |
commit | 43463fd1b8ce847b2fe976427d6c114581342bfa (patch) | |
tree | 81136a4eaa3e43ed3930decc7589acca9ef242d4 /sources/projects/post.sql | |
parent | 0bce8570acd121ffb6b65ec58d7e678cbd89798f (diff) | |
download | taginfo-43463fd1b8ce847b2fe976427d6c114581342bfa.tar taginfo-43463fd1b8ce847b2fe976427d6c114581342bfa.tar.gz |
Add some statistics for project source.
Diffstat (limited to 'sources/projects/post.sql')
-rw-r--r-- | sources/projects/post.sql | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/sources/projects/post.sql b/sources/projects/post.sql index 9f94257..5fa2b5a 100644 --- a/sources/projects/post.sql +++ b/sources/projects/post.sql @@ -6,8 +6,10 @@ .bail ON --- CREATE INDEX project_keys_idx ON project_tags (key) WHERE value IS NULL; --- CREATE INDEX project_tags_idx ON project_tags (key, value) WHERE value IS NOT NULL; +INSERT INTO stats (key, value) SELECT 'projects', count(*) FROM projects; +INSERT INTO stats (key, value) SELECT 'projects_ok', count(*) FROM projects WHERE status='OK'; +INSERT INTO stats (key, value) SELECT 'project_keys', count(*) FROM project_tags WHERE value IS NULL; +INSERT INTO stats (key, value) SELECT 'project_tags', count(*) FROM project_tags WHERE value IS NOT NULL; ANALYZE; |