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

15 votes319 views3 answers
Postgresql change column type
SQL
0 vote214 views1 answer
Create function in microsoft sql server
SQL
2 votes193 views1 answer
Oracle find unusable indexes
SQL
0 vote172 views1 answer
Sql fetch next 10 rows pdo
SQL
4 votes181 views1 answer
Data types in sql
SQL
0 vote181 views1 answer
Dns slave zone convert
SQL
1 vote240 views1 answer
Psql connect
SQL
5 votes202 views1 answer
Mysql count newlines in field
SQL
1 vote173 views1 answer
Xampp import sql file command line
SQL
2 votes199 views1 answer
Mysql select true or false
SQL