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 vote184 views1 answer
Mysql multiple count
SQL
0 vote181 views1 answer
How to get employee having maximum experience in mysql
SQL
7 votes190 views5 answers
Oracle alter table
SQL
0 vote227 views1 answer
Kimball data warehouse sql calendar
SQL
2 votes191 views1 answer
How to Add a Default Value to a Column in MS SQL Server
SQL
0 vote177 views1 answer
How to connect pgadmin with excel
SQL
1 vote190 views1 answer
Mysql month name extract
SQL
1 vote140 views1 answer
Strict in postgres SQL
SQL
0 vote189 views1 answer
Oracle query archive mode
SQL
0 vote193 views1 answer
Case when with count and combining similar values in sql
SQL