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

2 votes217 views1 answer
Sql server current date minus 5 years
SQL
0 vote206 views1 answer
How to get employee having maximum experience in mysql
SQL
0 vote216 views1 answer
Sql trigger to call stored procedure with parameters
SQL
0 vote209 views1 answer
Mysql wsrep ls
SQL
0 vote229 views1 answer
Table user postgres
SQL
6 votes262 views3 answers
Check if string contains substring sql
SQL
0 vote226 views3 answers
Join
SQL
15 votes209 views1 answer
Mysql int range
SQL
0 vote260 views1 answer
Pgadmin postgres ERROR: database is being accessed by other users
SQL
0 vote233 views1 answer
LoadError: cannot load such file -- mysql2/2.7/mysql2
SQL