Simpler psql statement - Maps-l

25 Jun 2010

Hi,

to  see  what  keys there are for rendering on my bicycle map, I query
the db for %cycle%:

SELECT key, count(*)
FROM (
     SELECT (each(tags)).key
     FROM planet_osm_line
) AS stat
WHERE key LIKE '%cycle%'
GROUP by key
ORDER by count DESC

As  this is rather slow, I was trying to take the %cycle% to the inner
query.  But  how  can  I trigger the keys in 'tags'? And would that be
really faster?

Thanks for any hint,
Thomas