There is huge slowness in the database now with any queries.
Oracle - Select * from TABLENAME- in takes 0.009 milliseconds
Oracle is not returning 10 million rows in 0.009 milliseconds.
Perhaps whatever you are doing in Oracle is the equivalent of "EXPLAIN" without ANALYZE in PostgreSQL, or to PREPARE in PostgreSQL. It just plans the query without executing it.