At recent conferences, we have received a curious question from users who have used Oracle in the past and are now using PostgreSQL: Do we have hypothetical indexes in PostgreSQL ?. The answer to that question is EXPLAIN . However, if you wish to run an [crayon-5d10cd043e4a6942583604-i/] that runs that SQL and provides the run [&]

https://www.percona.com/blog/2019/06/21/hypothetical-indexes-in-postgresql/