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 vote176 views1 answer
Raiserror with nowait
SQL
0 vote174 views1 answer
Adding conditions in MERGE statement in Oracle SQL for INSERT/UPDATE
SQL
11 votes175 views1 answer
Creating tables in sql with python
SQL
-1 vote167 views1 answer
Get id from just inserted row mysql server python
SQL
1 vote165 views3 answers
Mysql parse int
SQL
5 votes240 views4 answers
Sql check
SQL
0 vote196 views1 answer
Mysql date equals to current_date plus days
SQL
2 votes158 views1 answer
When matched in sql server
SQL
0 vote162 views1 answer
Mysqlcli how to load external sql file
SQL
0 vote193 views1 answer
Get relation data in mysql using query to excel
SQL