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 vote111 views3 answers
Drop multiple columns in sql
SQL
1 vote105 views1 answer
Sql server datetime vs datetime2
SQL
0 vote125 views1 answer
Sqlalchemy empty table
SQL
5 votes106 views1 answer
Ascending order and where in sql
SQL
4 votes101 views1 answer
Mysql timestamp in laravel migration
SQL
0 vote132 views1 answer
Php insert null mysql
SQL
0 vote100 views1 answer
Downgrading sql localdb visual studio
SQL
0 vote109 views1 answer
Failed to process SQL command - ORA-28014: cannot drop administrative user or role
SQL
10 votes111 views4 answers
Mysql one week ago
SQL
0 vote140 views1 answer
Pgadmin postgres ERROR: database is being accessed by other users
SQL