@zatnosk no, it is a pretty straight forward select:
SELECT offset, node, run, time, hears, transmitting, received FROM data WHERE run=400
and run is now an index.
It is workable, about 5 seconds per query and it returns ~200k rows.
I was just expecting it to be faster. I don't know if that was an unreasonable expectation at the start.
@inmysocks 5 seconds seems high, but I'm also not used to work with picking 200k out of 50m rows.