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 vote297 views1 answer
How to update random rows in sql
SQL
0 vote194 views1 answer
C# execute transact sql
SQL
7 votes221 views2 answers
Sql remove duplicates based on column
SQL
0 vote259 views1 answer
Jooq replace
SQL
13 votes266 views3 answers
Sql select from multiple tables without join
SQL
0 vote289 views1 answer
Mysql grant access to one database
SQL
0 vote213 views1 answer
Redshift running queries
SQL
1 vote182 views1 answer
Partition by sql server
SQL
0 vote182 views1 answer
Is not null postgresql
SQL
0 vote238 views1 answer
Oracle running queries
SQL