From b27824c4b7696b0947861cf58c398716c8464d86 Mon Sep 17 00:00:00 2001 From: Jochen Topf Date: Thu, 26 Feb 2015 16:40:15 +0100 Subject: Add number of similar keys to stats. --- sources/db/post.sql | 3 +++ 1 file changed, 3 insertions(+) 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; -- cgit v1.2.3