Gaetano Mendola wrote:
Hans de Bruin wrote:
...
This is not what I get with a table similiars to your:
test=# select count(*) from user_logs;
count
-
3025880
(1 row)
empdb=# explain analyze
empdb-# select *
empdb-# from user_logs
empdb-# where login_time between (now()-interval '25 hour
Hans de Bruin wrote:
Hi there,
I like to speed up my homepage and need to do something about a query. A
half to one second to get 24 records from a time dimension table a bit
long. This is the table:
news2=> \d dim_time
And here is the query which in my opinion take way to long:
news2=> explain
