How to fix postgis query using 'or' operator when group by on polygon name

I have installed openstreetmap postgis database using .osm file for Scotland using osm2pgsql.

I have also imported a set of polygons of parliamentary constituencies in Scotland called 'area10'

I want to find out how much cycle path distance is within each constituency.

If I run this query:

SELECT m.name, sum(ST_Length(r.way))/1000 as roads_km FROM planet_osm_line r, area10 m WHERE ST_Contains(m.way,r.way) AND r.highway = 'cycleway' OR r.highway = 'path' AND bicycle = 'yes' GROUP BY m.name

The query runs indefinitely or at least for 45mins or so until my computer overheats but that is another issue...

If I run this query (without 'OR' operator):

SELECT m.name, sum(ST_Length(r.way))/1000 as roads_km FROM planet_osm_line r, area10 m WHERE ST_Contains(m.way,r.way) AND r.highway in ('cycleway','path') GROUP BY m.name

This returns within about 30 seconds:

`name | roads_km

• Mid Fife and Glenrothes P Const | 87.17134
• Glasgow Provan P Const | 19.11762
• Eastwood P Const | 19.97493`

...

Question: So why does using the OR operator in the WHERE clause greatly increase the time of the query? I really need to use the OR operator as there are lots of different highway= tags which I would like to include:

OR highway = 'path' AND bicycle = 'designated' OR highway = 'footway' AND bicycle = 'designated' OR highway='footway' AND bicycle = 'yes'

etc

I have also tried a similar query using the h-store tag values with the same issue.

Any help very much appreciated. Thank you.