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

18 votes314 views2 answers
Sql comments
SQL
1 vote328 views1 answer
Create temporal table in sql
SQL
1 vote344 views2 answers
Pad zero sql server
SQL
5 votes339 views1 answer
JBDC
SQL
2 votes320 views1 answer
Docker run postgres locally
SQL
5 votes366 views1 answer
Oracle nls session
SQL
2 votes329 views1 answer
Mysql find tables with name
SQL
1 vote328 views1 answer
Mysql show table character set
SQL
0 vote323 views1 answer
Call function in query sql server
SQL
0 vote355 views1 answer
Oracle 11g forget password
SQL