We have a large table and the error occurs with this where clause: FROM "elliedb"."documentlog" WHERE dcmodifiedutc>(extract(epoch from TIMESTAMP '2019-11-15 11:30:51')*1000)
When we reduce the scope to current time - 4 hours the query works within 44 seconds. where dcmodifiedutc > '1575282651000'
Is this expected? Is this a version issue being only 9.5?
From "Now minus 4" hours to now covers 100 fold less time than from 2019-11-15 11:30:51 until now does. Assuming your data is evenly distributed over the past and doesn't have data from the future, then I think that yes, selecting 100 time more data is expected to take more time and more memory. pgAdmin4 is not well suited to loading giant data sets into memory. You can extract large data sets directly into files. This will not depend on the version.
It seems the timestamp conversion would be done once and applied to the filter, but it seems to ballooning the query result being aggregated for the where clause?
Is aggregation being used? You haven't shown any aggregation.