SELECT route_id, (dp).path[1] As path_index, ST_AsTEXT((dp).geom) AS node
FROM (SELECT route_id, ST_DumpPoints(route) AS dp FROM cycling.activities) as segments;