The following bug has been logged on the website:
Bug reference: 15618
Logged by: cd a
Email address: cdalxndr@yahoo.com
PostgreSQL version: 10.3
Operating system: Windows 10
Description:
Adding a unused join clause to the query, modifies the run time from 50ms to
4seconds.
No columns from the join clause are returned and the joined table is not
used in other places.
The join clause is a duplicate of another one that is used for further
joining.
The joined clause should have been automatically removed as it has no side
effects, thus using indices and optimizing query runtime.