Postgresql datetrunc too slow

CREATE INDEX ON test (date_trunc('day', updated_at));

/*If updated_at is a timestamp without time zone, that will work fine. 
For a timestamp with time zone, you'll have to specify a time zone, 
because otherwise the result will depend on the session time zone, 
which makes it unusable for an index:*/

CREATE INDEX ON test (date_trunc('day', updated_at AT TIME ZONE 'UTC'));

Source: stackoverflow.com

Similar codes

0 vote188 views1 answer
Python mysql query where
SQL
0 vote247 views1 answer
Fetcht he leftmost word in a comma separated string in sql
SQL
11 votes248 views3 answers
Pl sql example
SQL
9 votes188 views2 answers
Get first 3 letters in sql
SQL
14 votes240 views3 answers
Inner join sql oracle
SQL
0 vote176 views1 answer
Full syntax inner join
SQL
2 votes241 views1 answer
Mysql shell insert into
SQL
0 vote185 views4 answers
Mysql desactivar trigger
SQL
0 vote221 views1 answer
Mysql conf.d exampel
SQL
2 votes215 views2 answers
SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' (SQL: select * from information_schema.tables where table_schema = laravel and table_name = migrations and table_type = 'BASE TABLE')
SQL