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 vote138 views1 answer
Split first name and last name in sql
SQL
1 vote126 views2 answers
Mysql limit offset
SQL
0 vote128 views1 answer
Mysql update set sum
SQL
1 vote126 views1 answer
How to truncate a table in databse
SQL
0 vote130 views1 answer
Create dump file mysql workbench
SQL
0 vote133 views1 answer
Mysql join table with a text columns with ids splited by char
SQL
10 votes135 views2 answers
Reset mysql root password mac
SQL
0 vote110 views1 answer
Pl sql join 3 tables
SQL
1 vote128 views2 answers
Begin transaction sql
SQL
2 votes120 views1 answer
Datetrunc
SQL