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 vote236 views1 answer
Setting default value for Boolean data type in SQL
SQL
1 vote233 views1 answer
Create new table from old table with data
SQL
3 votes169 views1 answer
Sql online test questions and answers
SQL
4 votes147 views4 answers
Start mysql
SQL
0 vote173 views2 answers
MySQL PARTITION BY month automatically
SQL
0 vote178 views1 answer
MySQL - How to find word with the most similar beginning
SQL
37 votes352 views3 answers
Sql check duplicate value in column
SQL
2 votes190 views1 answer
Mariadb json select
SQL
0 vote157 views1 answer
Couldn't execute 'SELECT COLUMN_NAME
SQL
0 vote168 views1 answer
Remove mysql from centos 7
SQL