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

1 vote114 views1 answer
How to delete data from sql database in android
SQL
0 vote116 views1 answer
Mysql use password error
SQL
1 vote116 views2 answers
Sqlalchemy postgres timestamp with timezone
SQL
19 votes125 views5 answers
Change column name mysql command line
SQL
0 vote121 views1 answer
Restore backupfile discourse
SQL
22 votes221 views4 answers
Tsql rename table
SQL
0 vote140 views1 answer
SQL get max per id
SQL
13 votes139 views4 answers
Mysql access denied for user 'root'@'localhost'
SQL
2 votes87 views5 answers
Alter table primary key postgresql
SQL
2 votes148 views1 answer
Query to check cpu utilization in oracle database
SQL