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

4 votes306 views1 answer
Sql select limit range
SQL
6 votes339 views2 answers
Oracle undotbs usage
SQL
0 vote290 views1 answer
EneratingSchemaError: Some errors occurred while generating GraphQL schema: Type Query must define one or more fields.
SQL
10 votes303 views4 answers
SELECT FROM WHERE
SQL
0 vote280 views1 answer
Commit transaction sql
SQL
0 vote286 views1 answer
How to select an index in oracle sql
SQL
0 vote288 views4 answers
User defined function sql
SQL
0 vote266 views1 answer
The local psql command could not be located
SQL
2 votes286 views5 answers
SQL trigger
SQL
0 vote292 views1 answer
Rename constraint postgresql
SQL