I encountered this problem in Postgres 13.

https://blog.timescale.com/blog/how-we-made-distinct-queries...