Ah, yeah, I guess "overwriting" with "AS ts" in this case would  understandably cause such issues, missed that detail. Well done finding it. 🙂

Lumor

To be fair, it's understandable that postgres doesn't know that 

For postgres, it's just a random function which could do anything, I guess. So it can't use the index since it needs to calculate that value for every row first. To spot stuff like this is part of my job as a developer :)

tech

That moment when you increase query performance by 600x by adding two characters

Postgres 14.7

To be fair, it's understandable that postgres doesn't know that `extract(epoch from ts)` does not change the order of `m.ts`.
For postgres, it's just a random function which could do anything, I guess. So it can't use the index since it needs to calculate that value for every row first. To spot stuff like this is part of my job as a developer :)