diff options
| author | Jochen Topf <jochen@topf.org> | 2015-02-26 16:40:15 +0100 |
|---|---|---|
| committer | Jochen Topf <jochen@topf.org> | 2015-02-26 16:40:15 +0100 |
| commit | b27824c4b7696b0947861cf58c398716c8464d86 (patch) | |
| tree | d9f134f71b9182d42fb6ea8c26b56e4dbc546fea | |
| parent | 2a61dab2ed4361b880a318e2b1d68317f3a2ae43 (diff) | |
| download | taginfo-b27824c4b7696b0947861cf58c398716c8464d86.tar taginfo-b27824c4b7696b0947861cf58c398716c8464d86.tar.gz | |
Add number of similar keys to stats.
| -rw-r--r-- | sources/db/post.sql | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/sources/db/post.sql b/sources/db/post.sql index 592df9d..3e5b931 100644 --- a/sources/db/post.sql +++ b/sources/db/post.sql @@ -85,6 +85,9 @@ INSERT INTO stats (key, value) SELECT 'num_keys_on_nodes', count(*) FROM INSERT INTO stats (key, value) SELECT 'num_keys_on_ways', count(*) FROM keys WHERE count_ways > 0; INSERT INTO stats (key, value) SELECT 'num_keys_on_relations', count(*) FROM keys WHERE count_relations > 0; +INSERT INTO stats (key, value) SELECT 'num_similar_keys', count(*) FROM similar_keys; +INSERT INTO stats (key, value) SELECT 'num_similar_keys_common_rare', count(*) FROM similar_keys_common_rare; + INSERT INTO stats (key, value) SELECT 'num_tags', count(*) FROM tags; INSERT INTO stats (key, value) SELECT 'num_tags_on_nodes', count(*) FROM tags WHERE count_nodes > 0; INSERT INTO stats (key, value) SELECT 'num_tags_on_ways', count(*) FROM tags WHERE count_ways > 0; |