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

9 votes135 views4 answers
SQL Date Format
SQL
2 votes147 views1 answer
Mysql time ago difference
SQL
1 vote135 views1 answer
Customer using hdfc bank sql query
SQL
6 votes170 views1 answer
Postgresql get year
SQL
1 vote140 views1 answer
Table information in sql server
SQL
2 votes139 views1 answer
How to select first row of database sql
SQL
1 vote134 views1 answer
How to find median of a column sql
SQL
25 votes142 views6 answers
Sql update query
SQL
11 votes142 views2 answers
Having in sql
SQL
1 vote131 views1 answer
Sql myisam vs innodb
SQL