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

4 votes351 views1 answer
Oracle select first 10 rows
SQL
0 vote341 views1 answer
Can we rollback deleted data in sql
SQL
0 vote370 views1 answer
Count number of entires by months sql
SQL
0 vote348 views1 answer
Can't connect to postgresql mac os
SQL
0 vote380 views1 answer
Show all sequences postgres
SQL
18 votes347 views6 answers
Mysql create table
SQL
53 votes566 views6 answers
Sql server alter column
SQL
4 votes369 views1 answer
Postgresql list sequences
SQL
0 vote351 views1 answer
Sqlplus change user
SQL
0 vote336 views1 answer
Psql no such file or directory
SQL